Intelligent MS SQL Server 2014 Assessment Test
10 Questions
| Total Attempts: 234
Powerful, reliable, free, rich, and lightweight are words that describe Microsoft SQL Server 2014, which is a data management system used for delivering data stores for websites and desktop apps. Take this quiz to find out more.
Questions and Answers
- 1.
How many authentication modes are there in an SQL server?- A.
7
- B.
6
- C.
2
- D.
3
- 2.
Which of these allows an admin to monitor events in an SQL server?
- A.
SQL profiler
- B.
Local table
- C.
Sub query
- D.
SQL server agent
- 3.
What is the maximum level a recursive stored procedure can reach?
- A.
40
- B.
200
- C.
32
- D.
48
- 4.
What happens to local temporary tables when connection is closed? They are...
- A.
Transferred
- B.
Deleted
- C.
Converted to numbers
- D.
Change to rows
- 5.
What type of table is created by ## commands?
- A.
Global temporary table
- B.
Local temporary table
- C.
Column table
- D.
Row table
- 6.
Which of these can be applied to a column to limit the data that can be placed in it?
- A.
Server agent
- B.
Check constraint
- C.
Column sub query
- D.
Coalesce
- 7.
Which of these cannot be checked by the sign function?
- A.
Positive
- B.
Negative
- C.
Zero
- D.
Alphabet
- 8.
All of these are types of trigger except...
- A.
Update
- B.
Instead of
- C.
Insert
- D.
Pull
- 9.
Which of these tools can be used to copy a large amount of data in an SQL?
- A.
Copy
- B.
Large copy
- C.
Bulk copy
- D.
Cut
- 10.
Which of these is used to compare only strings with strings?
- A.
==
- B.
=
- C.
====
- D.
===
Back to top