READ Free Dumps For Oracle- 1z0-001
| Question ID 8192 | You want to create a cursor that can be used several times in a block. Selecting a different active set each time that it is opened. Which type of cursor do you create? |
| Option A | A cursor FOR loop. |
| Option B | A multiple selection cursor. |
| Option C | A cursor for each active set. |
| Option D | A cursor that uses parameters |
| Correct Answer | D |
| Question ID 8193 | 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, UU NN NN Nulls/Unique FK table DOCTOR FK column Data type NUM DATE NUMBER VARCHAR2 VARCHAR2 Length 10 25 25 10 You created the patient_id_seq sequence to be used with the patient tables primary key column. The sequence begins at 1000 has a maximum value of 999999999 and increments by 1. You need to write a script to insert a row into the patient table and use the sequence you created. Which script would you use to complete this task? |
| Option A | This task can't be accomplished. |
| Option B | INSERT INTO patient(id_number) VALUES(patient_id_seq.NEXTVALUE) |
| Option C | INSERT INTO patient(id_number, last_name, first_name, Birth_date) VALUES(patient_id_seq, last_name, first_name,birth_date) / |
| Option D | INSERT INTO patient(id_number, last_name, first_name, Birth_date) VALUES(patient_id_seq.NEXTVALUE, &last_name,&first_name, & birth_date) / |
| Option E | INSERT INTO patient(id_number, last_name, first_name, Birth_date) VALUES(patient_id_seq.NEXTVAL, &last_name,&first_name, & birth_date) / |
| Option F | INSERT INTO patient(id_number, last_name, first_name, Birth_date) VALUES(patient_id_seq.CURRVAL, &last_name,&first_name, & birth_date) / |
| Correct Answer | E |