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

Oracle 1z0-071 Based on Real Exam Environment

Page: 16 / 24
Question 64

Which two are true about rollbacks?

Options:

A.

The ROLLBACK statement does not release locks resulting from table updates.

B.

Data Control L anguage (DCL) statements, such as GRANT and REVOKE, can be rolled back.

C.

A transaction interrupted by a system failure is automatically rolled back.

D.

If the ROLLBACK statement is used without TO SAVEPOINT, then all savepoints in the transaction are deleted .

E.

Data consistency is not guaranteed after a rollback.

Question 65

which is true about the round,truncate and mod functions>?

Options:

A.

ROUND(MOD(25,3),-1) IS INVALID

B.

ROUND(MOD(25,3),-1) AND TRUNC(MOD(25,3),-1) ARE BOTH VALID AND GIVE THE SAME RESULT.

C.

ROUND(MOD(25,3),-1) AND TRUNC(MOD(25,3),-1) ARE BOTH VALID AND GIVE THE DIFFERENT RESULTS.

D.

TRUNC(MOD(25,3),-1) IS INVALID.

Question 66

Examine the description of the transactions table:

Which two SQL statements execute successfully?

Options:

A.

SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount+100 "DUES" from transactions;

B.

SELECT customer_id AS 'CUSTOMER-ID',transaction_date AS DATE, amount+100 'DUES' from transactions;

C.

SELECT customer_id CUSTID, transaction_date TRANS_DATE,amount+100 DUES FROM transactions;

D.

SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount+100 DUES FROM transactions;

E.

SELECT customer id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount+100 "DUES AMOUNT" FROM transactions;

Question 67

Examine this statement which executes successfully:

Which statement will violate the CHECK constraint?

Options:

A.

UPDATE emp80

SET department_id=90

WHERE department_id=80;

B.

DELETE FROM emp80

WHERE department_id=90;

C.

SELECT *

FROM emp80

WHERE department_id=80;

D.

SELECT *

FROM emp80

WHERE department_id=90;

Page: 16 / 24
Exam Code: 1z0-071
Exam Name: Oracle Database 12c SQL
Last Update: Dec 26, 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