Introduction to Database System Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL? MODIFY TABLE ALTER TABLE All of the listed here DEFINE TABLE MODIFY TABLE ALTER TABLE All of the listed here DEFINE TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which command is used to select distinct subject (SUB) from the table (BOOK)? All of these None of these SELECT ALL FROM BOOK SELECT SUB FROM BOOK SELECT DISTINCT SUB FROM BOOK All of these None of these SELECT ALL FROM BOOK SELECT SUB FROM BOOK SELECT DISTINCT SUB FROM BOOK ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System The different classes of relations created by the technique for preventing modification anomalies are called: functional dependencies. referential integrity constraints. normal forms. None of these functional dependencies. referential integrity constraints. normal forms. None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which of the following refers to something that can be identified in the user's work environment, something that the users want to track? Relationship Attribute Identifier Entity Relationship Attribute Identifier Entity ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A _____ means that one record in a particular record type is related to only one record of another record type. None of these One-to-many relationship Many-to-one relationship Many-to-many relationship One-to-one relationship None of these One-to-many relationship Many-to-one relationship Many-to-many relationship One-to-one relationship ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System If you want to organize a file in multiple ways, it is better to _____ the data rather than to sort it. Update Sort Key Index Delete None of these Update Sort Key Index Delete None of these ANSWER DOWNLOAD EXAMIANS APP