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

Studying up for the quiz concept

SQL, 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.

Question 2:

SELECT ROUND(TRUNC(240985.3950, 3), -3)
FROM   dual;

What would be the result of the above SQL query?

A. 240985.40
B. 240000
C. 240985.395
D. 241000
E. 241000.395

Question 3:

Which of the following SQL statements would display the value 3689.82 as $3,689.82?

A. SELECT TO_CHAR(3689.82,'$99G999') FROM dual;
B. SELECT TO_CHAR(3689.82,'FML999G990.00') FROM dual;
C. SELECT TO_CHAR(3689.82,'$99G999D00') FROM dual;
D. SELECT TO_CHAR(3689.82,'$999G990.00') FROM dual;
E. SELECT TO_CHAR(3689.82,'$9,999D99') FROM dual;

Question 4:

Which of the following statements about subqueries are true?

A. Subqueries can contain both GROUP BY and ORDER BY clauses.
B. When the main query and subquery both have the same column names, it is a correlated subquery.
C. A nested subquery can contain up to 32 levels.
D. Subqueries can not contain the ORDER BY clause.
E. It is possible to compare only a single column or expression between the main query and a subquery.

Question 5:

Consider the following SQL statement:

TRUNCATE TABLE aircraft_types;

Which of the following statements is true?

A. LOB encryption is applicable to BasicFiles LOBs and SecureFiles LOBs.
B. The DECRYPT option can be used in an ALTER TABLE statement to convert encrypted columns to clear text form.
C. A partitioned LOB column can be encrypted in some partitions or all available partitions.
D. LOB encryption is salted by default. The NO SALT clause disables the use of salt in the encryption key.
E. The ENCRYPT option can be used in an ALTER TABLE statement to re-key encrypted columns to a new key or algorithm.

Would you like more insight into the history of hacking? Check out Calvin's other articles about historical hackery:
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.