data definition language (DDL) for all objects in a schema

DDL for all object grants on a table in the database

report of invalidated objects in a schema

report of statistics of an object in the database

The COMPRESSION HIGH option can be enabled only for CLOBs.

The COMPRESSION HIGH option can be enabled for all internal LOBs.

The DECRYPT option can be used to remove encryption only if the LOB column is empty.

The DECRYPT option can be used to remove encryption from LOB columns that are empty or contain data.

subquery results

results of a query having the SYSDATE function

results of a query having the GROUP BY clause

results of a query having the DATE data type in the WHERE clause

Use subprograms as pasrt of packages instead of stand-alone parameters

Use dynamic SQL’s constructed using concatenation of input values.

Use bind arguments

Usage of the NOT NULL constraint in PL/SQL code can degrade performance

REF CURSOR types cannot be defined inside a package

SYS_ REFCURSOR can be used to declare cursor variables in stored procedures and functions

A REF CURSOR return type can be declared using %TYPE or %ROWTYPE or a user-defined record.

Only a weak REF CURSOR type can be used as a formal parameter of a stored procedure or function.

It must be part of a package.

It must be a pipelined table function.

It must not be defined in an anonymous block.

It must have at least one OUT or IN OUT parameter.

1. Insert into

1. Create mining structure

1. Browse data

1. Select from

1. Browse mining model

1. Many dimensions, large dense datasets

1. Few dimensions, small dense datasets

1. Few dimensions, small sparse datasets

1. Many dimensions, small sparse datasets

1. Many dimensions, large sparse datasets

1. To show current warehouse product output levels on an assembly line

1. To track realtime sales figures

1. To help users make better business decisions

1. To show orders currently being processed

1. To keep track of business contacts and leads

1. Comprehensive data on operations from all departments

1. A subset of a data warehouse

1. Individual invoices

1. Accounting profit and loss reports

1. Data managed by a particular department of the company

1. Data fields that reference numeric data should be indexed.

1. Only data fields that change over time should be indexed.

1. Data fields that are referenced by queries should be indexed.

1. All data fields should be indexed.

1. Data fields that reference text and large object data should be indexed.

1. Data about an organization's staff

1. Data about accounting entries

1. Data about an organization's structure

1. Data about an organization's products

1. Data about transaction activity

1. Capture and store data rules.

1. Generate programs to extract data from a source system.

1. Store data warehouse database designs.

1. Store the layout or design of the load files.

1. Generate programs to transform data.

1. Bollenger bands

1. Averaging

1. Prediction joins

1. Analytic parsing

1. Relative strength

1. Snowflake queries are faster than the star schema.

1. Snowflake links each table to each other, while star schema links each table to a central table.

1. Snowflake has additional tables linked to the outer tables of a star schema.

1. Snowflake is more optimized for a data warehouse.

1. Snowflake is less complicated than star schema.

1. Database backups

1. Time an uncommon query will take

1. People entering data into the source database

1. Number of tables in the data mart, so they do not exceed six tables

1. Requirements of the department that will use the data mart

A only

Both A nad B

B Only

Both B and C

select min(field4) as Min,Max(field4) as Max,(select Max(field4) from table1 where field4 not in(Select Min(field4) from table1)) as 2nmax from table1

select min(field4) as Min,Max(field4) as Max,(select Min(field4) from table1 where field4 not in(Select Max(field4) from table1)) as 2nmax from table1

select min(field4) as Min,Max(field4) as Max,(select Max(field4) from table1 where field4 not in(Select Max(field4) from table1)) as 2nmax from table1

None of the Above

Corelated Subquery

Index

TOP()

None

1,10

10,10

1,249

249,1