Discussion
Home ‣ Database ‣ SQL for Database Construction Comments
- Question
The SQL ALTER statement can be used to:
Options- A. change the table structure.
- B. change the table data.
- C. add rows to the table.
- D. delete rows from the table.
- Correct Answer
- change the table structure.
- 1. 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
- 2. 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
- 3. 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
- 4. 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
- 5. 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
- 6. Which is NOT one of the most common types of SQL CHECK constraints?
Options- A. System date
- B. Range checks
- C. Lists of values
- D. Comparing one column value to another within the same table Discuss
- 7. What is an advantage of placing computations in SQL views?
Options- A. To save users from having to write an expression.
- B. To ensure that the results are consistent.
- C. To accomplish both of the above.
- D. None of the above is correct - computations cannot be placed in a view. Discuss
- 8. The SQL command to create a table is:
Options- A. MAKE TABLE.
- B. ALTER TABLE.
- C. DEFINE TABLE.
- D. CREATE TABLE. Discuss
- 9. A reason for using an SQL view to hide columns is:
Options- A. to simplify a result only.
- B. to prevent the display of sensitive data only.
- C. to accomplish both of the above.
- D. None of the above are reasons for using an SQL view. Discuss
- 10. What SQL structure is used to limit column values of a table?
Options- A. The LIMIT constraint
- B. The CHECK constraint
- C. The VALUE constraint
- D. None of the above is correct. Discuss
SQL for Database Construction problems
Search Results
Correct Answer: rows can either be inserted into a table one at a time or in groups.
Correct Answer: trigger
Correct Answer: both of the above can be hidden by an SQL view.
Correct Answer: ORDER BY.
Correct Answer: All of the above.
Correct Answer: System date
Correct Answer: To accomplish both of the above.
Correct Answer: CREATE TABLE.
Correct Answer: to accomplish both of the above.
Correct Answer: The CHECK constraint
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.