SQL Server DBA Test 1

Which is the first version of SQL Server?


Installation of SQL Server Can be done in which authentication mode?


What is DML stands for?


Which one is DML statement?


Which SQL Statement is used to extract the data from database?


DDL stands for?


Which one of the following is DDL?


DCL Stands for?


Which of the following is DCL?


DML is used ...


DDL is used....


DCL is used...


TCL Stands for?


TCL is used...


which of the following are SQL Server System Databases?

















Description:

This gives u basic idea to test where we are as a DBA.
Each question is from different topics ..In that way we can cover all the topics from Installation ,backups,restores,File groups,Moving data between sql servers or from source to destination,log shipping,mirroring, clustering ,replication,security,performance Tuning,Monitoring.. WILL COME UP WITH DIFFERENT TEST ...
ALL THE BEST!!

Tags:

SQL DBA

Discussion

Adeelmail.Com

its good for beginners but post the question from level 2 dba also

1149 days 23 hours 39 minutes ago

SK 1249

Thank you so much guys for the feed back .. I will come up with some challenging questions this time .. didn't had enough time so couldn't update

1416 days 21 hours ago

Bhaskar

Nice questions.. plz put much difficulty

1438 days 3 hours 32 minutes ago

Saket Bottuwar

Good questions buy post more difficult questions as Harsh Varsheny Kanha advised

1811 days 19 hours 7 minutes ago

Alessandro

the first MS SQL version is 7 only for those who never worked on the previous.

2146 days 18 hours 40 minutes ago

Your Facebook Friends on WizIQ