DBMS MCQ Questions With Answers Set 3

database mcqs, dbms mcqs for nts

A database, often abbreviated as DB, is a collection of data organized in such a manner that a computer application can fast select desired pieces of information. A database-management system (DBMS) is a computer 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, update, and administration of databases. DBMSs include MySQL, PostgreSQL, EnterpriseDB, MongoDB, MariaDB, Microsoft sq. Server, Oracle, Sybase, SAP HANA, MemSQL, SQLite and IBM DB2.

DBMS MCQs questions with answers set 3 includes the MCQs related to the topics such as database environment, three-level-architecture, mapping, data independence, introduction to database models, database development process, database administrator, data dictionary, logical database design, physical database design and functions of the database management system. This database MCQs series may help students or job seekers who are preparing their NTS educators, PPSC lecturer computer science, FPSC, CSS and database administrator, database manager, or database developer jobs test.


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
View Answer
Correct: C


2. Which Of three schemas used in three-schema model represents how users view database?
A). Internal
B). External
C). Implementation
D). Conceptual
View Answer
Correct: B


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


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


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
View Answer
Correct: B


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


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
View Answer
Correct: B


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


9. When discussing a data model under construction, users speak in terms of _________ schema they work With, Which database developers must translate into ______ schema?'
A). External, internal
B). Internal, implementation
C). Internal, conceptual
D). External, conceptual
View Answer
Correct: D


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


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
View Answer
Correct: D


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
View Answer
Correct: A


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


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
View Answer
Correct: A


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
View Answer
Correct: D


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


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


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


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
View Answer
Correct: C


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


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


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
View Answer
Correct: A


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
View Answer
Correct: D


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
View Answer
Correct: B


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




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

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

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

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

About the Author

My Name is M. Zahid, I have master degree in Computer Science. Currently I am working as an Information Technology Teacher in Govt sector of Pakistan. Blogging is my passion and I try my best to deliver some useful contents on our blogs for my res…
Oops!
It seems there is something wrong with your internet connection. Please connect to the internet and start browsing again.
AdBlock Detected!
We have detected that you are using adblocking plugin in your browser.
The revenue we earn by the advertisements is used to manage this website, we request you to whitelist our website in your adblocking plugin.