Module 7

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

b. GRANT VIEW ON SALES_REP TO JOHNSON;

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 not updatable regardless of the underlying query. e. All of the above f. None of the above

c. A view is updatable when the base table(s) contain the foreign keys.

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

c. A view provides a great simplification of table administration.

Which of the following SQL statements is correct? a. CREATE DISTINCT INDEX SSN ON SALES_REP (SOC_SEC_NUM); b. CREATE NODUPLICATE INDEX SSN ON SALES_REP (SOC_SEC_NUM); c. CREATE UNIQUE INDEX SSN ON SALES_REP (SOC_SEC_NUM); d. CREATE DUPLICATE INDEX SSN ON SALES_REP (SOC_SEC_NUM);

c. CREATE UNIQUE INDEX SSN ON SALES_REP (SOC_SEC_NUM);

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

c. Oracle and MS SQL Server

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

d. ALTER TABLE INVOICES ADD FOREIGN KEY (CUST_ID) REFERENCES CUSTOMER (CUST_ID);

Which of the following SQL clauses is used to enforce data integrity? a. WHERE b. UNIQUENESS c. NOT NULLABLE d. CHECK

d. CHECK

Which of the following SQL commands removes a view from the database? a. DELETE VIEW b. REMOVE VIEW c. ERASE VIEW d. DROP VIEW

d. DROP VIEW

Information kept about tables is usually known as a _______. a. table dictionary b. system dictionary c. schema dictionary d. data dictionary

d. data dictionary

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 occupy additional storage space which may outweigh 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.

e. All of the above.