Simple

Inline

Complex

Nested

1

2

3

None of the above

TRUNC=To_Date('09-Jan-02,DD-MON-YY,'YEAR',"Date" from Dual;

Select TRUNC(To_Date('09-Jan-02,DD-MON-YY,YEAR')) "DATE" from Dual;

Date =TRUNC(To_DATE('09-Jan-02','DD-MON-YY'),'YEAR'),'YEAR)"DATE: from DUAL;

SELECT TRUNC(TO_DATE('12-Feb-99','DD-MON-YY'), 'YEAR') "Date " FROM DUAL;

1

2

3

None of those

Any outer join

A left outer join

A cross join

A right outer join

1

2

3

None of those

SELECT SUBSTR ('HelloWorld',1) FROM dual;

SELECT LOWER (SUBSTR ('HellowWorld', 2,1) FROM dual;

SELECT INITCAP(TRIM('HellowWorld', 1,1) FROM dual;

SELECT LOWER (TRIM ('H' FROM 'Hello World')) FROM dual;

Immediately after the SELECT clause

Before the WHERE clause

After the ORDER BY clause

After the WHERE clause

restrict data access

easy maintainance of complex queries

fast access

data independence

control files

redo log files

user_views data dictionary view

base table

varchar2()

long

char()

lob()

True

False

restrict data access

fast access

easy maintainance for complex queries

data independence

user_views

all_views

user_updatable_columns

dba_views

inline view is a schema object

is a subquery used in where clause

inline view can't have group functions

none of the above

True

False

999

1000

1001

limit is only for tables....

drop the view and create a new one

use CREATE OR REPLACE syntax

use ALTER VIEW syntax

use UPDATE sytax

True

False

No

Yes

1

0