MCQ King

MS SQL Server Learn & MCQ Test

List of topics for learning and test:

  1. Database Systems An Overview MCQ
  2. Database Design MCQ
  3. Management Tools MCQ
  4. Planning Phase MCQ
  5. Installing SQL Server on Linux MCQ
  6. Installing SQL Server on Windows MCQ
  7. SQL Server Management Studio MCQ
  8. Managing Databases MCQ
  9. Query Editor and Solution Explorer MCQ
  10. Azure Data Studio MCQ
  11. SSMS and Azure Data Studio MCQ
  12. SQL Basic MCQ
  13. Data Types MCQ
  14. TSQL Functions MCQ
  15. NULL and Global Variables MCQ
  16. Create Database MCQ
  17. Create Table MCQ
  18. Integrity Constraints MCQ
  19. Alter Database & Table MCQ
  20. Removing Database Objects MCQ
  21. WHERE Clause MCQ
  22. IDENTITY and SEQUENCE MCQ
  23. Union and Case MCQ
  24. Subqueries MCQ
  25. Temporary Tables MCQ
  26. Joins MCQ
  27. Correlated Subqueries MCQ
  28. Table Expression MCQ
  29. Insert Update Delete MCQ
  30. TRUNCATE MERGE OUTPUT MCQ
  31. IF WHILE BLOCK MCQ
  32. Local Variables MCQ
  33. Set Commands MCQ
  34. TRY CATCH THROW MCQ
  35. Stored Procedures MCQ
  36. User-Defined Functions MCQ
  37. System Catalog MCQ
  38. System Stored Procedures and Functions MCQ
  39. Clustered and Nonclustered Indices (Index) MCQ
  40. Create Edit Indices MCQ
  41. Indices with Conditions and Joins MCQ
  42. View (Create Alter Remove) MCQ
  43. View Usage MCQ
  44. Encrypting Data MCQ
  45. Database System Security MCQ
  46. Schemas MCQ
  47. Managing Database Security MCQ
  48. Roles MCQ
  49. Managing Permissions MCQ
  50. Tracking and Data Security MCQ
  51. Locking MCQ
  52. Locking Commands MCQ
  1. Concurrency Models and Transactions
  2. Deadlock
  3. Lock Modes
  4. Isolation level
  5. Row Versioning
  6. Introduction of Trigger
  7. Triggers Usage
  8. System Databases
  9. Disk Storage
  10. bcp, sqlcmd, mssql-cli and sqlservr
  11. DBCC command
  12. Policy-Based Management
  13. Backup
  14. Backup Tasks
  15. Recovery
  16. System Availability
  17. Creating Jobs and Operators (SQL Server Agent)
  18. Alerts and Logs
  19. Replication Types and Models
  20. Managing Replication
  21. Query Processing
  22. Query Optimizing and Plans
  23. Query Optimizer Hints
  24. Performance
  25. Monitoring Performance
  26. Performance Monitoring Tool Part 1
  27. Performance Monitoring Tool Part 2
  28. Memory Optimized Tables
  29. In-Memory OLTP
  30. OLTP and Business Intelligence
  31. Data Warehouse
  32. Cubes and Architectures
  33. Multidimensional Model
  34. Tabular Model
  35. Partitioning
  36. CUBE and ROLLUP
  37. OLAP Query Functions
  38. Standard and Nonstandard Functions
  39. Reporting Services (SSRS)
  40. Data Partitioning
  41. Star Join Optimization and Indexed Views
  42. Columnstore Index
  43. JSON
  44. Spatial and Temporal Data
  45. Graph Databases
  46. Machine Learning