0

databases Online Quiz - 219

Description: databases Online Quiz - 219
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. multiply_months(x,y)

  2. add_months(x,y)

  3. devide_months(x,y)

  4. upper(x)


Correct Option: A
  1. last_day(x)

  2. next_day(x)

  3. first_day(x)

  4. 1 & 3

  5. 1 & 2

  6. 2 & 3


Correct Option: E
  1. divert

  2. convert

  3. straight

  4. revert


Correct Option: B
  1. compose

  2. decompose

  3. translate

  4. retranslate


Correct Option: D

find the correct usage....

  1. colesce

  2. coalesce

  3. coalsce

  4. coalese


Correct Option: B

Which one is date function of Oracle...?

  1. multiply_months(x,y)

  2. add_months(x,y)

  3. devide_months(x,y)

  4. upper(x)


Correct Option: B
  1. SQL*Plus installed on the PC

  2. Oracle Net on the PC

  3. HTTP Server

  4. iSQL*Plus Server


Correct Option: C,D
  1. SELECT *

  2. FROM emp

  3. WHERE comm = NULL

  4. There is no error in this statement.


Correct Option: D

IN which condition X is NOT equal to Y ?

  1. X<>Y

  2. X!=Y

  3. X^=Y

  4. X!=!Y


Correct Option: A,B,C
  1. 435600

  2. 0004356

  3. 00043560

  4. 4356


Correct Option: D
  1. COMPATIBILITY

  2. VERSION

  3. System.field_status

  4. System.current_field


Correct Option: A

which is correct about TABLE

  1. Table can have 100 column at MAX

  2. Table can have 1000 column at MAX

  3. Table can have 10,000 column at MAX

  4. Table can have unlimited column


Correct Option: B
  1. B-tree index used for table having completely unique colum

  2. REVERSE key index used for oracle parallel serve

  3. BIT MAP index is used for low cardinality

  4. None of these


Correct Option: A,B,C
  1. Outer Join view (complex view) is not updateable

  2. USER_View contain Status of view

  3. USER_ViEw NOT contain Status of view

  4. DML opration may NOT applied on view having Group by clasue


Correct Option: A,C,D
  1. In compiled form

  2. As source code

  3. Both A & B

  4. Not stored


Correct Option: C
- Hide questions