1Z0-047 Oracle 10g Database SQL Expert v2.11 278 questions
Sunday, May 16, 2010
1Z0-047 Oracle 10g Database SQL Expert v2.11 278 questions
| Retrieving Data Using the SQL SELECT Statement | |
[ ] | List the capabilities of SQL SELECT statements |
[ ] | Execute a basic SELECT statement |
[ ] | Describe how schema objects work |
| Restricting and Sorting Data | |
[ ] | Limit the rows that are retrieved by a query |
[ ] | Sort the rows that are retrieved by a query |
| Using Single-Row Functions to Customize Output | |
[ ] | Describe various types of functions that are available in SQL |
[ ] | Use character, number, and date functions in SELECT statements |
[ ] | Describe the use of conversion functions |
| Reporting Aggregated Data Using the Group Functions | |
[ ] | Identify the available group functions |
[ ] | Describe the use of group functions |
[ ] | Group data by using the GROUP BY clause |
[ ] | Include or exclude grouped rows by using the HAVING clause |
| Displaying Data from Multiple Tables | |
[ ] | Write SELECT statements to access data from more than one table using equijoins and nonequijoins |
[ ] | Join a table to itself by using a self-join |
[ ] | View data that generally does not meet a join condition by using outer joins |
[ ] | Generate a Cartesian product of all rows from two or more tables |
| Using Subqueries to Solve Queries | |
[ ] | Define subqueries |
[ ] | Describe the types of problems that subqueries can solve |
[ ] | List the types of subqueries |
[ ] | Write single-row and multiple-row subqueries |
| Using the Set Operators | |
[ ] | Describe set operators |
[ ] | Use a set operator to combine multiple a single query |
[ ] | Control the order of rows returned |
| Manipulating Data | |
[ ] | Describe each data manipulation language (DML) statement |
[ ] | Insert rows into a table |
[ ] | Update rows in a table |
[ ] | Delete rows from a table |
[ ] | Control transactions |
| Using DDL Statements to Create and Manage Tables | |
[ ] | Categorize the main database objects |
[ ] | Review the table structure |
[ ] | List the data types that are available for columns |
[ ] | Create a simple table |
[ ] | Explain how constraints are created at the time of table creation |
Creating Other Schema Objects | |
[ ] | Create simple and complex views |
[ ] | Retrieve data from views |
[ ] | Create, maintain, and use sequences |
[ ] | Create and maintain indexes |
[ ] | Create private and public synonyms |
| Managing Objects with Data Dictionary Views | |
[ ] | Use the data dictionary views to research data on your objects |
[ ] | Query various data dictionary views |
| Controlling User Access | |
[ ] | Differentiate system privileges from object privileges |
[ ] | Grant privileges on tables |
[ ] | View privileges in the data dictionary |
[ ] | Grant roles |
[ ] | Distinguish between privileges and roles |
| Managing Schema Objects | |
[ ] | Add constraints |
[ ] | Create indexes |
[ ] | Create indexes using the CREATE TABLE statement |
[ ] | Creating function-based indexes |
[ ] | Drop columns and set column UNUSED |
[ ] | Perform FLASHBACK operations |
[ ] | Create and use external tables |
| Manipulating Large Data Sets | |
[ ] | Manipulate data using subqueries |
[ ] | Describe the features of multitable INSERTs |
[ ] | Use the following types of multitable INSERTs (Unconditional, Conditional and Pivot) |
[ ] | Merge rows in a table |
[ ] | Track the changes to data over a period of time |
| Generating Reports by Grouping Related Data | |
[ ] | Use the ROLLUP operation to produce subtotal values |
[ ] | Use the CUBE operation to produce crosstabulation values |
[ ] | Use the GROUPING function to identify the row values created by ROLLUP or CUBE |
[ ] | Use GROUPING SETS to produce a single result set |
| Managing Data in Different Time Zones | |
[ ] | Use Various datetime functions |
| Retrieving Data Using Subqueries | |
[ ] | Write a multiple-column subquery |
[ ] | Use scalar subqueries in SQL |
[ ] | Solve problems with correlated subqueries |
[ ] | Update and delete rows using correlated subqueries |
[ ] | Use the EXISTS and NOT EXISTS operators |
[ ] | Use the WITH clause |
| Hierarchical Retrieval | |
[ ] | Interpret the concept of a hierarchical query |
[ ] | Create a tree-structured report |
[ ] | Format hierarchical data |
[ ] | Exclude branches from the tree structure |
| Regular Expression Support | |
[ ] | Using Meta Characters |
[ ] | Regular Expression Functions |
[ ] | Replacing Patterns |
[ ] | Regular Expressions and Check Constraints |
1Z0-047 Oracle 10g Database SQL Expert v2.11 278 questions
Download Password: 047ora
Installation / Configuration of VMware Server 2.0.2 + Oracle Enterprise Linux 5.4(32bit) + Oracle 11g R2 RAC (11.2.0.1)
Friday, May 14, 2010
VMware Server 2.0.2 + Oracle Enterprise Linux 5.4(32bit) + Oracle 11g R2 RAC (11.2.0.1)
- Environment Description
- Virtual Machine Setup
- Install the Linux Operating System
- Install VMware Tools
- Install Required Linux Packages for Oracle RAC
- Network Configuration
- Create Job Role Separation Operating System Privileges Groups, Users, and Directories
- Configure the Linux Servers for Oracle
- Create Shared Disks
- Install and Configure ASMLib 2.0
- Clone the Virtual Machine
- Install Oracle Grid Infrastructure for a Cluster
- Create ASM Disk Groups for Data and Fast Recovery Area
- Install Oracle Database 11g with Oracle Real Application Clusters
- Create the Oracle Cluster Database
- Verify Oracle Grid Infrastructure and Database Configuration
- Starting / Stopping the Cluster
- Troubleshooting
Replication with Oracle Streams
Monday, May 10, 2010
Replication with Oracle Streams
Replication with Oracle Streams
Step By Step guide for installing Oracle RAC 11gR2 on Linux
Thursday, May 6, 2010
Oracle Database 11gR2 RAC on Linux Install Guide
Introduction
Overview of new concepts in 11gR2 Grid Infrastructure
SCAN
GNS
OCR and Voting on ASM storage
Passwordless automatic SSH connectivity
Intelligent Platform Management interface (IPMI)
Time sync
Clusterware and ASM share the same Oracle Home
Hangchecktimer and oprocd are replaced
System Requirements
Hardware Requirements
IP Address Requirements
Installation method
Prepare the cluster nodes for Oracle RAC
User Accounts
Networking
Synchronizing the Time on ALL Nodes
Configuring Kernel Parameters
Set shell limits for the oracle user
Create the Oracle Inventory Directory
Creating the Oracle Grid Infrastructure Home Directory
Creating the Oracle Base Directory
Creating the Oracle RDBMS Home Directory
Stage the Oracle Software
Check OS Software Requirements
Prepare the shared storage for Oracle RAC
Shared Storage
Partition the Shared Disks
Installing and Configuring ASMLib
Using ASMLib to Mark the Shared Disks as Candidate Disks
Oracle Grid Infrastructure Install
Basic Grid Infrastructure Install (without GNS and IPMI)
Grid Infrastructure Home Patching
RDBMS Software Install
RAC Home Patching
Run ASMCA to create diskgroups
Run DBCA to create the database
OCA OCP Oracle Database 11g All-in-One Exam
Monday, May 3, 2010
A Fully Integrated Study System for OCA Exams 1Z0-051 and 1Z0-052, and OCP Exam 1Z0-053
Prepare for the Oracle Certified Associate Administration I and SQL Fundamentals I exams and the Oracle Certified Professional Administration II exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, and a two-minute drill to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all objectives for exams 1Z0-051, 1Z0-052, and 1Z0-053, including:
- Instance management
- Networking and storage
- Security
- SQL
- Oracle Recovery Manager and Oracle Flashback
- Oracle Automatic Storage Management
- Resource manager
- Oracle Scheduler
- Automatic workload repository
- Performance tuning
- And more
OCA / OCP Oracle Database 11g All-in-One Exam Read more...
OCA Oracle Database SQL Expert Exam Guide
Sunday, May 2, 2010
A fully integrated study system for Oracle Certification exam 1Z0-047
This exclusive Oracle Press guide covers all of the objectives on the newly created Oracle SQL Expert exam in detail, including control privileges, creating indexes and constraints, altering existing schema objects, creating and querying external tables, and using the advanced SQL features to query and manipulate data within the database.
Oracle Database SQL Expert Exam Guide features real-world examples, practice questions, and chapter summaries to help you learn the material. The CD-ROM contains two practice exams and an electronic copy of the book.
OCA.Oracle.Database.SQL.Expert.Exam.Guide Read more...
Subscribe to:
Posts (Atom)
