Database - SQL for Database Construction
Database - SQL for Database Construction
11. When using the SQL INSERT statement:
- rows can be modified according to criteria only.
- rows cannot be copied in mass from one table to another only.
- rows can be inserted into a table only one at a time only.
- rows can either be inserted into a table one at a time or in groups.
12. What is not an advantage of stored procedures?
- Greater security
- SQL can be optimized
- Code sharing
- Increased network traffic
13. A reason for using an SQL view to hide columns is:
- to simplify a result only.
- to prevent the display of sensitive data only.
- to accomplish both of the above.
- None of the above are reasons for using an SQL view.
14. Which of the following is an SQL trigger supported by Oracle?
- BEFORE
- INSTEAD OF
- AFTER
- All of the above
15. The SQL ALTER statement can be used to:
- change the table structure.
- change the table data.
- add rows to the table.
- delete rows from the table.
16. What SQL structure is used to limit column values of a table?
- The LIMIT constraint
- The CHECK constraint
- The VALUE constraint
- None of the above is correct.
17. Which is NOT one of the most common types of SQL CHECK constraints?
- System date
- Range checks
- Lists of values
- Comparing one column value to another within the same table
18. What is an advantage of placing computations in SQL views?
- To save users from having to write an expression.
- To ensure that the results are consistent.
- To accomplish both of the above.
- None of the above is correct - computations cannot be placed in a view.
19. Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:
- GROUP BY.
- WHERE.
- ORDER BY.
- FROM.