Database Interview in Technical Lead Round: Desc

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Database Interview in Technical Lead Round: Describe the advantages and disadvantages of DBMS-provided and application-provided security.

DBMS provided security :- Any database system requires you to login and then process the data depending on the rights given by the DBA to the user who has logged in. The advatage of such a system is securing the data and providing the user and the DBA the secured platform. Any user who logs in cannot do whatever he want but his role can be defined very easily. There is no major disadvantage about the DBMS provided security apart from overhead of storing the rights and priviledges about the users.
Application-provided security :- It is much similar to the DBMS provided security but the only difference is that its the duty of the programmer creating the application to provide all the seurities so that the data is not mishandled.

(Continued on next question...)

Other Job Interview Questions

• Engineering Interview in Technical Round: How can a candidate make a recovery if they get stumped ?
• Surviving The Technical Job Interview
• TECHNICAL QUESTIONS WHICH HAVE BEEN PUT TO KENT STUDENTS
• Engineering Interview in Technical Round: Describe one of the technical problems you had to solve.
• QUESTIONS THAT HAVE BEEN ASKED AT INTERVIEW FOR SCIENCE JOBS
• Engineering Interview in Technical Round: What is more important to you, money or success?
• Investment Banking Interview Questions - Technical Round
• C Technical Round Interview Questions and Answers
• Yahoo Interview questions in in Technical Round
• Project Manager Interview in Technical Round: What are some of the projects that you handled in the previous job?
• More...