When utilizing a unique secondary index, how may AMP (s) is usually accessed?
All-AMP
One-AMP
Multi-AMP
Two-AMP
How would you define a transaction?
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
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.
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;
In a database row is also called as
Query
Attribute
Relation
Record
which of the following denote single value function used in SQL
AVG ( )
SQRT ( )
COUNT ( )
All the Above
While creating tables the concept that is used to reduce redundancy in data is called
Views
Aliases
Sequence
Normalization
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
100 rows
50 rows
150 rows
5000 rows
Which isolation level doesn't exists
Isolation level2
Isolation level3
Isolation level4
Isolation level1
Which normal forms require that non-key columns be functionally dependent solely on the primary key?
Second
Fifth
Third
None of above
Which of the following options is FALSE about unchained mode in ASE
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