IndiaBIX

Database - SQL for Database Construction

Exercise : SQL for Database Construction - General Questions
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.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
12.
What is not an advantage of stored procedures?
Greater security
SQL can be optimized
Code sharing
Increased network traffic
Answer: Option
Explanation:
No answer description is available. Let's discuss.
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.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
14.
Which of the following is an SQL trigger supported by Oracle?
BEFORE
INSTEAD OF
AFTER
All of the above.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
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.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers