Placement papers on SQL Server - Set 1

Placement papers on SQL Server - Set 1

1. The identifers in SQL can have a character range from?

1 to 100
1 to 128
1 to 64
1 to 132
View Answer / Hide Answer


2. Embedded spaces or special characters are not allowed in SQL server identifiers

True
False
View Answer / Hide Answer


3. ______________ helps to restore the database to the point where it failed.

File backup
Differential Backups
File log
Transaction log
View Answer / Hide Answer


4. Which of the following statements is/are false for Declarative Management Framework (DMF) in sql server 2008?

System for managing the instances of SQL Server 2008
SQL Server does not enforce to define the policies by using Management Studio
Both b and d
A policy can be designed for allowing the usage of unauthorized applications
View Answer / Hide Answer


5. Dynamic Page Repair is a type of database mirroring.
False
True
View Answer / Hide Answer


6. Which of the following statement is used to make sql server resize the database file to its smallest possible size?

DBCC SHRINKFILE
DBCC SHRINKDB
DBCC SQLPERF SHRINKDB
View Answer / Hide Answer


7. Difference between UNION and UNION ALL.

Both are similar
UNION ALL is no longer supported in sql server 2000 onward
UNION returns only unique records from both tables. UNION ALL returns all records from both tables
View Answer / Hide Answer


8. 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