SQL for Database Construction problems
- 1. What is not an advantage of stored procedures?
Options- A. Greater security
- B. SQL can be optimized
- C. Code sharing
- D. Increased network traffic Discuss
Correct Answer: Increased network traffic
- 2. The SQL statement to create a view is:
Options- A. CREATE VIEW.
- B. MAKE VIEW.
- C. SELECT VIEW.
- D. INSERT VIEW. Discuss
Correct Answer: CREATE VIEW.
- 3. The DROP TABLE statement:
Options- A. deletes the table structure only.
- B. deletes the table structure along with the table data.
- C. works whether or not referential integrity constraints would be violated.
- D. is not an SQL statement. Discuss
Correct Answer: deletes the table structure along with the table data.
- 4. A ________ is a program that performs some common action on database data and that is stored in the database.
Options- A. trigger
- B. stored procedure
- C. pseudofile
- D. None of the above is correct. Discuss
Correct Answer: stored procedure
- 5. Which of the following is NOT a type of SQL constraint?
Options- A. PRIMARY KEY
- B. FOREIGN KEY
- C. ALTERNATE KEY
- D. UNIQUE Discuss
Correct Answer: ALTERNATE KEY
- 6. What is an SQL virtual table that is constructed from other tables?
Options- A. Just another table
- B. A view
- C. A relation
- D. Query results Discuss
Correct Answer: A view
- 7. For what purposes are views used?
Options- A. To hide columns only
- B. To hide rows only
- C. To hide complicated SQL statements only
- D. All of the above are uses for SQL views. Discuss
Correct Answer: All of the above are uses for SQL views.
- 8. To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
Options- A. a particular column in a particular underlying table.
- B. a particular column in a particular row.
- C. a particular row in a particular underlying table.
- D. None of the above is correct. Discuss
Correct Answer: a particular row in a particular underlying table.
- 9. Which of the following is an SQL trigger supported by Oracle?
Options- A. BEFORE
- B. INSTEAD OF
- C. AFTER
- D. All of the above. Discuss
Correct Answer: All of the above.
- 10. Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:
Options- A. GROUP BY.
- B. WHERE.
- C. ORDER BY.
- D. FROM. Discuss
Correct Answer: ORDER BY.
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.