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: Jun 16, 2026

Add To Cart

Question 1

Which three tasks can be performed using SQL functions built into Oracle Database? (Choose three.)

A : displaying a date in a nondefault format

B : finding the number of characters in an expression

C : substituting a character string in a text expression with a specified string

D : combining more than two columns or expressions into a single column in the output

Answer: A,B,C

Question 2

Which statement is true regarding the default behavior of the ORDER BY clause?

A : In a character sort, the values are case-sensitive.

B : NULLs are not included in the sort operation

C : Only columns that are specified in the SELECT list can be used in the ORDER BY clause

D : Numeric values are displayed in descending order if they have decimal positions.

E : Column aliases can be used in the ORDER BY clause.

Answer: A

Question 3

Which two are true about the data dictionary?

A : Base tables in the data dictionary have the prefix DBA_.

B : All user actions are recorded in the data dictionary.

C : The data dictionary is constantly updated to reflect changes to database objects, permissions, and data.

D : All users have permissions to access all information in the data dictionary by default

E : The SYS user owns all base tables and user-accessible views in the data dictionary.

Answer: C,E

Question 4

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

Question 5

The ORDERS table has a column ORDER_DATE of date type DATE The default display format for a date is DD-MON-RR Which two WHERE conditions demonstrate the correct usage of conversion functions?

A : WHERE ordet_date> TO_CHAR(ADD_MONTHS(SYSDATE, 6),'MON DD YYYY')

B : WHERE TO_CHAR(order_date,'MON DD YYYY') ='JAN 20 2019';

C : WHERE order_date> TO_DATE('JUL 10 2018','MON DD YYYY');

D : WHERE order_date IN (TO_DATE ('Oct 21 2018','MON DD YYYY'), TO_CHAR('Nov 21 2018','MON DD YYYY'));

E : WHERE order_date> TO_DATE(ADD_MONTHS(SYSDATE,6),'MON DD YYYY');

Answer: B,C

Page: 1 / 113

Total 561 Questions | Updated On: Jun 16, 2026

Add To Cart