Multiple Choice Questions on DBMS :
Q1. The ability to change the conceptual schema without affecting the externalschemas or application programs is known as ___________________.
a. Program-data independence
b. Logical data independence
c. Physical data independence
d. Data abstraction
Q2. Which of these levels deals with the physical representation of the database
on the computer?
a. External level
b. Conceptual level
c. Internal level
d. None of these
Q3. Which of these is not a representational data model?
a. Entity-relationship model
b. Hierarchical data model
c. Relational data model
d. Network data model
Q4. Which of these is not a feature of Hierarchical model?
a. Organizes the data in tree-like structure
b. Parent node can have any number of child nodes
c. Root node does not have any parent
d. Child node can have any number of parent nodes
Q5. Which of these data models is an extension of relational data model?
a. Object-oriented data model
b. Object-relational data model
c. Semi structured data model
d. None of these
Q6. The information about data in a database is called _______.
a. Metadata
b. Hyper data
c. Tera data
d. None of these
Q7.The relational database environment has all of the following components
except
a. users
b. separate files
c. database
d. query languages
Q8. DBMS are intended to
a. eliminate data redundancy
b. establish relationship among records in different files
c. manage file access
d. maintain data integrity
e. all of the above
Q9. The language used application programs to request data from the DBMS is
referred to as the
a. DML
b. DDL
c. query language
e. none of the above
Q10. The highest level in the hierarchy of data organization is called
a. data bank
b. data base
c. data file
d. data record
Q11. Report generators are used to
a. store data input by a user
b. retrieve information from files
c. answer queries
d. both b and c
Q12. A top-to-bottom relationship among the items in a database is established
by a
a. hierarchical schema
b. network schema
c. relational schema
d. all of the above
Q13. The management information system (MIS) structure with one main
computer system is called a
a. hierarchical MIS structure
b. distributed MIS structure
c. centralized MIS structure
d. decentralized MIS structure
Q14. A data dictionary is a special file that contains?
a. the names of all fields in all files
b. the data types of all fields in all files
c. the widths of all fields in all files
d. All of above
e. None of above
Q15. The DBMS acts as an interface between what two components of an
enterprise-class database system?
a. Database application and the database
b. Data and the database
c. The user and the database application
d. Database application and SQL
Q16. An on-line commercial site such as Amazon.com is an example of a(n)
________ .
a. Single-user database application
b. Multi-user database application
c. E-commerce application
d. Data mining database application
Q17. SQL stands for ___________________ .
a. Structured Query Language
b. Sequential Query Language
c. Structured Question Language
d. Sequential Question Language
Q18. The following are functions of a DBMS except ________ .
a. creating and processing forms
b. creating databases
c. processing data
d. administrating databases
Q19. A primary key should be defined as:
a. NULL
b. Not NULL
c. Either of the above can be used.
d. None of the above is correct.
Q20. A foreign key is:
a. a column containing the primary key of another table.
b. Used to define data types
c. Used to define NULL status
d. All of the above
Q21. The relational database model was created by E.F. Codd.
a. True
b. False
Q22. The terms alternate key and candidate key mean the same thing.
a. True
b. False
Q23. When transforming an entity-relationship model into a relational database
design, each entity is represented as a table.
a. True
b. False
Q24. The identifier of an entity will become the ________ of the new table.
a. Foreign Key
b. Main Attribute
c. Primary key
d. Identity Key
Q25. Which of the following is not true of the traditional approach to information
processing
a. there is common sharing of data among the various applications
b. it is file oriented
c. programs are dependent on the file
d. it is inflexible
e. all of the above are true
Q26. Which of the following hardware component is the most important to the
operation of database management system?
a. high resolution video display
b. printer
c. high speed, large capacity disk
d. plotter
e. mouse
Q27. If a piece of data is stored in two places in the database, then
a. storage space is wasted
b. changing the data in one spot will cause data inconsistency
c. in can be more easily accessed
d. both a and b
e. both a and c
Q28. An audit trail ___________ .
a. is used to make backup copies
b. is the recorded history of operations performed on a file
c. can be used to restore lost information
d. none of the above
Q29. Large collection of files are called ____________ .
a. fields
b. records
c. database
d. sectors
Q30. Generalized database management systems do not retrieve data to meet
routine request .
a. True
b. False
Answers:
Q1.b, Q2.c, Q3.a, Q4.d, Q5.b, Q6.a, Q7.b, Q8.e, Q9.a, Q10.b, Q11.d, Q12.a,
Q13.c,Q14.d, Q15.a, Q16.c, Q17.a, Q18.a, Q19.b, Q20.a,Q21.a, Q22.a, Q23.a,
Q24.c, Q25.a, Q26.c, Q27.d, Q28.b, Q29.c, Q30.b
Model 2 @ http://lecturenotes4you.blogspot.com/2014/05/dbms-objective-questions.html
.
