Practice 1Z0-071 Exam Online

Question 1

View the exhibit for the structure of the STUDENT and FACULTY tables.

You need to display the faculty name followed by the number of students handled by the faculty at

the base location.

Examine the following two SQL statements:

Statement 1

SQL>SELECT faculty_name, COUNT(student_id)

FROM student JOIN faculty

USING (faculty_id, location_id)

GROUP BY faculty_name;

Statement 2

SQL>SELECT faculty_name, COUNT(student_id)

FROM student NATURAL JOIN faculty

GROUP BY faculty_name;

Which statement is true regarding the outcome?

A : Only statement 2 executes successfully and gives the required result.

B : Only statement 1 executes successfully and gives the required result.

C : Both statements 1 and 2 execute successfully and give different results.

D : Both statements 1 and 2 execute successfully and give the same required result.

Answer: B

Question 2

Examine the description of the EMPLOYEES table:

Which query requires explicit data type conversion?

A : SELECT join_date FROM employees WHERE join_date > ’10-02-2018’;

B : SELECT salary + ‘120.50’ FROM employees;

C : SELECT SUBSTR(join_date, 1, 2) – 10 FROM employees;

D : SELECT join_date + ‘20’ FROM employees;

E : SELECT join_date || ‘ ‘ || salary FROM employees;

Answer: D

Question 3

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

A : Creating an external table creates a directory object.

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

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

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

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

Answer: B,D

Question 4

Examine this statement:

SELECT cust_id, cust^last_ndma "Last Name"

FROM customers

WHERE country_id — 10 UNION

SELECT cust_ID_CUST_NO, cust_last_name

PROM customers

WHERE country__id = 30

Identify three order by clauses, any one of which will complete the query successfully

A : ORDER BY 2. cust _id

B : ORDER BY 2,

C : ORDER BY "CUST^NO

D : ORDER BY 'Last Name

E : ORDER BY CUST_NO

Answer: A,B,D

Question 5

Which two statements are true about Oracle databases and SQL?

A : A user can be the owner of multiple schemas In the same database

B : The database guarantees read consistency at select level on user-created tables.

C : Updates performed by a database user can be rolled back by another user by using the rollback command.

D : A query can access only tables within the same schema.

E : When you execute an update statement, the database Instance locks each updated row.

Answer: A,B

Name:	Oracle Database 12c SQL
Exam Code:	1Z0-071
Certification:	Oracle Database 12c
Vendor:	Oracle
Total Questions:	544
Last Updated:	Apr 25, 2024

Oracle 1Z0-071