Single Row And Group Function - Online Test

Test Difficulty Level: Easy

Syllabus of Test

Single - Row Functions in SQL - NULLs and Single - Row Functions, Single - Row Numeric Functions, Single - Row Date Functions, Single - Row Conversion Functions, Programmer - Written Single - Row Functions, Other Single - Row Functions. Group Functions SQL - Group (Multi - row) Functions, Grouping Data with GROUP BY, Limiting Grouped Data with HAVING, Nesting Functions.

Sample Question from this online test:

Question: You want to display each project's start date as the day, week, number, and year. Which statement will give output like the following ?

Tuesday Week 23, 1997

Option A: Select proj_id, to_char(start_date, 'DOW Week WOY YYYY') from projects

Option B: Select proj_id, to_char(start_date, 'Day'||' Week'||' WOY, YYYY') from projects;

Option C: Select proj_id, to_char(start_date, 'Day" Week" WW, YYYY') from projects;

Option D: Select proj_id, to_char(start_date, 'Day Week# , YYYY') from projects;

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

Start this Test






Comments

Anu Desale on 2011-02-25 07:04:20 wrote,

Good test...very intersting

Anu Desale on 2011-02-25 07:04:28 wrote,

Good test...very interesting

suresh reddy on 2012-02-29 04:18:14 wrote,

Nice

warda gill on 2012-05-06 08:57:59 wrote,

:(