Q.1. Which of the following is a type of DBMS Software?
(1) Data
(2) My SQL
(3) MS-office
(4) utility
(5) None of these
Q.2. Which of the following is NOT a type of Microsoft Access database object?
(1) Queries
(2) Workbooks
(3) Forms
(4) Tables
(5) None of these
Q.3. The complete picture of data stored in database is known as
(1) System flowchart
(2) Schema
(3) record
(4) DBMS
(5) None of these
Q.4. A subset of characters within a data field is known as
(1) Record
(2) File
(3) Data string
(4) Byte
(5) None of these
Q.15. Data items grouped together for storage purposes are called-
(1) Record
(2) Title
(3) List
(4) string
(5) None of these
Q.6. Which of the following terms does not describe a database structure used by a DBMS to link data from several files?
(1) Relational
(2) Structural
(3) Network
(4) All of the above
(5) None of these
Q.7. The feature that database allows to access only certain records in database is:
(1) Forms
(2) Reports
(3) Queries
(4) Tables
(5) None of these
Q.8. Set of permitted values of each attribute is called ______.
(1) Domain
(2) Relation
(3) Tuple
(4) Schema
(5) None of these
Q.9. The primary key must be ____.
(1) Unique
(2) Not null
(3) Both 1 and 2
(4) Either 1 or 2
(5) None of these
Q.10. Logical design of the database is called ______.
(1) Database Snapshot
(2) Database Instance
(3) Database Schema
(4) All of the above
(5) None of these
ANSWERS
Q.1. (2) My SQL
Q.2. (2) Workbooks
Q.3. (2) Schema
Q.4. (3) Data string
Q.5. (1) Record
Q.6. (2) Structural
Q.7. (3) Queries
Q.8. (1) Domain
Q.9. (3) Primary key must satisfy unique and not null condition for sure.
Q.10. (3) Logical design of database is called Database Schema.