Tag: databases

Questions Related to databases

When utilizing a unique secondary index, how may AMP (s) is usually accessed?
technology databases

  1. All-AMP

  2. One-AMP

  3. Multi-AMP

  4. Two-AMP

Show answer
Correct Option: D

How would you define a transaction?
technology 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

Show answer
Correct Option: C

Consider the emp table having columns empno, ename Which of the following SQL query fetches empno that occur more than twice in the emp table.

technology databases

  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;

Show answer
Correct Option: D

In a database row is also called as
technology databases

  1. Query

  2. Attribute

  3. Relation

  4. Record

Show answer
Correct Option: D

which of the following denote single value function used in SQL
technology databases

  1. AVG ( )

  2. SQRT ( )

  3. COUNT ( )

  4. All the Above

Show answer
Correct Option: B

While creating tables the concept that is used to reduce redundancy in data is called
technology databases

  1. Views

  2. Aliases

  3. Sequence

  4. Normalization

Show answer
Correct Option: D

A table T1 having 100 rows is joined with a table T2 with 50 rows without specifying the joined column in the where clause then result will have
technology databases

  1. 100 rows

  2. 50 rows

  3. 150 rows

  4. 5000 rows

Show answer
Correct Option: D

Which isolation level doesn't exists
technology databases

  1. Isolation level2

  2. Isolation level3

  3. Isolation level4

  4. Isolation level1

Show answer
Correct Option: C

Which normal forms require that non-key columns be functionally dependent solely on the primary key?
technology databases

  1. Second

  2. Fifth

  3. Third

  4. None of above

Show answer
Correct Option: C

Which of the following options is FALSE about unchained mode in ASE
technology databases

  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

Show answer
Correct Option: A