Category Archives: SQL Server DBA MCQs

A candidate key cannot be regarded as a possible primary key | SQL Server DBA Mcqs

A. True B. False Ans: B

Posted in SQL Server DBA MCQs | Leave a comment

What is the difference between adhoc queries from stored procedures? | SQL Server DBA Mcqs

A. Adhoc queries are placed embedded in the business logic code B. Stored procedures are placed embedded in the business logic code C. There is no difference as both are fired on the databases D. None of the above Ans: … Continue reading

Posted in SQL Server DBA MCQs | Leave a comment

What is a MULTI_USER in sql server? | SQL Server DBA Mcqs

A. users that have the appropriate permissions to connect to the database are allowed B. One user at a time is allowed to connect to the database C. Only some members are allowed to access the database D. Only the … Continue reading

Posted in SQL Server DBA MCQs | Leave a comment

Can we temporarily disable a login name? | SQL Server DBA Mcqs

A. Yes B. No Ans: A

Posted in SQL Server DBA MCQs | Leave a comment

Which of the following below are valid database states? | SQL Server DBA Mcqs

A. OFFLINE B. SUSPECT C. EMERGENCY D. All of the above Ans: D

Posted in SQL Server DBA MCQs | Leave a comment

Stored procedures are safe from SQL injection attacks | SQL Server DBA Mcqs

A. True B. False Ans: A

Posted in SQL Server DBA MCQs | Leave a comment

When SQL server is installed, which of the following databases are created by default? | SQL Server DBA Mcqs

A. Master B. Model C. Both a and b D. Root Ans: C

Posted in SQL Server DBA MCQs | Leave a comment

Why type of user is the default in sql server? | SQL Server DBA Mcqs

A. SINGLE_USER B. MULTI_USER C. RESTRICTED_USER D. ROOT_USER Ans: B

Posted in SQL Server DBA MCQs | Leave a comment

An index can be defined for a single column | SQL Server DBA Mcqs

A. True B. False Ans: B

Posted in SQL Server DBA MCQs | Leave a comment

What is the syntax for creating new login on the SQL sevrer? | SQL Server DBA Mcqs

A. USE LOGIN login_id WITH PASSWORD password B. CREATE LOGIN login_id WITH USE password C. CREATE LOGIN login_id USE password D. CREATE LOGIN login_id WITH PASSWORD password Ans: D

Posted in SQL Server DBA MCQs | Leave a comment