1. The option to start the SQL Server instance with minimal configuration is ______________.

A. -i

B. -f

C. -l

D. None of the above

2. The special connection to SQL Server used by DBA under sever resource depletion is ______________.

A. AC

B. DAC

C. PAC

D. None of the above

3. The authentication which uses local windows credentials is ______________.

A. SQL Server Authentication

B. Local Authentication

C. Windows Authentication

D. None of the above

4. The numeric data type is synonym for ______________.

A. Decimal

B. Integer

C. Bigint

D. None of the above

5. The option in create index command which defines storage percentage for each index page during creation is______________.

A. Fillfactor

B. Unique

C. Clustered

D. None of the above

Answers: 1 (B), 2 (B), 3 (C), 4 (A), 5 (A)

More Practice Test at:

https://www.vskills.in/practice/quiz/SQL-Server-2008

Apply Certification

https://www.vskills.in/certification/Certified-SQL-Server-2008-Programmer