Tag: databases

Questions Related to databases

There is a % sign in one field of a column. Say for example table test_chk has a column name1 which contains a value “desdf%dsf”. What will be the queries to find it?

  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

There is a % sign in one field of a column. Say for example table test_chk has a column name1 which contains a value “desdf%dsf”. What will be the queries to find it?

  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 a function have an out parameter?

  1. True

  2. False


Correct Option: A

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