DBMS Questions and Answers updated daily – Computer Knowledge



310 DBMS Questions and answers section with explanation for various online exam preparation, various interviews, Computer Knowledge DBMS online test. DBMS Questions with detailed description, explanation will help you to master the topic.

DBMS Questions

1. The type of relationship between attributes in which similar entity participates more than once by playing different roles is classified as



SHOW ANSWER
Correct Ans:recursive relationship
Explanation:


2. In traditional DBMS, the application programs are considered to be the part of domain of



SHOW ANSWER
Correct Ans:software engineering
Explanation:


3. In entity-relationship diagram, the key attributes are represented by



SHOW ANSWER
Correct Ans:oval shape and underline
Explanation:


4. The partial key is differentiated by other keys in database by underlining the key with



SHOW ANSWER
Correct Ans:dotted line
Explanation:


5. In ER diagrams, the partial participation is shown by



SHOW ANSWER
Correct Ans:single line
Explanation:


6. The two main types of constraints of entity relationships are



SHOW ANSWER
Correct Ans:both b and c
Explanation:


7. IN DBMS, the set of associations can be defined among different entities from different entity types as



SHOW ANSWER
Correct Ans:both b and c
Explanation:


8. The set of key attributes that identify weak entities related to some owner entity is classified as



SHOW ANSWER
Correct Ans:partial key
Explanation:


9. In entity-relationship, the entity type which has existence dependency constraint is classified as



SHOW ANSWER
Correct Ans:weak entity
Explanation:


10. In the database, the set of all entities related to a particular entity type is classified as



SHOW ANSWER
Correct Ans:entity set
Explanation:


11. In designing of software, the functional requirements are specified with the help of



SHOW ANSWER
Correct Ans:All of the above
Explanation:


12. The derived attributes in entity relationship diagrams are denoted by



SHOW ANSWER
Correct Ans:dotted oval
Explanation:


13. The attributes which have only more than one value for a specific entity are classified as



SHOW ANSWER
Correct Ans:multi-valued attributes
Explanation:


14. The weak entities are represented in UML diagrams by using aggregations called



SHOW ANSWER
Correct Ans:qualified aggregation
Explanation:


15. The total participation constraint is also known as



SHOW ANSWER
Correct Ans:existence dependency
Explanation:


16. In constructing ER diagrams, the double ovals are used to denote



SHOW ANSWER
Correct Ans:multi-value attributes
Explanation:


17. In the commercial database management system, the relational database model is also known as



SHOW ANSWER
Correct Ans:implementation data model
Explanation:


18. The constraint which specifies the minimum number of relationship instances is classified as



SHOW ANSWER
Correct Ans:participation constraint
Explanation:


19. The relationship type with two degrees is classified as



SHOW ANSWER
Correct Ans:binary relationship
Explanation:


20. The parent entity type or identifying entity type are considered as other names of



SHOW ANSWER
Correct Ans:dominant entity type
Explanation:





Are you seeking for good platform for practicing DBMS questions in online. This is the right place. The time you spent in Fresherslive will be the most beneficial one for you.

Online Test on DBMS @ Fresherslive

This page provides important questions on DBMS along with correct answers and clear explanation, which will be very useful for various Interviews, Competitive examinations and Entrance tests. Here, Most of the DBMS questions are framed with Latest concepts, so that you may get updated through these DBMS Online tests. DBMS Online Test questions are granted from basic level to complex level.

Why To Practice DBMS Test questions Online @ Fresherslive?

DBMS questions are delivered with accurate answer. For solving each and every question, very lucid explanations are provided with diagrams wherever necessary.

Practice in advance of similar questions on DBMS may improve your performance in the real Exams and Interview.

Time Management for answering the DBMS questions quickly is foremost important for success in Competitive Exams and Placement Interviews.

Through Fresherslive DBMS questions and answers, you can acquire all the essential idea to solve any difficult questions on DBMS in short time and also in short cut method.

Winners are those who can use the simplest method for solving a question. So that they have enough time for solving all the questions in examination, correctly without any tense. Fresherslive provides most simplest methods to answer any tough questions. Practise through Fresherslive test series to ensure success in all competitive exams, entrance exams and placement tests.

Why Fresherslive For DBMS Online Test Preparation?

Most of the job seekers finding it hard to clear DBMS test or get stuck on any particular question, our DBMS test sections will help you to success in Exams as well as Interviews. To acquire clear understanding of DBMS, exercise these advanced DBMS questions with answers.

You're Welcome to use the Fresherslive Online Test at any time you want. Start your beginning, of anything you want by using our sample DBMS Online Test and create yourself a successful one. Fresherslive provides you a new opportunity to improve yourself. Take it and make use of it to the fullest. GOODLUCK for Your Bright Future.


FreshersLive - No.1 Job site in India. Here you can find latest 2018 government as well as private job recruitment notifications for different posts vacancies in India. Get top company jobs for both fresher and experienced. Job Seekers can get useful interview tips, resume services & interview Question and answer. Practice online test free which is helpful for interview preparation. Register with us to get latest employment news/rojgar samachar notifications. Also get latest free govt and other sarkari naukri job alerts daily through E-mail.