Database Archives - CS Electrical & Electronics

All Questions › Category: Database

Filter:All Open Resolved Closed Unanswered
Which database concept describes the structure inside the database?
AnsweredAnonymous asked 4 years ago • Database
14651 views1 answers0 votes
Which items represent database table columns value constraints?
OpenAnonymous asked 4 years ago • Database
1254 views1 answers0 votes
What information gathering techniques might be applied during the requirement gathering phase of the DDLC process?
OpenAnonymous asked 4 years ago • Database
1986 views1 answers0 votes
Which key database design methodology characteristics are required to support the creation of databases?
OpenAnonymous asked 4 years ago • Database
2290 views1 answers0 votes
Which components help to define business requirements during the requirement gathering and analysis phase of the DDLC process?
OpenAnonymous asked 4 years ago • Database
2431 views1 answers0 votes
What does the three-schema architecture include?
OpenAnonymous asked 4 years ago • Database
486 views1 answers0 votes
What are the potential drawbacks of conducting end-user interviews during the Requirement Gathering phase of the DDLC process?
OpenAnonymous asked 4 years ago • Database
2414 views1 answers0 votes
Which fundamental data actions must be supported on an appropriately structured database?
OpenAnonymous asked 4 years ago • Database
1841 views1 answers-1 votes
Which options represent required characteristics of interview questions posed during end-user interview?
OpenAnonymous asked 4 years ago • Database
2684 views1 answers0 votes
Where is the three-schema mapping information stored?
OpenAnonymous asked 4 years ago • Database
1228 views1 answers0 votes
Which options represent common data object to data object relationships?
OpenAnonymous asked 4 years ago • Database
2179 views1 answers0 votes
What activities are executed during the Logical Database Design phase of the DDLC process?
OpenAnonymous asked 4 years ago • Database
2687 views1 answers-2 votes
What are the first two stages of the Database Design Life-Cycle (DDLC) process?
OpenAnonymous asked 4 years ago • Database
1539 views1 answers1 votes
What is the purpose of the UPDATE statement?
OpenAnonymous asked 4 years ago • Database
1064 views1 answers0 votes
What is the purpose of the ORDER BY clause?
OpenAnonymous asked 4 years ago • Database
1646 views1 answers0 votes
When deleting a record from a table which clause would you almost always have in your statement so only a particular record is deleted and not the whole table?
OpenAnonymous asked 4 years ago • Database
2560 views1 answers0 votes
When would you need to include square brackets around the name of a table within a SELECT statement?
OpenAnonymous asked 4 years ago • Database
2902 views1 answers-1 votes
Used to add in two or more conditions where any condition can be satisfied
OpenAnonymous asked 4 years ago • Database
507 views1 answers0 votes
Used to add in multiple conditions where all conditions must be satisfied
OpenAnonymous asked 4 years ago • Database
590 views1 answers0 votes
Selects values within a range
OpenAnonymous asked 4 years ago • Database
427 views1 answers0 votes
Sorts the result-set
OpenAnonymous asked 4 years ago • Database
397 views1 answers0 votes
Used in a multi-table SELECT statement
OpenAnonymous asked 4 years ago • Database
468 views1 answers0 votes
Which of the following statements are true regarding the SQL Server System Database?
OpenAnonymous asked 4 years ago • Database
4752 views1 answers0 votes
Which of the following statements are true regarding NULL and IS NOT NULL values?
OpenAnonymous asked 4 years ago • Database
8868 views1 answers-2 votes
What would be reasons you would use the DEFAULT value in a column?
OpenAnonymous asked 4 years ago • Database
3783 views1 answers1 votes
What is the purpose of the SQL SELECT TOP Clause?
OpenAnonymous asked 4 years ago • Database
746 views1 answers0 votes
Which of the following statements are true regarding the PRIMARY KEY when creating a table?
OpenAnonymous asked 4 years ago • Database
10702 views1 answers0 votes
When would you use the nvarchar data type within a table?
OpenAnonymous asked 4 years ago • Database
1498 views1 answers0 votes
Which SQL syntax would you use to delete a table titled My_Table_1?
OpenAnonymous asked 4 years ago • Database
2344 views1 answers0 votes
Which of the following statements are true regarding the SQL INSERT INTO statement?
OpenAnonymous asked 4 years ago • Database
3928 views1 answers0 votes
Which of the following SQL constraints ensures that a column has a unique identity and NOT NULL?
OpenAnonymous asked 4 years ago • Database
1686 views1 answers0 votes
You want to remove a PRIMARY KEY you added to a column in an existing table. Which two SQL statements would you use to do this?
OpenAnonymous asked 4 years ago • Database
2142 views1 answers-1 votes
Which table names represent those that are in accordance with naming convention best practices?
OpenAnonymous asked 4 years ago • Database
2902 views1 answers0 votes
Which constraint types in SQL Server are most closely associated with enforcing Referential Integrity?
OpenAnonymous asked 4 years ago • Database
2634 views1 answers0 votes
Which statement can be used to rename a table?
OpenAnonymous asked 4 years ago • Database
1593 views1 answers0 votes
While duplicating a table, what are the elements which are copied?
OpenAnonymous asked 4 years ago • Database
2571 views1 answers0 votes
Which statement represents the correct syntax to add columns to a table?
OpenAnonymous asked 4 years ago • Database
1697 views1 answers0 votes
The ALTER TABLE statement can be used to change which of the following components?
OpenAnonymous asked 4 years ago • Database
1988 views1 answers0 votes
Dropping a table removes what from the database?
OpenAnonymous asked 4 years ago • Database
564 views1 answers0 votes
Which statement represents the correct syntax to create new tables in SQL Server 2016?
OpenAnonymous asked 4 years ago • Database
1882 views1 answers0 votes
Which numerical data type has a precision of 2(2^16)?
OpenAnonymous asked 4 years ago • Database
7288 views1 answers0 votes
Which description accurately describes a basic SQL statement?
OpenAnonymous asked 4 years ago • Database
5229 views1 answers0 votes
Which of the following statements are true regarding an ad hoc query?
OpenAnonymous asked 4 years ago • Database
8897 views1 answers0 votes
Which database file type is used as a recovery process when the database fails?
OpenAnonymous asked 4 years ago • Database
6234 views1 answers0 votes
Used to add in multiple conditions where all conditions must be satisfied
OpenAnonymous asked 4 years ago • Database
367 views1 answers0 votes
Allows you to specify sorted columns
OpenAnonymous asked 4 years ago • Database
525 views1 answers0 votes
Used to add in two or more conditions where any condition can be satisfied
OpenAnonymous asked 4 years ago • Database
595 views1 answers0 votes
Allows you to categorize the results
OpenAnonymous asked 4 years ago • Database
2792 views1 answers0 votes
Retrieves records from a table
OpenAnonymous asked 4 years ago • Database
474 views1 answers0 votes
Allows you to specify your criteria and filters only records you are interested in
OpenAnonymous asked 4 years ago • Database
1932 views1 answers0 votes
Collection of all records for that relation
OpenAnonymous asked 4 years ago • Database
815 views1 answers0 votes
Describes the relation identify and attributes
OpenAnonymous asked 4 years ago • Database
579 views1 answers0 votes
Identifies the row in the relation
OpenAnonymous asked 4 years ago • Database
435 views1 answers0 votes
Specific set of tuples in a relational database architecture
OpenAnonymous asked 4 years ago • Database
1308 views1 answers0 votes
Single row of a table that contains a single record for that relation
OpenAnonymous asked 4 years ago • Database
589 views1 answers-1 votes
Free MongoDB courses for students?
OpenAnonymous asked 4 years ago • Database
608 views1 answers0 votes
how to install mangodb?
OpenChetan Shidling asked 4 years ago • Database
390 views0 answers0 votes
What is binary serialization of object notation?
OpenAnonymous asked 4 years ago • Database
322 views0 answers0 votes
What is binary encoded serialization?
OpenAnonymous asked 4 years ago • Database
335 views0 answers0 votes
Difference between Mongo DB and RDBMS?
OpenAnonymous asked 4 years ago • Database
295 views0 answers0 votes
12 Next »

Share Now