RelationalDBDesign
SiteMap
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Database Web Apps
Data Manipulation
Access Features
Tables Queries
Monitoring SQL
«Prev
Next»
Configuration Monitoring
Importing/Exporting Data
Insert Data Load Statement
Select into Statement
Bulk Insert Statement
SQL Bulk Copy Program
Data Transformation Services
DTS Package Designer
Scheduling Running Package
Monitoring SQL-EM
Monitoring SQL Connections
Monitor Locked Resources
SQL-EM Monitor Locks
Overall System Performance
Monitor Data Cache
Monitor Performance using DBCC
Monitoring Databases
Monitor Database Size
use SQL-EM to Database Size
Monitor Databases using DBCC
Monitor Consistency Individual Tables
Miscellaneous DB Monitoring via Dbcc
Monitor Transaction Log
Maintaining Database Statistics
View Statistical Information
Run sqlmaint.exe
Database Maintenance Plan wizard
SQL-Em Conclusion
SQL Server System - Quiz
Each question is worth one point. Select the best answer for each question.
1.
To find out what the current connections to SQL Server are, you use which stored procedure?
Please select the best answer.
A.
sp_connection
B.
sp_who
C.
sp_user
D.
sp_helpuser
2.
When running
sp_monitor
SQL Server produces the following output:
Please select the best answer.
A.
14
B.
1
C.
7
D.
6
3.
Which of the following tools can be used to check for locking problems?
Please select all the correct answers.
A.
sp_lock
B.
sp_who
C.
SQL-EM
D.
sp_monitor