Exercise : Database Management System MCQ Questions and Answers
Question 1
A _________________ index is the one which satisfies all the columns requested in the query without performing further lookup into the clustered index.
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. Covering
Description :
A covered query is a query where all the columns in the query’s result set are pulled from non-clustered indexes.
View Answer
50/50
Workspace
Report
Discuss
Question 2
Redundancy is dangerous as it is a potential threat to data
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. Both Integrity and Consistency
Description :
No answer description available for this question. Let us discuss.
Question 3
A relational database consists of a collection of
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. Tables
Description :
Fields are the column of the relation or tables.Records are each row in relation.Keys are the constraints in a relation .
Question 4
The term _______ is used to refer to a row.
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. Tuple
Description :
Tuple
Tuple is one entry of the relation with several attributes which are fields.
Question 5
This set of Database Questions & Answers focuses on “SQL Data Types and Schemas” Dates must be specified in the format
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. yyyy/mm/dd
Description :
yyyy/mm/dd is the default format in sql
Question 6
Domain constraints, functional dependency and referential integrity are special forms of _________.
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. Assertion
Description :
Assertion
An assertion is a predicate expressing a condition we wish the database to always satisfy.
Question 7
The _______ operator takes the results of two queries and returns only rows that appear in both result sets
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. Intersect
Description :
Intersect
The union operator gives the result which is the union of two queries and difference is the one where query which is not a part of second query .
Question 8
A transaction completes its execution is said to be
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. Committed
Description :
Committed
A complete transaction always commits.
Question 9
Aggregate functions are functions that take a ___________ as input and return a single value.
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. Collection of values
Description :
No answer description available for this question. Let us discuss.
Question 10
Manager&rsquos salary details are to be hidden from Employee Table. This Technique is called as
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. External level Datahiding
Description :
No answer description available for this question. Let us discuss.