Exercise: Sql For Database Construction And Application Processing

Questions for: Sql For Database Construction And Application Processing

Which of the following is an SQL trigger supported by Oracle?
A:
BEFORE
B:
INSTEAD OF
C:
AFTER
D:
All of the above.
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
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: C
No answer description is available. Let's discuss.
📖
📝
💬
👁️
What is not an advantage of stored procedures?
A:
Greater security
B:
SQL can be optimized
C:
Code sharing
D:
Increased network traffic
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
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: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
What is an SQL virtual table that is constructed from other tables?
A:
Just another table
B:
A view
C:
A relation
D:
Query results
Answer: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Ad Slot (Above Pagination)
Quiz