Oracle9iDBAOCA.docVIP

Exam Number: 1Z0-001 Associated Certifications: Oracle9i DBA OCAApplication Developer R.6i OCPApplication Developer R.9i OCA Exam Price: $125.00 USD Exam Registration: Register Duration: 120 minutes Number of Questions: 57 Passing Score: 68% Passing score subject to change. View Details 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 Create and maintain constraints [??] Describe a view [??] Create a view [??] Retrieve data through a view [??] Insert, update, and delete data through a view [??] Drop a view Oracle Data Dictionary [??] Describe the data dictionary views a user may access [??] Query data from the data dictionary Writing Control Structures [??] Identify the uses and types of control structures [??] Construct an IF statement [??] Construct and identify different loop statements [??] Use logic tables [??] Control block flow using nested loops and labels Working with Composite Datatypes [??] Create user-defined PL/SQL records [??] Create a record with the % ROWTYPE attribute [??] Create a PL/SQL table [??] Create a PL/SQL table of records [??] Describe the difference between records, tables, and tables of records Overview of Relational Databases, SQL, and PL/SQL [??] Discuss the theoretical and physical aspects of a relational database [??] Describe the Oracle implementation of the RDBMS and ORDBMS [??] Describe the use and benefits of PL/SQL 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 Creating Views [??] Describe a view [??] Create, alter the definition, and drop a view [??] Retrieve d