WorksheetsMS-SQL-SERVER-DAY 10
Total questions: 10
Worksheet time: 6mins
In this state, any of a number of commands,
including Create, Insert, Update, Delete, Drop
Implicit
Explicit
Roll Back
None
When ______ Transactions is set to OFF, SQL Server
will not initiate a transaction on its own.
Implicit
Explicit
Roll Back
None
Each individual statement is a ____transaction.
Implicit
Explicit
Roll Back
Auto Commit
Each transaction is starts with the BEGIN
TRANSACTION statement and ends with a COMMIT or ROLLBACK statement.
Implicit
Explicit
Roll Back
Auto Commit
__________are used to retrieve data from the
database more quickly than otherwise
Implicit
Index
Roll Back
Auto Commit
SQL Server supports two types of indexes
Clustered
Implicit
Non-Clustered
Explicit
Indexes can be deleted
TRUE
FALSE
There is a system table with the name _______ that
content information about indexes are available on tables into the database
MyIndex
DBIndex
None
SysIndex
Maintenance Plan is done for
Regular Backup
Disaster Management
Safeguard of Data
Improve Efficiency
In Maintenenance Plan, more than 1 DB cannot be
backedup
TRUE
FALSE
