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): insertion anomaly. transitive dependency. referential integrity constraint. normal form. insertion anomaly. transitive dependency. referential integrity constraint. normal form. ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which of the following is a database administrator's function? backing up the database All of the listed here performance monitoring database design backing up the database All of the listed here performance monitoring database design ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A _____ database does not use pointers or physical links, but instead finds related records by examining the contents of fields. Relational Network Hierarchical None of these Object-Oriented Relational Network Hierarchical None of these Object-Oriented ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that: (B,C) → A → (B,C). A → A → (B,C) → A → (B,C). A → A → ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System An operation that will increase the length of a list is Insert Look-up All of the listed here Modify Insert Look-up All of the listed here Modify ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System The _____ command is used to allocates an extent for the table in SQL MODIFY TABLE ALTER TABLE REDEFINE TABLE MODIFY ALLOCATES None of these MODIFY TABLE ALTER TABLE REDEFINE TABLE MODIFY ALLOCATES None of these ANSWER DOWNLOAD EXAMIANS APP