Introduction to Database System In SQL, which command is used to add a column/integrity constraint to a table INSERT COLUMN ALTER TABLE ADD COLUMN MODIFY TABLE INSERT COLUMN ALTER TABLE ADD COLUMN MODIFY TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which of the following is not characteristic of a relational database model? records treelike structure complex logical relationships tables records treelike structure complex logical relationships tables ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System The relational model uses some unfamiliar terminology. A tuple is equivalent to a field data base data item record field data base data item record ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n): normal form. transitive dependency. referential integrity constraint. insertion anomaly. normal form. transitive dependency. referential integrity constraint. insertion anomaly. 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 creating the physical and logical designs None of these removing flagged records for deletion monitoring performance creating and maintaining the data dictionary creating the physical and logical designs None of these removing flagged records for deletion ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System The _____ command is used to allocates an extent for the table in SQL REDEFINE TABLE None of these MODIFY TABLE MODIFY ALLOCATES ALTER TABLE REDEFINE TABLE None of these MODIFY TABLE MODIFY ALLOCATES ALTER TABLE ANSWER DOWNLOAD EXAMIANS APP