Free Online Oracle 1Z0-071 Practice Test

Prepare Your Oracle 1Z0-071 Exam Questions with Free online 1Z0-071 Practice Test. Get Brilliant Oracle Database 12c SQL Exam Results with Valid 1Z0 071 Exam Dumps.

Page: 1 / 109

Total 544 Questions | Updated On: Apr 23, 2024

Question 1

Examine this query which executes successfully:

SELECT job, deptno FROM emp

UNION ALL

SELECT job, deptno FROM jobs_ history;

What will be the result?

A : It will return rows common to both SELECT statements.

B : It will return rows from both SELECT statements after eliminating duplicate rows

C : It will return rows that are not common to both SELECT statements.

D : It will return rows from both SELECT statements including duplicate rows.

Answer: D

Question 2

Which three statements are true regarding single-row functions? (Choose three.)

A : The data type returned, can be different from the data type of the argument that is referenced.

B : They can return multiple values of more than one data type.

C : They can accept only one argument.

D : They can be nested up to only two levels.

E : They can be used in SELECT, WHERE, and ORDER BY clauses.

F : They can accept column names, expressions, variable names, or a user-supplied constants as arguments.

Answer: A

Question 3

Examine the description of the EMPLOYEES table:

You write this falling statement:

SELECT dept-no AS department_id MAX (salary) AS max-sal

FROM employees

WHERE salary > 10000

GROUP BY department_id

ORDER BY max-sal:

Which clause causes the error?

A : WHERE

B : SELECT

C : ORDER BY

D : GROUP BY

Answer: D

Question 4

You issued this command: SQL > DROP TABLE employees; Which three statements are true? (Choose three.)

A : Sequences used in the EMPLOYEES table become invalid.

B : If there is an uncommitted transaction in the session, it is committed.

C : All indexes and constraints defined on the table being dropped are also dropped.

D : The space used by the EMPLOYEES table is always reclaimed immediately.

E : The EMPLOYEES table can be recovered using the ROLLBACK command.

F : The EMPLOYEES table may be moved to the recycle bin.

Answer: A,B,C

Question 5

Which two are true about multitable insert statements?

A : The conditional insert all statement inserts rows into a single table by aggregating source rows.

B : The unconditional insert all statement must have the same number of columns In both the source and target tables.

C : The conditional insert first statement always Inserts a row Into a single table.

D : They always use subqueries.

E : They can transform a row from a source table Into multiple rows In a target table.

Answer: A,D

Page: 1 / 109

Total 544 Questions | Updated On: Apr 23, 2024