100% Free 1Z0-071 Practice Exam Questions and Answers

Stay Ahead with Latest 1Z0-071 Oracle Database 12c Practice Test Questions 2026

Page: 1 / 113

Total 561 Questions | Updated On: Sep 25, 2026

Add To Cart

Question 1

View the Exhibit and examine the description of the EMPLOYEES table.

You want to calculate the total remuneration for each employee. Total remuneration is the sum of

the annual salary and the percentage commission earned for a year. Only a few employees earn

commission.

Which SQL statement would you execute to get the desired output?

A : SELECT first_name, salary, salary*12+(salary*NVL2 (commission_pct,salary,salary+commission_pct))“Total”FROM EMPLOYEES;

B : SELECT first_name, salary, salary*12+salary*commission_pct “Total”FROM EMPLOYEES;

C : SELECT first_name, salary (salary + NVL (commission_pct, 0)*salary)*12 “Total”FROM EMPLOYEES;

D : SELECT first_name, salary, salary*12 + NVL(salary,0)*commission_pct, “Total”FROM EMPLOYEES;

Answer: A

Question 2

Which two statements execute successfully?

A : SELECT TO_ DATE('2019-DEC-25 15:30' 'YYYY-MON-DD HH24:MI', 'NLS_ DATE_ LANGUAGE=AMERICAN' ) FROM DUAL;

B : SELECT TO_CHAR('2019-DEC-25 15:30' YY-MON-D HH24:M2', 'NLS_DATE LANGUAGE =AMERICAN')FROM DUAL;

C : SELECT TO _DATE (TO_ CHAR ('2019-DEC-25 03:30', 'YYYY-MON-DD HH12:MI'))FROM DUAL;

D : SELECT TO _ CHAR (TO_ DATE ('2019-DEC-25 03:30','YYYY-MON-DD HH12:MI'))FROM DUAL

E : SELECT TO _ CHAR ('2019-DEC-25 15:30'.'YYYY-MON-DD HH24:MI')FROM DUAL

Answer: A,D

Question 3

View the Exhibit and examine PRODUCTS and ORDER_ITEMS tables.

You executed the following query to display PRODUCT_NAME and the number of times the product

has been ordered:

SELECT p.product_name, i.item_cnt

FROM (SELECT product_id, COUNT (*) item_cnt

FROM order_items

GROUP BY product_id) i RIGHT OUTER JOIN products p

ON i.product_id = p.product_id;

What would happen when the above statement is executed?

A : The statement would execute successfully to produce the required output

B : The statement would not execute because inline views and outer joins cannot be used together.

C : The statement would not execute because the ITEM_CNT alias cannot be displayed in the outer query.

D : The statement would not execute because the GROUP BY clause cannot be used in the inline.

Answer: A

Question 4

Which two are true about transactions In the Oracle Database?

A : DDL statements automatically commit only data dictionary updates caused by executing the DDL.

B : A DDL statement issued by a session with an uncommitted transation automaticall commits that transaction.

C : An uncommitted transaction is automatically committed when the user exits SQL*PLUS

D : DML statements always start new transactions.

E : A session can see uncommitted updates made by the same user in a different session

Answer: B,D

Question 5

Examine these statements and results

SQL> SELECT COUNT(*) FROM emp

COUNT(*)

---------------------

sQL> CREATE GLOBAL TEMPORARY TABLE t emp As SELECT * FROM emp;

Table created

SQL> INSERT INTo temp SELECT * FROM emp;

14 rows created

SQL> COMMIT:

Commit complete*

SQL> INSERT INTo temp SELECT * EROM emp;

14. rows created

SQL> SELECT COUNT(*) FROM t emp

How many rows are retrieved by the last query?

A : 28

B : 0

C : 14

D : 42

Answer: C

Page: 1 / 113

Total 561 Questions | Updated On: Sep 25, 2026

Add To Cart