0

databases Online Quiz - 241

Description: databases Online Quiz - 241
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

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

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

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

  3. select 'TCS' from dual

  4. select "TCS" from dual


Correct Option: B

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

  1. TWO

  2. ONE

  3. FIVE

  4. EIGHT


Correct Option: B

Which view contains details about locked objects ?

  1. v$lock

  2. v$user_objects

  3. v$locked_object

  4. v$session


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

  1. No data found

  2. Error

  3. 1

  4. 0


Correct Option: D

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

  1. 3

  2. 6

  3. 5

  4. 4


Correct Option: C

MAX. NO OF ROWS PER PAGE?

  1. 127

  2. 136

  3. 38

  4. 16


Correct Option: A

What is the size of a data page?

  1. 4K to 8K

  2. 4K to 10K

  3. 5K to 10K

  4. 5K to 15K


Correct Option: A

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

  1. TWO

  2. ONE

  3. FIVE

  4. EIGHT


Correct Option: B

What is the maximum number of tables that can be joined?

  1. Twenty

  2. Eight

  3. Fifteen

  4. Six


Correct Option: C

Can I use DB2 Stored Procedures with Debug Tool?

  1. True

  2. False


Correct Option: A

When you COMMIT, is the cursor closed?

  1. True

  2. False


Correct Option: A

Is DECLARE CURSOR Executable?

  1. True

  2. False


Correct Option: B

Can you have more than one cursor open at any one time in a program?

  1. True

  2. False


Correct Option: A

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

  1. 10 bytes

  2. 2 bytes

  3. 5 bytes

  4. 4 bytes


Correct Option: A

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

  1. 2 bytes

  2. 4 bytes

  3. 8 bytes

  4. 6 bytes


Correct Option: B

Select odd item from the list.

  1. VARCHAR2

  2. CHAR

  3. NCHAR

  4. VARCHAR


Correct Option: D

Following datatype cannot be used twice in a table.

  1. NCHAR

  2. LONG

  3. INTEGER

  4. TIMESTAMP


Correct Option: B

CHAR is not compatible with.

  1. NCHAR

  2. DATE

  3. VARCHAR2

  4. BLOB


Correct Option: D

Which one is PL/SQL (but not SQL) datatype

  1. LONG

  2. NUMBER

  3. INTEGER

  4. REF


Correct Option: C

Select all ANSI supported datatypes.

  1. CHARACTER

  2. NUMBER

  3. INTEGER

  4. REAL


Correct Option: A,C,D
- Hide questions