Free Oracle 1Z0-071 Exam Questions

Become Oracle Certified with updated 1Z0-071 exam questions and correct answers

Page: 1 / 113

Total 561 Questions | Updated On: May 12, 2026

Add To Cart

Question 1

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database?

A : The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC).

B : A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row

C : A TIMESTAMP data type column contains information about year, month, and day

D : The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

E : The CURRENT_TIMESTAMP function returns data without time zone information

Answer: A,B,D

Question 2

You want to display 5 percent of the rows from the SALES table for products with the lowest

AMOUNT_SOLD and also want to include the rows that have the same AMOUNT_SOLD even if this

causes the output to exceed 5 percent of the rows.

Which query will provide the required result?

A : SELECT prod_id, cust_id, amount_soldFROM salesORDER BY amount_soldFETCH FIRST 5 PERCENT ROWS WITH TIES;

B : SELECT prod_id, cust_id, amount_soldFROM salesORDER BY amount_soldFETCH FIRST 5 PERCENT ROWS ONLY WITH TIES;

C : SELECT prod_id, cust_id, amount_soldFROM salesORDER BY amount_soldFETCH FIRST 5 PERCENT ROWS WITH TIES ONLY;

D : SELECT prod_id, cust_id, amount_soldFROM salesORDER BY amount_soldFETCH FIRST 5 PERCENT ROWS ONLY;

Answer: A

Question 3

Which three statements are true about multiple row subqueries?

A : They can contain GROUP BY clauses.

B : They can return multiple columns.

C : Two or more values are always returned from the subquery.

D : They can contain HAVING clauses.

E : They cannot contain a subquery.

Answer: A,B,D

Question 4

Examine the description of the CUSTOMERS table:

Which three statements will do an implicit conversion?

A : SELECT * FROM customers WHERE insert_date=DATE'2019-01-01';

B : SELECT * FROM customers WHERE customer_id='0001';

C : SELECT * FROM customers WHERE TO_DATE(insert_date)=DATE'2019-01-01';

D : SELECT * FROM customers WHERE insert_date'01-JAN-19';

E : SELECT * FROM customers WHERE customer_id=0001;

F : SELECT * FROM customers WHERE TO_CHAR(customer_id)='0001';

Answer: B,C,D

Question 5

Which two are true about the WITH GRANT OPTION clause?

A : The grantee can grant the object privilege to any user in the database, with of without including this option.

B : The grantee must have the GRANT ANY OBJECT PRIVILEGE system prvilege to use this option.

C : It can be used when granting privileges to roles.

D : It can be used for system and object privileges.

E : It cannot be used to pass on privileges to PUBLIC by the grantee.

F : It can be used to pass on privileges to other users by the grantee.

Answer: E,F

Page: 1 / 113

Total 561 Questions | Updated On: May 12, 2026

Add To Cart