Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
Section 1
1. The employees table contains a foreign key column department_id that references the id column in the departments table. Which of the following constraint modifiers will NOT allow the deletion of id values in the department table?Mark for Review
(1) Points
ON DELETE CASCADE
ON DELETE SET NULL
Neither A nor B (*)
Both A and B
2. The table that contains the Primary Key in a Foreign Key Constraint is known as:Mark for Review
(1) Points
Child Table
Parent Table (*)
Detail Table
Mother and Father Table
3. If a Primary Key is made up of more than one column, one of the columns can be null. True or False?Mark for Review
(1) Points
True
False (*)
4. The main reason that constraints are added to a table is:Mark for Review
(1) Points
Constraints add a level of complexity
Constraints ensure data integrity (*)
Constraints gives programmers job security
None of the Above
5. A composite primary key may only be defined at the table level. True or False?Mark for Review
(1) Points
True (*)
False
6. To automatically delete rows in a child table when a parent record is deleted use:Mark for Review
(1) Points
ON DELETE SET NULL
ON DELETE ORPHAN
ON DELETE CASCADE (*)
None of the Above
7. The number of check constraints that can be defined on a column is:Mark for Review
(1) Points
10
5
100
There is no limit (*)
8. A Primary Key that is made up of more than one column is called a:Mark for Review
(1) Points
Multiple Primary Key
Composite Primary Key (*)
Double Key
Primary Multi-Key
None of the Above
9. An example of adding a check constraint to limit the salary that an employee can earn is:Mark for Review
(1) Points
ALTER TABLE employees ADD CONSTRAINT emp_salary_ck SALARY <>
*OBS: Se pare ca a aparut o noua intrebare : Which line of the following code will cause an error:
1. CREATE TABLE clients
2. (client_number NUMBER(4) CONSTRAINT client_client_num_pk PRIMARY KEY client_number),
3. first_name VARCHAR2(14),
4. last_name VARCHAR2(13),
right answer, 2.
