Question Paper of PTU DEP

Would you please provide here sample / old question paper of database administration subject for ADHNT (204) (S05) (Sem. - 2nd) exam of PTU ?

[Shaleen]

As you want I am here giving you sample / old question paper of database administration subject for ADHNT (204) (S05) (Sem. - 2nd) exam of PTU.

Sample paper :
a) What is meant by client / server?
b) What are the disadvantages of unattended installations?
c) What parameters need to be specified for TCP / IP network protocols?
d) Why are SQL server groups created?
e) What are the options in tools Menu?
f) What is T-SQL?
g) What are the advantages of RAID 2?
h) Why are the indexes being created?
i) Why do we have different security modes?
j) Why do we need SQL server logins?
k) When is restoring needed?
l) What is DTS?
m) What are EVENTS?
n) What are stored procedures?
o) What is the role of locks?
P.T.O. J-8005 [S-9700455]
Section - B
(9 × 5 = 45)
Q2) Compare relational and flat file databases.
Q3) Write the informations needed to configure SQL server.
Q4) What are the actions in SQL server under action menu?
Q5) Describe the features of enterprise manager.
Q6) Describe the different RAID levels.
Q7) How will you create views? Explain by an example.
Q8) What are the possible operations on databases?
Q9) Describe N-Tier security of SQL server.
Q10) Describe the features of database wizard.


Paper : Database Administration :ADHNT (204) (S05) (Sem. - 2nd) exam of PTU