The SQL*Plus Keyword.

The username

The password

The database name

17000.00

17000*****

****170.00

**17000.00

an error statement

Convert any date literal to a date

Convert any numeric literal to a date

Convert any character literal to a date

Convert any date to a character literal

Format ’10-JAN-99’ to ‘January 10 1999’

select

delete

execute

alter table

create table

String

Character

Integer

Calander

Numeric

Translation

The UNIQUE constraint does not permit a null value for the column.

A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.

The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.

The NOT NULL constraint ensures that null values are not permitted for the column.

GRANT select ON dept TO ALL_USERS;

GRANT select ON dept TO ALL;

GRANT QUERY ON dept TO ALL_USERS;

GRANT select ON dept TO PUBLIC;

Unique

Not null

Check

Primary key

Foreign key

a schema object

a subquery that can contain an ORDER BY clause

another name for a view that contains group functions

a subquery that is part of the FROM clause of another query

no privileges

only the SELECT privilege

only the CONNECT privilege

all the privileges of a default user

Insert

Update

Select

Describe

Delete

Rename

SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;

SELECT ROUND(hire_date)FROM EMP;

SELECT sysdate-hire_date FROM EMP;

SELECT TO_NUMBER(hire_date + 7)FROM EMP;

none

DELETE, INSERT,SELECT

ALTER, DELETE, INSERT, SELECT

DELETE, INSERT, SELECT, UPDATE

the use of rowed

a GROUP BY clause

an ORDER BY clause

only an inline view

an inline view and an outer query

Not null

Primary key

Foreign key

Check

Unique

In the database

using a source qualifier transformation

using a joiner transformation

his cannot be done in Power Center 8.x

Near to source

Near to target

Can be placed anywhere

(i)Session performance is not affected

Aggregator

Expression

Joiner

Filter

Stored procedure, Look up

Stored procedure, filter

Look up , joiner

Filter, Expression

Session

Command

Email

All of the above