Placement papers on SQL Server - Set 3

Placement papers on SQL Server - Set 3

1. Which of the following commands below are used to run a stored procedure?

EXEC MyStoredProcedure
EXECUTE MyStoredProcedure
RUN MyStoredProcedure
Both a and b above
View Answer / Hide Answer


2. Which of the following below are capabilities of SQL Server Integration Services (SSIS)?

integrate smoothly with other applications and data sources.
copy or download files
ALL
send e-mail messages in response to events
View Answer / Hide Answer


3. Which of the follwing statements is/are not true for SQL profiler?

enables you to monitor events
check if rows are being inserted properly
check the performance of a stored procedure
ALL
View Answer / Hide Answer


4. ______________ Allows you to provide the full path to a template.

Trace file name
Trace file path
Template name
Trace name
View Answer / Hide Answer


5. Which of the following below are Compound Operators in sql server 2008

+=
%=
*=
all of above
View Answer / Hide Answer


6. Which statement is correct from partitioned view?

We cannot create an indexed view on a partitioned view
We can create an indexed view on a partitioned view as long as the index is clustered
We can create an indexed view on a partitioned view
View Answer / Hide Answer


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

OLE DB
DBLib
ODBC
OLE DB and ODBC
View Answer / Hide Answer


8. Which of the following DBCC command is used to see when was the last time the index rebuild?

DBCC SHOW_STATISTICS
DBCC SHOWCONFIG
DBCC DBREINDEX
View Answer / Hide Answer