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 A list in alphabetical order both (b) and (c) is the result of a sort operation is in ascending order is in descending order None of these both (b) and (c) is the result of a sort operation is in ascending order is in descending order None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, which command(s) is(are) used to redefine an index's future storage allocation REDEFINE INDEX MODIFY INDEX None of these ALTER INDEX DO INDEX REDEFINE INDEX MODIFY INDEX None of these ALTER INDEX DO INDEX ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System What is the language used by most of the DBMSs for helping their users to access data? SQL 4GL High level language Query language SQL 4GL High level language Query language ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Which of the following is not a restriction for a table to be a relation? The columns must be ordered. All of the entries in any column must be of the same kind. The cells of the table must contain a single value. No two rows in a table may be identical. The columns must be ordered. All of the entries in any column must be of the same kind. The cells of the table must contain a single value. No two rows in a table may be identical. ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A scheme describes All of these record relationships None of these records and files data elements All of these record relationships None of these records and files data elements ANSWER DOWNLOAD EXAMIANS APP