READ Free Dumps For Oracle- 1z0-007
| Question ID 7867 | Which statement explicitly names a constraint?
|
| Option A | ALTER TABLE student_grades ADD FOREIGN KEY (student_id) REFERENCES students (student_id);
|
| Option B | ALTER TABLE student_grades ADD CONSTRAINT NAME = student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);
|
| Option C | ALTER TABLE student_grades ADD CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);
|
| Option D | ALTER TABLE student grades ADD NAMED CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);
|
| Option E | ALTER TABLE student grades ADD NAME student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: This statement provides correct syntax to add a foreign key constraint to the existing table. Incorrect Answers A: The ADD FOREIGN KEY is wrong construction to add a foreign key constraint to the existing table. B: The ADD CONSTRAINT NAME is wrong construction to add a foreign key constraint to the existing table. D: The ADD NAMED CONSTRAINT is wrong construction to add a foreign key constraint to the existing table. E: The ADD NAME is wrong construction to add a foreign key constraint to the existing table. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 238-239 Chapter 5: Creating Oracle Database Objects
| Question ID 7868 | Examine the SQL statements that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL STATUS VARCHARD2(10) CHECK (status IN ('CREDIT','CASH')), PROD_ID_NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order id, order date)); For which columns would an index be automatically created when you execute the aboveSQL statement? (Choose two)
|
| Option A | SER_NO
|
| Option B | ORDER_ID
|
| Option C | STATUS
|
| Option D | PROD_ID
|
| Option E | ORD_TOTAL
|
| Option F | Composite index on ORDER_ID and ORDER_DATE
|
| Correct Answer | AF |
Explanation Explanation/Reference: Explanation: Indexes are created automatically by Oracle to support integrity constraints that enforce uniqueness. The two types of integrity constraints that enforce uniqueness are PRIMARY KEY and UNIQUE constraints. When the primary key or UNIQUE constraint is declared, a unique index to support the column's uniqueness is also created, and all values in all columns that were defined as part of the primary key or UNIQUE constraint are placed into the index. Incorrect Answers B: There will not be index for ORDER_ID column. C: There will not be index for STATUS column. D: There will not be index for PROD_ID column. E: There will not be index for ORD_TOTAL column. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 237-238 Chapter 5: Creating Oracle Database Objects