Exam2pass
0 items Sign In or Register
  • Home
  • IT Exams
  • Guarantee
  • FAQs
  • Reviews
  • Contact Us
  • Demo
Exam2pass > Oracle > Oracle Certifications > 1Z0-071 > 1Z0-071 Online Practice Questions and Answers

1Z0-071 Online Practice Questions and Answers

Questions 4

Examine this statement:

What is returned upon execution?

A. 2 rows

B. 0 rows

C. An error

D. 1 ROW

Buy Now

Correct Answer: D

Questions 5

Which statement will execute successfully?

A. SELECT 1, 2 FROM DUAL UNION SELECT 3, 4 FROM DUAL ORDER BY 1, 2;

B. SELECT 3 FROM DUAL UNION SELECT 4 FROM DUAL ORDER BY 3 ;

C. SELECT 1, 2 FROM DUAL UNION SELECT 3, 4 FROM DUAL ORDER BY 3, 4;

D. SELECT 1 FROM DUAL UNION SELECT 2 FROM DUAL ORDER BY 1, 2;

Buy Now

Correct Answer: A

Questions 6

Examine the description of the PRODUCTS table:

Which three queries use valid expressions? (Choose three.)

A. SELECT product_id, unit_price, S "Discount", unit_price + surcharge - discount FROM products;

B. SELECT product_id, (unit_price * 0.15 / (4.75 + 552.25)) FROM products;

C. SELECT product_id, (expiry_date - delivery_date) * 2 FROM products;

D. SELECT product_id, unit_price || 5 "Discount", unit_price + surcharge - discount FROM products;

E. SELECT product_id, expiry_date * 2 FROM products;

F. SELECT product_id, unit_price, unit_price + surcharge FROM products;

Buy Now

Correct Answer: BCF

Questions 7

Which two statements are true about date/time functions in a session where NLS_DATE_PORMAT is set to DD-MON-YYYY SH24:MI:SS

A. SYSDATE can be used in expressions only if the default date format is DD-MON-RR.

B. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE.

C. CURRENT_DATE returns the current date and time as per the session time zone

D. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server.

E. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of functional seconds.

F. SYSDATE can be queried only from the DUAL table.

Buy Now

Correct Answer: CE

Questions 8

Examine the description of the EMPLOYEES table:

Which query is valid?

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

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

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

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

Buy Now

Correct Answer: B

Questions 9

The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type number.

Which two queries execute successfully? (Choose two.)

A. SELECT NVL2(cust_credit_limit * .15, 'Not Available') FROM customers;

B. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers

C. SELECT NVL(cust_credit_limit * .15, 'Not Available') FROM customers;

D. SELECT NVL(TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;

E. SELECT TO_CHAR(NVL(cust_credit_iimit * .15, 'Not Available')) FROM customers;

Buy Now

Correct Answer: BD

Questions 10

Which two statements are true about the DUAL table: (Choose two.)

A. It can display multiple rows but only a single column.

B. It can be accessed only by the SYS user.

C. It can be accessed by any user who has the SELECT privilege in any schema.

D. It can display multiple rows and columns.

E. It consists of a single row and single column of VARCHAR2 data type.

F. It can be used to display only constants or pseudo columns.

Buy Now

Correct Answer: CE

Questions 11

Which three statements are true regarding subqueries? (Choose three.)

A. Multiple columns or expressions can be compared between the main query and subquery.

B. Subqueries can contain ORDER BY but not the GROUP BY clause.

C. Main query and subquery can get data from different tables.

D. Subqueries can contain GROUP BY and ORDER BY clauses.

E. Main query and subquery must get data from the same tables.

F. Only one column or expression can be compared between the main query and subquery.

Buy Now

Correct Answer: ACD

References: http://docs.oracle.com/javadb/10.6.2.1/ref/rrefsqlj13658.html

Questions 12

Which three statements are true regarding the usage of the WITH clause in complex correlated subqueries? (Choose three.)

A. It can be used only with the SELECT clause.

B. The WITH clause can hold more than one query.

C. If the query block name and the table name are the same, then the table name takes precedence.

D. The query name in the WITH clause is visible to other query blocks in the WITH clause as well as to the main query block

Buy Now

Correct Answer: ABD

Questions 13

Which three statements are true about external tables? (Choose three.)

A. They can be temporary tables.

B. DML statements can modify them.

C. They can be used in queries containing joins.

D. They can be used in queries containing sorts.

E. They can be indexed.

F. Their metadata is stored in the database.

Buy Now

Correct Answer: CDF

Exam Code: 1Z0-071
Exam Name: Oracle Database SQL
Last Update: Jun 09, 2025
Questions: 415

PDF (Q&A)

$45.99
ADD TO CART

VCE

$49.99
ADD TO CART

PDF + VCE

$59.99
ADD TO CART

Exam2Pass----The Most Reliable Exam Preparation Assistance

There are tens of thousands of certification exam dumps provided on the internet. And how to choose the most reliable one among them is the first problem one certification candidate should face. Exam2Pass provide a shot cut to pass the exam and get the certification. If you need help on any questions or any Exam2Pass exam PDF and VCE simulators, customer support team is ready to help at any time when required.

Home | Guarantee & Policy |  Privacy & Policy |  Terms & Conditions |  How to buy |  FAQs |  About Us |  Contact Us |  Demo |  Reviews

2025 Copyright @ exam2pass.com All trademarks are the property of their respective vendors. We are not associated with any of them.