Database Systems - Section 7 | Multiple Questions and Answers

41.	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

42.	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)

43.	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

44.	In SQL, the CREATE TABLESPACE is used

	A.	to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace
	B.	to create a database trigger
	C.	to add/rename data files, to change storage
	D.	All of the above