Question 1

Which statement executes successfully?

Options :

A : SELECT TO_DATE(TO_NUMBER(INTERVATL '800' SECOND)) FROM DUAL;

B : SELECT TO_NUMBER(INTERVAL'800' SECOND, 'HH24:MM') FROM DUAL;

C : SELECT TO_DATE(INTERVAL '800' SECOND,'HH24:MM') FROM DUAL;

D : SELECT TO_NUWBER(TO_DATE(INTERVAL '800' SECOND)) FROM DUAL;

E : SELECT TO_CHAR(INTERVAL '800' SECOND, 'HH24:MM') FROM DUAL;

Answer: E

Question 2

Examine the data in the CUST_NAME column of the CUSTOMERS table.

You want to extract only those customer names that have three names and display the * symbol in

place of the first name as follows:

Which two queries give the required output?

Options :

A : SELECT LPAD(SUBSTR(cust_name, INSTR(cust_name, ' ')),LENGTH(cust_name),'*') “CUST NAME”FROM customersWHERE INSTR(cust_name, ' ',1,2)<>0;

B : SELECT LPAD(SUBSTR(cust_name, INSTR(cust_name, ' ')),LENGTH(cust_name),'*') “CUST NAME”FROM customersWHERE INSTR(cust_name, ' ',-1,2)<>0;

C : SELECT LPAD(SUBSTR(cust_name, INSTR (cust_name ' ')),LENGTH(cust_name) - INSTR(cust_name, ' '), '*') “CUST NAME”FROM customersWHERE INSTR(cust_name, ' ',1,-2)<>0;

D : SELECT LPAD(SUBSTR(cust_name, INSTR (cust_name ' ')),LENGTH(cust_name) - INSTR(cust_name, ' '), '*') “CUST NAME”FROM customersWHERE INSTR(cust_name, ' ',1,2)<>0;

Answer: A,B

Question 3

Examine the data in the PRODUCTS table:

Examine these queries:

1. SELECT prod name, prod list

FROM products

WHERE prod 1ist NOT IN(1020) AND category _id=1;

2. SELECT prod name, | prod _ list

FROM products

WHERE prod list < > ANY (1020) AND category _id= 1;

SELECT prod name, prod _ list

FROM products

WHERE prod_ list < > ALL (10 20) AND category _ id= 1;

Which queries generate the same output?

Options :

A : 1 and 3

B : 1, 2 and 3

C : 2 and 3

D : 1 and 2

Answer: A

Question 4

Examine this query which executes successfully;

Select job,deptno from emp

Union all

Select job,deptno from jobs_history;

What will be the result?

Options :

A : It will return rows from both select statements after eliminating duplicate rows.

B :

It will return rows common to both select statements.

C :

It will return rows both select statements including duplicate rows.

D :

It will return rows that are not common to both select statements.

Answer: C

Question 5

Examine this description of the PRODUCTS table:

You successfully execute this command:

Which two statements execute without errors?

Options :

A :

B :

C :

D :

Answer: B