Quiz Maker LogoMake your own QuizCopy & Edit
Make your own quizManage my QuizzesPlans / FeaturesGuides and HelpContactPrivacy & Security

SQL Server 2016 Runner's Test

What is the maximum number of cores supported by a database engine instance of SQL Server 2016 Standard?
8
16
24
32
Which of the following security features is NOT new to SQL Server 2016?
Always Encrypted
Dynamic Data Masking
Transparent Data Encryption
Row Level Security
What value will be displayed for string value 'SQLDay' after using Dynamic Data Masking with function partial(1, 'peedwa', 1)
PeedwaQLday
Speedway
Sp
PeedwaSQLDay
Which stored procedure allows to run R scripts inside the SQL Server 2016 database engine?
Sp_execute_r_script
Sp_runr
Sp_execute_script
Sp_execute_external_script
How many rows will the following query produce in SQL Server 2016?
 
SELECT STRING_SPLIT('SQLDay 2016 rocks!', ' ');
1
2
3
0
How many replicas are supported by Basic Availability Group feature in SQL Server 2016 Standard Edition?
2
4
3
6
Which of the following scalar functions is NOT new in SQL Server 2016?
STRING_ESCAPE
SESSION_CONTEXT
COMPRESS
CONTEXT_INFO
How many instances of SQL Server 2016 PolyBase service can run on a single server?
1
2
16
50
Can Live Query Statistics feature of SQL Server 2016 work with SQL Server 2014 instance?
YES
NO
Which function available in SQL Server 2016 can compress data using GZip algorithm?
COMPRESS
PACK
GZIP
ZIP
What is the purpose of the following statement in SQL Server 2016?
 

ALTER TABLE dbo.Product SET (SYSTEM_VERSIONING = ON);

Turn on CDC feature
Turn on Change Tracking feature
Turn on data versioning for Temporal Table feature
This is not a valid statement
In what year was the Polish SQL Server User Group (PLSSUG) founded?
2000
2006
2007
2010
Which edition of SQLDay do we have in 2016?
1st
5th
8th
10th
Which system view does allow to view database options set with ALTER DATABASE SCOPED CONFIGURATION statement in SQL Server 2016?
Sys.databases
Sys.database_scoped_configurations
Sys.database_configurations
Sys.configurations
What DMV can be used in SQL Server 2016 to show wait stats for a single session?
Sys.dm_exec_session_wait_stats
Sys.dm_exec_sessions
Sys.dm_os_session_wait_stats
Sys.dm_os_wait_stats
Which feature of SQL Server 2016 allows efficient operational analytics?
In-memory OLTP
ColumnStore Indexes
Query Store
Live Query Statistics
Which property has to be used in a predicate function for Row Level Security in SQL Server 2016?
ENCRYPTION
SCHEMABINDING
READONLY
EXTERNAL
{"name":"SQL Server 2016 Runner's Test", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"What is the maximum number of cores supported by a database engine instance of SQL Server 2016 Standard?, Which of the following security features is NOT new to SQL Server 2016?, What value will be displayed for string value 'SQLDay' after using Dynamic Data Masking with function partial(1, 'peedwa', 1)","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}

More Quizzes

Common chemotherapy drugs
31160
7th Pre Test
26130
TEST1
210
TYPES OF ASSESSMENTS
7428
Chapter 2 - Marketing
28140
Escha
7424
Er du dansk?
1050
If you get 8/10 ur like my best buddy
10517
The rock cycle
100
Test Your Knowledge on GIT and FOSS!
10531
Are you popular or just that one?
420
Pratique pour examen
33160
Quiz Maker Logo Make your own Quiz
Powered by: Quiz Maker