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

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

Which one is date function of oracle....?

  1. last_day(x)

  2. next_day(x)

  3. first_day(x)

  4. 1 & 3

  5. 1 & 2

  6. 2 & 3


Correct Option: E

Which one is oracle function....?

  1. divert

  2. convert

  3. straight

  4. revert


Correct Option: B

which one is not a function in oracle....?

  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

Which components are required to run iSQL*Plus from your PC? (Choose all that apply.)

  1. SQL*Plus installed on the PC

  2. Oracle Net on the PC

  3. HTTP Server

  4. iSQL*Plus Server


Correct Option: C,D

Which line of the following code has an error? SELECT * FROM emp WHERE comm = NULL ORDER BY ename;

  1. SELECT *

  2. FROM emp

  3. WHERE comm = NULL

  4. There is no error in this statement.


Correct Option: D

What are the special characters allowed in a table name? (Choose two answers.)

  1. &

  2. #

  3. @

  4. $


Correct Option: C,D

If char data type column contain number value (say 9) than condition 9>12 IS ?

  1. True

  2. False


Correct Option: A

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

Trim('0' from 000435600 )?

  1. 435600

  2. 0004356

  3. 00043560

  4. 4356


Correct Option: D

Which variable specifies to which version we are connected to ORACLE?

  1. COMPATIBILITY

  2. VERSION

  3. System.field_status

  4. System.current_field


Correct Option: A

Which is correct ? I DDL-Create,alter.delete II DML-Update,drop,delete III DCL-Grant,revoke IV DDL-Create,drop,alter

  1. I

  2. II

  3. III

  4. IV


Correct Option: C,D
  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

Column ALIASE can be used in Order by clause ?

  1. True

  2. False


Correct Option: A

Table (having constraint) can only be delete by

  1. TRUNCATE

  2. DELETE

  3. DROP

  4. REMOVE


Correct Option: C

Which is correct about index?

  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

Which is correct about view ?

  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

A Database Procedure is stored in the Database

  1. In compiled form

  2. As source code

  3. Both A & B

  4. Not stored


Correct Option: C
- Hide questions