Tag: databases

Which three definitions are associated with implicit cursors?

technology databases

Which command will delete all data from a table and will not write to the rollback segment?

technology databases

Which character is used to continue a statement in SQL*Plus?

technology databases

Assuming today is Monday, 10 July 2000, what is returned by this statement: SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual;

technology databases

SELECT NULLIF('testing','testing') FROM DUAL ;

technology databases

SELECT NULLIF(NULL,'testing') FROM DUAL ;

technology databases

SELECT NVL2(null,'second','third') FROM DUAL ;

technology databases

SELECT NVL2('first','second','testing') FROM DUAL ;

technology databases

SELECT NVL(null,'testing') FROM DUAL ;

technology databases

select decode('a','b','value-b','d','value-d','a','value-a','NA') result from dual;

technology databases