Introduction to Database- General Questions


11. 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
Ans: Option C

12. The following are functions of a DBMS except ________ .
A.            creating and processing forms
B.            creating databases
C.            processing data
D.            administrating databases
Ans: Option A

13. Helping people keep track of things is the purpose of a(n) ________ .
A.            database             B.            table
C.            instance               D.            relationship
Ans: Option A

14. Which of the following products implemented the CODASYL DBTG model?
A.            IDMS     B.            DB2
C.            dBase-II               D.            R:base
Ans: Option A

15. An Enterprise Resource Planning application 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
Ans: Option B

16. 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
Ans: Option B

17. You have run an SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled "TableName," "NumberOfColumns" and "PrimaryKey." You are looking at ________ .
A.            user data.
B.            metadata
C.            A report
D.            indexes
Ans: Option B

18. Which of the following is not considered to be a basic element of an enterprise-class database system?
A.            Users
B.            Database applications
C.            DBMS
D.            COBOL programs
Ans: Option D

19.          The DBMS that is most difficult to use is ________ .
A.            Microsoft's SQL Server
B.            Microsoft's Access
C.            IBM's DB2
D.            Oracle Corporation's Oracle
Ans: Option D


Comments