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 |
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 |