0

databases Online Quiz - 105

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

maximum limit of VARCHAR2 datatype in SQL & PLSQLRespectively

  1. 4000 / 4000

  2. 4000 / 32767

  3. 2000 / 4000

  4. None of these


Correct Option: B
  1. INTERPRETTED

  2. NATIVE

  3. BOTH

  4. None of these


Correct Option: B

A Package spec is compulsory but a package Body is not compulsory

  1. True

  2. False


Correct Option: A

For a certain row ina table, a VARCHAR2 coilumn contains the value TCSLTD, padded to the right with seven spaces by the application when the length() function processes the coplumn value , what will be the value returned

  1. 6

  2. 13

  3. 30

  4. 60


Correct Option: B

Dropping of table has which of the following effects on the non unique index created on the table

  1. no effect

  2. The Index will be dropped

  3. The index will become unusable

  4. the index will have NULLvalues

  5. You cannot drop a table until you drop the index


Correct Option: B
  1. IDENTIFIED BY

  2. USING TEMPORARY TABLESPACE

  3. MAXVALUE

  4. ON DELETE CASCADE

  5. CURRVAL

  6. NEXTVAL


Correct Option: C
  1. alter table table1 rename column column1 to column2

  2. alter table table1 rename to table 2

  3. alter table table1 add (c1 char(10))

  4. alter table table1 enable constraint t1_pk


Correct Option: D
  1. yes always

  2. yes on simple views with group by

  3. no on simple views with group by and distinct clause

  4. yesy on complex views


Correct Option: C

The Default indexing system in oracle

  1. BALANCED TREE

  2. BITMAP

  3. FUNCTIONAL

  4. BINARY TREE


Correct Option: A

An Equi join can be:

  1. Natural join

  2. Inner Join

  3. Both

  4. Cross Join


Correct Option: C

What are the different methods of refreshing the materialized view?

  1. Complete

  2. Slow

  3. Fast

  4. Never


Correct Option: A,C,D
  1. Left Outer Join

  2. Right outer Join

  3. Full Outer Join

  4. Inner Join


Correct Option: A
  1. Equi Join

  2. Natural Join

  3. Left Inner Join

  4. Cartesian product


Correct Option: C
  1. Null

  2. The Null values of COMMISSION column will be displayed as Null after addition to sal

  3. The Null values of COMMISSION column will be changed to 0 & will be added to sal

  4. Syntax error


Correct Option: C
  1. ) SER_NO, PROD_ID_NUMBER

  2. ORDER_ID and ORDER_DATE

  3. SER_NO, Composite index on ORDER_ID and ORDER_DATE

  4. SER_NO, ORDER_ID and ORDER_DATE


Correct Option: C
- Hide questions