SQL for Database Construction Questions and Answers

Practice Mode
Showing 10 of 19 questions
Q11
When using the SQL INSERT statement:
  • 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.
Answer: Option D
Q12
What is not an advantage of stored procedures?
  • A Greater security
  • B SQL can be optimized
  • C Code sharing
  • D Increased network traffic
Answer: Option D
Q13
A reason for using an SQL view to hide columns is:
  • 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.
Answer: Option C
Q14
Which of the following is an SQL trigger supported by Oracle?
  • A BEFORE
  • B INSTEAD OF
  • C AFTER
  • D All of the above
Answer: Option D
Q15
The SQL ALTER statement can be used to:
  • A change the table structure.
  • B change the table data.
  • C add rows to the table.
  • D delete rows from the table.
Answer: Option A
Q16
What SQL structure is used to limit column values of a table?
  • A The LIMIT constraint
  • B The CHECK constraint
  • C The VALUE constraint
  • D None of the above is correct.
Answer: Option B
Q17
Which is NOT one of the most common types of SQL CHECK constraints?
  • A System date
  • B Range checks
  • C Lists of values
  • D Comparing one column value to another within the same table
Answer: Option A
Q18
What is an advantage of placing computations in SQL views?
  • 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.
Answer: Option C
Q19
Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:
  • A GROUP BY.
  • B WHERE.
  • C ORDER BY.
  • D FROM.
Answer: Option C

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test