Oracle Certificate Examination

Al Those who recd call report at given timings, others report at 11:30 AM tomorrow
Get 2 IDS with u.
WebCom Technologies
SCO 114-115, sector 34A, CHD

Oracle Certificate Examination

SE 3rd Sessional on Monday(27/04/09)

Syllabus:

Evrything left after 2nd sessional

Documentation, Maintenance, etc.

SE 3rd Sessional on Monday(27/04/09)

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 test (update)

Forward dis msg 2all ur frnds...
Draft to be deposited tmrw morning(15/04/09)
Draft of Rs.3030/- in favour of Oracle India (P) Ltd.
payable at Bangalore
Other details needed>>
Name,Correspondence Address,City,PIN,EmailID,MobileNo,Res.Ph.No
Contact Anjul Hans  before 5PM today for any clarifications.

Oracle Module 1 test (update)

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

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