SQL Server  «Prev  Next»

SQL Server Overview - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Before you actually construct a database, what should you do?
Please select the best answer.
  A. Nothing. Begin constructing the database immediately.
  B. Construct a physical model.
  C. Construct a logical model.
  D. Construct your tables.

2. Within SQL Server Management Studio (SSMS), which component would you use if you wanted to browse the objects in a Timesheet database?
Please select the best answer.
  A. A web browser
  B. Object Explorer
  C. The Query Editor
  D. SQL Server Profiler

3. Before you can issue a query to SQL Server 2025, which service must already be running?
Please select the best answer.
  A. MSDTC
  B. MSSQLSERVER
  C. SQLSERVERAGENT
  D. DCOM Distributed Service

4. Within SQL Server Management Studio (SSMS), which component would you use if you wanted to issue an ad hoc query against a Timesheet database?
Please select the best answer.
  A. A web browser
  B. Object Explorer
  C. The Query Editor
  D. SQL Server Profiler

5. SQL Server Management Studio (SSMS) is the modern successor to which two legacy SQL Server 2000-era tools, merged into a single application starting with SQL Server 2005?
Please select the best answer.
  A. Enterprise Manager and Query Analyzer
  B. Enterprise Manager and SQL Server Profiler
  C. Query Analyzer and the Web Assistant Wizard
  D. Azure Data Studio and Query Analyzer