Tag: databases

Questions Related to databases

Output of the query if emp table is having 100 rows: select rownum from emp group by rownum having rownum = 69;

  1. Error

  2. 69

  3. 1

  4. None


Correct Option: B
  1. It throws error

  2. it will give 8th row

  3. no rows will get displayed

  4. None


Correct Option: C
  1. sp_databases

  2. sp_spaceused

  3. db_dbm_space_file

  4. None of the above


Correct Option: A,B,C,D