Free Oracle 1Z0-071 Exam Questions

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

Page: 1 / 109

Total 544 Questions | Updated On: Nov 11, 2024

Add To Cart

Question 1

Which two statements best describe the benefits of using the WITH clause? (Choose two.)

A : can improve the performance of a large query by storing the result of a query block having the WITH clause in the session's temporary tablespace.

B : enables sessions to reuse the same query block in a SELECT statement, if it occurs more than once in a complex query.

C : enables sessions to store a query block permanently in memory and use it to create complex queries.

D : enables sessions to store the results of a query permanently.

Answer: A,B

Question 2

Examine the description of the CUSTOMERS table:

Which three statements will do an implicit conversion?

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

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

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

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

E : LECT * FROM customers WHERE customer_id=0001;

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

Answer: B,C,D

Question 3

View the Exhibit and examine the description of the tables.

You execute this SQL statement:

Which three statements are true?

A : statement will execute successfully and a new row will be inserted into the SALES table.

B : product can have a different unit price at different times

C : statement will fail because a subquery may not be contained in a VALUES clause.

D : statement will fail if a row already exists in the SALES table for product 23.

E : customer can exist in many countries.

F : SALES table has five foreign keys.

Answer: A

Question 4

Which two are true about external tables that use the ORACLE _DATAPUMP access driver?

A : eating an external table creates a directory object.

B : en creating an external table, data can be selected only from a table whose rows are stored in database blocks.

C : en creating an external table, data can be selected from another external table or from a table whose rows are stored in database blocks.

D : eating an external table creates a dump file that can be used by an external table in the same or a different database.

E : eating an external table creates a dump file that can be used only by an external table in the same database.

Answer: B,D

Question 5

SCOTT is a user in the database. Evaluate the commands issued by the DBA:

Which statement is true regarding the execution of the above commands?

A : atement 1 would not execute because the WITH GRANT option is missing.

B : atement 2 would not execute because system privileges and object privileges cannot be granted together in a single GRANT command.

C : atement 3 would not execute because role and system privileges cannot be granted together in a single GRANT statement.

D : atement 1 would not execute because the IDENTIFIED BY clause is missing.

Answer: B

Page: 1 / 109

Total 544 Questions | Updated On: Nov 11, 2024

Add To Cart