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
Business Rule Engine is a product which allows separating business rules from the application.
True
False
What are HA Options in SQL server 2005 database.
Data Guard
Clustering
Mirroring
Transaction log shipping
RAC
Which edition of SQL server supports Asynchronous mirroring.
Workgroup
Express
Standard
Enterprise
Using the Class Explorer to examine classes sorted alphabetically will allow you to view which type of inheritance?
Directed Inheritance
Pattern Inheritance
Class Inheritance
Genetic Inheritance
How to find out no. of objects in a database.
Sp_find
select * from Sys.sysobjects
select * from sys.dm_exec_objects
Sp_helpobjects