SQL Data Definition Quiz Questions and Answers PDF - 425

MCQ 2121: The constraint on an attribute specifies that the null value is not allowed for that attribute, is known to be

1. Candidate key attribute
2. Foreign key attribute
3. Unique key attribute
4. Not Null attribute

MCQ 2122: The contrast to the relational data model, is

1. Semi-structured data model
2. Object-based Data model
3. Entity relationship model
4. Relation View data model

MCQ 2123: Dates must be specified in the format

1. day-year-month
2. year-month-day
3. year-date-month
4. month-year-date

MCQ 2124: An index entry appears for only some of the search-key values, in a

1. Clustering index
2. Non-clustering index
3. Sparse index
4. Dense index

MCQ 2125: To simplify users interaction with the system, data abstraction uses

1. 2 levels
2. 3 levels
3. 4 levels
4. 5 levels