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.
- A database component that stores the raw bits and bytes of data is called ________
A. DBMS
B. schema
C. Physical Data Store
D. None of the Above
Answer
C. Physical Data Store - A database component that contains descriptive information about the data stored in the physical data store is called _________
A. Schema
B. Attribute
C. Table
D. None of the Above
Answer
A. Schema - A consistent state among foreign key and primary key values is called _________
A. Schema
B. Attribute
C. Referential Integrity
D. None of the Above
Answer
C. Referential Integrity - A formal technique for evaluating and improving the quality of a relational database schema is known as ________
A. Integration
B. Normalization
C. Dependency
D. None of the Above
Answer
B. Normalization - One or more databases are hosted by a single DBMS running on a single server is called __________
A. Single database server architecture
B. Replicated database server architecture
C. Partitioned database server architecture
D. Cloud-based database server architecture
Answer
A. Single database server architecture - Complete database copies are hosted by cooperating DBMSs running on multiple servers is called __________
A. Single database server architecture
B. Replicated database server architecture
C. Partitioned database server architecture
D. Cloud-based database server architecture
Answer
B. Replicated database server architecture - Potential problems in the design of a relational database are known as ___________
A. update anomalies
B. relational anomalies
C. modification anomalies
D. select anomalies
Answer
A. update anomalies - The conversion of an unnormalized table to first normal form requires the removal of _________
A. interrelation constraints
B. repeating groups
C. determinants
D. None of the Above
Answer
B. repeating groups - _________ normal form has an additional condition that the only determinants the table contains are candidate keys.
A. Fourth
B. Second
C. Third
D. First
Answer
C. Third - A set of requirements that is necessary to support the operations of a particular database user is known as a(n) _________
A. user view
B. user attribute
C. user table
D. user field
Answer
A. user view
AffairsCloud Recommends Oliveboard Mock Test
AffairsCloud Ebook - Support Us to Grow
Govt Jobs by Category
Bank Jobs Notification
