Tag: databases

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