0

databases Online Quiz - 83

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

select dummy,count(1) from dual group by dummy; O/p:

  1. Error: Not a GROUP BY Clause

  2. X,0

  3. X,1

  4. Two rows of value (X,0) & (X,1)

  5. No rows returned


Correct Option: C

select avg(dummy) from dual; o/p:

  1. Error: Invalid Number

  2. Error: Invalid Character

  3. 0

  4. 1

  5. Error: divisor is equal to zero


Correct Option: A

select min(dummy) from dual union all select max(dummy) from dual group by dummy; o/p: ??

  1. Two rows of value X and X

  2. Error: SQL command not properly ended

  3. Error: Not a proper GROUP BY clause

  4. X

  5. NULL


Correct Option: A
  1. X

  2. Two rows of value X and X

  3. Error: Not a proper ORDER BY clause

  4. Error: SQL command not properly ended

  5. 1


Correct Option: D
  1. Error: Missing expression

  2. connect

  3. It will show connection string name

  4. NULL


Correct Option: A
  1. It will show one row but no no column,no value,not even NULL value

  2. 1

  3. 0

  4. NULL


Correct Option: A
  1. It will show one row but no no column,no value-,not even NULL value

  2. NULL

  3. 0

  4. 1


Correct Option: D

select level from dual connect by level between 1 and 50 minus select level from dual connect by level between 2 and 50; o/p:

  1. 1

  2. No rows returned

  3. Values 1 to 50

  4. Values 0 & 1


Correct Option: B

select level from dual connect by level between 3 and 50; o/p:

  1. NULL

  2. Values 3 to 50

  3. 1

  4. 0


Correct Option: C
  1. Construction

  2. Destruction

  3. Activation

  4. Passivation

  5. All the above


Correct Option: E

Which of the following statements are correct?

  1. Every entity must have a primary key

  2. It is not necessary to define primary key for an Entity

  3. @Primary annotation is used for denoting a simple primary key

  4. All the above


Correct Option: A

Thread creation allowed in EJB

  1. True

  2. False


Correct Option: B
  1. ORACLE 11G

  2. ORACLE 10G

  3. ORACLE 9I

  4. ORACLE 9G

  5. ORACLE 11I

  6. ORACLE 8I


Correct Option: A
  1. ORACLE 11G

  2. ORACLE 10G

  3. ORACLE 9I

  4. ORACLE 9G

  5. ORACLE 11I

  6. ORACLE 8I


Correct Option: A
- Hide questions