Description

Candidates for the Oracle Certified Associate in Oracle Database 11g need to pass Exams 1Z0-051 and 1Z0-052 to achieve their certification—this guide prepares you for taking both those exams. This two-in-one study guide covers the Oracle Certified Associate certification for Oracle database 11g and reviews exam topics such as restricting and sorting data, using conversion functions and conditional expressions, displaying data from multiple tables, and exploring the Oracle database architecture. Plus, you’ll learn how to create and maintain an Oracle database, perform database backups and recovery, move and manipulate data, prepare the database environment, and more.

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

For Instructors: Teaching supplements are available for this title.

Related Resources

Instructor

About the Author

Biju Thomas, OCA, OCP, is a senior database administrator with more than 15 years of Oracle application development and database management experience. He has coauthored five Oracle certification books published by Sybex and has written articles for multiple Oracle technical publications.

Text correction: Errors in SQL Fundamentals I Assessment Test,Question 14: The name of the table is FIRED EMPLOYEES, so each instance of FIRED EMPLOYEE in the INSERT statements should read FIRED EMPLOYEES. In addition, the four INSERT statements are missing close parentheses at the end. Each INSERT statement should end with ...TRUNC(SYSDATE))

Answer to Question 3: Correct answers are A. and C., not C. only as given. Append the following sentence to the explanation:NULLIF function with a NULL value and non-NULL value as parameters will return non-NULL value.

8/29/12

2

83

Text correction: Errors in Numeric Function Descriptions,The last sentence in the first paragraph under ATAN2,ATAN2(n1,n2) is equivalent to ATAN(n1/n2). should read:

ATAN2(n1,n2) is equivalent to ATAN(n1/n2) if n1 and n2 are positive integers.

The first sentence under BITAND,BITAND(n1, n2) takes two arguments, where n1 and n2 are positive integers or zero. should read:

BITAND(n1, n2) takes two arguments, where n1 and n2 are NUMBER data type.

04/19/2012

1st-3rd

93

Text correction: Error under "SYSTIMESTAMP",Delete takes no arguments from the first sentence.

Add, following first sentence: The SYSTIMESTAMP function accepts an optional parameter to specify the precision of seconds value. The precision argument can be between 0 and 9, the default is 6.

The sentence following, that reads: The fractional second is returned with six digits of precision. assumes the default.

The SUBSTR function in option A would return the last two characters of the last name. These two characters are right trimmed using the RTRIM function. The result would be first portion of the last name concatenated with XX, only if the last two characters are not repeating (for example Pululul will be PXX. Option B would replace all the occurrences of the last two characters.

Text correction: Error in code, Options for Review Question 11,Question 11, Option D: delete the end parenthesis before the semicolon at the end of the line, so that ...WHERE DEPT_ID = 22); reads ...WHERE DEPT_ID = 22;