Transcender by Kaplan, Inc. 1Z0-047 - 180 Days
Oracle Database SQL Expert - Online

1Z0-047 - 180 Days
MSRP: $139.00 Add to Cart
YOUR PRICE: $111.20

Shipping charges apply for all orders containing a CD.

Candidates for the Oracle Database: SQL Certified Expert demonstrate the complete set of skills required for working with SQL programming language and have mastered the key concepts of a relational database.

Candidates will be tested on the following objectives:

  • Retrieving data using the SQL SELECT statement
  • Restricting and sorting data
  • Using single-row functions to customize output
  • Reporting aggregated data using the group functions
  • Displaying data from multiple tables
  • Using subqueries to solve queries
  • Using the set operators
  • Manipulating data
  • Using DDL statements to create and manage tables
  • Creating other schema objects
  • Managing objects with data dictionary news
  • Controlling user access
  • Managing schema objectives
  • Manipulating large data sets
  • Generating reports by grouping related data
  • Managing data in different time zones
  • Retrieving data using subqueries
  • Hierarchical retrieval
  • Regular experssion support

Technical Requirements

CD-ROM

 

Provides a 3 year license to access this practice exam on two computers: home & work. Your CD will be shipped via the option you select during checkout. While you are waiting for your shipment, a download of the exam will be available from the Club Product Access page.

 

Download + Bonus Online

Provides a 3 year license to access this practice exam on two computers: such as your home computer and your work computer. The test engine and the exam are downloaded from the Product Access page in your Club Account.

 

Recommended requirements:
  • Windows XP
  • P-III 500 MHz processor or faster
  • 256 MB RAM or more
  • 50 MB of hard drive space
  • Microsoft Internet Explorer 6.0+
Minimum requirements:
  • Windows 98, Windows 2000, Windows NT with SP6, Windows Millennium, or Windows XP
  • P-II 400 MHz processor
  • 128 MB RAM
  • 50 MB of hard drive space
  • Microsoft Internet Explorer 5.5+ or Netscape Navigator 6.0+

 

30 Day Online Access

Provides you with 30-day access to this exam from any computer using Internet Explorer. No test engine or exam file to download. The 30-day period starts when you activate your product from your Club Account.

180 Day Online Access

Provides you with 180-day access to this exam from any computer using Internet Explorer. No test engine or exam file to download. The 180-day period starts when you activate your product from your Club Account.

365 Day Online Access

Provides you with 365-day access to this exam from any computer using Internet Explorer. No test engine or exam file to download. The 365-day period starts when you activate your product from your Club Account.

Recommended requirements for Online practice exams:

  • JavaScript is required for client-side functions and must be enabled.
  • Cookies must also be enabled.
  • For Microsoft Internet Explorer browsers only, ActiveX controls must be allowed to run.
  • Check that your current system date and time are set correctly. System date and time dictate when session-based cookies will expire. If your date and time are set incorrectly, your cookies may be expiring immediately and not allowing the product to start or run properly.
  • The online exam does not currently support IE10. Use IE10's compatibility mode which temporarily reverts to IE8.