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 max(5)*min(5)/avg(5) from dual group by dummy; o/p:

  1. 5

  2. 25

  3. 125

  4. 1

  5. Error: Syntax error


Correct Option: A

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

select min(dummy) from dual order by dummy union all select max(dummy) from dual; O/p:

  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

select connect from dual; o/p:

  1. Error: Missing expression

  2. connect

  3. It will show connection string name

  4. NULL


Correct Option: A

select rowid from dual;

  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

select rownum from dual;

  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 0 and 50; o/p:

  1. 1

  2. Values 1 to 50

  3. Values 0 to 50

  4. 0


Correct Option: B

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

Which of the following call backs are called for the stateful session bean?

  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

Which transaction attribute should be set in the deployment descriptor for a method to guarantee that the method is NOT invoked with a transaction?

  1. RequiresNew

  2. Supported

  3. Never

  4. Mandatory


Correct Option: C

The annotation @PrePassivate be used for more than one method in a bean

  1. True

  2. False


Correct Option: B

Thread creation allowed in EJB

  1. True

  2. False


Correct Option: B

INTERVAL PARTITIONING IS NOT SUPPORTED FOR INDEX-ORGANIZED TABLES.

  1. True

  2. False


Correct Option: B

INTERVAL PARTITIONING IS A PARTITIONING TECHNIQUE BASED ON

  1. HASH

  2. MODULUS

  3. RANGE

  4. RANDOM


Correct Option: C

INTERVAL PARTITIONING IS A PARTITIONING TECHNIQUE USED IN

  1. ORACLE 11G

  2. ORACLE 10G

  3. ORACLE 9I

  4. ORACLE 9G

  5. ORACLE 11I

  6. ORACLE 8I


Correct Option: A

MIXED NOTATION IS A FUNCTIONALITY USED IN

  1. ORACLE 11G

  2. ORACLE 10G

  3. ORACLE 9I

  4. ORACLE 9G

  5. ORACLE 11I

  6. ORACLE 8I


Correct Option: A
- Hide questions