Oracle Certification exam details

Duration:	120 minutes
Number of Questions:	52
Passing Score:	71%

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=41&p_exam_id=1Z0_007

Writing Basic SQL Select Statements [ ] List the capabilities of SQL SELECT statements [ ] Execute a basic SELECT statement [ ] Differentiate between SQL statements and iSQL*Plus commands Restricting and Sorting Data [ ] Limit the rows retrieved by a query [ ] Sort the rows retrieved by a query Single-Row Functions [ ] Describe various types of functions available in SQL [ ] Use character, number, and date functions in SELECT statements [ ] Use conversion functions Displaying Data from Multiple Tables [ ] Write SELECT statements to access data from more than one table using equality and nonequality joins [ ] View data that generally does not meet a join condition by using outer joins [ ] Join a table to itself using a self-join Aggregating Data using Group Functions [ ] Identify the available group functions [ ] Use group functions [ ] Group data using the GROUP BY clause [ ] Include or exclude grouped rows by using the HAVING clause

Subqueries [ ] Describe the types of problems that subqueries can solve [ ] Define subqueries [ ] List the types of subqueries [ ] Write single-row and multiple-row subqueries Producing Readable Output with iSQL*Plus [ ] Produce queries that require a substitution variable [ ] Produce more readable output [ ] Create and execute script files Manipulating Data [ ] Describe each DML statement [ ] Insert rows into a table [ ] Update rows in a table [ ] Delete rows from a table [ ] Merge rows in a table [ ] Control transactions Creating and Managing Tables [ ] Describe the main database objects [ ] Create tables [ ] Describe the datatypes that can be used when specifying column definition [ ] Alter table definitions [ ] Drop, rename and truncate tables Including Constraints [ ] Describe constraints [ ] Create and maintain constraints

Creating Views [ ] Describe a view [ ] Create, alter the definition, and drop a view [ ] Retrieve data through a view [ ] Insert, update and delete data through a view Creating Other Database Objects [ ] Create, maintain and use sequences [ ] Create and maintain indexes [ ] Create private and public synonyms

Oracle Certification exam details

Oracle Examination-Registered Students

Here is the list of registered students for oracle examination to be held on 25th April,2009

1.Garima Tokhi-CSE

2.Divya-CSE

3.Gagan Kalra-CSE

4.Jaspreet Kaur-CSE

5.Kanureet Kaur-CSE

6.Monica-CSE

7.Jaskiran Bhattal-CSE

8.Anjul Hans-CSE

9.Nandini Sharma-CSE

10.Megha Arora-IT

The test will be held in WebCom Technologies SCO-114-115 Sector 34, Chandigarh

It is near SSI in sector 34.

Test date is 25th April,2009 (Saturday)

Other details will be mailed/phoned to you all directly by Oracle India.

Oracle Examination-Registered Students

ORACLE MODULE 1 EXAMINATION

PLZ PLZ FORWARD THIS MESSAGE TO YOUR FRIENDS EVEN IF U ARE NOT INTERESTED!!!!!!

ORACLE MODULE ! TEST TO BE HELD IN CHANDIGARH ON 25TH APRIL. PLEASE BRING DRAFTS WITH DETAILS AS FOLLOWS>>

RS.3030/-

Payment Details: Draft favoring ''Oracle India Private Limited'' payable at Bangalore

ALL INTERESTED CANDIDATES>> PLEASE BRING DRAFTS ON TUESDAY>>14TH APRIL 2009

CONTACT PERSONS>>

GAGAN JINDAL SIR>>ASST. PROFESSOR>>CSE>>LAB 2 MAIN BLOCK

ANJUL HANS CSE 6TH SEM >>9915036941

ORACLE MODULE 1 EXAMINATION

PTU Proposed Datesheet(All Branches)

http://ptu.ac.in/Proposed_date_sheet-May-2009.pdf

PTU Proposed Datesheet(All Branches)

ORACLE CERTIFICATE EXAMINATION

to be conducted in Chandigarh on 25th April.
Last Date for registration 10th April,2009
Fee:Rs.3030/-
Contact Person: Gagan Sir(Mr. Gagan Jindal),S/W Lab 2, Ground Floor, Engg Block-1

ORACLE CERTIFICATE EXAMINATION