DBMS MCQ Questions With Answers Set 3

A database (DB) is a collection of data organized in a way that a computer application can quickly select desired information. A database management system (DBMS) is a software application that interacts with end-users, other programs, and the database itself to capture and analyze data. A general-purpose DBMS allows the definition, creation, querying, updating, and administration of databases.

Popular DBMSs include MySQL, PostgreSQL, EnterpriseDB, MongoDB, MariaDB, Microsoft SQL Server, Oracle, Sybase, SAP HANA, MemSQL, SQLite, and IBM DB2.

DBMS MCQs Set 3 covers topics such as the database environment, three-level architecture, mapping, data independence, database models, database development processes, the role of database administrators, data dictionaries, logical and physical database design, and the functions of a DBMS. This series of database MCQs is useful for students or job seekers preparing for GATE CSE, ISRO, IBPS IT Officer, UPSC IES, PPSC Lecturer Computer Science, FPSC, CSS exams, and for database administrator, SBI IT Officer, BIS Scientist or developer job tests.

Database Management System – DBMS MCQs Set 3

1. Which of the following is not one of the three schemas used in the ANSI/SPARC?
A). External
B). Internal
C). Implementation
D). Conceptual

2. Which of three schemas used in the three-schema model represents how users view the database?
A). Internal
B). External
C). Implementation
D). Conceptual

3. Which of three schemas used in the three-schema model is a complete logical view of the database?
A). Conceptual
B). External
C). Internal
D). Implementation

4. Which of three schemas used in the three-schema model shows physical storage using a particular product or technique?
A). Internal
B). External
C). Conceptual
D). Implementation

5. Which of the following data models stores data in table structures and performs various operations on table rows and columns?
A). Object
B). Relational
C). Hierarchical
D). Network

6. Although all database professionals are concerned with performance, select the database professional that is most likely to be concerned about database performance:
A). Application developer
B). Website designer
C). Database administrator
D). Database designer

7. Which data model creates parent-child relationships between data elements and restricts each child to have just one parent?
A). Relational
B). Hierarchical
C). Network
D). Object

8. Which of the following is not a major area for the database administrator?
A). Planning
B). Programming
C). Implementation
D). Security

9. When discussing a data model under construction, users speak in terms of the _______ schema they work with, which database developers must translate into ______ schema?
A). External, internal
B). Internal, implementation
C). Internal, conceptual
D). External, conceptual

10. The older logical database model that organizes data in a tree-like structure is?
A). Network
B). Relational
C). Hierarchical
D). Object

11. The hierarchical database is very efficient when?
A). Handling little amounts of transactions
B). Handling many transactions
C). Handling large amounts of data
D). a and c

12. Which data model creates parent-child relationships between data elements and enables each child to have more than one parent?
A). Network
B). Hierarchical
C). Relational
D). Object

13. DBA stands for?
A). Data basic Administration
B). Database authority
C). Database Administrator
D). Database Application

14. Which of the following represents a collection of concepts that are used to describe the structure of a database?
A). Data model
B). Data structure
C). Data type
D). Data warehouse

15. The relational model ________?
A). Was first proposed in 1970
B). Was developed by E- F- Codd
C). Was developed at IBM
D). All of these

16. Physical database design decisions must be made carefully because of impacts on?
A). Response times
B). Data accessibility
C). Security
D). All

17. An advantage of partitioning is _______?
A). Efficiency
B). Extra space and update time
C). Both A and B
D). None

18. A disadvantage of partitioning is_______?
A). Extra space and update time
B>. Simplicity
C). Both a and b
D). None

19. Merge relation is important because_______?
A). Different views may need to be integrated.
B). New data requirements may produce new relations to be merged.
C). Both a and b
D>. None

20. Organizing the database in computer disk storage is done in________?
A). Physical design
B). Logical design
C). Analysis
D). Implementation

21. Which of the following are basic data distribution strategies?
A). Partitioned
B). Centralized
C). Replication
D). All

22. _______ refers to a method of database distribution in which different portions of the database reside at different nodes in the network.
A). Partitioning
B). Replication
C). Splitting
D). Dividing

23. _______ refers to a method of database distribution in which one database contains data that are included in another database.
A). Splitting
B). Partitioning
C). Dividing
D). Replication

24. 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.
A). Instance, Schema
B). Schema, Instance
C). Relation, Domain
D). Relation, Schema

25. Relational schemas and other metadata about relations are stored in a structure called the _____?
A). Catalog
B). Log
C). Data Dictionary
D). Metadata

Read also>->>Database MCQs With Answers Set 2

Read also>->>Database MCQs With Answers Set 4