MCQ King
62 – bcp, sqlcmd, mssql-cli and sqlservr MCQ
1 / 25
1. Which utility in SQL Server is used for bulk copying data into or out of tables?
2 / 25
2. What is the primary use of the bcp Utility in SQL Server?
3 / 25
3. Which SQL Server utility is a command-line tool for executing T-SQL queries and scripts?
4 / 25
4. What is the primary purpose of the sqlcmd Utility in SQL Server?
5 / 25
5. Which utility in SQL Server is a cross-platform command-line client for SQL Server?
6 / 25
6. What is the primary use of the mssql-cli Utility in SQL Server?
7 / 25
7. Which utility in SQL Server is the database engine executable that runs as a Windows service?
8 / 25
8. What is the primary purpose of the sqlservr Utility in SQL Server?
9 / 25
9. Which SQL Server utility is commonly used for importing data from external sources into SQL Server tables?
10 / 25
10. What is the file format typically used with the bcp Utility for bulk data import and export?
11 / 25
11. Which utility in SQL Server allows you to interactively execute SQL queries and provides enhanced features for code editing and history?
12 / 25
12. What is the primary benefit of using the mssql-cli Utility over the sqlcmd Utility for SQL Server command-line interactions?
13 / 25
13. In SQL Server, which utility allows you to specify a query or script in a file and execute it from the command line?
14 / 25
14. What is the purpose of the -i option in the sqlcmd Utility?
15 / 25
15. In SQL Server, which utility provides the ability to specify connection details, such as the server name and authentication options, when executing queries from the command line?
16 / 25
16. What is the primary purpose of the -S option in the sqlcmd Utility?
17 / 25
17. Which utility in SQL Server is commonly used for exporting query results to text files?
18 / 25
18. What is the primary use of the -o option in the sqlcmd Utility?
19 / 25
19. In SQL Server, which utility allows you to specify the query timeout duration when executing queries from the command line?
20 / 25
20. What is the purpose of the -t option in the sqlcmd Utility?
21 / 25
21. Which SQL Server utility is commonly used for running diagnostic tests and managing server configurations?
22 / 25
22. What is the primary use of the sqlservr Utility’s configuration options?
23 / 25
23. In SQL Server, which utility allows you to configure server startup options?
24 / 25
24. What is the primary purpose of the -m option in the sqlservr Utility?
25 / 25
25. In SQL Server, what does starting SQL Server in single-user mode using the -m option allow you to do?
Your score is
Restart quiz