Estimating Statistics of Expression Results

1.

Which statement is used to define a cursor?

   A.) OPEN
   B.) FETCH
   C.) DECLARE CURSOR
   D.) @@FETCH_STATUS

Answer: Option 'C'

DECLARE CURSOR

2.

Which feature converts row data to column for better analytical view?

   A.) Views
   B.) Join
   C.) Pivot
   D.) Trigger

Answer: Option 'C'

Pivot

3.

Cursor that reflects the changes made to the database table even after the result set is returned

   A.) Static
   B.) Dynamic
   C.) FORWARD_ONLY
   D.) Keyset

Answer: Option 'B'

Dynamic

4.

Which of the following statements is/are not true for SQL profiler?

   A.) Enables you to monitor events
   B.) Check if rows are being inserted properly
   C.) Check the performance of a stored procedure
   D.) ALL

Answer: Option 'C'

Check the performance of a stored procedure

5.

Which of the following connection type supports application role permissions and password encryption?

   A.) OLE DB
   B.) DBLib
   C.) ODBC
   D.) OLE DB and ODBC

Answer: Option 'D'

OLE DB and ODBC

Estimating Statistics of Expression Results Download Pdf