adplus-dvertising
61. Which of the following are integrity controls that a DBMS may support?
a. Assume a default value in a field unless a user enters a value for that field.
b. Limit the set of permissible values that a field may assume.
c. Limit the use of null values in some fields.
d. All of the above.
Answer: (d).All of the above.
62. A secondary key is which of the following?
a. Nonunique key
b. Primary key
c. Useful for denormalization decisions
d. Determines the tablespace required
Answer: (a).Nonunique key
63. The fastest read/write time and most efficient data storage of any disk array type is:
a. RAID-0.
b. RAID-1.
c. RAID-2.
d. RAID-3.
Answer: (a).RAID-0.
64. Which of the following improves a query's processing time?
a. Write complex queries.
b. Combine a table with itself.
c. Query one query within another.
d. Use compatible data types.
Answer: (d).Use compatible data types.
65. The blocking factor is:
a. a group of fields stored in adjacent memory.
b. the number of physical records per page.
c. attributes grouped together by the same primary key.
d. attributes grouped together by the same secondary key.
Answer: (b).the number of physical records per page.
66. Which of the following is not a relational database?
a. dBASE IV
b. 4th Dimension
c. FoxPro
d. Reflex
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
a. the pin code
b. the last name
c. a compound key consisting of the first name and the last name
d. All of the above
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
a. file
b. field
c. data
d. batch
Answer: (a).file
69. If you want to group the records in the abc database, you could use the Jobcode as the _____.
a. Delete
b. Update
c. Sort Key
d. Index
Answer: (c).Sort Key
70. Which of the following is not characteristic of a relational database model?
a. tables
b. treelike structure
c. complex logical relationships
d. records
Answer: (b).treelike structure

GATE CSE Resources

Questions from Previous year GATE question papers

UGC NET Computer science Resources

UGC NET Previous year questions and practice sets

NET General Paper 1

UGC NET Previous year questions and practice sets

GATE CSE Online Test

Attempt a small test to analyze your preparation level. This GATE exam includes questions from previous year GATE papers.

UGC NET practice Test

Practice test for UGC NET Computer Science Paper. The questions asked in this NET practice paper are from various previous year papers.