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 - ProProfs]( "How can you trace traffic hitting an SQL server? It can be traced using")
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? - ProProfs]( "Which of these is not a type of SQL Replication?")
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? - ProProfs]( "Which of these Replication uses a snapshot to seed the replication?")
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? - ProProfs]( "How can you schedule jobs to run at set time or when a specific event occurs?")
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? - ProProfs]( "What is a correlated sub-query?")
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 - ProProfs]( "SQL supports__ types of authentication modes")
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? - ProProfs]( "What type of subquery can you use to return multiple rows?")
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? - ProProfs]( "Which of these functions is function is used to round up a non-integer value to the previous least integer?")
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? - ProProfs]( "Which of these is not a type of trigger?")
Which of these is not a type of trigger?- A.
Error
- B.
Insert
- C.
Delete
- D.
Update
- 10.
![What do we use collation for? - ProProfs]( "What do we use collation for?")
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
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?
Questions: 31 | Attempts: 8284 | Last updated: Oct 14, 2020
-
Sample QuestionWhat are the multiple levels or layers to analyzing a message?
Questions: 8 | Attempts: 6592 | Last updated: Dec 14, 2012
-
Sample QuestionWhich of the following would you NOT inspect while observing gait?
Back to top