On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 49

Q1 | A set of objects that share a common structure and a common behavior is called:
  • Object
  • Class
  • Entity
  • None of these
Q2 | Every weak entity set can be converted into a strong entity set by:
  • using generalization
  • adding appropriate attributes
  • using aggregation
  • none of the above
Q3 | The number of entities to which another entity can be associated via a relationship set is expressed as:
  • Entity
  • Cardinality
  • Schema
  • Attributes
Q4 | The view of total database content is
  • Conceptual view.
  • Internal view.
  • External view
  • Physical view
Q5 | The file organization that provides very fast access to any arbitrary record of a file is:
  • Ordered file
  • Unordered file
  • Hashed file
  • B-tree
Q6 | What is not true about a view?
  • It is a definition of a restricted portion of the database
  • It is a security mechanism
  • It is always updatable like any other table
  • All are true
Q7 | The database schema is written in
  • HLL
  • DML
  • DDL
  • DCL
Q8 | Who developed SEQUEL?
  • Dr. E.F. Codd
  • Chris Date
  • Chamberlain
Q9 | Which of the following is used to get all the columns of a table?
  • *
  • @
  • %
  • #
Q10 | The first commercial RDBMS is:
  • INGRESS
  • DB2
  • ORACLE
  • None of these.
Q11 | Which of the following is not a DCL statement?
  • Rollback
  • Grant
  • Revoke
  • None of these
Q12 | Which of the following is the result of a select statement?
  • Trigger
  • Index
  • Table
  • None of these
Q13 | Which of the following clause specifies the table or tables from where the data has tobe retrieved?
  • Where
  • Table
  • From
  • None of these
Q14 | How many tables can be joined to create a view?
  • 1
  • 2
  • Database dependent
  • None of these
Q15 | Which of the following can be used to get those items that fall within a range?
  • IN
  • BETWEEN
  • DISTINCT
  • LIKE
Q16 | Which of the following constitutes a basic set of operations for manipulating relationaldata?
  • Predicate calculus
  • Relational algebra
  • Relational calculus
  • None of the above
Q17 | Which of the following is not a relational algebraic operation that is not form the settheory?
  • UNION
  • INTERSECTION
  • CARTESIAN PRODUCT
  • SELECT
Q18 | Which of the following is not a relational algebraic operation that is developedspecifically for the relational databases?
  • SELECT
  • UNION
  • JOIN
  • PROJECT
Q19 | Which is the symbol used to denote the SELECT operation?
  • Sigma
  • Rho
  • Pi
  • None of the above
Q20 | Which of the following operations need the participating relations to be unioncompatible?
  • UNION
  • INTERSECTION
  • DIFFERENCE
  • All of the above
Q21 | What will be the number of columns of CARTESIAN PRODCUT if the participatingrelations have 5 and 7 columns respectively?
  • 5
  • 12
  • 35
  • None of the above
Q22 | What will be the number of columns of CARTESIAN PRODCUT if the participatingrelations have 5 and 20 rows respectively?
  • 5
  • 20
  • 25
  • 100
Q23 | Which of the following is the operation that is used if we are interested in only certainattributes or columns of a table?
  • SELECT
  • PROJECT
  • UNION
  • JOIN
Q24 | Which of the following is not a procedural language?
  • Relational Algebra
  • SQL
  • Relational calculus
  • None of the above
Q25 | Who developed QBE?
  • C.J. Date
  • E.F. Codd
  • M.M. Zloof
  • None of the above