Introduction to Database System Which command is used to select distinct subject (SUB) from the table (BOOK)? None of these SELECT DISTINCT SUB FROM BOOK SELECT ALL FROM BOOK All of these SELECT SUB FROM BOOK None of these SELECT DISTINCT SUB FROM BOOK SELECT ALL FROM BOOK All of these SELECT SUB FROM BOOK ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System An indexing operation sorts a file using a single key sorts file using two keys None of the listed here establishes an index for a file sorts a file using a single key sorts file using two keys None of the listed here establishes an index for a file ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System An-owner-member set in the CODASYL specifications may have only one owner but many owner occurrences more than one member but only one occurrence per member All of the listed here only one member but many member occurrence only one owner but many owner occurrences more than one member but only one occurrence per member All of the listed here only one member but many member occurrence ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, which command is used to add a column/integrity constraint to a table ALTER TABLE ADD COLUMN MODIFY TABLE INSERT COLUMN ALTER TABLE ADD COLUMN MODIFY TABLE INSERT COLUMN ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System The following are functions of a DBMS except ________ . administrating databases creating databases processing data creating and processing forms administrating databases creating databases processing data creating and processing forms ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity? Supertype entity Instance entity Archetype entity Subtype entity Supertype entity Instance entity Archetype entity Subtype entity ANSWER DOWNLOAD EXAMIANS APP