The IT Certification Resource Center

Featured Deal

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

Exam 1Z0-047 — Oracle Database SQL Certified Expert

Hitting the books with coffee readySQL, 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-047: Oracle Database SQL Expert 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 valid function to use for measures in a pattern matching query?

A. RUNNING COUNT()
B. LAST FINAL()
C. AVG COUNT()
D. MULTIPLIER()
E. NEXT COUNT()