Question 1

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

Accepted Answer

The answer of The ____________________ TABLE command is used to...

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Explain the similarities and differences between the UNIQUE and PRIMARY KEY constraints.​

Accepted Answer

Both constraints will ensure that no dup

Question 4

Which clause will allow you to delete a constraint?​

Accepted Answer

A)  ​DROP 
B)  ​DISABLE 
C)  ​DELETE 
D)  ​MODIFY 
A)  ​DROP 
B)  ​DISABLE 
C)  ​DELETE 
D)  ​MODIFY

Question 5

Which clause will allow you to disable a constraint?​

Accepted Answer

A)  ​MODIFY 
B)  ​DROP 
C)  ​DISABLE 
D)  ​STOP 
A)  ​MODIFY 
B)  ​DROP 
C)  ​DISABLE 
D)  ​STOP

Question 6

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

Accepted Answer

The answer of A(n)____________________ constraint requires that,if an entry is...

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A)  ​C 
B)  ​K 
C)  U​ 
D)  ​R 
A)  ​C 
B)  ​K 
C)  U​ 
D)  ​R

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

The answer of Referential ____________________ means that the user is...

Question 11

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

Accepted Answer

A)  ​CREATE TABLE orderitems
(order# NUMBER (4)PRIMARY KEY,
Item# NUMBER(2)PRIMARY KEY,
Isbn VARCHAR2(10),
Qty NUMBER(3)); 
B)  ​CREATE TABLE orderitems
(order# NUMBER (4),
Item# NUMBER(2),
Isbn VARCHAR2(10),
Qty NUMBER(3),
NOT NULL (order#,item#)); 
C)  ​CREATE TABLE orderitems
(order# NUMBER (4),
Item# NUMBER(2),
Isbn VARCHAR2(10),
Qty NUMBER(3),
PRIMARY KEY(order#,item#)); 
D)  ​CREATE TABLE orderitems
(order# NUMBER (4),
Item# NUMBER(2),
Isbn VARCHAR2(10),
Qty NUMBER(3),
PRIMARY KEY(order#),
PRIMARY KEY(order#)); 
A)  ​CREATE TABLE orderitems
(order# NUMBER (4)PRIMARY KEY,
Item# NUMBER(2)PRIMARY KEY,
Isbn VARCHAR2(10),
Qty NUMBER(3)); 
B)  ​CREATE TABLE orderitems
(order# NUMBER (4),
Item# NUMBER(2),
Isbn VARCHAR2(10),
Qty NUMBER(3),
NOT NULL (order#,item#)); 
C)  ​CREATE TABLE orderitems
(order# NUMBER (4),
Item# NUMBER(2),
Isbn VARCHAR2(10),
Qty NUMBER(3),
PRIMARY KEY(order#,item#)); 
D)  ​CREATE TABLE orderitems
(order# NUMBER (4),
Item# NUMBER(2),
Isbn VARCHAR2(10),
Qty NUMBER(3),
PRIMARY KEY(order#),
PRIMARY KEY(order#));

Question 12

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

Accepted Answer

The answer of The ____________________ command can be used to...

Question 13

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

Accepted Answer

A)  ​NOT NULL 
B)  ​UNIQUE 
C)  ​CHECK 
D)  ​none of the above 
A)  ​NOT NULL 
B)  ​UNIQUE 
C)  ​CHECK 
D)  ​none of the above

Question 14

How can constraints be added to a table?​

Accepted Answer

A)  ​as part of the CREATE TABLE command 
B)  ​as part of the ALTER TABLE command 
C)  ​as part of the PRIMARY KEY command 
D)  ​both a and b 
A)  ​as part of the CREATE TABLE command 
B)  ​as part of the ALTER TABLE command 
C)  ​as part of the PRIMARY KEY command 
D)  ​both a and b

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A)  ​It identifies which column(s)uniquely identify each record. 
B)  ​It can be NULL,as long as the FOREIGN KEY contains a value. 
C)  ​Each data value must be unique. 
D)  ​none of the above 
A)  ​It identifies which column(s)uniquely identify each record. 
B)  ​It can be NULL,as long as the FOREIGN KEY contains a value. 
C)  ​Each data value must be unique. 
D)  ​none of the above

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

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

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

Explain the similarities and differences between the UNIQUE and PRIMARY KEY constraints.

Which clause will allow you to delete a constraint?

Which clause will allow you to disable a constraint?

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

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

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

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

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

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 ____________________ command can be used to enable or disable a constraint.

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

How can constraints be added to a table?

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

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

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

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

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

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.

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 ____________________ TABLE command is used to add a PRIMARY KEY constraint to an existing table.​

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

Explain the similarities and differences between the UNIQUE and PRIMARY KEY constraints.​

Which clause will allow you to delete a constraint?​

Which clause will allow you to disable a constraint?​

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

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

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

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

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

​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 ____________________ command can be used to enable or disable a constraint.​

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

How can constraints be added to a table?​

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

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

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

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

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

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

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

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

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

Explain the similarities and differences between the UNIQUE and PRIMARY KEY constraints.

Which clause will allow you to delete a constraint?

Which clause will allow you to disable a constraint?

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

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

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

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

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

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 ____________________ command can be used to enable or disable a constraint.

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

How can constraints be added to a table?

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

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

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

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

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

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.