IndiaBIX

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
SELECT DISTINCT
SELECT UNIQUE
SELECT DIFFERENT
All of the above
None of the above
Answer: Option
Explanation:
No answer description is available. Let's 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 tree file
an indexed file
a hashed file
a sequential file
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.
43.
Which command is used to select distinct subject (SUB) from the table (BOOK)?
SELECT ALL FROM BOOK
SELECT DISTINCT SUB FROM BOOK
SELECT SUB FROM BOOK
All of the above
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.
44.
The master list of an indexed file
is sorted in ascending order
contains only a list of keys and record numbers
has a number assigned to each record
both (b) and (c)
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.
45.
Which of the following is not the responsibility of the utilities component of DBMS software?
creating the physical and logical designs
removing flagged records for deletion
creating and maintaining the data dictionary
monitoring performance
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers