7 JUNE 2021 CURRENT AFFAIRS QUIZ

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

Query results

A relation

Just another table

A view

TRUE ANSWER : ?
YOUR ANSWER : ?

When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL Server does not support the BEFORE trigger.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL ALTER statement can be used to:

add rows to the table.

change the table structure.

delete rows from the table.

change the table data.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

WHERE

ORDER BY

GROUP BY

FROM

TRUE ANSWER : ?
YOUR ANSWER : ?

What is not an advantage of stored procedures?

SQL can be optimized

Increased network traffic

Greater security

Code sharing

TRUE ANSWER : ?
YOUR ANSWER : ?

For what purposes are views used?

To hide complicated SQL statements only

To hide columns only

To hide rows only

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

SQL statements can be embedded in triggers, stored procedures, and program code.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

ALTERNATE KEY

FOREIGN KEY

PRIMARY KEY

UNIQUE

TRUE ANSWER : ?
YOUR ANSWER : ?

What is an advantage of placing computations in SQL views?

To save users from having to write an expression.

None of these

To accomplish both of the above.

To ensure that the results are consistent.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑