Introduction to Database System Which of the following is not an advantage of the data-base approach? program/data independence elimination of the data redundancy ability to associate related data increased security All of these program/data independence elimination of the data redundancy ability to associate related data increased security All of these 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): transitive dependency. insertion anomaly. normal form. referential integrity constraint. transitive dependency. insertion anomaly. normal form. referential integrity constraint. ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Any table that meets the definition of a relation is said to be in first normal form. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which command is used to remove an index from the database in SQL? REMOVE INDEX DROP INDEX DELETE INDEX ROLL BACK INDEX REMOVE INDEX DROP INDEX DELETE INDEX ROLL BACK INDEX ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System When designing a database, first identify the entities, then determine the attributes, and finally establish the relationships. False True False True 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. Delete Update Index Sort Key None of these Delete Update Index Sort Key None of these ANSWER DOWNLOAD EXAMIANS APP