GENERATION OF ELECTRICAL ENERGY QUIZ

There are three SQL data modification operations: insert, modify and delete.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

For what purposes are views used?

To hide columns only

To hide complicated SQL statements only

To hide rows only

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A ________ is a stored program that is attached to a table or a view.

pseudofile

embedded SELECT statement

trigger

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

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

None of these

a particular row in a particular underlying table.

a particular column in a particular underlying table.

a particular column in a particular row.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

PRIMARY KEY

FOREIGN KEY

ALTERNATE KEY

UNIQUE

TRUE ANSWER : ?
YOUR ANSWER : ?

Common types of SQL CHECK constraints include range checks and limiting columns values.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL DELETE statement is used to delete both the table structure and table data.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A benefit of using a stored procedure is that it can be distributed to client computers.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑