databases Online Quiz - 83
Description: databases Online Quiz - 83 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
select dummy,count(1) from dual group by dummy; O/p:
select max(5)*min(5)/avg(5) from dual group by dummy; o/p:
select avg(dummy) from dual; o/p:
select min(dummy) from dual union all select max(dummy) from dual group by dummy; o/p: ??
select min(dummy) from dual order by dummy union all select max(dummy) from dual; O/p:
select connect from dual; o/p:
select rowid from dual;
select rownum from dual;
select level from dual connect by level between 0 and 50; o/p:
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:
select level from dual connect by level between 3 and 50; o/p:
Which of the following call backs are called for the stateful session bean?
Which of the following statements are correct?
Which transaction attribute should be set in the deployment descriptor for a method to guarantee that the method is NOT invoked with a transaction?
The annotation @PrePassivate be used for more than one method in a bean
Thread creation allowed in EJB
INTERVAL PARTITIONING IS NOT SUPPORTED FOR INDEX-ORGANIZED TABLES.
INTERVAL PARTITIONING IS A PARTITIONING TECHNIQUE BASED ON
INTERVAL PARTITIONING IS A PARTITIONING TECHNIQUE USED IN
MIXED NOTATION IS A FUNCTIONALITY USED IN