Question 1

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

technology databases

Error: Not a GROUP BY Clause
X,0
X,1
Two rows of value (X,0) & (X,1)
No rows returned

Answer

Correct Option: C

Question 2

select max(5)*min(5)/avg(5) from dual group by dummy; o/p:

technology databases

5
25
125
1
Error: Syntax error

Answer

Correct Option: A

Question 3

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

technology databases

Error: Invalid Number
Error: Invalid Character
0
1
Error: divisor is equal to zero

Answer

Correct Option: A

Question 4

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

technology databases

Two rows of value X and X
Error: SQL command not properly ended
Error: Not a proper GROUP BY clause
X
NULL

Answer

Correct Option: A

Question 5

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

technology databases

X
Two rows of value X and X
Error: Not a proper ORDER BY clause
Error: SQL command not properly ended
1

Answer

Correct Option: D

Question 6

select connect from dual; o/p:

technology databases

Error: Missing expression
connect
It will show connection string name
NULL

Answer

Correct Option: A

Question 7

select rowid from dual;

technology databases

It will show one row but no no column,no value,not even NULL value
1
0
NULL

Answer

Correct Option: A

Question 8

select rownum from dual;

technology databases

It will show one row but no no column,no value-,not even NULL value
NULL
0
1

Answer

Correct Option: D

Question 9

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

technology databases

1
Values 1 to 50
Values 0 to 50
0

Answer

Correct Option: B

Question 10

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
No rows returned
Values 1 to 50
Values 0 & 1

Answer

Correct Option: B

Question 11

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

technology databases

NULL
Values 3 to 50
1
0

Answer

Correct Option: C

Question 12

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

technology databases

Construction
Destruction
Activation
Passivation
All the above

Answer

Correct Option: E

Question 13

Which of the following statements are correct?

technology databases

Every entity must have a primary key
It is not necessary to define primary key for an Entity
@Primary annotation is used for denoting a simple primary key
All the above

Answer

Correct Option: A

Question 14

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

RequiresNew
Supported
Never
Mandatory

Answer

Correct Option: C

Question 15

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

technology databases

True
False

Answer

Correct Option: B

Question 16

Thread creation allowed in EJB

technology databases

True
False

Answer

Correct Option: B

Question 17

INTERVAL PARTITIONING IS NOT SUPPORTED FOR INDEX-ORGANIZED TABLES.

technology databases

True
False

Answer

Correct Option: B

Question 18

INTERVAL PARTITIONING IS A PARTITIONING TECHNIQUE BASED ON

technology databases

HASH
MODULUS
RANGE
RANDOM

Answer

Correct Option: C

Question 19

INTERVAL PARTITIONING IS A PARTITIONING TECHNIQUE USED IN

technology databases

ORACLE 11G
ORACLE 10G
ORACLE 9I
ORACLE 9G
ORACLE 11I
ORACLE 8I

Answer

Correct Option: A

Question 20

MIXED NOTATION IS A FUNCTIONALITY USED IN

technology databases

ORACLE 11G
ORACLE 10G
ORACLE 9I
ORACLE 9G
ORACLE 11I
ORACLE 8I

Answer

Correct Option: A

Description: databases Online Quiz - 83
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 83

Find more quizzes from top tags