What command(s) you have to execute to know the processes running inside SQL server.
Sp_helpdb
sp_helpprocess
sp_who2
select * from sys.sysprocesses
On which port does SQL server runs.
1433
1434
1432
1435
Wchich recovery model should database be in for database mirroring to be configured on it
Bulk logged
Half
Full
Simple
What are the modes of authentication in SQL server database.
Builtin/Administrator
Windows authentication
Mixed mode
SQL authentication
What is process to truncate a transaction log in SQL server
Fire truncate command
Backup the transaction log
Backup the database
Logs cannot be truncated in SQL Server
Mark all the indexes which are their in SQL server
Bit Map
clustered
Non clustered
filter
covering
Composite
How many types of system database are therand which database stores information about jobs running on the SQL server
4,Model
4,MSDB
5,MSDB
5,Master
Waht is page size and Extent size in SQL server
8,64 MB
8,64 KB
16,64 KB
10,86 MB
What is view in sql server database
Logical form of table
Physical view of table
Logical view of table
View are thoes which are created on Stored procedure
What are HA Options in SQL server 2005 database.
Data Guard
Clustering
Mirroring
Transaction log shipping
RAC