Oracle 10g for Developers Assessment

$27.37

Oracle 10g for Developers Assessment

$27.37
Skills Assessment
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.

 

What Am I Buying?
When you purchase an assessment with Talevation, you will receive a credit for our online assessment portal. To access your purchase, you must head to our Login page found in the top right corner. There, you may redeem your credit and generate a link which will be sent to the candidate of your choosing.


How does it work?
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