Tag: databases

Questions Related to databases

select level from dual connect by level between 0 and 50; o/p:
technology databases

  1. 1

  2. Values 1 to 50

  3. Values 0 to 50

  4. 0

Show answer
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:
technology databases

  1. 1

  2. No rows returned

  3. Values 1 to 50

  4. Values 0 & 1

Show answer
Correct Option: B

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

  1. NULL

  2. Values 3 to 50

  3. 1

  4. 0

Show answer
Correct Option: C

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

  1. Construction

  2. Destruction

  3. Activation

  4. Passivation

  5. All the above

Show answer
Correct Option: E

Which of the following statements are correct?
technology databases

  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

Show answer
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?
technology databases

  1. RequiresNew

  2. Supported

  3. Never

  4. Mandatory

Show answer
Correct Option: C

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

  1. True

  2. False

Show answer
Correct Option: B

Thread creation allowed in EJB
technology databases

  1. True

  2. False

Show answer
Correct Option: B

INTERVAL PARTITIONING IS NOT SUPPORTED FOR INDEX-ORGANIZED TABLES.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

INTERVAL PARTITIONING IS A PARTITIONING TECHNIQUE BASED ON
technology databases

  1. HASH

  2. MODULUS

  3. RANGE

  4. RANDOM

Show answer
Correct Option: C