Oracle 10g for Developers Assessment

$16.00

Oracle 10g for Developers Assessment

$16.00
description

This Oracle 10g for Developers test covers creation and management of database schema objects, as well as retrieving data, inserting new data, modifying existing data, and deleting existing data from the database.  In addition to basic SELECT statements, the questions in this test will examine the knowledge of developers in the area of functions, aggregates, joins, tables, indexes, views, constraints, and cover the new features that are specific to the Oracle 10g database.

Assessments for Oracle 10g DBA and Oracle 9i for Developers are also available.

 

Total Questions 55
Question Types Multiple Choice
Competencies Tested Functions
Basic Select Statement
Creating Constraints
Creating Tables
Creating Indexes
Managing Users and Object Access
PL/SQL
Tasks Tested Function Definition
Updating Table Rows
Evaluating Functions
SQL Command
Using the Analyze Command
Usage of SQL Function
Function Usage
Character Function
Returning a Numeric Value
Truncated Values
SQLCODE
Sorting Results
Privileges
Locating an Error
Functions
Flashback
Select Privileges for Tables
Type of Joins
Evaluating a Command
Operators
Parameters
Evaluating Code
Null Comparision
Clauses
Expression Precedence
DML
Evaluating SQL Code
Fixing Mistakes
Evaluating Code for Errors
Constraint Restrictions
Creating Constraints
Foreign Key Constraint
Constraint Integrity
Data Purge
Joins
Retrieving Dropped Tables
NVL Function Usage
B-Tree Indexes
Choosing Indexes
Creating Indexes on Columns
Determining Code Output
Invoking Stored Functions
Cursor Types
Packages
Cursor
Functions Versus Procedures
PL/SQL Packages
Changing Code
Overloading Constructs Within a Package