Tag: databases

Questions Related to databases

what is the output of the the query: select 'Sql' from dual where null = null;

  1. No rows will be displayed

  2. Sql

  3. It throws Error

  4. None


Correct Option: A

What is the output of the the query: select 'Sql' from dual where null is null;

  1. No rows will be displayed

  2. Sql

  3. It throws Error

  4. None


Correct Option: B

If emp table having 10 records what is the output of : select * from emp where rownum=8;

  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