Practice SQL For Database Construction Multiple Choice Questions Quiz-2 - MCQGeeks.com

Q.1

SQL Server does not support the BEFORE trigger.

True
False

Q.2

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.

Q.3

Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:

GROUP BY
WHERE
ORDER BY
FROM

Q.4

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.

Q.5

What is not an advantage of stored procedures?

Greater security
SQL can be optimized
Code sharing
Increased network traffic

Q.6

The SQL statement used to create a view is CREATE VIEW.

True
False

Q.7

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.

Q.8

Which of the following is an SQL trigger supported by Oracle?

BEFORE
INSTEAD OF
AFTER
All of the above.

Q.9

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.

Q.10

To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:

a particular column in a particular underlying table.
a particular column in a particular row.
a particular row in a particular underlying table.
None of the above is correct.

Q.11

Which of the following is NOT a type of SQL constraint?

PRIMARY KEY
FOREIGN KEY
ALTERNATE KEY
UNIQUE

Q.12

A ________ is a program that performs some common action on database data and that is stored in the database.

trigger
stored procedure
pseudofile
None of the above is correct.

Q.13

For what purposes are views used?

To hide columns only
To hide rows only
To hide complicated SQL statements only
All of the above are uses for SQL views.

Q.14

What is an SQL virtual table that is constructed from other tables?

Just another table
A view
A relation
Query results

0 h : 0 m : 1 s