Tag: databases

15

16

255

49

A)Process control Block

B)Program Control Block

C)Program Communication Block

D)Process Communication Block

A)II

B)AI

C)IX

D)AJ

A)PSB

B)DBD

C)ACB

D)DBDGEN

Find the process in System Monitor and select Kill Process.

Find the process in Activity Monitor and select Kill Process.

Find the process in SQL Profiler and select Kill Process.

Find the process in SSRS and select Kill Process.

Class MyDictionary Implements Dictionary(Of String, String)

Class MyDictionary Inherits HashTable

Class MyDictionary Implements IDictionary

Class MyDictionary End Class Dim t As New Dictionary(Of String, String) Dim dict As MyDictionary = CType(t, MyDictionary)

A. Enable Anonymous access. Enable Integrated Windows authentication.

B. Enable Anonymous access. Enable Basic authentication

C. Disable Anonymous access. Enable Integrated Windows authentication.

D. Disable Anonymous access. Enable Basic authentication

The user had to have knowledge of the table and index structures.

Navigational data access was far slower than declarative access.

Navigational access languages required the coder to embed their queries inside a procedural language shell.

Navigational languages were far slower then SQL

SQL cannot support object-orientation

The same query can be written in many ways, each with vastly different execution plans.

SQL syntax is too difficult for non-computer professionals to use

SQL creates excessive locks within the database

Use the sys.dm_exec_requests dynamic management view.

Use the sys.dm_exec_sessions dynamic management view.

Use the sys.dm_exec_query_stats dynamic management view.

Use the sys.dm_exec_query_optimizer_info dynamic management view.