Skip to main content

Database FAQ's


“DBMS/RDBMS” Interview Questions With Answers".

Here, are some sample questions based on “RDBMS”. Read it carefully as these questions will improve your basic concept on RDBMS, and will help you in cracking any interview.


Click on any question to find out it's answers:


1) What Is A Database?
2) What Is DBMS & Database?
3) What Are The Advantages Of DBMS?
4) What Are The Disadvantages In File Processing System?
5) Discuss How To Know When There Is A Need Of DBMS & When There Is Not?
6) What Is Parallel & Distributed Database? Differentiate Them.
7) Differentiate Between File-Oriented System & Database System?
8) What Are The Applications Of Databases?
9) What Is The Importance Of Databases?
10) What Is DBMS & RDBMS?
11) What Are The Three Types Of Users In DBMS?
12) What Are The Disadvantages Of Database System?
13) Describe The Three Levels Of Data Abstraction?
14) Discuss About External/ View/Individual Level Of The Architecture?
15) Discuss About Logical/ Conceptual Level Of The Architecture?
16) Discuss About Internal/Physical/Storage Level Of The Architecture?
17) What Is Data Independence?
18) What Is Physical Data Independence?
19) What Is Logical Data Independence?
20) What Is A Data Model? What Are The Types Of Data Model?
21) What Is DDL (Data Definition Language), VDL (View Definition Language) and SDL (Storage Definition Language)?
22) What Is Data Storage - Definition Language?
23) What Is DML (Data Manipulation Language) and DML Compiler?
24) What Is DDL Interpreter?
25) What Is Data Model, E-R MODEL & Object Oriented Model?
26) What Is An Entity, Entity Type & An Entity Set?
27) What Is An Attribute? Also Define What Is A Domain?
28) What Are The Different Types Of Attributes In DBMS?
29) Differentiate Between Simple, Composite & Multi-Valued Attributes In DBMS?
30) What Are Relation Schema & A Relation?
31) What Is Degree Of A Relation?
32) Discuss The Properties Of A Relation?
33) What Is Relationship, Relationship Type & Relationship Set?
34) What Is Degree Of Relationship Type?
35) What Is A Recursive Relationship Type?
36) What Is An Extension Of Entity Type?
37) What Is Weak Entity Set?
38) What Is An Entity? Differentiate Between Strong & Weak Entity?
39) What Is An Attribute? What Are The Types Of Attributes?
40) Differentiate Between The Different Types Of Attributes?

 41) Define The Types Of Data Integrity Rules?
42) What Is A Table? What Is A Tuple? What Is A Relation?
43) What Are Extension & Intension?
44) What Is A View? How It Is Related To Data Independence?
45) What Is A View? Discuss The Difference Between A View & A Base Relation?
46) What Is A Key? What Are Different Types Of Keys In A Database?
47) What Is A Primary Key & Secondary Key?
48) What Is A Candidate Key & Alternate Key?
49) What Is A Super Key & Composite Key?
50) What Is Foreign Key?
51) What Is Normalization. Explain It In Detail?
52) What Is The Need For Normalization In DBMS?
53) What Are The Goals Of Normalization In DBMS?
54) State The Benefits Of Normalization In DBMS?
55) What Is Functional Dependency?
56) What Is Fully Functional Dependency?
57) What Is Partial Dependency?
58) What Is Transitive Dependency?
59) What Is A Trivial Functional Dependency?
60) What Is Multivalued Dependency?
61) What Are The Steps Of Normalization?
62) What Is First (1st) Normal Form (1NF)?
63) What Is Second (2nd) Normal Form (2NF)?
64) What Is Third (3rd) Normal Form (3NF)?
65) What Is Boyce-Codd Normal Form (BCNF)? Also Define Multivalued Dependency?
66) What is Fourth (4th) Normal Form (4NF)?
67) What is Fifth (5th) Normal Form (5NF)?
68) What Are The Lossless Inference Rules For Functional Dependencies (FD's) Or State The Armstrong's Axioms?
69) What Is Domain-Key Normal Form (DKNF)?
70) Define Transaction? Explain Different States Of Transaction?


71) Describe The ACID Properties Of A Transaction?
72) What Is Schedule & What Is The Importance Of Schedule?
73) What Do You Mean By Serializability In Transaction Processing?
74) What Are The Two Methods That Guarantee Serializability?
75) What Is Locking? What Are The Types Of Locking?
76) Discuss Two Phase Locking (2PL) Protocol?
77) What Is Meant By Deadlock In DBMS?
78) What Are The Three Techniques For Handling Deadlocks?
79) How You Can Identify, Prevent & Resolve A Deadlock?
80) What Is Timestamping? Between Timestamping & Locking Which Is A Better Concurrency Control Technique?

 81) What Is A Wait For Graph?

Comments

Post a Comment

Please share your opinions and suggestions or your experience in the comments section. This way we can all help each other...

Experienced guys can share their resumes at admin@interview-made-easy.com

Popular posts from this blog

Tell Me Something About Yourself - Interview Answers.

Try to introduce some of your most important employment-oriented skills as well as your education and accomplishments to the interviewer. Answer to this question is very important because it positions you for the rest of the interview . That's why this statement is often called the "Positioning Statement". One should take the opportunity to show his/her communication skills by speaking clearly and concisely in an organized manner. Since there is no right or wrong answer for this question hence it is important to appear friendly. YOUR ANSWERS CAN BE: 1) I am a person with strong interpersonal skills and have the ability to get along well with people . I enjoy challenges and looking for creative solutions to problems. 2) Besides the details given in my resume, I believe in character values, vision and action. I am quick in learning from mistakes. I am confident that the various tests that you have conducted will corroborate my competencies apti
132 comments
Read More »

HR Interview Questions With Simple Answers - Top 30.

Here are some very important HR questions which are often asked during Interviews and I believe these answers can really help you to get through....... Click on them to view the answer: 1) Tell Me Something About Yourself ? 2) What Are Your Strengths? 3) What Are Your Weaknesses? 4) How Do You Handle Pressure / Can You Work Well Under Pressure? 5) What Are Your Short Term Goals? 6) What Are Your Long Term Goals? 7) Where Do You See After 5 Years? 8) Why Should We Hire You? 9) What Is Your Salary Expectation? 10) Why Do You Want To Leave Your Current Job? 11) Do You Prefer To Work Alone Or As A Team Player? 12) What Made You Choose Your Major / Stream? 13) Why Didn’t You Pursue A Career In Your Major / Stream? 14) Why Do You Want To Work For Us? 15) Are You Willing To Travel? 16) Are You Willing To Take Risks? 17) What Do You Know About This Company? 18) What Do You Seek From A Job? 19) How Do You Evaluate Success? 20) During Your Performance Rev
79 comments
Read More »

Why Should We Hire You? - Interview Answers

The interviewer asks this question just to find out how your skills, experience and knowledge can add value to the job. Well to answer this question you need to learn what they are looking for and then tie them with your strengths. This ensures that you are a viable fit for the position. The more detail you give the stronger your answers will be. Try to summarize all your accomplishments and relate what makes you unique. The question can also be " Why should we hire you over other candidates? " OR "Why should we hire you over the others waiting to be interviewed?" Your answers can be: 1) You should hire me because I’m the best person for the job. I realize that there are likely other candidates who also have the ability to do this job. Yet I bring an additional quality that makes me the best person for the job - my passion for excellence. I am passionately committed to producing truly class results. 2) I believe I’m the perfect fit for this
40 comments
Read More »