New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: Board70

Oracle PL 1z0-071 Full Course Free

Page: 7 / 24
Question 28

Examine the description of the PRODUCT_ STATUS table:

The STATUS column contains the values IN STOCK or OUT OF STocK for each row.

Which two queries will execute successfully?

Options:

A.

SELECT prod_id ||q’(‘ s not available)’ ‘CURRENT AVAILABILITY’ FROM

product_ status WHERE status = ‘OUT OF STOCK’

B.

SELECT prod_id ||q”‘ s not available” FROM

product_ status WHERE status = ‘OUT OF STOCK’;

C.

SELECT PROD_ID||q’(‘s not available)’ FROM

product_ status WHERE status = ‘OUT OF STOCK’;

D.

SELECT PROD_ID||q’(‘s not available)’ “CURRENT AVAILABILITY”

FROM product_ status WHERE status = ‘OUT OF STOCK’;

E.

SELECT prod_id q’s not available” from product_ status WHERE status = ‘OUT OF STOCK’;

F.

SELECT prod_id “CURRENT AVAILABILITY”||q’ (‘s not available)’ from product_ status WHERE status

= ‘OUT OF STOCK’;

Question 29

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;

Question 30

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.

Only the EMPLOYEES_ID column is indexed.

Rows exist for employees 100 and 200.

Examine this statement:

UPDATE employees

SET (job_id, salary) =

(SELECT job_id, salary

FROM employees

WHERE employee_id = 200)

WHERE employee id=100;

Which two statements are true?

Options:

A.

Employees 100 and 200 will have the same SALARY as before the update command.

B.

Employee 100 will have SALARY set to the same value as the SALARY of employee 200.

C.

Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200.

D.

Employees 100 and 200 will have the same JOB ID as before the update command.

E.

Employee 200 will have SALARY set to the same value as the SALARY of employee 100.

F.

Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100

Question 31

Which two statements are true about single row functions?

Options:

A.

CONCAT: can be used to combine any number of values

B.

MOD: returns the quotient of a division operation

C.

CEIL: can be used for positive and negative numbers

D.

FLOOR: returns the smallest integer greater than or equal to a specified number

E.

TRUNC: can be used with NUMBER and DATE values

Page: 7 / 24
Exam Code: 1z0-071
Exam Name: Oracle Database 12c SQL
Last Update: Dec 22, 2024
Questions: 326
1z0-071 pdf

1z0-071 PDF

$25.5  $84.99
1z0-071 Engine

1z0-071 Testing Engine

$28.5  $94.99
1z0-071 PDF + Engine

1z0-071 PDF + Testing Engine

$40.5  $134.99