Tag: databases

Questions Related to databases

  1. A logon, submittal of work, and logoff

  2. A single sql statement

  3. A logical unit or work

  4. A single sql, statement and the unit of recovery


Correct Option: C
  1. select count() from emp group by empno having count() >2;

  2. select empno, count() from emp having count() >2;

  3. select empno, count() from emp where count() >2;

  4. select empno, count() from emp group by empno having count() >2;


Correct Option: D

In a database row is also called as

  1. Query

  2. Attribute

  3. Relation

  4. Record


Correct Option: D

Which isolation level doesn't exists

  1. Isolation level2

  2. Isolation level3

  3. Isolation level4

  4. Isolation level1


Correct Option: C
  1. A commit tran is always implied for every transaction.

  2. Unchained mode is the default mode in ASE

  3. The server does not issue the begin tran implicity

  4. The value of @@tranchained is 0


Correct Option: A