Do U know?

1. The data dictionary is

a. a utility program                     b. a list of database personnel

c. different from an index procedure                d. an application generator

2. Users usually retrieve information from a database using

a. FORTRAN    b. COBOL    c. SQL       d. PL/1

3. What is embedded SQL?

a. A subset of SQL for Macintosh system

b. An SQL compiler built by Microsoft

c. SQL statements used in a program written in some other programming language, usually prefixed by some symbols recognizable by preprocessor

d. SQL written for embedded systems, used in a program written in some other programming language

e. A UNIX version of SQL

4. Relationship 'attends' from 'student' to 'class' is an example of

a. one-to-one relationship                b. many-to-one relationship

c. one-to-many relationship                d. many-to-many relationship

5. An integrated collection of related data files is called a

a. record             b. database             c. table                         d. data element

6. What file access method allows the user to directly access records organized sequentially using an index of key fields?

a. Sequential access method             b. Indexed sequential access method

c. Direct access method                                     d. Relational access method

7. Adding new data, modifying existing data, and deleting data are the three basic operations of data

a. maintenance                b. management                 c. retrieval             d. backup

8. Which of the  following keywords is NOT included in most data retrieval statements?

a. SELECT                   b. AS                c. FROM d. WHERE

9. Functions include

a. COUNT, MIN, OR

b. MAX, SUM, AND

c. AVG, IF, COUNT

d. COUNT, SUM, AVG

10. What is the smallest unit of data recognized by database software?

a. Row                         b. Field             c. Record             d. Table

11. Data integrity controls may include

a. default values, null value control, denormalization

b. default values, hashing, referential integrity

c. range control, hashing, denormalization

d. range control, referential integrity, default values

12. Another name for a synonym is a(n)

a. alias                         b. homonym             c. constraint             d. enterprise key

13. All of the following are basic constructs of E-R modeling EXCEPT

a. attributes             b. entity types    c. relationships             d. identifiers

14. A base table is a

a. mathematical table                                                                             b. table with indexing

c. table that physically exists in the database                         d. virtual table

15. In a multi-user database environment, the word key is synonymous with the word

a. index             b. password             c. superuser             d. lock