Which four are valid Oracle constraint types?

Which four are valid Oracle constraint types? (Choose four.)

Which four are valid Oracle constraint types? (Choose four.)

A.
CASCADE

B.
UNIQUE

C.
NONUNIQUE

D.
CHECK

E.
PRIMARY KEY

F.
CONSTANT

G.
NOT NULL

Explanation:
Oracle constraint type is Not Null, Check, Primary Key, Foreign Key and
Unique
Incorrect answer:
A:
Is not Oracle constraint
C:
Is not Oracle constraint
F:
Is not Oracle constraint
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 10-3

Show Hint

Leave a Reply 2

Your email address will not be published. Required fields are marked *

Hola

Hola

Cascade-
A foreign key with cascade delete means that if a record in the parent table is deleted, then the corresponding records in the child table will automatically be deleted. This is called a cascade delete in SQL Server.

Reply

Hola

Hola

Oracle constraint type is Not Null, Check, Primary Key, Foreign Key and
Unique

Reply