Exam 1Z0-061 - Oracle Database 12c: SQL Fundamentals

Oracle Database, Oracle Corporation's flagship product, is so central to the company's identity that most people refer to the computing world's signature relational database management system (RDBMS) simply as Oracle. The latest version, Oracle Database 12c, was released in 2014. Oracle has been the leading player in the RDBMS game for quite a while now, and while you may occasionally hear opinions to the contrary, that position of preeminence is likely to remain secure in the foreseeable future.

Oracle certification expert Matthew Morris has created a series of practice tests at his site, Oracle Certification Prep. These free practice questions are a sampling of what you'll find there. After you try these questions, visit Oracle Certification Prep for (paid) access to a full 1Z0-061: Oracle Database 12c: SQL Fundamentals practice test.

Ready to rumble? Simply scroll down the page to begin your quiz. Or check out our other free Oracle quizzes.

Note: Your browser must permit multiple dialog boxes per page in order to complete this quiz.

Question 1:

Which of the following is a logical storage structures of the Oracle database?

‍

A. Archive Log file
B. Tablespace
C. OS block
D. Online redo log file
E. Control file
F. Data file

‍

Question 2:

Evaluate the SQL statements below:

SELECT act_name, act_body_style, act_seats AS SEATS
FROM   aircraft_types
ORDER BY act_seats;

SELECT act_name, act_body_style, act_seats AS SEATS
FROM   aircraft_types
ORDER BY SEATS ASC;

SELECT act_name, act_body_style, act_seats AS SEATS
FROM   aircraft_types
ORDER BY 3 ASC;

Which of the following statements is true?

‍

A. The three statements produce identical results.
B. The three statements can be made to produce identical results by adding ASC to the the ORDER BY clause of the first statement.
C. The first statement returns an error.
D. The second statement returns an error.
E. The third statement returns an error.

‍

Question 3:

Evaluate the following SQL query;

SELECT TRUNC(LAST_DAY(TO_DATE('07-APR-15', 'DD-MON-YY')) + 2, 'MM')
FROM   dual;

What would be the result of executing this query?

A. 01-APR-15
B. 30-APR-15
C. 31-MAY-15
D. 01-MAY-15
E. 02-MAY-15

‍

Question 4:

Which of the following is a valid type of function available in Oracle SQL?

A. Transfer
B. Calendar
C. Datetime
D. Decimal
E. Intersect

‍

Question 5:

Which of the following statements about aggregate functions is correct?

A. All of the aggregate functions ignore NULL values.
B. If a query using aggregated functions has no GROUP BY clause, only a single row will be returned.
C. Aggregate functions cannot be nested.
D. Aggregate functions can appear only in the SELECT list and the ORDER BY clauses.
E. Aggregate functions can be used in any clause of a SELECT statement.

‍