Tag: databases

No Rows returned

10 rows of Emp table

Error

8 is displayed 10 times

True

False

True

False

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;

Any outer join

A left outer join

A cross join

A right outer join

1

2

3

None of these

None of the above

Convert '10'to 10

Convert 10 to '10'

Convert 'TEN' to 10

Convert a date to a character expression

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

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

SELECT LOWER (SUBSTR('HellowWorld', 2,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