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
  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
  1. 4K to 8K

  2. 4K to 10K

  3. 5K to 10K

  4. 5K to 15K


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
  1. VARCHAR2

  2. CHAR

  3. NCHAR

  4. VARCHAR


Correct Option: D

CHAR is not compatible with.

  1. NCHAR

  2. DATE

  3. VARCHAR2

  4. BLOB


Correct Option: D
  1. CHARACTER

  2. NUMBER

  3. INTEGER

  4. REAL


Correct Option: A,C,D
- Hide questions