Tag: databases
Questions Related to databases
-
All-AMP
-
One-AMP
-
Multi-AMP
-
Two-AMP
-
A logon, submittal of work, and logoff
-
A single sql statement
-
A logical unit or work
-
A single sql, statement and the unit of recovery
-
select count() from emp group by empno having count() >2;
-
select empno, count() from emp having count() >2;
-
select empno, count() from emp where count() >2;
-
select empno, count() from emp group by empno having count() >2;
-
Query
-
Attribute
-
Relation
-
Record
-
AVG ( )
-
SQRT ( )
-
COUNT ( )
-
All the Above
-
Views
-
Aliases
-
Sequence
-
Normalization
-
100 rows
-
50 rows
-
150 rows
-
5000 rows
-
Isolation level2
-
Isolation level3
-
Isolation level4
-
Isolation level1
-
Second
-
Fifth
-
Third
-
None of above
-
A commit tran is always implied for every transaction.
-
Unchained mode is the default mode in ASE
-
The server does not issue the begin tran implicity
-
The value of @@tranchained is 0