CONTROL SYSTEMS QUIZ

Changing cardinalities in a database is:

a database design task that never occurs.

a common database design task.

is impossible to do, so a new database must be constructed and the data moved into it.

a rare database design task, but does occur.

TRUE ANSWER : ?
YOUR ANSWER : ?

Although creating test databases is a critical and necessary job, there are few career opportunities in this area.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

It is not easy to build a database correctly the first time.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following modifications may not succeed?

Neither of the above actions will succeed

Changing a column data type from numeric to char

Both of the above actions should succeed

Changing a column data type from char to date

TRUE ANSWER : ?
YOUR ANSWER : ?

The NOT EXISTS keyword will be true if any row in the subquery meets the condition.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Dependency graphs are diagrams that consist of nodes and arcs that show the dependencies of a database.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Adding null columns to a table is straightforward.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A correlated subquery is processed as a nested subquery.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?

None of these

ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);

ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0);

ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);

TRUE ANSWER : ?
YOUR ANSWER : ?

What SQL command can be used to delete columns from a table?

ALTER TABLE TableName DROP COLUMN ColumnName

MODIFY TABLE TableName DROP ColumnName

MODIFY TABLE TableName DROP COLUMN ColumnName

ALTER TABLE TableName DROP ColumnName

TRUE ANSWER : ?
YOUR ANSWER : ?

↑