The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?
no privileges
only the SELECT privilege
only the CONNECT privilege
all the privileges of a default user
Which is iSQL*Plus commands?
Insert
Update
Select
Describe
Delete
Rename
Which SQL statement returns a numeric value?
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;
Which object privileges can be granted on a view?
none
DELETE, INSERT,SELECT
ALTER, DELETE, INSERT, SELECT
DELETE, INSERT, SELECT, UPDATE
Top N analysis requires _____ and _____.
the use of rowed
a GROUP BY clause
an ORDER BY clause
only an inline view
an inline view and an outer query
For which two constraints does the Oracle Server implicitly create a unique index?
Not null
Primary key
Foreign key
Check
Unique
What is generally the most efficient way to join to join two tables in the same database?
In the database
using a source qualifier transformation
using a joiner transformation
his cannot be done in Power Center 8.x
To maximize session performance by filter it should be
Near to source
Near to target
Can be placed anywhere
(i)Session performance is not affected
Which of the following transformation is passive and connected?
Aggregator
Expression
Joiner
Filter
Which of the below transformation can be used as connected and unconnected both way?
Stored procedure, Look up
Stored procedure, filter
Look up , joiner
Filter, Expression