SQL: Additional Commands - Online Test

Test Difficulty Level: Medium

Syllabus of Test

Sample Question from this online test:

Question: What is the output of the following SQL statement? select TRANSLATE('MASTER AUTHOR', 'MAOU', 'Maou')

Option A: MaSTER auTHoR

Option B: master author


Option D: mAster AUthOr

To answer, click the "Start This Test" button below.

Start this Test


srikanth k on 2011-05-23 07:08:28 wrote,

Is it possible to convert a number to date by using to_date format?. But In oracle we cannot do that...right?

lavanya challa on 2011-07-07 08:27:50 wrote,

it is very helpful test paper for improving our skills

rana ajay on 2012-03-30 05:13:41 wrote,

nice test...

Kimberly Garbacz on 2012-05-28 23:10:15 wrote,

There is a FETCH SQL command when doing embedded SQL and T-SQL with a cursor declared. I did all the time in COBOL. So you should probably change the wording of the question on number 2 because FETCH can be correct.