Discussion
Home ‣ Database ‣ SQL for Database Construction Comments
- Question
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.
- Correct Answer
- a particular row in a particular underlying table.
- 1. 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
- 2. 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
- 3. Which of the following is NOT a type of SQL constraint?
Options- A. PRIMARY KEY
- B. FOREIGN KEY
- C. ALTERNATE KEY
- D. UNIQUE Discuss
- 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
- 5. 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
- 6. 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
- 7. 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
- 8. SQL views can be used to hide:
Options- A. columns and rows only.
- B. complicated SQL syntax only.
- C. both of the above can be hidden by an SQL view.
- D. None of the above is correct. Discuss
- 9. A ________ is a stored program that is attached to a table or a view.
Options- A. pseudofile
- B. embedded SELECT statement
- C. trigger
- D. None of the above is correct. Discuss
- 10. When using the SQL INSERT statement:
Options- A. rows can be modified according to criteria only.
- B. rows cannot be copied in mass from one table to another only.
- C. rows can be inserted into a table only one at a time only.
- D. rows can either be inserted into a table one at a time or in groups. Discuss
SQL for Database Construction problems
Search Results
Correct Answer: All of the above are uses for SQL views.
Correct Answer: A view
Correct Answer: ALTERNATE KEY
Correct Answer: stored procedure
Correct Answer: deletes the table structure along with the table data.
Correct Answer: All of the above.
Correct Answer: ORDER BY.
Correct Answer: both of the above can be hidden by an SQL view.
Correct Answer: trigger
Correct Answer: rows can either be inserted into a table one at a time or in groups.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.