Oracle 1z0-047 : Oracle Database SQL Expert Exam
The Oracle 1z0-047: Oracle Database SQL Expert exam is a part of the Oracle Certification Program. Its associated certifications are for Oracle Database: SQL Certified Expert, Oracle 11g DBA OCA, Oracle 10g DBA OCA, Oracle 9i/ DBA OCA, Oracle PL/SQL Developer Certified Associate.
Exam topics for 1z0-047: Oracle Database SQL Expert are included, but not limited to, the following:
1. Retrieving Data Using the SQL SELECT Statement - Participants in this exam will be required to list the capabilities of SQL SELECT Statements, to execute a basic SELECT statement and to describe how schema object work.
2. Restricting and Sorting Data - Exam participants must be able to limit the rows that tare retrieved by a query and to sort said rows.
3. Displaying Data from Multiple Tables - Participants must accurately describe set operators, to use a set operator to combine multiple a single query and to control the order of rows returned.
4. Manipulating Large Data Sets - Exam participants will be required to manipulate data using sub-queries, to describe the features of multitable INSERTs, and to use the following types of multitable INSERTs (Unconditional, conditional and Pivot. ) Participants should know how to merge rows in a table and to track the changes to data over a period of time.