Intelligent MS SQL Basic Assessment Test
10 Questions
Settings
-
+
Developed by Microsoft, MS SQL is a relational database management system. Take this short basic assessment test to assess your knowledge of MS SQL.
Questions and Answers
- 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
Back to top