Dear Aspirants,
Welcome to Online Computer Quiz in Affairscloud.com. Here we are providing sample questions in DBMS. It will be very useful for all SBI/IBPS/LIC exams and other competitive exams. We have also included some important questions that are repeatedly asked in previous exams.
- The ________ manages interaction between the end user and the database.
A. DP
B. DBMS
C. DM query engine
D. None of the Above
Answer
B. DBMS - A database that supports data distributed across several different sites is called a(n) ________ database.
A. desktop
B. distributed
C. workgroup
D. enterprise
Answer
B. distributed - Data ________is defined as “the condition in which all of the data in the database are consistent with the real-world events and conditions.”
A. verification
B. redundancy
C. inconsistency
D. integrity
Answer
D. integrity - _________ are the instructions and rules that govern the design and use of the database system.
A. Procedures
B. Hardware
C. Software
D. Data
Answer
A. Procedures - Activities that make the database perform more efficiently in terms of storage and access speed are known as performance _________
A. development
B. upgrades
C. enhancements
D. tuning
Answer
D. tuning - __________ is the de facto query language and data access standard supported by the majority of DBMS vendors.
A. DBMS
B. Access Query Language
C. 4GL
D. Structured Query Language
Answer
D. Structured Query Language - Where does the DBMS store the definitions of data elements and their relationships?
A. data map
B. data file
C. index
D. data dictionary
Answer
D. data dictionary - The term ____ refers to an organization of components that define and regulate the collection, storage, management, and use of data within a database environment.
A. people
B. DBMS
C. database system
D. hardware
Answer
C. database system - Data ____ exists when the same data are stored unnecessarily at different places.
A. fragmentation
B. dependency
C. redundancy
D. inconsistency
Answer
C. redundancy - Data ____ exists when it is possible to make changes in the data storage characteristics without affecting the application program’s ability to access the data.
A. mining
B. integrity
C. independence
D. inconsistency
Answer
C. independence
AffairsCloud Recommends Oliveboard Mock Test
AffairsCloud Ebook - Support Us to Grow
Govt Jobs by Category
Bank Jobs Notification