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

Student pink shirt computer

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.

MORE HISTORIC HACKS
Would you like more insight into the history of hacking? Check out Calvin's other articles about historical hackery:
"Work on Your Wellness" Articles
Want to improve your health and live a better life? Check out Reena's other articles in this series:
About the Author

GoCertify's mission is to help both students and working professionals get IT certifications. GoCertify was founded in 1998 by Anne Martinez.