All exams are online now due to COVID related precautions read more

Certified SQL Server 2008 Programmer Sample Questions


Sample Questions
 

 

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

 For Support