Exam 4: Constraints

The ____________________ keywords can be added to the end of the command that creates a FOREIGN KEY constraint to indicate that when a row is deleted from the parent table that is referenced by entries in the child table, the rows in the child table should also be deleted.

(Short Answer)

4.8/5

(35)

Question 41

The ____________________ command can be used to enable or disable a constraint.

(Short Answer)

5.0/5

(39)

Question 42

When a constraint is created at the table level, the constraint definition is provided ____ the column definition list.

(Multiple Choice)

4.7/5

(38)

Question 43

A constraint name can consist of up to $\underline { 25 }$ characters and numbers. _________________________

(True/False)

4.8/5

(36)

Question 44

The $\underline {\text { REFERENCE } }$ constraint is used to ensure that a data value meets a specified condition before a record is added to a table. _________________________

(True/False)

4.9/5

(33)

Question 45

Which of the following statements about the FOREIGN KEY constraint is incorrect?

(Multiple Choice)

4.9/5

(33)

Question 46

The UNIQUE constraint differs from the PRIMARY KEY constraint in what way?

(Multiple Choice)

4.9/5

(46)

Question 47

The ____________________ view can be used to list the names of the constraints that exist for all tables owned by the user.

(Short Answer)

4.9/5

(39)

Question 48

In the USER_CONSTRAINTS view, the value displayed in the CONSTRAINT_TYPE column will be a(n) ____ for a FOREIGN KEY constraint.

(Multiple Choice)

5.0/5

(39)

Question 49

What is the relationship between a NOT NULL constraint and a CHECK constraint?

(Essay)

4.9/5

(48)

Question 50

The FOREIGN KEY constraint is usually placed on the $\underline { \text { "one" } }$ side of a one-to-many relationship. _________________________

(True/False)

4.7/5

(33)

Question 51

A PRIMARY KEY constraint will make certain the column designated as the primary key does not contain a NULL value.

(True/False)

4.9/5

(34)

Question 52

The data $\underline { \text { warehouse } }$ contains information about objects included in the database. _________________________

(True/False)

4.8/5

(34)

Question 53

If the ____ keyword is included when a constraint is created, a constraint name must be provided by the user.

(Multiple Choice)

4.8/5

(31)

Question 54

Structure of the PROMOTION table -Which of the following commands will add a UNIQUE constraint to the MINRETAIL column of the PROMOTION table?

(Multiple Choice)

4.8/5

(33)

Question 55

In a "one-to-many" relationship, which constraint is usually added to the "many" table?

(Multiple Choice)

4.7/5

(32)

Question 56

The $\underline { ADD }$ clause of the ALTER TABLE command is used to add a PRIMARY KEY constraint to an existing table. _________________________

(True/False)

4.9/5

(30)

Question 57

Structure of the ORDERITEMS table -If a PRIMARY KEY constraint, named ORDERITEMS_PK, exists for the ORDER# and ITEM# columns of the ORDERITEMS table, which of the following commands will drop the constraint?

(Multiple Choice)

4.9/5

(43)

Question 58

The ____________________ TABLE command is used to add a PRIMARY KEY constraint to an existing table.

(Short Answer)

5.0/5

(36)

Question 59

How can constraints be added to a table?

(Multiple Choice)

4.9/5

(39)

Question 60

Showing 41 - 60 of 132

The ____________________ keywords can be added to the end of the command that creates a FOREIGN KEY constraint to indicate that when a row is deleted from the parent table that is referenced by entries in the child table, the rows in the child table should also be deleted.

The ____________________ command can be used to enable or disable a constraint.

When a constraint is created at the table level, the constraint definition is provided ____ the column definition list.

A constraint name can consist of up to $\underline { 25 }$ characters and numbers. _________________________

The $\underline {\text { REFERENCE } }$ constraint is used to ensure that a data value meets a specified condition before a record is added to a table. _________________________

Which of the following statements about the FOREIGN KEY constraint is incorrect?

The UNIQUE constraint differs from the PRIMARY KEY constraint in what way?

The ____________________ view can be used to list the names of the constraints that exist for all tables owned by the user.

In the USER_CONSTRAINTS view, the value displayed in the CONSTRAINT_TYPE column will be a(n) ____ for a FOREIGN KEY constraint.

What is the relationship between a NOT NULL constraint and a CHECK constraint?

The FOREIGN KEY constraint is usually placed on the $\underline { \text { "one" } }$ side of a one-to-many relationship. _________________________

A PRIMARY KEY constraint will make certain the column designated as the primary key does not contain a NULL value.

The data $\underline { \text { warehouse } }$ contains information about objects included in the database. _________________________

If the ____ keyword is included when a constraint is created, a constraint name must be provided by the user.

Structure of the PROMOTION table -Which of the following commands will add a UNIQUE constraint to the MINRETAIL column of the PROMOTION table?

In a "one-to-many" relationship, which constraint is usually added to the "many" table?

The $\underline { ADD }$ clause of the ALTER TABLE command is used to add a PRIMARY KEY constraint to an existing table. _________________________

Structure of the ORDERITEMS table -If a PRIMARY KEY constraint, named ORDERITEMS_PK, exists for the ORDER# and ITEM# columns of the ORDERITEMS table, which of the following commands will drop the constraint?

The ____________________ TABLE command is used to add a PRIMARY KEY constraint to an existing table.

How can constraints be added to a table?

Overview of Database Concepts

Basic Sql Select Statements

Table Creation and Management

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

Exam 4: Constraints

The ____________________ keywords can be added to the end of the command that creates a FOREIGN KEY constraint to indicate that when a row is deleted from the parent table that is referenced by entries in the child table, the rows in the child table should also be deleted.

The ____________________ command can be used to enable or disable a constraint.

When a constraint is created at the table level, the constraint definition is provided ____ the column definition list.

A constraint name can consist of up to 25‾\underline { 25 }25​ characters and numbers. _________________________

The REFERENCE ‾\underline {\text { REFERENCE } } REFERENCE ​ constraint is used to ensure that a data value meets a specified condition before a record is added to a table. _________________________

Which of the following statements about the FOREIGN KEY constraint is incorrect?

The UNIQUE constraint differs from the PRIMARY KEY constraint in what way?

The ____________________ view can be used to list the names of the constraints that exist for all tables owned by the user.

In the USER_CONSTRAINTS view, the value displayed in the CONSTRAINT_TYPE column will be a(n) ____ for a FOREIGN KEY constraint.

What is the relationship between a NOT NULL constraint and a CHECK constraint?

The FOREIGN KEY constraint is usually placed on the "one" ‾\underline { \text { "one" } } "one" ​ side of a one-to-many relationship. _________________________

A PRIMARY KEY constraint will make certain the column designated as the primary key does not contain a NULL value.

The data warehouse ‾\underline { \text { warehouse } } warehouse ​ contains information about objects included in the database. _________________________

If the ____ keyword is included when a constraint is created, a constraint name must be provided by the user.

Structure of the PROMOTION table -Which of the following commands will add a UNIQUE constraint to the MINRETAIL column of the PROMOTION table?

In a "one-to-many" relationship, which constraint is usually added to the "many" table?

The ADD‾\underline { ADD }ADD​ clause of the ALTER TABLE command is used to add a PRIMARY KEY constraint to an existing table. _________________________

Structure of the ORDERITEMS table -If a PRIMARY KEY constraint, named ORDERITEMS_PK, exists for the ORDER# and ITEM# columns of the ORDERITEMS table, which of the following commands will drop the constraint?

The ____________________ TABLE command is used to add a PRIMARY KEY constraint to an existing table.

How can constraints be added to a table?

Overview of Database Concepts

Basic Sql Select Statements

Table Creation and Management

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

A constraint name can consist of up to $\underline { 25 }$ characters and numbers. _________________________

The $\underline {\text { REFERENCE } }$ constraint is used to ensure that a data value meets a specified condition before a record is added to a table. _________________________

The FOREIGN KEY constraint is usually placed on the $\underline { \text { "one" } }$ side of a one-to-many relationship. _________________________

The data $\underline { \text { warehouse } }$ contains information about objects included in the database. _________________________

The $\underline { ADD }$ clause of the ALTER TABLE command is used to add a PRIMARY KEY constraint to an existing table. _________________________