READ Free Dumps For Oracle- 1z0-001
| Question ID 8065 | You create the sales table with this command CREATE TABLE sale. (purchase-no NUMBER(9) CONSTRAINT sale-purchase-no-pk PRIMARY KEY, costumer-id NUMBER(9) CONSTRAINT sale-customerid-nk NOT NULL); Which index or indexes are created for this table?
|
| Option A | No indexes are created for this table.
|
| Option B | An index is created for purchase_no column.
|
| Option C | An index is created for the customer_no column.
|
| Option D | An index is created for each column.
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct because index will be created for PRIMARY KEY column automatically during table creation. Also index is created for UNIQUE constraint, but this table creation statement does not include any UNIQUE constraint. Incorrect Answers: A: A system index will be created for PRIMARY KEY column. C: An index will not be created for customer_no column. D: Indexes will not be created for EACH column. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 110 Chapter 3: Creating Oracle Database Objects
| Question ID 8066 | How would you add a foreign key constraint on the dept_no column in the EMP table. Referring to the ID column in the DEPT table?
|
| Option A | Use the ALTER TABLE command with the ADD clause in the DEPT table.
|
| Option B | Use the ALTER TABLE command with the ADD clause on the EMP table.
|
| Option C | Use the ALTER TABLE command with the MODIFY clause on the DEPT table.
|
| Option D | Use the ALTER TABLE command with the MODIFY clause on the EMP table.
|
| Option E | This task cannot be accomplished.
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct because constraint will be created for EMP table using ALTER TABLE command. Incorrect Answers: A: Foreign key constraint will not be created for DEPT table, only for EMP table. DEPT table needs to have PRIMARY KEY for successful creation foreign key for EMP table. C: Foreign key constraint will not be created for DEPT table and MODIFY clause is used for different purposes. D: MODIFY clause of ALTER TABLE command is used for different purposes. E: It's possible to add foreign constraint after table creation. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 143 Chapter 4: Creating Other Database Objects in Oracle