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? Relational DBMS A. Sequential DBMS C. Object-Oriented DBMS B. 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? Relational Model A. Hierarchical Model B. Network Model C. 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 design computer hardware B. To manage and organize data A. To compile programming languages C. 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? Redis C. MySQL A. 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. Tuple B. Attribute A. 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? Primary Key B. Foreign Key A. 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? Relational Model B. Network Model C. 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? Standard Question Language C. Sequential Query Language B. Structured Query Language A. 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 Redundancy A. Data Integrity B. Data Duplication C. 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? Reduced Data Redundancy A. Improved Data Security B. 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 sort records in a table C. A key used to establish relationships between tables B. A key used to uniquely identify each record in a table A. 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. Candidate Key A. Super Key C. 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 that contains duplicate values A. A key used only for sorting records C. 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? A key that allows duplicate records C. A key that must contain only one attribute B. Any set of attributes that uniquely identifies a record A. 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? UNIQUE Constraint B. CHECK Constraint C. DEFAULT Constraint A. 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? Foreign Key B. Primary Key A. Both Primary Key and Foreign Key C. 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 candidate key not selected as the primary key B. A key containing duplicate values C. A candidate key selected as the primary key A. 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? Composite Key B. Primary Key A. Alternate Key C. 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 cannot contain NULL values B. It uniquely identifies each record A. 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? First Normal Form (1NF) A. Second Normal Form (2NF) B. Third Normal Form (3NF) C. 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? 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: (23). Which normal form eliminates transitive functional dependencies? First Normal Form (1NF) A. Second Normal Form (2NF) B. Third Normal Form (3NF) C. 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? Boyce-Codd Normal Form (BCNF) B. Fourth Normal Form (4NF) C. First Normal Form (1NF) A. 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 duplicate records C. To increase data redundancy A. 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? Fourth Normal Form (4NF) C. Third Normal Form (3NF) B. Second Normal Form (2NF) A. 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 1NF only A. The relation must be in 2NF and have no transitive dependency of non-prime attributes on candidate keys B. 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? 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: (32). Which normal form requires that all attribute values in a relation be atomic? First Normal Form (1NF) A. Second Normal Form (2NF) B. 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? 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: (34). Which normal form is based on the condition that every determinant must be a candidate key? First Normal Form (1NF) A. Boyce-Codd Normal Form (BCNF) B. Fourth Normal Form (4NF) C. 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 reduce data redundancy and avoid anomalies B. To increase data redundancy A. 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? Insertion Anomaly A. Compilation Anomaly C. Deletion Anomaly B. 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? 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: (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? A key depends on a non-key attribute C. A non-prime attribute depends on only a proper subset of a candidate key A. An attribute depends on the entire candidate key B. 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 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: (41). Which of the following is a disadvantage of using a distributed database system? Data inconsistency C. Increased data security B. Improved data accessibility A. 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 whose data is stored across multiple interconnected locations B. A database without any tables C. A database stored at a single location A. 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. Normalization C. Replication B. 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. Dividing a table into columns or attributes B. Deleting duplicate records C. 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 prevent all network communication C. To increase data duplication B. 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? Distributed Database B. Centralized Database A. 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? Using only one database server C. Removing all backup copies B. Data Replication A. More than one of the above D. None of the above E. Check Answer Open question page
