Answer - Truncate command is used to remove all rows of the
column.The removed records are not recorded in the transaction log......
Answer - Shared Lock allows simultaneous
access of record by multiple Select statements. Shared Lock blocks record from
updating and will remain in queue waiting while record is accessed for
reading......
Answer - Column with identity property
contains unique system generated value in the table. Column with identity
property is similar to AutoNumber field in MS Access....
Answer - Master database is system database.
It contains information about server’s configuration. It is a very important
database and important to backup Master.....
Answer - SQL Profiler is a tool that stores
events from the server. SQL Profiler saves the events in the trace file......
Answer - A transaction is a set of
operations that works as a single unit. The ransactions can be categorized into
explicit, autocommit, and implicit....
Answer - Restricting query result means
return of required rows instead of all rows of the table. This helps in
reducing network traffic......
Answer - Both are used for filtering of
records based on filtered criteria.....
Answer - This is the default and recommended
security mode. In this mode, access to SQL server is controlled by Windows
NT.....
Answer - It is system variable that returns error code of the
SQL statement.....