Multiple Choice Questions for DBMS Architecute and Database Model
×
Hidden Questions!
Some MCQs are not visible. Usually teachers hides their visibility if they are few in number. Subject Expert recommends them to have more than 70+ questions against the topic and make them public.
1
The ANSI-SPARC committee produced________ level DBMS architecture in the year 1975.
19
Which part of SQL language allows the DBA or user to describe and name the entities, attributes, and relationships required for the application, together with any associated integrity and security constraints?
22
There is a relation Student (stID, sName, city), where city and sName attributes may have repeated values, but stID cannot have repeated values, then which one of the following can be a candidate key in the relation:
23
If one user wants to view the employee’s hire date in form of (day, month, year), but other user wants to view the same employee’s hire date in the different form like (year, month, day), which one of the three-level architecture represents it?