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

1z0-071 Exam Dumps - Oracle PL Questions and Answers

Question # 64

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;

Buy Now
Question # 65

You execute this command:

TRUNCATE TABLE depts;

Which two are true?

Options:

A.

It retains the indexes defined on the table.

B.

It drops any triggers defined on the table.

C.

A Flashback TABLE statement can be used to retrieve the deleted data.

D.

It retains the integrity constraints defined on the table.

E.

A ROLLBACK statement can be used to retrieve the deleted data.

F.

It always retains the space used by the removed rows

Buy Now
Question # 66

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’;

Buy Now
Question # 67

Which two are true about unused columns?

Options:

A.

The DESCRIBE command displays unused columns

B.

A primary key column cannot be set to unused.

C.

A query can return data from unused columns, but no DML is possible on those columns.

D.

Once a column has been set to unused, a new column with the same name can be added to the table.

E.

A foreign key column cannot be set to unused.

F.

Unused columns retain their data until they are dropped

Buy Now
Question # 68

The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2.

The table has two rows whose COST_LAST_MANE values are Anderson and Ausson.

Which query produces output for CUST_LAST_SAME containing Oder for the first row and Aus for the second?

Options:

A.

SELECT REPLACE (REPLACE(cust_last_name,'son',''),'An','O') FROM customers;

B.

SELECT REPLACE (TRIM(TRALING'son' FROM cust_last_name),'An','O') FROM customers;

C.

SELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name),'An','O')) FROM customers;

D.

SELECT REPLACE (SUBSTR(cust_last_name,-3),'An','O') FROM customers;

Buy Now
Question # 69

Examine these statements executed in a single Oracle session:

CREATE TABLE product (pcode NUMBER(2),pname VARCHAR2(20));

INSERT INTO product VALUES(1,'pen');

INSERT INTO product VALUES (2,'pencil');

INSERT INTO product VALUES(3,'fountain pen');

SAVEPOINT a;

UPDATE product SET pcode=10 WHERE pcode =1;

COMMIT;

DELETE FROM product WHERE pcode =2;

SAVEPOINT b;

UPDATE product SET pcode=30 WHERE pcode =3;

SAVEPOINT c;

DELETE FROM product WHERE pcode =10;

ROLLBACK TO SAVEPOINT b;

COMMIT;

Which three statements are true？

Options:

A.

The code for pen is 10.

B.

There is no row containing fountain pen.

C.

There is no row containing pencil.

D.

The code for pen is 1.

E.

The code for fountain pen is 3

F.

There is no row containing pen

Buy Now
Question # 70

Which two queries execute successfully?

Options:

A.

SELECT INTERVAL '1' DAY - SYSDATE FROM DUAL;

B.

SELECT SYSTIMESTAMP + INTERVAL '1' DAY FROM DUAL;

C.

SELECT INTERVAL '1' DAY - INTERVAL '1' MINUTE FROM DUAL;

D.

select INTERVAL '1' DAY +INTERVAL '1' MONTH FROM DUAL;

E.

SELECT SYSDATE “INTERRVAL '1' DAY FROM DUAL;

Buy Now
Question # 71

Which three statements are true about the DESCRIBE command?

Options:

A.

It can be used from SQL Developer.

B.

It can be used to display the structure of an existing view.

C.

It can be used only from SQL*Plus.

D.

It displays the NOT NULL constraint for any columns that have that constraint.

E.

It displays all constraints that are defined for each column.

F.

It displays the PRIMARY KEY constraint for any column or columns that have that constraint.

Buy Now
Question # 72

Choose the best answer.

Examine the description of the EMPLOYEES table:

Which query is valid?

Options:

A.

SELECT dept_id, join_date,SUM(salary) FROM employees GROUP BY dept_id, join_date;

B.

SELECT depe_id,join_date,SUM(salary) FROM employees GROUP BY dept_id:

C.

SELECT dept_id,MAX(AVG(salary)) FROM employees GROUP BY dept_id;

D.

SELECT dept_id,AVG(MAX(salary)) FROM employees GROUP BY dapt_id;

Buy Now
Question # 73

Which three queries execute successfully?

Options:

A.

SELECT (SYSDATE-DATE '2019-01-01') / 1 FROM DUAL;

B.

SELECT 1 / SYSDATE - DATE '2019-01-01' FROM DUAL;

C.

SELECT SYSDATE / DATE '2019-01-01' - 1 FROM DUAL

D.

SELECT SYSDATE - DATE '2019-01-01' - 1 FROM DUAL;

E.

SELECT 1 – SYSDATE- DATE '2019-01-01' FROM DUAL;

F.

SELECT SYSDATE - 1 - DATE'2019-01-01' EROM DUAL;

Buy Now
Exam Code: 1z0-071
Exam Name: Oracle Database 12c SQL
Last Update: Feb 22, 2025
Questions: 326
1z0-071 pdf

1z0-071 PDF

$25.5  $84.99
 Add to Cart
1z0-071 Engine

1z0-071 Testing Engine

$28.5  $94.99
 Add to Cart
1z0-071 PDF + Engine

1z0-071 PDF + Testing Engine

$40.5  $134.99
 Add to Cart