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? Asked in BPSC TRE 3.0 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? 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 design computer hardware B. To compile programming languages C. 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: Attribute A. Tuple B. Domain C. 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. Alternate Key C. Foreign Key A. 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. Hierarchical Model A. Relational Model B. 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? Structured Query Language A. Sequential Query Language B. 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 Redundancy A. Data Duplication C. Data Integrity B. 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? Data Sharing C. Improved Data Security B. Reduced Data Redundancy A. 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? Asked in BPSC TRE 3.0 A key used to establish relationships between tables B. A key used to uniquely identify each record in a table A. A key used to sort records in a table C. 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? Super Key C. Candidate Key A. Foreign Key B. 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 minimal set of attributes that uniquely identifies a record B. A key used only for sorting records C. A key that contains duplicate values A. 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? 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? Both Primary Key and Foreign Key C. Foreign Key B. Primary Key A. 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. Alternate Key C. 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 can contain duplicate values C. It cannot contain NULL values B. It uniquely identifies each record A. 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? Asked in BPSC TRE 3.0 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: (22). Which normal form requires that all attribute values in a relation be atomic? 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: (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? Fourth Normal Form (4NF) C. First Normal Form (1NF) A. 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 increase data redundancy A. To reduce data redundancy and avoid anomalies B. 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? 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? Fifth Normal Form (5NF) C. Fourth Normal Form (4NF) B. Third Normal Form (3NF) A. 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? A key depends on a non-key attribute C. An attribute depends on the entire candidate key B. 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)? 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. The relation must be in 1NF only A. 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? Asked in BPSC TRE 3.0 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: (32). 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: (33). 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: (34). 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: (35). What is the main purpose of database normalization? To increase data redundancy A. To reduce data redundancy and avoid anomalies B. To increase duplicate records C. 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? Compilation Anomaly C. Insertion Anomaly A. 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. Third Normal Form (3NF) B. Fourth Normal Form (4NF) C. 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? Fifth Normal Form (5NF) C. Third Normal Form (3NF) A. Fourth Normal Form (4NF) B. 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 non-prime attribute depends on only a proper subset of a candidate key A. An attribute depends on the entire candidate key B. A key depends on a non-key attribute C. 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? Asked in BPSC TRE 3.0 Improved data accessibility A. Increased data security B. Data inconsistency C. 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 whose data is stored across multiple interconnected locations B. 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. 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 columns B. Dividing a table into rows A. Combining multiple databases C. 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 columns or attributes B. Deleting duplicate records C. Dividing a table into rows A. 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? Atomicity C. Isolation B. Consistency A. 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? Distributed Database B. Personal Database C. Centralized Database A. 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? Removing all backup copies B. Using only one database server C. Data Replication A. More than one of the above D. None of the above E. Check Answer Open question page Que: (51). Which SQL command is used to add new rows to a database table? CREATE B. ADD A. INSERT C. More than one of the above D. None of the above E. Check Answer Open question page Que: (52). Which SQL statement correctly inserts a new record into a table named students? INSERT students VALUES (1, Amit) A. ADD INTO students VALUES (1, Amit) C. INSERT INTO students VALUES (1, Amit) B. More than one of the above D. None of the above E. Check Answer Open question page Que: (53). Which SQL command is used to modify existing records in a table? UPDATE B. INSERT A. ALTER C. More than one of the above D. None of the above E. Check Answer Open question page Que: (54). Which SQL command is used to remove specific records from a table? DELETE B. DROP A. ALTER C. More than one of the above D. None of the above E. Check Answer Open question page Que: (55). Which SQL command is used to create a new table in a database? INSERT A. UPDATE C. CREATE B. More than one of the above D. None of the above E. Check Answer Open question page Que: (56). Which SQL command is used to add a new column to an existing table? ALTER C. UPDATE A. INSERT B. More than one of the above D. None of the above E. Check Answer Open question page Que: (57). Which SQL command permanently removes a table along with its structure? REMOVE C. DELETE A. DROP B. More than one of the above D. None of the above E. Check Answer Open question page Que: (58). Which SQL command removes all rows from a table while retaining its table structure? TRUNCATE B. ALTER C. DROP A. More than one of the above D. None of the above E. Check Answer Open question page Que: (59). Which SQL command is primarily used to retrieve data from a database table? GET A. SELECT B. FETCH TABLE C. More than one of the above D. None of the above E. Check Answer Open question page Que: (60). Which SQL clause is used to filter records based on a specified condition? WHERE C. ORDER BY A. GROUP BY B. More than one of the above D. None of the above E. Check Answer Open question page