Computer Science - Database Systems

Exercise :: Database Systems - Section 3

41. 

In SQL, which command is used to select only one copy of each set of duplicable rows

A. SELECT DISTINCT
B. SELECT UNIQUE
C. SELECT DIFFERENT
D. All of the above
E. None of the above

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

42. 

The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in

A. a tree file
B. an indexed file
C. a hashed file
D. a sequential file
E. None of the above

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

43. 

Which command is used to select distinct subject (SUB) from the table (BOOK)?

A. SELECT ALL FROM BOOK
B. SELECT DISTINCT SUB FROM BOOK
C. SELECT SUB FROM BOOK
D. All of the above
E. None of the above

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

44. 

The master list of an indexed file

A. is sorted in ascending order
B. contains only a list of keys and record numbers
C. has a number assigned to each record
D. both (b) and (c)
E. None of the above

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

45. 

Which of the following is not the responsibility of the utilities component of DBMS software?

A. creating the physical and logical designs
B. removing flagged records for deletion
C. creating and maintaining the data dictionary
D. monitoring performance
E. None of the above

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.