About Paper
Plino’s Database Administrator Certification exam evaluates the ability to design, implement and manage SQL Server databases. This paper contains 30 MCQs as per the given syllabus. Candidates are required to score a minimum of 30 marks out of 60 to successfully qualify for the examination.
Syllabus
1.Usage and history of Sql Server
2.Server Editions
3.Data Types
4.Command(DDL,DML,DQL,DCL,TCL)
1.Create Table, Delete Table, Update Data, Delete Data, Alter Table Commands
2.View
1.MIN,Max,SUM,AVG,Count Functions.
1.Comparison Operator
2.Union Operator
3.Intersect Operator
4.IN,NOT,Between,Is Null, Is Not Null operators .
5.Like Operator.
1.Primary Key, Foreign key
2.Composite Key
1.Clustered Indexes
2.Non-Clustered Indexes
1.Triggers
2.Locks
3.Sql Server Profiler
4.RAID
5.DB Auditing Tool
6.Log Shipping
7.Hybrid Model
8.Sql Server Agent
9.DotConnect
10.Transactions
11.Cursor
12.Stored Procedure
13.User Defined Functions
Exam Format
This is an online examination with 30 objective-type questions. Each question
carries 2 marks. The minimum qualifying marks are 50% of the total marks. The
candidates attaining the minimum qualifying marks shall be declared eligible
for E-certification.
Candidates may also seek re-examination by paying Rs. 600.