TRE 4.0 DBMS Quiz Practice Set 1 31st October 2026 Share On Que: (1). Which of the following is NOT a type of DBMS? Sequential DBMS C. Object-Oriented DBMS B. Relational DBMS A. More than one of the above D. None of the above E. Check Answer Open question page Que: (2). Which data model organizes data in the form of a tree structure? Network Model C. Relational Model A. Hierarchical Model B. More than one of the above D. None of the above E. Check Answer Open question page Que: (3). Which of the following is the primary purpose of a DBMS? To compile programming languages C. To design computer hardware B. To manage and organize data A. More than one of the above D. None of the above E. Check Answer Open question page Que: (4). Which of the following is an example of a Relational Database Management System? MySQL A. Redis C. MongoDB B. More than one of the above D. None of the above E. Check Answer Open question page Que: (5). In a relational database, a row is also known as: Domain C. Attribute A. Tuple B. More than one of the above D. None of the above E. Check Answer Open question page Que: (6). Which key uniquely identifies each record in a database table? Foreign Key A. Primary Key B. Alternate Key C. More than one of the above D. None of the above E. Check Answer Open question page Que: (7). Which database model allows a record to have multiple parent records? Network Model C. Relational Model B. Hierarchical Model A. More than one of the above D. None of the above E. Check Answer Open question page Que: (8). What is the full form of SQL? Sequential Query Language B. Structured Query Language A. Standard Question Language C. More than one of the above D. None of the above E. Check Answer Open question page Que: (9). Which property of a DBMS ensures that data remains accurate and consistent? Data Integrity B. Data Duplication C. Data Redundancy A. More than one of the above D. None of the above E. Check Answer Open question page Que: (10). Which of the following is a major advantage of using a DBMS? Improved Data Security B. Reduced Data Redundancy A. Data Sharing C. More than one of the above D. None of the above E. Check Answer Open question page Que: (11). In a relational database, what is a primary key? A key used to uniquely identify each record in a table A. A key used to sort records in a table C. A key used to establish relationships between tables B. More than one of the above D. None of the above E. Check Answer Open question page Que: (12). Which key is used to establish a relationship between two relational database tables? Foreign Key B. Super Key C. Candidate Key A. More than one of the above D. None of the above E. Check Answer Open question page Que: (13). What is a candidate key in a relational database? A key used only for sorting records C. A key that contains duplicate values A. A minimal set of attributes that uniquely identifies a record B. More than one of the above D. None of the above E. Check Answer Open question page Que: (14). What is a super key in a relational database? Any set of attributes that uniquely identifies a record A. A key that allows duplicate records C. A key that must contain only one attribute B. More than one of the above D. None of the above E. Check Answer Open question page Que: (15). Which of the following statements is correct about a composite key? It cannot be used as a primary key C. It consists of multiple attributes used together to identify a record A. It always contains only one attribute B. More than one of the above D. None of the above E. Check Answer Open question page Que: (16). Which constraint prevents duplicate values in a database column? DEFAULT Constraint A. UNIQUE Constraint B. CHECK Constraint C. More than one of the above D. None of the above E. Check Answer Open question page Que: (17). Which type of key can contain NULL values in a relational database? Primary Key A. Both Primary Key and Foreign Key C. Foreign Key B. More than one of the above D. None of the above E. Check Answer Open question page Que: (18). What is an alternate key in a relational database? A key containing duplicate values C. A candidate key selected as the primary key A. A candidate key not selected as the primary key B. More than one of the above D. None of the above E. Check Answer Open question page Que: (19). Which key is formed by combining two or more foreign keys? Alternate Key C. Composite Key B. Primary Key A. More than one of the above D. None of the above E. Check Answer Open question page Que: (20). Which of the following is NOT a property of a primary key? It uniquely identifies each record A. It cannot contain NULL values B. It can contain duplicate values C. More than one of the above D. None of the above E. Check Answer Open question page Que: (21). Which normal form ensures that every non-prime attribute in a table is fully functionally dependent on the primary key? Third Normal Form (3NF) C. Second Normal Form (2NF) B. First Normal Form (1NF) A. More than one of the above D. None of the above E. Check Answer Open question page Que: (22). Which normal form requires that all attribute values in a relation be atomic? Second Normal Form (2NF) B. Third Normal Form (3NF) C. First Normal Form (1NF) A. More than one of the above D. None of the above E. Check Answer Open question page Que: (23). Which normal form eliminates transitive functional dependencies? Third Normal Form (3NF) C. First Normal Form (1NF) A. Second Normal Form (2NF) B. More than one of the above D. None of the above E. Check Answer Open question page Que: (24). Which normal form is based on the condition that every determinant must be a candidate key? First Normal Form (1NF) A. Fourth Normal Form (4NF) C. Boyce-Codd Normal Form (BCNF) B. More than one of the above D. None of the above E. Check Answer Open question page Que: (25). What is the main purpose of database normalization? To reduce data redundancy and avoid anomalies B. To increase data redundancy A. To increase duplicate records C. More than one of the above D. None of the above E. Check Answer Open question page Que: (26). Which of the following is NOT a type of database anomaly? Deletion Anomaly B. Compilation Anomaly C. Insertion Anomaly A. More than one of the above D. None of the above E. Check Answer Open question page Que: (27). Which normal form deals with multivalued dependencies? Second Normal Form (2NF) A. Fourth Normal Form (4NF) C. Third Normal Form (3NF) B. More than one of the above D. None of the above E. Check Answer Open question page Que: (28). Which normal form is concerned with join dependencies? Third Normal Form (3NF) A. Fourth Normal Form (4NF) B. Fifth Normal Form (5NF) C. More than one of the above D. None of the above E. Check Answer Open question page Que: (29). What is a partial functional dependency in database normalization? An attribute depends on the entire candidate key B. A key depends on a non-key attribute C. A non-prime attribute depends on only a proper subset of a candidate key A. More than one of the above D. None of the above E. Check Answer Open question page Que: (30). Which of the following is a valid requirement for a relation to be in Third Normal Form (3NF)? The relation must be in 2NF and have no transitive dependency of non-prime attributes on candidate keys B. The relation must be in 1NF only A. Every table must contain exactly one primary key column C. More than one of the above D. None of the above E. Check Answer Open question page Que: (31). Which normal form ensures that every non-prime attribute in a table is fully functionally dependent on the primary key? Third Normal Form (3NF) C. Second Normal Form (2NF) B. First Normal Form (1NF) A. More than one of the above D. None of the above E. Check Answer Open question page Que: (32). Which normal form requires that all attribute values in a relation be atomic? Second Normal Form (2NF) B. First Normal Form (1NF) A. Third Normal Form (3NF) C. More than one of the above D. None of the above E. Check Answer Open question page Que: (33). Which normal form eliminates transitive functional dependencies? Third Normal Form (3NF) C. First Normal Form (1NF) A. Second Normal Form (2NF) B. More than one of the above D. None of the above E. Check Answer Open question page Que: (34). Which normal form is based on the condition that every determinant must be a candidate key? First Normal Form (1NF) A. Fourth Normal Form (4NF) C. Boyce-Codd Normal Form (BCNF) B. More than one of the above D. None of the above E. Check Answer Open question page Que: (35). What is the main purpose of database normalization? To increase duplicate records C. To increase data redundancy A. To reduce data redundancy and avoid anomalies B. More than one of the above D. None of the above E. Check Answer Open question page Que: (36). Which of the following is NOT a type of database anomaly? Deletion Anomaly B. Compilation Anomaly C. Insertion Anomaly A. More than one of the above D. None of the above E. Check Answer Open question page Que: (37). Which normal form deals with multivalued dependencies? Third Normal Form (3NF) B. Fourth Normal Form (4NF) C. Second Normal Form (2NF) A. More than one of the above D. None of the above E. Check Answer Open question page Que: (38). Which normal form is concerned with join dependencies? Fourth Normal Form (4NF) B. Fifth Normal Form (5NF) C. Third Normal Form (3NF) A. More than one of the above D. None of the above E. Check Answer Open question page Que: (39). What is a partial functional dependency in database normalization? An attribute depends on the entire candidate key B. A key depends on a non-key attribute C. A non-prime attribute depends on only a proper subset of a candidate key A. More than one of the above D. None of the above E. Check Answer Open question page Que: (40). Which of the following is a valid requirement for a relation to be in Third Normal Form (3NF)? The relation must be in 1NF only A. Every table must contain exactly one primary key column C. The relation must be in 2NF and have no transitive dependency of non-prime attributes on candidate keys B. More than one of the above D. None of the above E. Check Answer Open question page Que: (41). Which of the following is a disadvantage of using a distributed database system? Improved data accessibility A. Data inconsistency C. Increased data security B. More than one of the above D. None of the above E. Check Answer Open question page Que: (42). What is a distributed database system? A database without any tables C. A database stored at a single location A. A database whose data is stored across multiple interconnected locations B. More than one of the above D. None of the above E. Check Answer Open question page Que: (43). Which technique is used to maintain copies of data at multiple sites in a distributed database? Fragmentation A. Replication B. Normalization C. More than one of the above D. None of the above E. Check Answer Open question page Que: (44). What is horizontal fragmentation in a distributed database? Dividing a table into rows A. Combining multiple databases C. Dividing a table into columns B. More than one of the above D. None of the above E. Check Answer Open question page Que: (45). What is vertical fragmentation in a distributed database? Dividing a table into rows A. Deleting duplicate records C. Dividing a table into columns or attributes B. More than one of the above D. None of the above E. Check Answer Open question page Que: (46). Which property ensures that a distributed transaction is completed entirely or not at all? Consistency A. Isolation B. Atomicity C. More than one of the above D. None of the above E. Check Answer Open question page Que: (47). Which protocol is commonly used to ensure atomic commitment of distributed transactions? Stop-and-Wait Protocol B. Two-Phase Commit Protocol A. Sliding Window Protocol C. More than one of the above D. None of the above E. Check Answer Open question page Que: (48). What is the main purpose of a distributed database transparency? To increase data duplication B. To prevent all network communication C. To hide distribution details from users A. More than one of the above D. None of the above E. Check Answer Open question page Que: (49). Which type of distributed database has a single logical schema but multiple physical data locations? Centralized Database A. Distributed Database B. Personal Database C. More than one of the above D. None of the above E. Check Answer Open question page Que: (50). Which of the following can improve the availability of a distributed database? Data Replication A. Using only one database server C. Removing all backup copies B. More than one of the above D. None of the above E. Check Answer Open question page
