Introduction to Database System The _____ command is used to allocates an extent for the table in SQL REDEFINE TABLE MODIFY TABLE MODIFY ALLOCATES None of these ALTER TABLE REDEFINE TABLE MODIFY TABLE MODIFY ALLOCATES None of these ALTER TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System Queries to a database can use aggregate functions like SUM and COUNT None of these All of these are written in English both (a) and (b) can use aggregate functions like SUM and COUNT None of these All of these are written in English both (a) and (b) 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): insertion anomaly. transitive dependency. normal form. referential integrity constraint. insertion anomaly. transitive dependency. normal form. referential integrity constraint. ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction? ZIP COMMIT PACK SAVE ZIP COMMIT PACK SAVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System You have run an SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled "TableName," "NumberOfColumns" and "PrimaryKey." You are looking at ________ . user data A report metadata indexes user data A report metadata indexes ANSWER DOWNLOAD EXAMIANS APP
Introduction to Database System A database management system allows simultaneous access to multiple files can do more than a record management system Both of the listed here None of the listed here allows simultaneous access to multiple files can do more than a record management system Both of the listed here None of the listed here ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS