Computer Science: Constraints

If a FOREIGN KEY constraint is displayed in the USER_CONSTRAINTS view, the constraint type will have the letter ____________________ displayed.​

With the exception of the NOT NULL constraint, constraints can be added to a table using the ADD clause of the ALTER TABLE command.​

The SYSDATE can be used as a condition in a CHECK constraint.​

Only one ____ constraint can exist for each table.​

The default name for a constraint is SYS Cn where n consists of a number that will make the name unique within the database. _________________________​

A(n) ____________________ is a rule imposed on data stored in a database in order to ensure its integrity of the data.​

​ Which of the following is the standard abbreviation for the constraint FOREIGN KEY?

The CONSTRAINT keyword is required if the user is going to assign a name to a constraint.​

The ____ constraint requires that a specific condition be met before a record can be added to a table.​

If a(n) FOREIGN KEY constraint has been created for a table, it means the data values in that column must be unique and cannot contain NULL values. _________________________​

Which view will display the names of all the constraints that you own?​

Constraints are used to ensure the accuracy and integrity of the data contained in the database.​

Which of the following types of constraints is used to enforce referential integrity?​

A(n) ____________________ constraint requires that, if an entry is made into the column, the data value must be unique.​

​Structure of the ORDERITEMS table Based on the structure of the ORDERITEMS table, which of the following commands was most likely used to create the table?​

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

The ALTER TABLE command with the MODIFY clause can be used to disable a constraint. _________________________​

A NOT NULL constraint can be added to an existing table using the ALTER TABLE command with the ____________________ clause.​

A NOT NULL constraint is a special FOREIGN KEY constraint.​

​ Where does the Oracle 12c server store information about objects in the database, including information about constraints?

Which keywords identify a column that, if it contains a value, it must match data contained in another table?​

Which of the following constraints cannot be added to an existing table with the ADD clause of the ALTER TABLE command?​

The ____ constraint requires that a specific condition be met before a record can be added to a table.​

A(n) NOT NULL constraint is a special CHECK constraint with the condition of IS NOT NULL. _________________________​

A CHECK constraint requires that a data value meet a certain condition before the record is added to the database table.​

A referential integrity constraint is usually placed on the ____________________ side of a one-to-many relationship.​

A constraint can be added to a table after the table has been populated with data even if the existing data violates the constraint.​

A constraint is always enforced at the table level.​

​ Which of the following statements about creating constraints is incorrect?​

A(n) FOREIGN KEY constraint can only reference a column in the parent table that has been designated as the primary key for that table. _________________________​

The ALTER TABLE command can be used to delete an existing constraint. _________________________​

If a(n) ____________________ constraint is being dropped, then only the type of constraint needs to be identified in the ALTER TABLE because there can only be one such constraint for each table.​

Only one PRIMARY KEY constraint can exist for each table.​

Which of the following statements about creating constraints is incorrect?​

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

A PRIMARY KEY constraint can be added to an existing table by using the ____ clause of the ALTER TABLE command.​

​Structure of the ORDERITEMS table Based on the structure of the ORDERITEMS table, which of the following commands will make certain that the ISBN entered actually exists in the ISBN column of the BOOKS table?​

A(n) UNIQUE constraint will allow NULL values to be stored in the designated column. _________________________​

Which of the following is the standard abbreviation for the constraint NOT NULL?​

When a FOREIGN KEY constraint is being created, the REFERENTIAL keyword is used to indicate the table being referenced. _________________________​

With the exception of the NOT NULL constraint, constraints can be added to a table using the ADD clause of the ALTER TABLE command.​

Which of the following types of constraints is used to enforce referential integrity?​

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

In the USER_CONSTRAINTS view, the constraint type for a PRIMARY KEY constraint will be listed as PK.​

The MODIFY clause is used with the ALTER TABLE command to add a PRIMARY KEY constraint to an existing table.​

A FOREIGN KEY constraint will not allow a row containing a NULL value in the foreign key column to be added to the table.​

A foreign key constraint can only be created at the column level.​

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

Each column can only be included in one constraint.​

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

The NOT NULL constraint can only be created at the ____ level.​

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

Which keywords identify a column that, if it contains a value, it must match data contained in another table?​

A FOREIGN KEY constraint can be added to the column of a table to ensure that the referenced data value actually exists in the other table.​

The table level approach can be used to create any constraint, except a CHECK constraint.​

When dropping a(n) PRIMARY KEY constraint, the name of the column does not need to be included in the ALTER TABLE command. _________________________​

A(n) constraint can be created during the creation of a database table or added to a table afterwards. _________________________​

​Structure of the ORDERITEMS table If the constraints on the ORDER# and ITEM# columns of the ORDERITEMS table were created as a PRIMARY constraint, and the actual constraint name is not known, which of the following commands can be used to delete the constraint?​

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.​

Referential ____________________ means that the user is referring to something that actually exists in the referenced table.​

Which of the following are used to enforce business rules?​

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 disable the constraint?​

Which of the following keywords must have been included during the creation of a FOREIGN KEY constraint to allow a row from the parent table to be deleted, even if it is referenced by a row in the child table?​

Any constraint can be created at the table or the column level.​

Unless a PRIMARY KEY or a(n) ____________________ constraint is being dropped, the actual name assigned to the constraint must be included in the ALTER TABLE command.​

If a data value violates a(n) constraint, the entire row is prevented from being added to the table. _________________________​

Which clause will allow you to disable a constraint?​

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

A NOT NULL constraint can only be created at the table level. _________________________​

The purpose of the ____ constraint is to ensure that two records do not have the same value stored in the same column. However, it can contain NULL values.​

​Structure of the ORDERITEMS table Based on the structure of the ORDERITEMS table, which of the following commands was most likely used to create the table?​

The REFERENCE constraint is used to ensure that a data value meets a specified condition before a record is added to a table. _________________________​

​Structure of the PROMOTION table Based on the structure of the PROMOTION table, which of the following commands will add a PRIMARY KEY constraint to the GIFT column?​

Which command can be used to determine whether or not a column is allowed to contain a NULL value?​

​Structure of the PROMOTION table Based on the structure of the PROMOTION table, which of the following commands will add a PRIMARY KEY constraint to the GIFT column?​

A NOT NULL constraint will display the search condition of ____________________ in the USER_CONSTRAINTS view.​

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

A FOREIGN KEY constraint can only reference a column in another table that has been assigned a(n) ____ constraint.​

The ____________________ clause of the ALTER TABLE command is used to add a PRIMARY KEY constraint to an existing table.​

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

A NOT NULL constraint can only be created at the column level.​

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

​Structure of the ORDERITEMS table Based on the structure of the ORDERITEMS table, which of the following commands will add a NOT NULL constraint to the ISBN column?​

Which clause will allow you to delete a constraint?​

​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 disable the constraint?​

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

A primary key is usually given the abbreviation _pk in the constraint name if the name is assigned by the user.​

If a(n) ____________________ constraint is being dropped, then only the type of constraint and the column name need to be included in the DROP clause of the ALTER TABLE command.​

If the Oracle 12c server assigns a name to a constraint, it will use the format ____________________ for the constraint name.​

A Datatype is a rule used to ensure the accuracy of data stored in a database. _________________________​

A(n) ____________________ constraint is a special CHECK constraint with the condition of IS NOT NULL.​

Any type of constraint can be created at the ____________________ level, unless the constraint is being defined for more than one column.​

The ALTER TABLE command with the ENABLE clause can be used to enable a constraint.​

A quick way to determine whether a column can contain a NULL value is to issue the ____________________ command, followed by the table name.​

If a constraint applies to more than one column, the constraint must be created at the ____ level.​

A PRIMARY KEY that consists of more than one column is called a(n) ____ key.​

In the USER_CONSTRAINTS view, the constraint type for a NOT NULL constraint will be listed as N. _________________________​

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

When dropping a constraint, the user is always required to specify the name of the constraint being dropped.​

The FOREIGN KEY constraint is usually placed on the "one" side of a one-to-many relationship. _________________________​

The ALTER TABLE command can be used to disable a constraint.​

What is the syntax for the default constraint name provided by the Oracle 12c server?​

Unless a PRIMARY KEY or a(n) ____________________ constraint is being dropped, the actual name assigned to the constraint must be included in the ALTER TABLE command.​

If a FOREIGN KEY constraint exists, then a record cannot be deleted from the parent table if that row is referenced by an entry in the child table.​

A constraint for a composite primary key must be created at the table level.​

Which of the following types of constraints will not allow NULL values?​

​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 ____________________ clause of the ALTER TABLE command must be used to drop an existing constraint.​

If a user is going to assign a name to a constraint, the ____________________ keyword must be included in the command.​

Any type of constraint for a single column can be created at the column level. _________________________​

A constraint can be renamed using the ALTER TABLE command.​

A maximum of ____________________ PRIMARY KEY constraints can exist for each database table.​

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

​Structure of the ORDERITEMS table If a PRIMARY KEY constraint, named ORDERITEMS_PK, for the ORDER# and ITEM# columns of the ORDERITEMS table have been disabled, which of the following commands will enable the constraint?​

Structure of the ORDERITEMS table Based on the structure of the ORDERITEMS table, which of the following commands will add a NOT NULL constraint to the ISBN column?​

Which of the following statements about a PRIMARY KEY is incorrect?​

​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 ____ constraint prevents the user from adding a NULL value in the specified column.​

​Structure of the ORDERITEMS table Based on the structure of the ORDERITEMS table, which of the following commands will make certain that the ISBN entered actually exists in the ISBN column of the BOOKS table?​

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

A constraint name can consist of up to 25 characters and numbers. _________________________​

When a constraint is created at the ____ level with the CREATE TABLE command, the constraint definition is simply included as part of the column definition.​

A UNIQUE constraint is the same as a PRIMARY KEY constraint, except that it will accept NULL values.​