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