Placement papers on SQL Server - Set 2

Placement papers on SQL Server - Set 2

1. Which utilities can we used to export data from sql server to a text file?

a. DTS export wizard
b. BCP
c. ISQL
a and b
View Answer / Hide Answer


2. How inserting data through stored procedure do reduces network traffic and increase database performance?

Stored procedure can accept parameter
Permission check is not required
The execution plan is stored in the cache after it was executed the first time.
View Answer / Hide Answer


3. What is the default "SORT" order for a SQL?

Ascending
Descending
View Answer / Hide Answer


4. Which of the following is not correct for DELETE and TRUNCATE?

DELETE table can be rolled back
TRUNCATE table cannot have triggers
TRUNCATE table can have criteria
DELETE table can have criteria
View Answer / Hide Answer


5. Choose the incorrect option about the sql server index

Two types of indexes - clustered indexes and non-clustered indexes
Both types use B-TREE for searching data
Only one clustered index on a table
More than one clustered index on a table
View Answer / Hide Answer


6. By default "FILLFACTOR" value is

Zero
One
Two
Five
View Answer / Hide Answer


7. The SQL Query Analyzer is the main interface for running SQL queries against your database

True
False
View Answer / Hide Answer


8. Which of the below is the correct syntax for a VIEW?

Both b and d below
CREATE VIEW ViewName AS INSERT ...
CREATE VIEW ViewName AS UPDATE ...
CREATE VIEW ViewName AS SELECT ...
View Answer / Hide Answer