Database Application Unit 7

Which of the following statements is not true about a view?

A. A view is an individual user's picture of the database.
B. A view is a derived table from one or more base tables.
C. A view provides a great simplification of table administration.
D. A view provides a measure of security.
E. All of the above
F. None of the above

Which of the following vendors will display an error when using an ORDER BY clause in a CREATE VIEW statement?

A. MySQL and Oracle
B. MySQL and MS SQL Server
C. Oracle and MS SQL Server
D. All of the above
E. None of the above

Which of the following is not true about updatable views?

A. A view is updatable when the base table(s) contain the primary keys.
B. A view is not updatable when it contains computed column.
C. A view is updatable when the base table(s) contain the foreign keys.
D. A view is updatable regardless of the underlying query.
E. All of the above
F. None of the above

Which of the following SQL commands removes a view from the database?

A. REMOVE VIEW
B. ERASE VIEW
C. DELETE VIEW
D. DROP VIEW

Which of the following SQL statements is false?

A. GRANT SELECT ON SALES_REP TO JOHNSON;
B. GRANT VIEW ON SALES_REP TO JOHNSON;
C. GRANT DELETE ON SALES_REP TO JOHNSON;
D. GRANT UPDATE ON SALES_REP TO JOHNSON;
E. All of the above
F. None of the above

Which of the following statements is true?

A. In a large database, indexes are essential to decrease the time required to retrieve records
B. DBMS must update the index whenever corresponding data in the database is updated.
C. Indexes consume large amount of space that outweighs its benefits.
D. In a small database, however, indexes might not provide any significant benefits.
E. All of the above
F. None of the above

Information kept about tables is usually known as a __________.

A. table dictionary
B. data dictionary
C. system dictionary
D. schema dictionary

Which of the following SQL statements is valid?

A. ALTER TABLE INVOICES ADD FOREIGN KEY (CUST_ID) CUSTOMER (CUST_ID);
B. ALTER TABLE INVOICES FOREIGN KEY (CUST_ID) REFERENCES CUSTOMER (CUST_ID);
C. ALTER TABLE INVOICES ADD (CUST_ID) REFERENCES CUSTOMER (CUST_ID);
D. ALTER TABLE INVOICES ADD FOREIGN KEY (CUST_ID) REFERENCES CUSTOMER (CUST_ID);
E. All of the above
F. None of the above

Which of the following SQL clauses is used to enforce data integrity?

A. UNIQUENESS
B. NOT NULLABLE
C. WHERE
D. CHECK

Which of the following SQL statements is correct?

A. CREATE UNIQUE INDEX SSN ON SALES_REP (SOC_SEC_NUM);
B. CREATE DUPLICATE INDEX SSN ON SALES_REP (SOC_SEC_NUM);
C. CREATE DISTINCT INDEX SSN ON SALES_REP (SOC_SEC_NUM);
D. CREATE NODUPLICATE INDEX SSN ON SALES_REP (SOC_SEC_NUM);