Tag: databases

Questions Related to databases

How many columns are there in dual table?
technology databases

  1. 1

  2. 2

  3. >1

  4. N

Show answer
Correct Option: A

There are 10 rows in Table A and 0 Rows in table B. Select * from A,B How many rows will be retrieved.
technology databases

  1. 1

  2. 0

  3. 10

  4. None of the above

Show answer
Correct Option: B

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?
technology 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 '!'

Show answer
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?
technology 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 '!'

Show answer
Correct Option: A,D

Can a function have an out parameter?

technology databases

  1. True

  2. False

Show answer
Correct Option: A

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

  1. True

  2. False

Show answer
Correct Option: A

Say for e.g. we declare x char(20): = 'name' and y varchar2(20):='name' If we compare x and y then what should be the result?
technology databases

  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

Show answer
Correct Option: B

In PL/SQL if we write select statement with INTO clause which of the following exceptions are returned

technology databases

  1. NO_DATA_FOUND

  2. ROWTYPE_MISMATCH

  3. TOO_MANY_ROW

  4. DUP_VAL_ON_INDEX

Show answer
Correct Option: A,C

Without closing the cursor, If you want to open it what will happen. If error, get what is the error?
technology databases

  1. INVALID_CURSOR

  2. CURSOR_ALREADY_OPEN

  3. TIMEOUT_ON_RESOURCE

  4. SYS_INVALID_ROWID

Show answer
Correct Option: B

What is Detail Object?
technology databases

  1. More detail about either Dimension/Measure

  2. More detail about Measure

  3. More detail about Dimension

  4. separate object for Time Dimension

Show answer
Correct Option: C