This Test will cover complete DBMS with very important questions, starting off from basics to advanced level.
Q. Database management systems are intended to __________.
A. eliminate data redundancy |
B. establish relationship among records in different files |
C. manage file access |
D. all of these |
Q. Which of the following is not a characteristics of a relational database model?
A. Tables | B. Treelike Structure |
C. Complex logical relationships | D. Records |
Q. Which of the following is not the responsibility of the utilities component of DBMS software?
A. Creating the physical and logical designs |
B. Removing flagged records for deletion |
C. Creating and maintaining the data dictionary |
D. Monitoring performance |
Q. Which of the following is a type of DBMS software?
A. Database manipulation language |
B. Query language |
C. Utilities |
D. All of these |
Q. A database administrator's function is __________.
A. Database design | B. Backing up the database |
C. Performance monitoring | D. All of these |
Q. A data dictionary doesn't provide information about __________.
A. where data is located |
B. the size of the storage disk |
C. who owns or is responsible for the data |
D. how the data is used |
Q. Which of the following is a serious problem of file management systems?
A. Difficult to update |
B. Lack of data independence |
C. Data redundancy |
D. All of these |
Q. A database management system __________.
A. allows simultaneous access to multple file |
B. can do more than a record management system |
C. is a collection of programs for managing data in a single file |
D. both (a) and (b) |
Q. Which of the following is true for a large DBMS?
A. In a large DBMS each user can "see" only a small part of the entire database. |
B. In a large DBMS each sub-schema contains every field in the logical schema. |
C. In a large DBMS each user can access every sub-schema. |
D. All of these |
Q. Which of the following is true for a transparent DBMS?
A. A transparent DBMS cannot hide sensitive information from users. |
B. A transparent DBMS keeps its logical structure hidden from users. |
C. A transparent DBMS keeps its physical structure hidden from users. |
D. both (b) and (c) |
Q. Goals for the design of the Logical schema includes __________.
A. avoiding data inconsistency |
B. being able to construct queries easily |
C. being able to accesss data efficiently |
D. all of these |
Q. 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 these |
Q. Which of the following is true for a Network Schema?
A. A Network Schemarestricts the structure to a one to many relationships. |
B. A Network Schema permits many to many relationships. |
C. A Network Schema stores data in tables. |
D. None of these |
Q. In a relational schema, each tuple is divided into fields called __________.
A. relations | B. domains |
C. queries | D. none of these |
Q. The online(over Internet) softcopy displays a customer's charge account to respond to an inquiry is an example of __________.
A. Forecasting report | B. Exception report |
C. Regularly scheduled report | D. On demand report |