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. insertion anomaly. referential integrity constraint. transitive dependency. normal form. insertion anomaly. referential integrity constraint. transitive dependency. ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database? FMS DBMS DASD None of these EMMS FMS DBMS DASD None of these EMMS ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A file that is organized in uniform format is formally referred to as a _____ or a database file. None of these Structured data file Document Database Record None of these Structured data file Document Database Record ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, the _____ command is used to recompile a view DEFINE VIEW ALTER VIEW None of these CREATE VIEW COMPILE VIEW DEFINE VIEW ALTER VIEW None of these CREATE VIEW COMPILE VIEW ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A candidate key is a determinant that determines all the other columns is a relation. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Entities use identifiers while tables use keys. False True False True ANSWER DOWNLOAD EXAMIANS APP