On This Page

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

Q1 | Which of the following is characteristic of the data in a database?
  • Independent
  • Secure
  • Shared
  • All of these.
Q2 | Relationships could be of the following type:
  • One-to-one relationship
  • One-to-many relationships
  • Many-to-many relationships
  • All of these.
Q3 | In a file-oriented system there is:
  • Data inconsistency
  • Duplication of data
  • Data independence
  • Al of these.
Q4 | In a database system there is:
  • Increased productivity
  • Improved security
  • Economy of scale
  • All of these.
Q5 | VDL is used to specify:
  • Internal schema
  • External schema
  • Conceptual schema
  • None of these.
Q6 | The DML provides following functional access to the database:
  • Retrieve data and/or records
  • Add (or insert) records
  • Delete records from database files
  • All of these
Q7 | 4GL has the following components inbuilt in it:
  • Query languages
  • Report generators
  • Spreadsheets
  • All of these.
Q8 | Which of the following is database element?
  • Data
  • Constraints and schema
  • Relationships
  • All of these.
Q9 | What separates the physical aspects of data storage from the logical aspects of datarepresentation?
  • Data
  • Schema
  • Constraints
  • Relationships
Q10 | What scheme defines how and where the data are organized in a physical data storage?
  • External
  • Internal
  • Conceptual
  • None of these.
Q11 | Which of the following schemas defines the stored data structures in terms of thedatabase model used?
  • External
  • Conceptual
  • Internal
  • None of these
Q12 | Which of the following schemas defines a view or views of the database for particularusers?
  • External
  • Conceptual
  • Internal
  • None of these
Q13 | A collection of data designed to be used by different people is called.
  • Database
  • RDBMS
  • DBMS
  • None of these
Q14 | Which of the following is an object-oriented feature?
  • Inheritance
  • Abstraction
  • Polymorphism
  • All of these
Q15 | A physical data models are used to
  • Specify overall logical structure of the database
  • Describe data and its relationships
  • Higher-level description of storage structure and access mechanism
  • All of these
Q16 | Which data model organizes the data in the form of tables and relations?
  • Relational Model
  • Hierarchical Model
  • Network Model
  • none of the above
Q17 | Which company has developed the hierarchical model?
  • Oracle
  • IBM
  • Sun MicroSystems
  • Microsoft
Q18 | The name of the system database that contains descriptions of data in the database is
  • Data dictionary
  • Metadata
  • Table
  • None of these
Q19 | System catalog is a system-created database that describes:
  • Database objects
  • Data dictionary information
  • User access information
  • All of these
Q20 | Following is the type of metadata:
  • Operational
  • EDW
  • Data mart
  • All of these
Q21 | What is refined data?
  • Knowledge
  • Information
  • Statistics
  • None of the above
Q22 | Which of the following is a database element?
  • Data
  • Relationships
  • Constraints and Schema
  • All of the above
Q23 | What defines how and where data are organized in physical data storage?
  • Internal schema
  • External schema
  • Conceptual schema
  • None of the above
Q24 | What defines a view or views of the database for particular users?
  • Internal schema
  • External schema
  • Conceptual schema
  • None of the above
Q25 | To access information from a database, you need a ___________
  • EIS
  • DBMS
  • MIS
  • None of the above