Tag: databases

Questions Related to databases

  1. SELECT * FROM test_chk ;

  2. select * from test_chk where name1 like '%%\%' escape '\'

  3. select * from test_chk where name1 like ' \ ' escape '\';

  4. select * from test_chk where name1 like '%!%%' escape '!'


Correct Option: A,D
  1. SELECT * FROM test_chk ;

  2. select * from test_chk where name1 like '%%\%' escape '\'

  3. select * from test_chk where name1 like ' \ ' escape '\';

  4. select * from test_chk where name1 like '%!%%' escape '!'


Correct Option: A,D

Can you add not null column to a table already containing data ?

  1. True

  2. False


Correct Option: A
  1. Both values will be equal

  2. Both values will not be equal

  3. You can’t compare these two values

  4. Both will be NULL


Correct Option: B
  1. INVALID_CURSOR

  2. CURSOR_ALREADY_OPEN

  3. TIMEOUT_ON_RESOURCE

  4. SYS_INVALID_ROWID


Correct Option: B
  1. More detail about either Dimension/Measure

  2. More detail about Measure

  3. More detail about Dimension

  4. separate object for Time Dimension


Correct Option: C