151 DBMS MCQ Questions and Answer-DBMS Tutorial

This post includes the latest 151 questions and answers related to the database management system. Latest MCQ questions. A relational database consists of a collection ofa) Tablesb) Fieldsc) Recordsd) Keyse) none of these A __ in a table represents a relationship among a set of values.a) Columnb) Keyc) Rowd) Entrye) none of these b The … Read more

DBMS MCQ Questions and Answer Set-12

1-Which statement would add a column CGPA to a table Student which is already created? ALTER TABLE Student ADD COLUMN (CGPA NUMBER(3,1)); ALTER TABLE Student CGPA NUMBER(3,1); ALTER TABLE Student ADD (CGPA NUMBER(3,1)); ALTER TABLE Student ADD CGPA NUMBER(3,1); 2- Which statement is TRUE regarding ALTER statement? ALTER TABLE cannot be used to remove a … Read more

OOP’S & Java Interview Questions

OOP’S & Java Interview Questions What are the principle concepts of OOPS? There are four principle concepts upon which object-oriented design and programming rest. They are: Abstraction Polymorphism Inheritance Encapsulation (i.e. easily remembered as A-PIE). What is Abstraction? Abstraction refers to the act of representing essential features without including the background details or explanations. What … Read more

Python MCQ Questions Set-11

Here is an interesting Python Multiple choice questions Quiz. Attempting this MCQ will help you to evaluate your knowledge and skills. 1. What will be the output of the following Python code? count={}count[(1,2,4)] = 5count[(4,2,1)] = 7count[(1,2)] = 6count[(4,2,1)] = 2 tot = 0 for i in count:tot=tot+count[i] print(len(count)+tot) a) 25b) 17c) 16d) Tuples can’t … Read more

DBMS MCQ Questions and Answer Set-13

1.  The EXISTS keyword will be true if: Any row in the subquery meets the condition only All rows in the subquery fail the condition only Both of these two conditions are met Neither of these two conditions is met Explanation: EXISTS keyword checks for existance of a condition. 2. How many tables may be … Read more