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.
- DBMS is an intermediate between the user and the _________
A. Information
B. Meta Data
C. Database
D. None of the Above
Answer
C. Database - What is the relationship between programs and data in the database approach?
A. Data abstraction
B. Data Model
C. Meta Data
D. None of the Above
Answer
A. Data abstraction - Which describes physical storage structure of the database?
A. External or View level
B. Conceptual Level
C. Internal Level
D. None of the Above
Answer
C. Internal Level - Which describes structure of the whole database for a community of users?
A. External or View level
B. Conceptual Level
C. Internal Level
D. None of the Above
Answer
B. Conceptual Level - A(n) _________ backup produces a complete copy of the entire database.
A. Entire
B. Full
C. Half
D. None of the Above
Answer
B. Full - A(n) ____ is a uniquely identifiable object that allows a given person to log on to the database.
A. user
B. client
C. server
D. None of the Above
Answer
A. user - ________ backups take place while the user is working on the database.
A. Specialization
B. Concurrent
C. server
D. None of the Above
Answer
B. Concurrent - A(n) ____ data dictionary is automatically updated by the DBMS with every database access.
A. Active
B. Passive
C. In Active
D. None of the Above
Answer
A. Active - In which architecture, multiple distributed database servers are used and the database schema is partitioned?
A. Single database server architecture
B. Replicated database server architecture
C. Partitioned database server architecture
D. Cloud-based database server architecture
Answer
C. Partitioned database server architecture - In which architecture, cloud computing service provider is used to provide some or all database services?
A. Single database server architecture
B. Replicated database server architecture
C. Partitioned database server architecture
D. Cloud-based database server architecture
Answer
D. Cloud-based database server architecture
AffairsCloud Recommends Oliveboard Mock Test
AffairsCloud Ebook - Support Us to Grow
Govt Jobs by Category
Bank Jobs Notification