AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-001





Question ID 8168

Examine the structure of the department and employee table. There points a line from id PK to dept_id DEPARTMEN Tid PK Name EMPLOYEE id PK Last_ name First_name Dept_id Evaluate this SQL statement: CREATE INDEX emp_dept_id_idx ON employee(dept_id); Which result will this statement provide?

Option A

Store and index in the employee table.

Option B

Increase the chance of full table scans.

Option C

May reduce the amount of disk I/O for select statement.

Option D

May reduce the amount of disk I/O for insert statement.

Option E

Override the unique index created when the PK relation was defined.

Correct Answer C
Explanation Explanation/Reference: Explanation: Answer C is correct because by creating index on DEPT_ID column you will reduce the I/O reads for select statement. Oracle will use index without full scan of DEPARTMENT table. Incorrect Answers: A: Indexes always are stored in tablespace, not in the table. B: Chances for full table scan will be decreased because of index usage, not increased. D: Insert statements may increase the amount of disk I/O because after each insert index will need to be rebuilt for new row. E: New index will not override any unique PRIMARY indexes. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 169-177 Chapter 4: Creating Other Database Objects in Oracle


Question ID 8169

Examine the table instance chart for the patient table. Column id_number last_name first_name birth_date doctor_id name Key type PK NN, U NN NN Nulls/Unique FK table DOCTOR FK column Data type NUM DATE NUMBER VARCHAR2 VARCHAR2 Length 10 25 25 10 You need to create the patient_id_seq sequence to be used with the patient table's primary key column. The sequence will begin with 1000, have a maximum value of 999999999 never reuse any number an increment by 1. Which statement would you use to complete this task?

Option A

CREATE SEQUENCE patient_id_seq START WITH 1000 MAXVALUE 999999999 NO CYCLE:

Option B

CREATE SEQUENCE patient_id_seq START WITH 1000 MAXVALUE 999999999 STEP BY 1;

Option C

CREATE SEQUENCE patient_id_seq ON PATIENT(patient_id) MINVALUE 1000 MAXVALUE 999999999 INCREAMENT BY 1 NO CYCLE;

Option D

This task can't be accomplished.

Correct Answer A
Explanation Explanation/Reference: Explanation: Answer A is correct because keyword NOCYCLE shows that the sequence will not reuse generated values after it reach maximum value of sequence. Incorrect Answers: B: This statement does not use NOCYCLE keyword, so sequences values will be reused after maximum value of sequence. C: This statement is wrong, because sequence exist without any relation with tables. D: This task can be successfully completed with NOCYCLE keyword in the CREATE SEQUENCE. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 153-160 Chapter 4: Creating Other Database Objects in Oracle

Send email to admin@getfreedumps for new dumps request!!!