My Report

SQL Server Mock Test 3


Correct Answer: 2 points | Wrong: -1 point
Grades: A* (100% score) | A (80%-99%) | B (60%-80%) | C (40%-60%) | D (0%-40%)
advertisement
 10%

Question 1 of 10

1. Which of the following is a control flow keyword?

Question 1 of 10

Question 2 of 10

2. We can create a full-text index on _____________

Question 2 of 10

Question 3 of 10

3. Which of the following database should be backed up regularly?

Question 3 of 10

Question 4 of 10

4. Which of the following language is used for procedural flow in SQL Server?

Question 4 of 10

Question 5 of 10

5. SQL Server 2008 has made several extensions to the XML Schema support which includes?

Question 5 of 10

Question 6 of 10

6. Point out the wrong statement.

Question 6 of 10

Question 7 of 10

7. Every database you create has which collection by default?

Question 7 of 10

Question 8 of 10

8. Which of the following statement drops the synonym?

Question 8 of 10

Question 9 of 10

9. Which of the following creates a new Microsoft Windows or SQL Server login account?

Question 9 of 10

Question 10 of 10

10. Which is the minimal permission that a user must have to drop the database?

Question 10 of 10


 

Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.