Tag: databases

Questions Related to databases

Command to retrieve today’s date in the format DD/month/YY ?

  1. Select to_date(sysdate,’DD/MONTH/YY’) from dual;

  2. Select to_date(sysdate,’DD/MM/YY’) from dual;

  3. Select to_char(sysdate,’DD/MONTH/YY’) from dual;

  4. Select to_char(sysdate,’DD/MM/YY’) from dual;


Correct Option: C

SELECT count(*),status_id,status_name FROM kcrt_statuses WHERE STATUS_ID IN (SELECT STATUS_ID FROM kcrt_request_type_statuses) GROUP BY status_id; What will be the output?

  1. Returns the count of rows grouped by statuses

  2. Error - Incorrect use of COUNT. It has to have a column name.

  3. Error - because of the GROUP BY Clause or Selected columns

  4. Does not return the count, just displays the other two fields.


Correct Option: C

Alias/Shortcuts in Framework manager use the Storage/Space in Database which we are using(oracle/DB2/server...)

  1. True

  2. False


Correct Option: B