Database Management Systems MCQs
Database Management Systems MCQs
Our experts have gathered these Database Management Systems MCQs through research, and we hope that you will be able to see how much knowledge base you have for the subject of Database Management Systems by answering these multiple-choice questions.
Get started now by scrolling down!
1: A ____ is a set of letters or numbers that represents a data item.
A. Orphan
B. Code
C. Attribute
D. Field
2: A programming language typically used for cgi scripts is ____.
A. PERL
B. SQL
C. Java
D. JavaScript
3: A(n) _____ allows a user to specify a task without specifying how the task will be accomplished.
A. Query language
B. Mark-up language
C. Both a and b
D. None of the above
4: Each record in a table is uniquely identified by a foreign key. _________________________
A. True
B. False
5: In the _____ model, the basic logical structure is represented as an upside-down tree.
A. Hierarchical
B. Network
C. Relational
D. Entity relationship
6: The ____ view involves how data is stored on and retrieved from storage media.
A. Logical view
B. Physical View
C. Neither physical nor logical
D. None of the above
7: A good filing system shares all of the common characteristics of a _________.
A. Using an electronic scanner
B. Requires forming new habits
C. Take up little physical
D. Database - it must store information for easy access and retrieval
8: Bcnf can be violated only if the table contains more than one _____ key.
A. Primary
B. Candidate
C. Foreign
D. Secondary
9: Popular ____ include access, oracle, db2, mysql, and sql server.
A. E-R diagrams
B. DBAs
C. Data files
D. DBMSs
10: In macos, the ____ fork typically contains data the user creates.
A. Ghost
B. Filevault
C. Logical
D. Shadow
11: Ideally, an entity identifier is composed of _____ attribute(s).
A. One
B. Two
C. Three
D. Four
12: Fields in the query design grid include all of the following except ________.
A. Outermost
B. Enforce Referential Integrity is checked
C. Brackets ([])
D. Query design grid
E. Fields that are listed as Primary Keys
13: Union-compatible means that the ____.
A. Names of the relation attributes can be different, but the data types must be identical
B. Names of the relation attributes must be the same, but the data types can be different
C. Names of the relation attributes must be the same and their data types must be identical
D. Number of attributes must be the same, but the names and data types can be different
List of Database Management Sy...
Available in:
Database Management Systems MCQs
