True

False

The field mentioned in the where clause should be one of the columns selected

The distinct function can not be used on a field of type Char

The Integer value mentioned in the where clause should not be enclosed by quotes since it is of integer type.

none of the above.

True

False

left,right

right,left

left,left

right,right

UNION ENTIRE

FULL UNION

UNION ALL

none of the above

Select employee_name,count() from employee_Details group by employee_id where count()>2;

Select employee_name,employee_id,count() from employee_Details group by employee_id having count()>2;

Select employee_name,employee_id,count() from employee_Details order by employee_id where count()>2;

NONE of THE ABOVE

Under Read

neither a,c or d

Uncommitted Read

Uncommitted Ride

can read data that has been changed and committed.

can read data that has been changed but is not yet committed.

both a and b

neither a or b

delete * from employee_Details

delete from employee_Details

truncate table employee_Details

drop table employee_Details

Sp_helpdb

sp_helpprocess

sp_who2

select * from sys.sysprocesses

1433

1434

1432

1435

Bulk logged

Half

Full

Simple

Builtin/Administrator

Windows authentication

Mixed mode

SQL authentication

Fire truncate command

Backup the transaction log

Backup the database

Logs cannot be truncated in SQL Server

Bit Map

clustered

Non clustered

filter

covering

Composite

4,Model

4,MSDB

5,MSDB

5,Master

8,64 MB

8,64 KB

16,64 KB

10,86 MB

Logical form of table

Physical view of table

Logical view of table

View are thoes which are created on Stored procedure

Data Guard

Clustering

Mirroring

Transaction log shipping

RAC

Workgroup

Express

Standard

Enterprise