Database :: Introduction to Database

General Questions


1. 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

Answer: Option A

2. Which of the following projects illustrates a database being designed from existing data?
A.            A database using the Production Department's spreadsheets
B.            A database designed to produce production reports for a new Production Department manufacturing process
C.            A database that will combine two databases currently used by the Production Department
D.            None of the above is correct.

Answer: Option A

3. Which of the following projects illustrates a database being designed as a new systems development project?
A.            A database using the Production Department's spreadsheets
B.            A database designed to produce production reports for a new Production Department manufacturing process
C.            A database that will combine two databases currently used by the Production Department
D.            None of the above is correct.

Answer: Option B

4. Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?
A.            IDMS     B.            DB2
C.            dBase-II               D.            R:base

Answer: Option B

5. The following are components of a database except ________ .
A.            user data
B.            metadata
C.            reports
D.            indexes

Answer: Option C



6. An application where only one user accesses the database at a given time 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
Answer: Option A

7.  Which of the following projects illustrates a database being designed as a redesign of an existing database?
A.            A database using the Production Department's spreadsheets
B.            A database designed to produce production reports for a new Production Department manufacturing process
C.            A database that will combine two databases currently used by the Production Department
D.            None of the above is correct.
Answer: Option C

8. 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
Answer: Option C

9. Which of the following products was the first to implement true relational algebra in a PC DBMS?
A.            IDMS     B.            Oracle
C.            dBase-II               D.            R:base
Answer: Option D

10. SQL stands for ________ .
A.            Structured Query Language
B.            Sequential Query Language
C.            Structured Question Language
D.            Sequential Question Language
Answer: Option A

Comments