Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
2. You need to create a composite primary key constraint on the EMPLOYEES table. Which statement is true? Mark for Review
The PRIMARY KEY constraint must be defined at the table level and for each column in the composite primary key.
8. Which type of constraint by default requires that a column be both unique and not null? Mark for Review
10. You need to add a NOT NULL constraint to the EMAIL column in the EMPLOYEES table. Which clause should you use? Mark for Review
11. When dropping a constraint, which keyword(s) specifies that all the referential integrity constraints that refer to the primary and unique keys defined on the dropped columns are dropped as well? Mark for Review
12. You need to add a PRIMARY KEY to the DEPARTMENTS table. Which statement should you use? Mark for Review
13. What is the syntax for removing a PRIMARY KEY constraint and all its dependent constraints? Mark for Review
Using the DELETE command on a row that contains a primary key with a dependent foreign key declared without either an ON DELETE CASCADE or ON DELETE SET NULL. (*)
15. You want to disable the FOREIGN KEY constraint that is defined in the EMPLOYEES table on the DEPARTMENT_ID column. The constraint is referenced by the name FK_DEPT_ID_01. Which statement should you issue? Mark for Review
21. You need to add a NOT NULL constraint to the COST column in the PART table. Which statement should you use to complete this task? Mark for Review
24. Primary Key, Foreign Key, Unique Key and Check Constraints can be added at which two levels? (Choose two) Mark for Review
25. You need to ensure that the LAST_NAME column only contains certain character values. No numbers or special characters are allowed.
You are a member of the SYSDBA role, but are not logged in as SYSDBA. You issue this CREATE TABLE statement. Which statement is true?
28. You are creating the EMPLOYEES table. This table should contain the COMMISSION_PCT column and use a value of 10 percent if no commission value is provided when a record is inserted. Which line should you include in the CREATE TABLE statement to accomplish this task? Mark for Review
29. You want to create a database table that will contain information regarding products that your company released during 2001. Which name can you assign to the table that you create? Mark for Review
30. Which of the following SQL statements will create a table called Birthdays with three columns for storing employee number, name and date of birth? Mark for Review
33. You are designing a table for the Human Resources department. This table must include a column that contains each employee's hire date. Which data type should you specify for this column? Mark for Review
35. A column that will be used to store binary data up to 4 Gigabyes in size should be defined as which datatype? Mark for Review
36. To store time with fractions of seconds, which datatype should be used for a table column? Mark for Review
38. You need to store the HIRE_DATE value with a time zone displacement value and allow data to be returned in the user's local session time zone. Which data type should you use? Mark for Review
40. The previous administrator created a table named CONTACTS, which contains outdated data. You want to remove the table and its data from the database. Which statement should you issue? Mark for Review
41. You need to remove all the rows from the SALES_HIST table. You want to release the storage space, but do not want to remove the table structure. Which statement should you use? Mark for Review
The EMPLOYEE_ID column currently contains 500 employee identification numbers. Business requirements have changed and you need to allow users to include text characters in the identification values. Which statement should you use to change this column's data type?
44. Your supervisor has asked you to modify the AMOUNT column in the ORDERS table. He wants the column to be configured to accept a default value of 250. The table constains data that you need to keep. Which statement should you issue to accomplish this task? Mark for Review
45. You need to change the name of the EMPLOYEES table to the EMP table. Which statement should you use? Mark for Review
Which statement should you use to decrease the width of the FIRST_NAME column to 10 if the column currently contains 1500 records, but none are longer than 10 bytes or characters?
48. To do a logical delete of a column without the performance penalty of rewriting all the table datablocks you can issue the following command: Mark for Review
49. Which command could you use to quickly remove all data from the rows in a table without deleting the table itself? Mark for Review
The TEAMS table is currently empty. You need to allow users to include text characters in the manager identification values. Which statement should you use to implement this?