Developed by Microsoft, MS SQL is a relational database management system. Take this short basic assessment test to assess your knowledge of MS SQL.
A collection of data
A collection of structured data
A collection of similar data
A large collection of desimilar data
Row
Records
Fields
Data
Unique key
Foreign key
Surrogate key
Primary key
Remove all duplicate columns
Remove all duplicate rows
Remove all duplicate records
Remove all duplicate files
Unique index
Ordinary index
Clustered index
Unclustered index
1
2
3
4
Command
Query
Question
SERP
Correlated and non-correlated
Query and question
Regular and irregular
Centralized and decentralized
Table
Unit
Clause
Row
INTERSECT
UNION
MINUS
MULTIPLE