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 8087

The PLAYER table contains these columns id number(9) name varchar(2) manager_id number(9) In this instance, managers are players with you need to display a list of players. Evaluate these TWO SQL statements: SELECT p.name,m.name FROM player p,player m WHERE m.id= m.manager_id; SELECT p.name,m.name FROM player p,player m WHERE m.manager_id=p.id; How would the results differ?

Option A

Statement1 will not execute, statement2 will

Option B

Statement1 will execute, statement2 will not.

Option C

Statement1 is self join, statement2 is not

Option D

The results will be same but the display will be different.

Correct Answer D
Explanation Explanation/Reference: Explanation: Answer D is correct because the results of these queries will be same, just will look different. In first statement driving column is ID, in second - MANAGER_ID. Incorrect Answers: A: Both statements will be executed successfully. B: Both statements will be executed successfully. C: Both statements are self join, not only Statement1. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 55-56 Chapter 4: Advanced Data Selection in Oracle


Question ID 8088

How would you declare a PL/SQL table of records to hold the rows selected from the EMP table?

Option A

DECLARE emp-table is TABLE of emp%ROWTYPE.

Option B

BEGIN TYPE emp-table is TABLE of emp%ROWTYPE emp-table emp-table-type;

Option C

DECLARE TYPE emp-table is TABLE of emp%ROWTYPE INDEX BY WHOLE NUMBER; emp-table emp-table-type;

Option D

DECLARE TYPE emp-table-type is TABLE of emp%ROWTYPE INDEX BY BINARY INTEGER; emp-table emp-table-type;

Correct Answer D
Explanation Explanation/Reference: Explanation: Answer D is correct because INDEX BY BINARY INTEGER (clause need to be set for TABLE type. Incorrect Answers: A: INDEX BY clause is not used in definition statement of PL/SQL block. B: INDEX BY clause is not used in definition statement of PL/SQL block. C: INDEX BY clause uses WHOLE NUMBER option, which is incorrect for TABLE type definition. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 392 Chapter 8: Managing Database Objects I

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