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.
- Which of the following is/are advantages of DBMS?
A. Increased Security
B. Data Integrity
C. Avoids Data redundancy
D. All of the Above
Answer
D. All of the Above - The process of keeping information uniform is called _______
A. Data consistency
B. Data redundancy
C. Increased Security
D. None of the Above
Answer
A. Data consistency - _________ is a form of database management that keeps data separated from all programs that make use of it.
A. Data independence
B. Data redundancy
C. Increased Security
D. None of the Above
Answer
A. Data independence - The specific representation of an external view, that is, the end user’s view of the data environment is known as __________
A. External Schema
B. Internal schema
C. Both (A) and (B)
D. None of the Above
Answer
A. External Schema - The DBMS allows the user to specify what must be done, without having to specify how it is to be done, by using a(n) ________
A. access control
B. query language
C. table generator
D. security system
Answer
B. query language - All fields for a specific entity can be grouped together as a __________
A. database
B. file
C. field
D. record
Answer
D. record - A record consists of a _______
A. group of files
B. character
C. collection of related records
D. set of one or more fields
Answer
D. set of one or more fields - The design of a _________ database recognizes the use of historical and aggregated data.
A. multiuser
B. data warehouse
C. single-user
D. production
Answer
B. data warehouse - The ________ is a specialized database that stores data in a format optimized for decision support.
A. production database
B. distributed database
C. workgroup database
D. data warehouse
Answer
D. data warehouse - Another name for a production database is a _______ database.
A. data mining
B. development
C. warehousing
D. transactional
Answer
D. transactional
AffairsCloud Recommends Oliveboard Mock Test
AffairsCloud Ebook - Support Us to Grow
Govt Jobs by Category
Bank Jobs Notification