Intelligent MS SQL Basic Assessment Test
We sincerely welcome you to this informative Intelligent MS SQL basic assessment test! Developed by Microsoft, MS SQL is a relational database management system. Take this short basic assessment test to assess your knowledge of MS SQL. Please make sure to read all the questions very carefully before answering. All the questions in the quiz are mandatory and your scores are dependent on how many questions you get correct. Your scores will be reflected once you've completed answering the quiz. Keep learning and have fun!
- 1.What is a database?
- A.
A collection of data
- B.
A collection of structured data
- C.
A collection of similar data
- D.
A large collection of desimilar data
- 2.Which of these is referred to as a specified number of columns in a table?
- A.
Row
- B.
Records
- C.
Fields
- D.
Data
- 3.Which of these is a combination of fields which uniquely specify a row?
- A.
Unique key
- B.
Foreign key
- C.
Surrogate key
- D.
Primary key
- 4.The first normal form (1NF) is used to...
- A.
Remove all duplicate columns
- B.
Remove all duplicate rows
- C.
Remove all duplicate records
- D.
Remove all duplicate files
- 5.Which of these is a not a type of index?
- A.
Unique index
- B.
Ordinary index
- C.
Clustered index
- D.
Unclustered index
- 6.How many cluster indexes can be found in a table?
- A.
1
- B.
2
- C.
3
- D.
4
- 7.A code written to get information back from the database is called...
- A.
Command
- B.
Query
- C.
Question
- D.
SERP
- 8.What are the types of subquery?
- A.
Correlated and non-correlated
- B.
Query and question
- C.
Regular and irregular
- D.
Centralized and decentralized
- 9.The Scala user function is primarily used to return _____ from the database.
- A.
Table
- B.
Unit
- C.
Clause
- D.
Row
- 10.Which of these operators is used to return rows from the first query but not from the second query?
- A.
INTERSECT
- B.
UNION
- C.
MINUS
- D.
MULTIPLE