Database Management System Set 47
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 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