OCA OCP Oracle Certification Exam Braindumps

1.Click on the EXHIBIT button and examine the table instance chart for the cars table. Which SELECT statement will display style, color, and lot number for all cars based on the model entered at the prompt, regardless of case?
A.SELECT style, color, lot_no FROM cars WHERE model = UPPER('&model');
B.SELECT style, color, lot_no FROM cars WHERE model = '&model';
C.SELECT style, color, lot_no FROM cars WHERE UPPER(model) = UPPER('&model');
D.SELECT style, color, lot_no FROM cars WHERE UPPER(model) = '&model';
Correct:C

2.Click on the EXHIBIT button and examine the table instance chart for the patient table. You need to create the patient_id_seq sequence to be used with the patient table's primary key column. The sequence should begin at 1000, have a maximum value of 999999999, never reuse any numbers, and increment by 1. Which statement would you use to complete this task?
A.CREATE SEQUENCE patient_id_seq START WITH 1000 MAXVALUE 999999999 NOCYCLE;
B.CREATE SEQUENCE patient_id_seq START WITH 1000 MAXVALUE 999999999 STEP BY 1;
C.CREATE SEQUENCE patient_id_seq ON patient (patient_id) MINVALUE 1000 MAXVALUE 999999999 INCREMENT BY 1 NOCYCLE;
D.This task cannot be accomplished.
Correct:A

3.You issue this command: CREATE SYNONYM emp FOR ed.employee; Which task has been accomplished?
A.The need to qualify an object name with its schema was eliminated for user Ed.
B.The need to qualify an object name with its schema was eliminated for only you.
C.The need to qualify an object name with its schema was eliminated for all users.
D.The need to qualify an object name with its schema was eliminated for users with access.
Correct:B

4.Click on the EXHIBIT button and examine the structure of the DEPARTMENT and EMPLOYEE tables. Evaluate this SQL statement: CREATE INDEX emp_dept_id_idx ON employee(dept_id); Which result will the statement provide?
A.Store an index in the EMPLOYEE table.
B.Increase the chance of full table scans.
C.May reduce the amount of disk I/O for SELECT statements.
D.May reduce the amount of disk I/O for INSERT statements.
E.Override the unique index created when the FK relationship was defined.
Correct:C

5.Which should you do after each FETCH statement in a PL/SQL block?
A.Open the cursor.
B.Close the cursor.
C.Initialize the loop.
D.Test for rows using a cursor attribute.
Correct:D

6.Given this executable section of a PL/SQL block: BEGIN FOR employee_record IN salary_cursor LOOP employee_id_table(employee_id) := employee_record.last_name; END LOOP; CLOSE salary_cursor; END; Why does this section cause an error?
A.The cursor needs to be opened.
B.No FETCH statements were issued.
C.Terminating conditions are missing.
D.The cursor does not need to be closed.
Correct:D