Tag: databases

Questions Related to databases

What is the Physical Storage Length of DATE DB2 data type?

technology databases

  1. 2 Bytes

  2. 4 Bytes

  3. 8 Bytes

  4. 6 Bytes

Show answer
Correct Option: B

What's the output select to_Date('2009-may-25','yyyymmdd') from dual
technology databases

  1. 20090525

  2. Error

  3. 2009-may-25

  4. may-25-2009

Show answer
Correct Option: B

Which of the query will print the output as 'TCS' (single quotes should come in the output)
technology databases

  1. select ' ' ' || 'TCS' || ' ' ' from dual

  2. select ' ' 'TCS' ' ' from dual

  3. select 'TCS' from dual

  4. select "TCS" from dual

Show answer
Correct Option: B

What is the maximum number of tables that can be stored on a Partitioned Table Space?
technology databases

  1. TWO

  2. ONE

  3. FIVE

  4. EIGHT

Show answer
Correct Option: B

Which view contains details about locked objects ?

technology databases

  1. v$lock

  2. v$user_objects

  3. v$locked_object

  4. v$session

Show answer
Correct Option: C

A new table has been created in the employee. There are no rows in the table.What would be the output of the query?select count(*) from employee
technology databases

  1. No data found

  2. Error

  3. 1

  4. 0

Show answer
Correct Option: D

select INSTR('TCS_SQL','S',4) from dual;
technology databases

  1. 3

  2. 6

  3. 5

  4. 4

Show answer
Correct Option: C

MAX. NO OF ROWS PER PAGE?
technology databases

  1. 127

  2. 136

  3. 38

  4. 16

Show answer
Correct Option: A

What is the size of a data page?

technology databases

  1. 4K to 8K

  2. 4K to 10K

  3. 5K to 10K

  4. 5K to 15K

Show answer
Correct Option: A

What is the maximum number of tables that can be stored on a Partitioned Table Space?
technology databases

  1. TWO

  2. ONE

  3. FIVE

  4. EIGHT

Show answer
Correct Option: B