Hello Friends,this particular section is well focused on the DBMS Basics mcq questions for placement. the set of questions are very basic and easily understandable by reader.we have kept the question hardness level to very basic.

 

1
. The full form of DDL is
  • Dynamic Data Language
  • Detailed Data Language
  • Data Definition Language
  • Data Derivation Language
2
. Which of the following is an advantage of view?
  • Data security
  • Derived columns
  • Hiding of complex queries
  • All of the above
3
. Which of the following is a legal expression in SQL?
  • SELECT NULL FROM EMPLOYEE;
  • SELECT NAME FROM EMPLOYEE;
  • SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL;
  • None of the above
4
. A set of possible data values is called
  • attribute
  • degree
  • tuple
  • domain
5
. Which of the operations constitute a basic set of operations for manipulating relational data?
  • Predicate calculus
  • Relational calculus
  • Relational algebra
  • None of the above
6
. Which of the following is another name for weak entity?
  • Child
  • Owner
  • Dominant
  • All of the above
7
. Which of the following database object does not physically exist?
  • base table
  • index
  • view
  • none of the above
8
. Which of the following is record based logical model?
  • Network Model
  • Object oriented model
  • E-R Model
  • None of these
9
. The natural join is equal to :
  • Cartesian Product
  • Combination of Union and Cartesian product
  • Combination of selection and Cartesian product
  • Combination of projection and Cartesian product
10
. Which one of the following is not true for a view:
  • View is derived from other tables.
  • View is a virtual table.
  • A view definition is permanently stored as part of the database.
  • View never contains derived columns.

 
 
You may be interested in:
Database Management System Basics MCQs
Database Management System Online Tests
Database Management System Short Questions With Answers
Database Management System Tutorials