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 1504

Examine the table structures:

EMP Table
Name Null? Type        
        
EMPNO NOT NULL NUMBER(4)
NAME VARCHAR2(10)
JOB VARCHAR2(9)
MGR NUMBER(4)
HIREDATE DATE
SALARY NUMBER(7,2)
COMM NUMBER(7,2)
DEPTNO NOT NULL NUMBER(2)
TAX Table
Name Null? Type
TAXGRADE NUMBER LOWSAL NUMBER HIGHSAL NUMBER
You want to create a report that displays the employee details along with the tax category of each employee. The tax category is determined by comparing the salary of the employee from the EMP table to the lower and upper salary values in the TAX table.
Which SELECT statement produces the required results?
 

Option A

A.    SELECT e.name, e.salary, t.taxgrade FROM emp e, tax t
WHERE e.salary IN t.lowsal AND t.highsal;
 

Option B

B.    SELECT e.name, e.salary, t.taxgrade FROM emp e, tax t
 
WHERE e.salary BETWEEN t.lowsal AND t.highsal;
 

Option C

C.    SELECT e.name, e.salary, t.taxgrade FROM emp e, tax t
WHERE e.salary >= t.lowsal AND <= t.highsal;
 

Option D

D.    SELECT e.name, e.salary, t.taxgrade
FROM emp e, tax t
WHERE e.salary <= t.lowsal AND e.salary >= t.highsal;
 

Correct Answer B
Explanation


Question ID 1505

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

Option A

A.    DECLARE
emp_table IS TABLE OF emp%ROWTYPE;
 

Option B

B.    DECLARE
TYPE emp_table_type IS TABLE OF emp%ROWTYPE INDEX BY BINARY_INTEGER;
emp_table emp_table_type;
 

Option C

C.    BEGIN
TYPE emp_table_type IS TABLE OF emp%ROWTYPE; emp_table emp_table_type;
 

Option D

D.    DECLARE
TYPE emp_table_type IS TABLE OF emp%ROWTYPE INDEX BY WHOLE_NUMBER;
emp_table emp_table_type;
 

Correct Answer B
Explanation

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