Introduction to Database System 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 the last name a compound key consisting of the first name and the last name All of these None of these the pin code the last name a compound key consisting of the first name and the last name All of these None of these the pin code ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which command is used to select distinct subject (SUB) from the table (BOOK)? All of these SELECT DISTINCT SUB FROM BOOK SELECT SUB FROM BOOK None of these SELECT ALL FROM BOOK All of these SELECT DISTINCT SUB FROM BOOK SELECT SUB FROM BOOK None of these SELECT ALL FROM BOOK ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System The master list of an indexed file contains only a list of keys and record numbers both (b) and (c) has a number assigned to each record None of these is sorted in ascending order contains only a list of keys and record numbers both (b) and (c) has a number assigned to each record None of these is sorted in ascending order ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which of the following is not the responsibility of the utilities component of DBMS software? monitoring performance creating and maintaining the data dictionary None of these removing flagged records for deletion creating the physical and logical designs monitoring performance creating and maintaining the data dictionary None of these removing flagged records for deletion creating the physical and logical designs ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, the CREATE TABLESPACE is used to add/rename data files, to change storage None of these All of these to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace to create a database trigger to add/rename data files, to change storage None of these All of these to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace to create a database trigger ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS