Database Management System Set 49
Computer Science Engineering (CSE),
Bachelor of Science in Computer Science FY (BSc CS),
Bachelor of Science in Computer Science SY (BSc CS),
Bachelor of Science in Information Technology SY (BSc IT),
Bachelor of Computer Applications (BCA),
Bachelor of Business Administration in Computer Applications (BBA [CA]),
Bachelor of Science in Information Technology (BSc IT),
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