Introduction to Database System In SQL, which command is used to add a column/integrity constraint to a table MODIFY TABLE ALTER TABLE ADD COLUMN INSERT COLUMN MODIFY TABLE ALTER TABLE ADD COLUMN INSERT COLUMN 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. normal form. insertion anomaly. referential integrity constraint. transitive dependency. normal form. insertion anomaly. referential integrity constraint. ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, the CREATE VIEW command is used to recompile a table to define a view of one or more tables or views to recompile view to create a trigger to recompile a table to define a view of one or more tables or views to recompile view to create a trigger ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A number of related records that are treated as a unit is called batch field data file batch field data file ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A data dictionary is a special file that contains the widths of all fields in all files None of these the names of all fields in all files the data types of all fields in all files All of these the widths of all fields in all files None of these the names of all fields in all files the data types of all fields in all files All 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 DO INDEX None of these ALTER INDEX MODIFY INDEX REDEFINE INDEX DO INDEX None of these ALTER INDEX MODIFY INDEX REDEFINE INDEX ANSWER DOWNLOAD EXAMIANS APP