Oracle 1Z0-061 Exam Questions & Practice Test – Free Download

16 Dec

Oracle Database 12c: SQL Fundamentals: 1Z0-061 Exam
1Z0-061 Questions & Answers
Exam Code: 1Z0-061
Exam Name: Oracle Database 12c: SQL Fundamentals
Q & A: 80 Q&As

You want to display 5 percent of the employees with the highest salaries in the EMPLOYEES
Which query will generate the required result?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: D

In the customers table, the CUST_CITY column contains the value ‘Paris’ for the
Evaluate the following query:
What would be the outcome?
A. Abigail PA
B. Abigail Pa
C. Abigail IS
D. An error message
Answer: B

Which normal form is a table in if it has no multi-valued attributes and no partial dependencies?
A. First normal form
B. Second normal form
C. Third normal form
D. Fourth normal form
Answer: B

Examine the types and examples of relationships that follow:
1. One-to-one
a) Teacher to students
2. One-to-many
b) Employees to Manager
3. Many-to-one
c) Person to SSN
4. Many-to-many
d) Customers to products
Which option indicates the correctly matched relationships?
A. 1-a, 2-b, 3-c, and 4-d
B. 1-c, 2-d, 3-a, and 4-b
C. 1-c, 2-a, 3-b, and 4-d
D. 1-d, 2-b, 3-a, and 4-c
Answer: C

You execute the following commands:
For which substitution variables are you prompted for the input?
A. None, because no input required
B. Both the substitution variables ‘hiredate’ and ‘mgr_id\
C. Only ‘hiredate’
D. Only ‘mgr_id’
Answer: B

Which two statements are true regarding subqueries?
A. A subquery can retrieve zero or more rows.
B. Only two subqueries can be placed at one level.
C. A subquery can be used only in SQL query statements.
D. A subquery can appear on either side of a comparison operator.
E. There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement.
Answer: AD

Which two statements are true regarding constraints?
A. A table can have only one primary key and one foreign key.
B. A table can have only one primary key but multiple foreign keys.
C. Only the primary key can be defined at the column and table levels.
D. The foreign key and parent table primary key must have the same name.
E. Both primary key and foreign key constraints can be defined at both column and table levels.
Answer: BE

In which three situations does a transaction complete?
A. When a DELETE statement is executed
B. When a ROLLBACK command is executed
C. When a PL/SQL anonymous block is executed
D. When a data definition language (DDL) statement is executed
E. When a TRUNCATE statement is executed after the pending transaction
Answer: BDE

…go to to download the full version Q&As.