Intelligent MS SQL Server 2014 Assessment Test
10 Questions
| Total Attempts: 206
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? - ProProfs]( "How many authentication modes are there in an SQL server?")
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? - ProProfs]( "Which of these allows an admin to monitor events in an SQL server?")
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? - ProProfs]( "What is the maximum level a recursive stored procedure can reach?")
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... - ProProfs]( "What happens to local temporary tables when connection is closed? They are...")
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?
- ProProfs]( "What type of table is created by ## commands?")
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? - ProProfs]( "Which of these can be applied to a column to limit the data that can be placed in it?")
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? - ProProfs]( "Which of these cannot be checked by the sign function?")
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... - ProProfs]( "All of these are types of trigger except...")
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? - ProProfs]( "Which of these tools can be used to copy a large amount of data in an SQL?")
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? - ProProfs]( "Which of these is used to compare only strings with strings?")
Which of these is used to compare only strings with strings?- A.
==
- B.
=
- C.
====
- D.
===
Trivia Questions Quiz On Cima Masters Gateway Assessment! A lot of people strive to get their master’s degree, some institutions vie CIMA as a master’s degree. Do you want to join the program but are worried you...
Questions: 10 | Attempts: 14763 | Last updated: Oct 21, 2019
-
Sample QuestionMicrobial fuel cells are considered a source of sustainable energy. Why? 1. They use living organisms as catalysts to generate electricity from certain substrates. 2. They use a variety of inorganic materials as substrates. 3. They can be installed in wastewater treatment plants to cleanse water and produce electricity. Which of the statements given above is/are correct?
Can You Pass The Educational Interpreter Performance Assessment Test? Educational interpreters are charged with translating classwork for students that have a hard time when it comes to hearing or is deaf. If you think you are...
Questions: 31 | Attempts: 8284 | Last updated: Oct 14, 2020
-
Sample QuestionWhat are the multiple levels or layers to analyzing a message?
Please select the best answer/s that fits with each question! Good luck!
Questions: 8 | Attempts: 6592 | Last updated: Dec 14, 2012
-
Sample QuestionWhich of the following would you NOT inspect while observing gait?
Back to top