61. | Which of the following are integrity controls that a DBMS may support? |
Answer: (d).All of the above.
|
62. | A secondary key is which of the following? |
Answer: (a).Nonunique key
|
63. | The fastest read/write time and most efficient data storage of any disk array type is: |
Answer: (a).RAID-0.
|
64. | Which of the following improves a query's processing time? |
Answer: (d).Use compatible data types.
|
65. | The blocking factor is: |
Answer: (b).the number of physical records per page.
|
66. | Which of the following is not a relational database? |
Answer: (d).Reflex
|
67. | A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be |
Answer: (c).a compound key consisting of the first name and the last name
|
68. | A number of related records that are treated as a unit is called |
Answer: (a).file
|
69. | If you want to group the records in the abc database, you could use the Jobcode as the _____. |
Answer: (c).Sort Key
|
70. | Which of the following is not characteristic of a relational database model? |
Answer: (b).treelike structure
|