Relational Database Design and SQL Questions

1. In a relational schema, each tuple is divided into fields called
a. Relations
b. Domains
c. Queries
d. All of the above

Ans: b

2. A logical schema
a. is the entire database
b. is a standard way of organizing information into accessible parts
c. describes how data is actually stored on disk
d. all of the above

Ans: b

3. A form defines
a. where data are placed on the screen
b. the width of each field
c. both (a) and (b)
d. All of the above

Ans: c

4. A top-to-bottom relationship among the items in a database is established by a
a. Hierarchical Schema
b. Network Schema
c. Relational Schema
d. All of the above

Ans: b

5. A good query system
a. can accept English language commands
b. allows non-programmers to access information stored in a database
c. can be accessed only by data processing professionals
d. Both (a) and (b)

Ans: b

6. A report form
a. appears on the computer monitor during data entry
b. is used during report generation to format data
c. Both a and b
d. All of the above

Ans: b

7. A list consists of last names, first names, addresses and pincodes if all people in the list have the same last and the same pincode, a useful key would be
a. the pincode
b. the last name
c. a compound key consisting of the first name and the last name
d. all of the above

Ans: c

8. A command that lets you change one or more fields in a record is
a. Insert
b. Modify
c. Look-up
d. All of the above

Ans: b

10. Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time ?
a. Report writer
b. Query language
c. Data manipulation language
d. Transaction Log

Ans: d