Archive for the ‘Oracle’ Category

Oracle 1Z0-052 Database 11g 052 Exam Administrator I

07.09.2010 by admin - Comments Off
Posted in Oracle

NowExam provide of 1Z0-052 dumps  Oracle Database 11g: Administrator I : 1z1-052 Exam 1Z0-052 training materials preparatory materials is products such as latest (1Z0-052 Exam) Oracle pdf Braindumps (Printable Version).NowExam torrent successful Guide students to pass any IT certification. Provide latest certification information of IT Exam .Self-learning is a big problem,The need for expert guidance. So NowExam crack will introduction exam service providers to better help all engineers to obtain the corresponding Oracle certification.
Exam 1Z0-052 Oracle Database 11g: Administration I
Exam 1Z0-052 Oracle Database 11g: Administration I has just been released in full production.
This new exam is part of the Oracle Certified Oracle Database 11g Administrator track, combining training, experience, and testing to endorse candidates with a strong foundation and expertise in the industry’s most advanced database management system.
Exam 1Z0-052 covers topics such as:
exploring Oracle database architectures,
preparing database environments,
creating Oracle databases,
managing Oracle instances,
configuring Oracle network environments,
managing database storage structures,
administering user security,
managing schema objects,
managing data and concurrency,
managing undo data,
implementing Oracle database security,
database maintenance,
performance management,
intelligent infrastructure enhancements,
backup and recovery concepts,
performing database backups,
performing database recovery, and
moving data.
The exam contains 70 questions, 90 minutes allowed for completion, and requires a score of 66% to pass. Cost is $125 USD, with immediate registration available through Prometric testing centers worldwide.
NowExam Questions and Answers for Oracle Oracle Database 11g: Administration I; also known as 1z0-052; are basically a set of all the questions you can expect in your 1z0-052 exam, the oldest, the latest, the random ones, the recurring ones as well as the once-in-a-blue-moon ones. These are compiled by industry experts, having Oracle Oracle Database 11g: Administration I to their credit. They also are constantly keeping up with the latest developments at Oracle so that the Questions and Answers can be aptly revised. Therefore once you register at NowExam, you don’t have to worry about missing anything, and not being up-to-date.

Oracle OCA Certification introduction

05.25.2010 by admin - Comments Off
Posted in Oracle

The target audience for the OCA certification is individuals who want to demonstrate their skill level and commitment to their careers as Oracle DBAs. Entry-level DBA’s and individuals looking for a job as a DBA are prime candidates for the OCA credential.
Exam details and overview
Candidates must complete two exams in order to complete the requirements for the OCA credential. They have a choice of three exams for their first exam:
Introduction to Oracle9i SQL
Oracle Database SQL Expert
Oracle Database 11g SQL Fundamentals I
Each of these exams has its own specific requirements which can be found on the Oracle Training website.
All candidates must then sit for the Oracle Database Administration I exam. This exam is a 90 minute exam consisting of 70 questions. Candidates must correctly answer 66% of the questions for a passing score, however Oracle clearly states that the passing score may change without notice. Exam topics include Preparing the Database Environment, Create an Oracle Database, Implementing Database Security, Database Maintenance and many others. The complete list can be found on the exam’s web page.
Retake policy
Candidates must wait 14 days before retaking a failed OCA exam. Candidates cannot retake a passed exam or a beta exam at any time.
Cost
The cost for the first OCA exam varies according to which exam you choose while the cost for the Oracle Database I exam is $125 USD (although there may be local currency variations depending on the candidate’s location). The exams can be taken at any Oracle Testing Center worldwide. Candidates can find their local testing center by registering through the Oracle website but make sure to check with your local testing center for up-to-date price information. Keep a look out for promotional exam discounts from Oracle or for third-party exam voucher specialists to help you save on the cost of the exam.

Introducing the SQL SELECT Statement

02.08.2010 by admin - Comments Off
Posted in Oracle

The SELECT statement from Structured Query Language (SQL) has to be the single most powerful nonspoken language construct. The SELECT statement is an elegant, flexible, and highly extensible mechanism created to retrieve information from a database table. A database would serve little purpose if it could not be queried to answer all sorts of interesting questions. For example, you may have a database that contains personal financial records like your bank statements, your utility bills, and your salary statements. You could easily ask the database for a date-ordered list of your electrical utility bills for the last six months or query your bank statement for a list of payments made to a certain account over the same period. The beauty of the SELECT statement is encapsulated in its simple English-like format that allows questions to be asked of the database in a natural manner.
Tables, also known as relations, consist of rows of information divided by columns. Consider two of the sample tables introduced in the previous chapter: the EMPLOYEES table and the DEPARTMENTS table. This sample dataset is based on the Human Resources (HR) information for some fictitious organization. In Oracle terminology, each table belongs to a schema (owner): in this case the HR schema.
The EMPLOYEES table stores rows or records of information. These contain several attributes (columns) that describe each employee in this organization. The DEPARTMENTS table contains descriptive information about each department within this organization, stored as rows of data divided into columns.
Assuming a connection to a database containing the sample HR schema is available, then using either SQL*Plus or SQL Developer you can establish a user session. Once connected to the database, you are ready to begin your tour of SQL.

A Set-oriented Language :Summarize the SQL Language

02.08.2010 by admin - Comments Off
Posted in Oracle

A Set-oriented Language :Summarize the SQL Language
Most 3GLs are procedural languages. Programmers working in procedural languages specify what to do with data, one row at a time. Programmers working in a setoriented language say what they want to do to a group (a “set”) of rows and let the database work out how to do it to however many rows are in the set.
Procedural languages are usually less efficient than set-oriented languages at managing data, as regards both development and execution. A procedural routine for looping through a group of rows and updating them one by one will involve many lines of code, where SQL might do the whole operation with one command: programmers’ productivity increases. During program execution, procedural code gives the database no options; it must run the code as it has been written. With SQL, the programmer states what he or she wants to do but not how to do it: the database has the freedom to work out how best to carry out the operation. This will usually give better results.
Where SQL fails to provide a complete solution is that it is purely a data access language. Most applications will need procedural constructs, such as flow control: conditional branching and iteration. They will also usually need screen control, user interface facilities, and variables. SQL has none of these. SQL is a set-oriented language capable of nothing other than data access. For application development, one will therefore need a procedural language that can invoke SQL calls. It is therefore necessary for SQL to work with a procedural language.
Consider an application that prompts a user for a name, retrieves all the people with that name from a table, prompts the user to choose one of them, and then deletes the chosen person. The procedural language will draw a screen and generate a prompt for a name. The user will enter the name. The procedural language will construct a SQL SELECT statement using the name and submit the statement through a database session to the database server for execution. The server will return a set of rows (all the people with that name) to the procedural language, which will format the set for display to the user and prompt him to choose one (or more) of them. The identifier for the chosen person (or people) will then be used to construct a SQL DELETE statement for the server to execute. If the identifier is a unique identifier (the primary key) then the set of rows to be deleted will be a set of just one row; if the identifier is nonunique, then the set selected for deletion would be larger. The procedural code will knownothing about the likely size of the sets retrieved or deleted.

Summarize the SQL Language , SQL Standards and SQL Commands

02.06.2010 by admin - Comments Off
Posted in Oracle

Summarize the SQL Language
SQL is defined, developed, and controlled by international bodies. Oracle Corporation does not have to conform to the SQL standard but chooses to do so. The language itself can be thought as being very simple (there are only 16 commands), but in practice SQL coding can be phenomenally complicated. That is why a whole book is needed to cover the bare fundamentals.
SQL Standards
Structured Query Language (SQL) was first invented by an IBM research group in the ’70s, but in fact Oracle Corporation (then trading as Relational Software, Inc.) claims to have beaten IBM to market by a few weeks with the first commercial implementation: Oracle 2, released in 1979. Since then the language has evolved enormously and is no longer driven by any one organization. SQL is now an international standard. It is managed by committees from ISO and ANSI. ISO is the Organisation Internationale de Normalisation, based in Geneva; ANSI is the American National Standards Institute, based in Washington, DC. The two bodies cooperate, and their SQL standards are identical.
Earlier releases of the Oracle database used an implementation of SQL that had some significant deviations from the standard. This was not because Oracle was being deliberately different: it was usually because Oracle implemented features that were ahead of the standard, and when the standard caught up, it used different syntax. An example is the outer join (detailed in Chapter 8), which Oracle implemented long before standard SQL; when standard SQL introduced an outer join, Oracle added support for the new join syntax while retaining support for its own proprietary syntax. Oracle Corporation ensures future compliance by inserting personnel onto the various ISO and ANSI committees and is now assisting with driving the SQL standard forward.
SQL Commands
These are the 16 SQL commands, separated into commonly used groups:The Data Manipulation Language (DML) commands:
SELECT
INSERT
UPDATE
DELETE
MERGE
The Data Definition Language (DDL) commands:
CREATE
ALTER
DROP
RENAME
TRUNCATE
COMMENT
The Data Control Language (DCL) commands:
GRANT
REVOKE
The Transaction Control Language (TCL) commands:
COMMIT
ROLLBACK
SAVEPOINT
The first command, SELECT, is the main subject of Chapters 2 through 9. The remaining DML commands are covered in Chapter 10, along with the TCL commands. DDL is detailed in Chapters 11 and 12. DCL, which has to do with security, is only briefly mentioned: it falls more into the domain of the database administrator than the developers.

Data Normalization :Oracle Server Technologies and the Relational Paradigm

02.06.2010 by admin - Comments Off
Posted in Oracle

The process of modeling data into relational tables is known as normalization and can be studied at university level for years. There are commonly said to be three levels of normalization: the first, second, and third normal forms. There are higher levels of normalization: fourth and fifth normal forms are well defined, but any normal data analyst (and certainly any normal human being) will not need to be concerned with them. It is possible for a SQL application to address un-normalized data, but this will usually be inefficient as that is not what the language is designed to do. In most cases, data stored in a relational database and accessed with SQL should be normalized to the third normal form.
dfa123

Rows and Tables 2 :CERTIFICATION OBJECTIVE

02.05.2010 by admin - Comments Off
Posted in Oracle

Looking at the tables, the two-dimensional structure is clear. Each row is of fixed length, each column is of fixed length (padded with spaces when necessary), and the rows are delimited with a new line. The rows have been stored in code order, but this is a matter of chance, not design: relational tables do not impose any particular ordering on their rows. Department number 10 has one employee, and department number 40 has none. Changes to data are usually very efficient with the relational model. New employees can be appended to the employees table, or they can be moved from one department to another simply by changing the DEPTNO value in their row.
Consider an alternative structure, where the data is stored according to the hierarchical paradigm. The hierarchical model was developed before the relational model, for technology reasons. In the early days of computing, storage devices lacked the capability for maintaining the many separate files that were needed for the many relational tables. Note that this problem is avoided in the Oracle database by abstracting the physical storage (files) from the logical storage (tables): there is no direct connection between tables and files and certainly not a one-to-one mapping. In effect, many tables can be stored in a very few files. A hierarchical structure stores all related data in one unit. For example, the record for a department would include all that department’s employees. The hierarchical paradigm can be very fast and very space efficient. One file access may be all that is needed to retrieve all the data needed to satisfy a query. The employees and departments listed previously could be stored hierarchically as follows:
123csasd
In this example layout, the rows and columns are of variable length. Columns are delimited with a comma, rows with a new line. Data retrieval is typically very efficient if the query can navigate the hierarchy: if one knows an employee’s department, the employee can be found quickly. If one doesn’t, the retrieval may be slow. Changes to data can be a problem if the change necessitates movement. For example, to move employee 7566, JONES from RESEARCH to SALES would involve considerable effort on the part of the database because the move has to be implemented as a removal from one line and an insertion into another. Note that in this example, while it is possible to have a department with no employees (the OPERATIONS department) it is absolutely impossible to have an employee without a department: there is nowhere to put him or her. This is excellent if there is a business rule stating that all employees must be in a department but not so good if that is not the case.
The relational paradigm is highly efficient in many respects for many types of data, but it is not appropriate for all applications. As a general rule, a relational analysis should be the first approach taken when modeling a system. Only if it proves inappropriate should one resort to nonrelational structures. Applications where the relational model has proven highly effective include virtually all Online Transaction Processing (OLTP) systems and Decision Support Systems (DSS). The relational paradigm can be demanding in its hardware requirements and in the skill needed to develop applications around it, but if the data fits, it has proved to be the most versatile model. There can be, for example, problems caused by the need to maintain the indexes that maintain the links between tables and the space requirements of maintaining multiple copies of the indexed data in the indexes themselves and in the tables in which the columns reside. Nonetheless, relational design is in most circumstances the optimal model.
A number of software publishers have produced database management systems that conform (with varying degrees of accuracy) to the relational paradigm; Oracle is only one. IBM was perhaps the first company to commit major resources to it, but their product (which later developed into DB2) was not ported to non-IBM platforms for many years. Microsoft’s SQL Server is another relational database that has been limited by the platforms on which it runs. Oracle databases, by contrast, have always been ported to every major platform from the first release. It may be this that gave Oracle the edge in the RDBMS market place.
A note on terminology: confusion can arise when discussing relational databases with people used to working with Microsoft products. SQL is a language and SQL Server is a database, but in the Microsoft world, the term SQL is often used to refer to either.

Rows and Tables 1 :CERTIFICATION OBJECTIVE

02.05.2010 by admin - Comments Off
Posted in Oracle

The relational paradigm models data as two-dimensional tables. A table consists of a number of rows, each consisting of a set of columns. Within a table, all the rows have the same column structure, though it is possible that in some rows some columns may have nothing in them. An example of a table would be a list of one’s employees, each employee being represented by one row. The columns might be employee number, name, and a code for the department in which the employee works. Any employees not currently assigned to a department would have that column blank. Another table could represent the departments: one row per department, with columns for the department’s code and the department’s name.
A note on terminology: what Oracle refers to as a table may also be called a relation or an entity. Rows are sometimes called records or tuples, and columns may be called attributes or fields. The number of “rows in the table” is the “cardinality of the tuples.”
Relational tables conform to certain rules that constrain and define the data. At the column level, each column must be of a certain data type, such as numeric, date-time, or character. The character data type is the most general, in that it can accept any type of data. At the row level, usually each row must have some uniquely identifying characteristic: this could be the value of one column, such as the employee number and department number in the preceding examples, which cannot be repeated in different rows. There may also be rules that define links between the tables,such as a rule that every employee must be assigned a department code that can be matched to a row in the departments table. Following are examples of the tabulated data definitions:
Departments table:12cdsEmployees table:
13cdsThe tables could contain these rows:
Departments:13cdsEmployees:15cds

11G CERTIFICATION OBJECTIVE: Understand Relational Structures

02.05.2010 by admin - Comments Off
Posted in Oracle

Critical to an understanding of SQL is an understanding of the relational paradigm and the ability to normalize data into relational structures. Normalization is the work of systems analysts, as they model business data into a form suitable for storing in relational tables. It is a science that can be studied for years, and there are many schools of thought that have developed their own methods and notations.

Investigate Your Database and Application Environment

02.05.2010 by admin - Comments Off
Posted in Oracle

This is a paper-based exercise, with no specific solution.
Attempt to identify the user processes, application servers, and database servers used in your environment. Try to work out where the SQL is being generated and where it is being executed. Bear in mind that usually the user processes used by end users will be graphical and will frequently go through application servers; the database administration and development staff will often prefer to use client-server tools that connect to the database server directly.
Development Tools and Languages
The Oracle server technologies include various facilities for developing applications,some existing within the database, others external to it.
Within the database, it is possible to use three languages. The one that is unavoidable, and the subject of this book, is SQL. SQL is used for data access, but it cannot be used for developing complete applications. It has no real facilities for developing user interfaces, and it also lacks the procedural structures needed for manipulating rows individually. The other two languages available within the database fill these gaps. They are PL/SQL and Java. PL/SQL is a third-generation language (3GL) proprietary to Oracle. It has the usual procedural constructs (such as if-then-else and looping) and facilities for user interface design. In the PL/SQL code,one can embed calls to SQL. Thus, a PL/SQL application might use SQL to retrieve one or more rows from the database, then perform various actions based on their content, and then issue more SQL to write rows back to the database. Java offers a similar capability to embed SQL calls within the Java code. This is industry standard technology: any Java programmer should be able write code that will work with an Oracle database (or indeed with any other Java-compliant database.)
Other languages are available for developing client-server applications that run externally to the database. The most commonly used are C and Java, but it is possible to use most of the mainstream 3GLs. For all these languages, Oracle Corporation provides OCI (Oracle Call Interface) libraries that let code written in these languages establish sessions against an Oracle database and invoke SQL commands. Many organizations will not want to use a 3GL to develop database applications.
Oracle Corporation provides rapid application development tools as part of the Oracle Developer Suite, and there are many third-party products. These can make programmers far more productive than if they were working with a 3GL. Like the languages, all these application development tools end up doing the same thing: constructing SQL statements that are sent to the database server for execution.