On This Page

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

Q1 | Which of the following is an advantage of a database?
  • Reduction in Redundancy
  • Avoidance of inconsistency
  • Security enforcement
  • All of the above
Q2 | Which of the following is an example of a database application?
  • Computerized library systems
  • ATMs
  • Flight reservation systems
  • All of the above
Q3 | DBMS stands for________________?
  • Data blocking and Management Systems
  • Database Management Systems
  • Database Business Management Systems
  • None of the above
Q4 | What is the name of the system database that contains descriptions of the data in thedatabase?
  • Metadata
  • Data dictionary
  • Table
  • None of the above
Q5 | IMS stands for ___________
  • Information Management System
  • Internal Mechanical Security
  • International Managers Society
  • None of the above
Q6 | Which of the following is the oldest database model?
  • Hierarchical
  • Network
  • Relational
  • Object Oriented
Q7 | Which category of users need not be aware of the presence of the database system?
  • DBA
  • Naive
  • Casual
  • Application Programmers
Q8 | Database __________ , which is the logical design of the database, and the database _______,which is a snapshot of the data in the database at a given instant in time.
  • Instance, Schema
  • Relation, Schema
  • Relation, Domain
  • Schema, Instance
Q9 | Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________ .
  • Relations, Attribute
  • Attributes, Relation
  • Tuple, Relation
  • Tuple, Attributes
Q10 | Department (dept name, building, budget) and Employee (employee_id , name, deptname,salary) Here the dept_name attribute appears in both the relations .Here using common attributes in relation schema is one way of relating ___________ relations.
  • Attributes of common
  • Tuple of common
  • Tuple of distinct
  • Attributes of distinct
Q11 | A domain is atomic if elements of the domain are considered to be ____________units.
  • Different
  • Indivisbile
  • Constant
  • Divisible
Q12 | Which of the following products was an early implementation of the relational modeldeveloped by E.F. Codd of IBM?
  • IDMS
  • DB2
  • dBase-II
  • R:base
Q13 | The following are components of a database except ________
  • user data
  • Metadata
  • Reports
  • Indexes
Q14 | An application where only one user accesses the database at a given time is an exampleof a(n) ________ .
  • single-user database application
  • multiuser database application
  • e-commerce database application
  • data mining database application
Q15 | An on-line commercial site such as Amazon.com is an example of a(n) ________ .
  • single-user database application
  • multiuser database application
  • e-commerce database application
  • data mining database application
Q16 | SQL stands for ________ .
  • Structured Query Language
  • Sequential Query Language
  • Structured Question Language
  • Sequential Question Language
Q17 | Because it contains a description of its own structure, a database is considered to be ________
  • Described
  • metadata compatible
  • self-describing
  • an application program
Q18 | The following are functions of a DBMS except ________ .
  • creating and processing forms
  • creating databases
  • processing data
  • administrating databases
Q19 | Helping people keep track of things is the purpose of a(n) ________ .
  • Database
  • Table
  • Instance
  • Relationship
Q20 | A DBMS that combines a DBMS and an application generator is ________ .
  • Microsoft's SQL Server
  • Microsoft's Access
  • IBM's DB2
  • Oracle Corporation's Oracle
Q21 | Let us consider phone_number ,which can take single or several values . Treating phone_numberasan _________ permits instructors to have several phone numbers (including zero) associated with them.
  • Entity
  • Attribute
  • Relation
  • Value
Q22 | Given the basic ER and relational models, which of the following is INCORRECT?
  • An attribute of an entity can have more than one value
  • An attribute of an entity can be composite
  • In a row of a relational table, an attribute can have more than one value
  • In a row of a relational table, an attribute can have exactly one value or a NULL value
Q23 | In an object-oriented model, one object can access data of another object by passing:
  • Instance variable
  • Message
  • Variable
  • None of these
Q24 | A view of database that appears to an application program is known as:
  • Schema
  • Subschema
  • virtual table
  • none of the above
Q25 | An abstraction concept for building composite object from their component object is called:
  • Specialization
  • Normalization
  • Generalization
  • Aggregation