SQL Server is one of the most widely used databases. A test for SQL Server DBA
will try to analyse the technical knowledge and ability of the candidate to
deal with complicated issues with the database. This objective test is a
collection of 15 tricky questions which a DBA has to face in his work life.
Take this test to prepare yourself before you appear for a test as SQL Server
Test > SQL Server DBA
Here are few sample SQL Server DBA test/quiz questions
What is the difference between adhoc queries from stored procedures?
Adhoc queries are placed embedded in the business logic code
Stored procedures are placed embedded in the business logic code
There is no difference as both are fired on the databases
None of the above
What is the syntax for creating new login on the SQL sevrer?
USE LOGIN login_id WITH PASSWORD password
CREATE LOGIN login_id WITH USE password
CREATE LOGIN login_id USE password
CREATE LOGIN login_id WITH PASSWORD password
What is a MULTI_USER in sql server?
users that have the appropriate permissions to connect to the database are
One user at a time is allowed to connect to the database
Only some members are allowed to access the database
Only the system admin and some members are allowed to access the database
Click here to
start SQL Server DBA quiz/test
Master Database MSDB Database, TEMPDB Database, Model Database.........
What operations do SQL Server transaction logs support?
Explain the purpose of check points in a transaction log.
What is write-ahead transaction log?.............