Introduction To Database Questions MCQs


introduction to database Questions

Total Questions : 38

Page 1 of 2 pages
Question 1. The DBMS acts as an interface between what two components of an enterprise-class database system?
  1.    Database application and the database
  2.    Data and the database
  3.    The user and the database application
  4.    Database application and SQL
Answer: Option A
Question 2. Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?
  1.    IDMS
  2.    DB2
  3.    dBase-II
  4.    R:base
Answer: Option B
Question 3. The following are components of a database except ________ .
  1.    user data
  2.    metadata
  3.    reports
  4.    indexes
Answer: Option C
Question 4. An application where only one user accesses the database at a given time is an example of a(n) ________ .
  1.    single-user database application
  2.    multiuser database application
  3.    e-commerce database application
  4.    data mining database application
Answer: Option A
Question 5. An on-line commercial site such as Amazon.com is an example of a(n) ________ .
  1.    single-user database application
  2.    multiuser database application
  3.    e-commerce database application
  4.    data mining database application
Answer: Option C
Question 6. Which of the following products was the first to implement true relational algebra in a PC DBMS?
  1.    IDMS
  2.    Oracle
  3.    dBase-II
  4.    R:base
Answer: Option D
Question 7. Because it contains a description of its own structure, a database is considered to be ________ .
  1.    described
  2.    metadata compatible
  3.    self-describing
  4.    an application program
Answer: Option C
Question 8. SQL stands for ________ .
  1.    Structured Query Language
  2.    Sequential Query Language
  3.    Structured Question Language
  4.    Sequential Question Language
Answer: Option A
Question 9. The following are functions of a DBMS except ________ .
  1.    creating and processing forms
  2.    creating databases
  3.    processing data
  4.    administrating databases
Answer: Option A
Question 10. Helping people keep track of things is the purpose of a(n) ________ .
  1.    database
  2.    table
  3.    instance
  4.    relationship
Answer: Option A
Question 11. Which of the following products implemented the CODASYL DBTG model?
  1.    IDMS
  2.    DB2
  3.    dBase-II
  4.    R:base
Answer: Option A
Question 12. An Enterprise Resource Planning application is an example of a(n) ________ .
  1.    single-user database application
  2.    multiuser database application
  3.    e-commerce database application
  4.    data mining database application
Answer: Option B
Question 13. A DBMS that combines a DBMS and an application generator is ________ .
  1.    Microsoft's SQL Server
  2.    Microsoft's Access
  3.    IBM's DB2
  4.    Oracle Corporation's Oracle
Answer: Option B
Question 14. 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 ________ .
  1.    user data
  2.    metadata
  3.    A report
  4.    indexes
Answer: Option B
Question 15. Which of the following is not considered to be a basic element of an enterprise-class database system?
  1.    Users
  2.    Database applications
  3.    DBMS
  4.    COBOL programs
Answer: Option D
Question 16. The DBMS that is most difficult to use is ________ .
  1.    Microsoft's SQL Server
  2.    Microsoft's Access
  3.    IBM's DB2
  4.    Oracle Corporation's Oracle
Answer: Option D
Question 17. The DBMS that is most difficult to use is ________ .
  1.    Microsoft's SQL Server
  2.    Microsoft's Access
  3.    IBM's DB2
  4.    Oracle Corporation's Oracle
Answer: Option D
Question 18. The DBMS that is most difficult to use is ________ .
  1.    Microsoft's SQL Server
  2.    Microsoft's Access
  3.    IBM's DB2
  4.    Oracle Corporation's Oracle
Answer: Option D
Question 19. The DBMS that is most difficult to use is ________ .
  1.    Microsoft's SQL Server
  2.    Microsoft's Access
  3.    IBM's DB2
  4.    Oracle Corporation's Oracle
Answer: Option D
Question 20. The relational database model was created by E.F. Codd.
  1.    True
  2.    False
Answer: Option A