31 terms

Oracle 12c SQL CH. 4

STUDY
PLAY
Constraints
...
FOREIGN KEY constraint
...
referential integrity
...
UNIQUE constraint
...
CHECK constraint
...
NOT NULL constraint
...
DISABLE a constraint
...
ENABLE a constraint
...
DROP (constraintname) command
...
What is the difference between a PRIMARY KEY constraint and a UNIQUE constraint?
...
How can you verify the constraints that exist for a table?
...
A table can have a maximum of how many PRIMARY KEY constraints?
...
Which type of constraint can be used to make certain the category for a book is included when a new book is added to inventory?
...
Whcih type of constraint should you use to ensure that every book has a profit margin between 15% and 25%?
...
How is adding a NOT NULL constraints at the table level rather than the column level?
...
To which table do you add a FOREIGN KEY constraint if you want to make certain every book ordered exists in the BOOKS table?
...
What is the difference between disabling a constraint and dropping a constraint?
...
What is the simplest way to determine whether a particular column can contain NULL values?
...
What is the maximum number of PRIMARY KEY constraints allowed for a table?
...
How many NOT NULL constraints can be created at the table level by using the CREATE TABLE command?
...
The FOREIGN KEY constraint should be added to which table?
...
What is the maximum number of columns you can define as a primary key when using the column-level approach to creating a table?
...
What commands can you use to rename a constraint?
...
Which type of constraint should you use on a column to allow entering only values above 100?
...
What commands can be used to enable a disabled constraint?
...
What keywords allows the user to delete a record from a table, even if rows in another table reference the record through a FOREIGN KEY constraint?
...
What data dictionary objects should be used to view information about the constraints in a database?
...
What types of constraints can't be created at the table level?
...
Suppose your created a PRIMARY KEY constraint at the same time you created a table and later decide to name the constraint. What commands can you use to change the constraint's name?
...
You're creating a new table consisting of three columns: Col1, Col2, and Col3. Col1 should be the primary key and can't have any NULL values, and each entry should be unique. Col3 must not contain any NULL values either. How many total constraints do you have to create?
...
What types of restrictions can be viewed with the DESCRIBE command?
...
YOU MIGHT ALSO LIKE...