Deck 13: Database Management

Question 1

2.A RDBMS is a relational database since it has a relational field relating two or more tables.

Answer 1

True

Question 2

18.A good application for a RDBMS is:

A)Costing a project.
B)CD collection organization.
C)An English report.
D)Calculating a grade average.

Answer 2

B

Question 3

16.Part(s)of a RDBMS include:

A)Data tables.
B)Reports.
C)Query tables.
D)All of the above.
E)None of the above.

Answer 3

D

Question 4

3.A query uses conditional expressions to select data.

Question 5

4.Queries build a new table by selecting all or part of the records and/or fields.

Question 6

19.Second normalization takes care of:

A)the insertion anomaly
B)the update anomaly
C)the deletion anomaly
D)the schema

Question 7

14.The output reports:

A)Should print all fields in a record.
B)Should print only relevant fields from a record.
C)Should print all records from the table.
D)None of the above.

Question 8

12.When designing a RDBMS:

A)You should start with the needed output reports.
B)You should start with the design of the records.
C)You should start with the division of data into separate tables.
D)You should start with a list of all the data that will be entered into the records.

Question 9

17.The schema of a RDBMS

A)Divides the fields into interrelated tables.
B)Shows the relationship between tables.
C)Describes the output reports.
D)Allows the user to enter data into the data tables.

Question 10

13.The relational field:

A)Does not have to have the same name in both tables.
B)Must have the same name in both tables.
C)Must be unique in both tables.
D)Is not necessary to relate two tables in a DBMS.