MS SQL Server - 8 - Managing Databases MCQ

8 – Managing Databases MCQ

Best of luck!

1 / 25

1. What is the primary role of a Database Administrator (DBin SQL Server?

Managing and maintaining database servers

Designing user interfaces

Writing application code

Performing data analysis

2 / 25

2. Which SQL Server role is responsible for performing administrative tasks such as creating and managing databases?

Data Analyst

Database Developer

Business Analyst

Database Administrator (DB

3 / 25

3. In SQL Server, what is the purpose of a system database?

To perform data analysis

To manage system configurations

To store user data

To execute queries

4 / 25

4. Which tool or utility can be used to perform administrative tasks on SQL Server instances and databases?

SQL Server Management Studio (SSMS)

SQL Server Profiler

SQLCMD

SQL Server Data Tools (SSDT)

5 / 25

5. What is the primary responsibility of a DBA when it comes to database backups in SQL Server?

Designing database schemas

Creating and managing backup strategies

Managing user permissions

Writing complex queries

6 / 25

6. Which SQL Server tool is commonly used to create and manage SQL Server Agent jobs for automated tasks and scheduling?

SQL Server Profiler

SQL Server Management Studio (SSMS)

SQL Server Configuration Manager

SQLCMD

7 / 25

7. In SQL Server, what is the purpose of the “sp_who” system stored procedure?

To execute a SELECT query

To create a new user database

To retrieve information about active user connections

To manage SQL Server services

8 / 25

8. How can you identify and kill a specific session in SQL Server that is causing performance issues?

By restarting the SQL Server service

By using the "sp_kill" stored procedure

By creating a new database

By using the "sp_who" stored procedure

9 / 25

9. What is the purpose of the “SQL Server Profiler” tool in SQL Server administration?

To optimize query performance

To monitor and capture SQL Server events and queries

To create and manage databases

To design user interfaces

10 / 25

10. Which SQL Server feature is used to manage the security and permissions of users and roles?

SQLCMD

SQL Server Agent

SQL Server Security

SQL Server Configuration Manager

11 / 25

11. In SQL Server, what is the primary role of the “SQL Server Configuration Manager” utility?

To manage SQL Server service configurations

To create and manage databases

To optimize query performance

To design user interfaces

12 / 25

12. What is the primary role of the “SQL Server Error Log” in SQL Server administration?

To create and manage backups

To store user data

To record system events and errors

To execute queries

13 / 25

13. Which SQL Server utility is used to troubleshoot and repair database corruption issues?

DBCC CHECKDB

SQL Server Profiler

Database Engine Tuning Advisor

SQLCMD

14 / 25

14. What is the primary purpose of the “SQL Server Agent” utility?

To design database schemas

To create and manage automated tasks and jobs

To manage SQL Server service configurations

To execute queries

15 / 25

15. In SQL Server, what is the purpose of the “SQL Server Agent Job Activity Monitor”?

To create and manage databases

To manage SQL Server services

To monitor and control SQL Server Agent jobs

To optimize query performance

16 / 25

16. Which utility in SQL Server is used for monitoring and capturing database activity, such as queries, transactions, and errors?

SQL Server Profiler

Database Engine Tuning Advisor

SQL Server Configuration Manager

SQL Server Management Studio (SSMS)

17 / 25

17. What is the primary purpose of SQL Server’s “Resource Governor” feature?

To design database schemas

To allocate system resources among multiple SQL Server instances

To create user databases

To execute queries

18 / 25

18. In SQL Server, what is the role of the “SQL Server Error Log”?

To record system events and errors

To manage SQL Server service configurations

To store user data

To create and manage backups

19 / 25

19. Which DBCC command in SQL Server is used to check the physical and logical consistency of a database?

DBCC CHECKTABLE

DBCC SHRINKDATABASE

DBCC CHECKDB

DBCC UPDATEUSAGE

20 / 25

20. In SQL Server, what is the primary role of the “DBCC SHRINKDATABASE” command?

To reduce the size of a database's data and log files

To create user databases

To optimize query performance

To check and repair database consistency

21 / 25

21. What is the purpose of the “SQL Server Error Log” in SQL Server administration?

To design user interfaces

To manage SQL Server service configurations

To store user data

To record system events and errors

22 / 25

22. Which DBCC command in SQL Server is used to update and correct the sysindexes table?

DBCC SHRINKDATABASE

DBCC UPDATEUSAGE

DBCC CHECKTABLE

DBCC CHECKDB

23 / 25

23. In SQL Server, what is the primary purpose of the “DBCC CHECKTABLE” command?

To check and repair the consistency of a specific table

To optimize query performance

To manage system configurations

To create user databases

24 / 25

24. What is the primary function of the “SQL Server Profiler” utility in SQL Server administration?

To optimize query performance

To capture and analyze SQL Server events and queries

To manage system configurations

To create and manage databases

25 / 25

25. How can you dock and undock panes in SQL Server Management Studio to customize the layout?

By pressing Ctrl+D

By dragging the pane to a different location

By clicking the "Close" button

By right-clicking and selecting "Dock"

Your score is

MS SQL Server – 8 – Managing Databases MCQ