Top 150+ Solved Advanced Database Management Systems (ADBMS) MCQ Questions Answer
Q. An on-line commercial site such as Amazon.com is an example of a(n) ________ .
a. single-user database application
b. multiuser database application
c. e-commerce database application
d. data mining database application
Q. SQL stands for ________ .
a. Structured Query Language
b. Sequential Query Language
c. Structured Question Language
d. Sequential Question Language
Q. Because it contains a description of its own structure, a database is considered to be________ .
a. Described
b. metadata compatible
c. self-describing
d. an application program
Q. The following are functions of a DBMS except ________ .
a. creating and processing forms
b. creating databases
c. processing data
d. administrating databases
Q. Helping people keep track of things is the purpose of a(n) ________ .
a. Database
b. Table
c. Instance
d. Relationship
Q. A DBMS that combines a DBMS and an application generator is ________ .
a. Microsoft's SQL Server
b. Microsoft's Access
c. IBM's DB2
d. Oracle Corporation's Oracle
Q. Which of the following is related to information?
a. Data
b. Communication
c. Knowledge
d. All of these.
Q. Which of the following is element of the database?
a. Data
b. Constraints and schema
c. Relationships
d. All of these.
Q. What represent a correspondence between the various data elements?
a. Data
b. Constraints
c. Relationships
d. Schema
Q. Which of the following is an advantage of using database system?
a. Security enforcement
b. Avoidance of redundancy
c. Reduced inconsistency
d. All of these.
Q. Which of the following is characteristic of the data in a database?
a. Independent
b. Secure
c. Shared
d. All of these.
Q. Relationships could be of the following type:
a. One-to-one relationship
b. One-to-many relationships
c. Many-to-many relationships
d. All of these.
Q. In a file-oriented system there is:
a. Data inconsistency
b. Duplication of data
c. Data independence
d. Al of these.
Q. In a database system there is:
a. Increased productivity
b. Improved security
c. Economy of scale
d. All of these.