Tag: 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