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 FunctionsBasic Select StatementCreating ConstraintsCreating TablesCreating IndexesManaging Users and Object AccessPL/SQL Tasks Tested Function DefinitionUpdating Table RowsEvaluating FunctionsSQL CommandUsing the Analyze CommandUsage of SQL FunctionFunction UsageCharacter FunctionReturning a Numeric ValueTruncated ValuesSQLCODESorting ResultsPrivilegesLocating an ErrorFunctionsFlashbackSelect Privileges for TablesType of JoinsEvaluating a CommandOperatorsParametersEvaluating CodeNull ComparisionClausesExpression PrecedenceDMLEvaluating SQL CodeFixing MistakesEvaluating Code for ErrorsConstraint RestrictionsCreating ConstraintsForeign Key ConstraintConstraint IntegrityData PurgeJoinsRetrieving Dropped TablesNVL Function UsageB-Tree IndexesChoosing IndexesCreating Indexes on ColumnsDetermining Code OutputInvoking Stored FunctionsCursor TypesPackagesCursorFunctions Versus ProceduresPL/SQL PackagesChanging CodeOverloading Constructs Within a Package
