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
  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

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

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
  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

Select all ANSI supported datatypes.

  1. CHARACTER

  2. NUMBER

  3. INTEGER

  4. REAL


Correct Option: A,C,D
- Hide questions