MS SQL Server 2012 (Administrator) Assessment Test
As an MS SQL Server database administrator, your role is to be efficient in the datacenter to the cloud, Platform as a Service, and Linux as you administer databases in SQL Server on a number of platforms.
- 1.
How can you trace traffic hitting an SQL server? It can be traced using- A.
SQL profiler
- B.
SQL replication
- C.
SQL agent
- D.
Update statistics
- 2.
Which of these is not a type of SQL Replication?
- A.
Merge
- B.
Snapshot
- C.
Transaction
- D.
Transformation
- 3.
Which of these Replication uses a snapshot to seed the replication?
- A.
Merge
- B.
Snapshot
- C.
Transaction
- D.
Transformation
- 4.
How can you schedule jobs to run at set time or when a specific event occurs?
- A.
By Using the SQL Agent
- B.
By Using the SQL scheduler
- C.
By Using checkpoints
- D.
By calling update statistics
- 5.
What is a correlated sub-query?
- A.
A nested subquery not linked with an outer query
- B.
An outer query linked with a nested subquery
- C.
A nested subquery linked to an outer query
- D.
An outer query not linked to a nested subquery
- 6.
SQL supports__ types of authentication modes
- A.
2
- B.
3
- C.
4
- D.
5
- 7.
What type of subquery can you use to return multiple rows?
- A.
Multiple rows
- B.
Multiple columns
- C.
Single
- D.
Double rows
- 8.
Which of these functions is function is used to round up a non-integer value to the previous least integer?
- A.
UNION ALL
- B.
FLOOR
- C.
IDENTITY
- D.
UNION
- 9.
Which of these is not a type of trigger?
- A.
Error
- B.
Insert
- C.
Delete
- D.
Update
- 10.
What do we use collation for?
- A.
To change a table
- B.
To specify order in a table
- C.
To collect data from a table
- D.
To create rows in a table
Back to top