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 8152

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
Explanation Explanation/Reference: Explanation: Answer E is correct because patient_id_seq.NEXTVAL will generate next value of sequence PATIENT_ID_SEQ for the ID_NUMBER column. Incorrect Answers: A: This task can be accomplished using function NEXTVAL. B: NEXTVALUE is wrong function to generate next value for the sequence. D: NEXTVALUE is wrong function to generate next value for the sequence. F: CURRVAL will not generate next value for the sequence, it will show the same value after each insert. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 153-154 Chapter 4: Creating Other Database Objects in Oracle


Question ID 8153

The employee table has ten columns. Since you often query the table with condition based on four or more columns, you created an index on all the columns in the table. Which result will occur?

Option A

Updates on the table will be slower.

Option B

The speed of inserts will be increased.

Option C

All queries on the table will be faster.

Option D

The size of the employee table will be increased.

Correct Answer A
Explanation Explanation/Reference: Explanation: Answer A is correct because if you use index built on ALL columns each DML operation (INSERT, UPDATE, DELETE) will be performed slower than without index. Index will be rebuilt after each DML operation. If table is large it can cause performance issues with this table. Incorrect Answers: B: Inserts will be slower too as all other DML operations. C: DML operations will work slower than without index. D: Index does not increase size of the table. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 169-171 Chapter 4: Creating Other Database Objects in Oracle

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