The IT Certification Resource Center

Featured Deal

Get CompTIA, Cisco, or Microsoft training courses free for a week.
Learn More ❯

Exam 1Z0-051 — Oracle Database 11g: SQL Fundamentals I

Need help preparing for your next Oracle certification exam? This is the third in our series of six Oracle certification quizzes, courtesy of Oracle expert Matthew Morris.

Studying up for the quiz conceptSQL, or Structured Query Language, is essential for managing data in a relational database management system (RDBMS). 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-051: Oracle Database 11g: SQL Fundamentals I 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 statements about single-row functions is correct?

A. They always return the same data type as the one that is supplied to the function.
B. They can only be nested three levels deep.
C. They accept a single argument and return a single row.
D. They return at least one row for every row of a queried table or view.
E. They can appear in START WITH and CONNECT BY clauses.