Intelligent MS SQL Server 2014 Assessment Test
10 Questions
| Total Attempts: 104
.
Questions and Answers
- 1.Hose can you trace traffic hitting an SQL? 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.
Transaction
- B.
Transformation
- C.
Snapshot
- D.
Merge
- 3.Which of these Replication uses a snapshot to seed the application?
- A.
Merge
- B.
Transformation
- C.
Transaction
- D.
Snapshot
- 4.How can you schedule jobs to run at a 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 query not linked with an outer query
- B.
An outer query linked with a nested query
- C.
A nested sub query linked with an outer query
- D.
An outer query not linked to a nested query
- 6.SQL supports___types of authentication modes
- A.
4
- B.
5
- C.
2
- D.
7
- 7.What type of sub query can you use to return multiple rows?
- A.
Single
- B.
Multiple rows
- C.
Multiple columns
- D.
Double rows
- 8.Which of these functions is used 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