TRE 4.0 DBMS Quiz Practice Set 2 11th November 2026 Share On Que: (1). What is a database? Asked in BPSC TRE 3.0 Organized collection of data or information that can be accessed, updated and managed B. Organized collection of data that cannot be updated C. Organized collection of information that cannot be accessed, updated and managed A. More than one of the above D. None of the above E. Check Answer Open question page Que: (2). What is the primary purpose of a Database Management System (DBMS)? To create computer hardware A. To manage, store and retrieve data efficiently B. To design operating systems C. More than one of the above D. None of the above E. Check Answer Open question page Que: (3). Who is responsible for managing and maintaining a database system? Web Designer B. Database Administrator A. System User C. More than one of the above D. None of the above E. Check Answer Open question page Que: (4). What is metadata in a database? Data that is permanently deleted B. Only numerical data C. Data about data A. More than one of the above D. None of the above E. Check Answer Open question page Que: (5). What does a database schema primarily describe? The physical location of a computer A. Only the records stored in a table C. The logical structure and organization of a database B. More than one of the above D. None of the above E. Check Answer Open question page Que: (6). What is data redundancy in a database? Encryption of database information C. Repeated storage of the same data in multiple places A. Complete removal of database records B. More than one of the above D. None of the above E. Check Answer Open question page Que: (7). Which database concept allows changes in the schema at one level without requiring changes at the next higher level? Data Independence 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: (8). Which key uniquely identifies each record in a relational database table? Candidate Key C. Foreign Key A. Primary Key B. More than one of the above D. None of the above E. Check Answer Open question page Que: (9). Which database model organizes data in a tree-like structure with parent-child relationships? Hierarchical Model C. Network Model B. Relational Model A. More than one of the above D. None of the above E. Check Answer Open question page Que: (10). What is a database instance? The actual data stored in a database at a particular moment B. The programming language used to access a database C. The logical design of a database A. More than one of the above D. None of the above E. Check Answer Open question page Que: (11). Which type of data can be stored in the database? Asked in BPSC TRE 3.0 Text, files containing data B. Data in the form of audio or video C. Image-oriented data A. More than one of the above D. None of the above E. Check Answer Open question page Que: (12). Which data type is commonly used to store binary large objects such as images and audio files in a database? BLOB B. VARCHAR A. INTEGER C. More than one of the above D. None of the above E. Check Answer Open question page Que: (13). Which of the following is an example of structured data? Unorganized video recordings B. Data organized in rows and columns A. Raw audio recordings C. More than one of the above D. None of the above E. Check Answer Open question page Que: (14). Which of the following is an example of unstructured data? Audio and video recordings C. Spreadsheet with fixed columns B. Relational database table A. More than one of the above D. None of the above E. Check Answer Open question page Que: (15). Which of the following formats is commonly used to represent semi-structured data? JSON A. JPEG B. MP3 C. More than one of the above D. None of the above E. Check Answer Open question page Que: (16). Which type of database is specifically designed to manage multimedia objects such as images, audio and video? Multimedia Database A. Relational Database only C. Hierarchical Database B. More than one of the above D. None of the above E. Check Answer Open question page Que: (17). Which database data type is used to store large amounts of character-based text data? BLOB A. BOOLEAN C. CLOB B. More than one of the above D. None of the above E. Check Answer Open question page Que: (18). Which type of system is primarily designed for analytical processing and storing large amounts of historical data? Operating System C. Transaction Processing System A. Data Warehouse B. More than one of the above D. None of the above E. Check Answer Open question page Que: (19). What is the full form of XML, which is commonly used for storing and exchanging structured information? Extended Markup Language A. Extra Machine Language C. Extensible Markup Language B. More than one of the above D. None of the above E. Check Answer Open question page Que: (20). Which of the following is a valid category of data commonly supported by database systems? Character or string data C. Date and time data B. Numeric data A. More than one of the above D. None of the above E. Check Answer Open question page Que: (21). Which of the following is not a type of database? Asked in BPSC TRE 3.0 Decentralized C. Network A. Distributed B. More than one of the above D. None of the above E. Check Answer Open question page Que: (22). Which database model allows a record to have multiple parent records? Network Model B. Relational Model C. Hierarchical Model A. More than one of the above D. None of the above E. Check Answer Open question page Que: (23). Which database model represents data using a tree-like structure? Network Model A. Relational Model B. Hierarchical Model C. More than one of the above D. None of the above E. Check Answer Open question page Que: (24). In which database model is data primarily organized into tables consisting of rows and columns? Network Model A. Relational Model B. Hierarchical Model C. More than one of the above D. None of the above E. Check Answer Open question page Que: (25). Which type of database stores data at multiple physical locations but provides a unified logical view? Centralized Database A. Flat File Database C. Distributed Database B. More than one of the above D. None of the above E. Check Answer Open question page Que: (26). Which database architecture maintains the database at a single central location? Centralized Database B. Decentralized Database C. Distributed Database A. More than one of the above D. None of the above E. Check Answer Open question page Que: (27). Which type of database stores information in the form of objects? Object-Oriented Database B. Relational Database A. Hierarchical Database C. More than one of the above D. None of the above E. Check Answer Open question page Que: (28). Which type of database is generally designed to handle flexible schemas and large-scale distributed data? Flat File Database C. NoSQL Database A. Hierarchical Database B. More than one of the above D. None of the above E. Check Answer Open question page Que: (29). Which database type is specifically designed to represent data using nodes and edges? Relational Database A. Hierarchical Database C. Graph Database B. More than one of the above D. None of the above E. Check Answer Open question page Que: (30). Which database model combines features of relational databases and object-oriented databases? Network Model B. Hierarchical Model A. Object-Relational Model C. More than one of the above D. None of the above E. Check Answer Open question page Que: (31). Which of the following is not an example of DBMS? Asked in BPSC TRE 3.0 Google C. Microsoft Access A. IBM Db2 B. More than one of the above D. None of the above E. Check Answer Open question page Que: (32). Which of the following is an open-source relational database management system? PostgreSQL A. Microsoft Excel C. Microsoft Access B. More than one of the above D. None of the above E. Check Answer Open question page Que: (33). Which company develops Oracle Database? Microsoft C. Oracle Corporation B. IBM A. More than one of the above D. None of the above E. Check Answer Open question page Que: (34). Which DBMS is developed by Microsoft? Microsoft SQL Server C. MySQL A. PostgreSQL B. More than one of the above D. None of the above E. Check Answer Open question page Que: (35). Which DBMS is commonly used as an embedded database in applications? SQLite B. IBM Db2 C. Oracle Database 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 a document-oriented NoSQL database? MongoDB A. Oracle Database C. MySQL B. More than one of the above D. None of the above E. Check Answer Open question page Que: (37). MariaDB was originally developed as a fork of which database system? MySQL C. PostgreSQL B. Oracle Database A. More than one of the above D. None of the above E. Check Answer Open question page Que: (38). Which database system is primarily known as an in-memory key-value data store? Redis B. Microsoft Access C. PostgreSQL A. More than one of the above D. None of the above E. Check Answer Open question page Que: (39). Which of the following database systems is developed by IBM? IBM Db2 A. MySQL B. SQLite 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 desktop database management system? Apache HTTP Server B. Microsoft Access A. Google Chrome 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 not a feature of DBMS? Asked in BPSC TRE 3.0 Support ACID property C. Single-user access only B. Minimum duplication and redundancy of data A. More than one of the above D. None of the above E. Check Answer Open question page Que: (42). Which DBMS feature allows multiple users to access the database at the same time? Concurrency control A. Data abstraction B. Data independence C. More than one of the above D. None of the above E. Check Answer Open question page Que: (43). Which property of DBMS ensures that committed transaction changes are not lost after a system failure? Atomicity A. Consistency B. Durability C. More than one of the above D. None of the above E. Check Answer Open question page Que: (44). Which DBMS feature provides different views of the same database to different users? View mechanism B. Backup management C. Data security A. More than one of the above D. None of the above E. Check Answer Open question page Que: (45). Which feature of DBMS protects data from unauthorized access? Data abstraction C. Data security A. Data redundancy B. More than one of the above D. None of the above E. Check Answer Open question page Que: (46). Which DBMS feature helps restore database information after accidental data loss? Data abstraction A. Backup and recovery B. Concurrency control C. More than one of the above D. None of the above E. Check Answer Open question page Que: (47). Which concept allows changes in the physical storage of data without affecting the logical structure of the database? Logical data independence A. Data redundancy C. Physical data independence B. More than one of the above D. None of the above E. Check Answer Open question page Que: (48). Which DBMS component is responsible for managing concurrent transactions and maintaining consistency? Data dictionary C. Query processor A. Transaction manager B. More than one of the above D. None of the above E. Check Answer Open question page Que: (49). Which DBMS facility maintains information about tables, columns, constraints and other database objects? Transaction log C. Data dictionary A. Query optimizer B. More than one of the above D. None of the above E. Check Answer Open question page Que: (50). Which DBMS feature ensures that a transaction is executed completely or has no effect at all? Durability B. Isolation A. Atomicity C. More than one of the above D. None of the above E. Check Answer Open question page Que: (51). Which of the following is not a function of the database? Asked in BPSC TRE 3.0 Analysing code C. Manipulating data A. Security for stored data B. More than one of the above D. None of the above E. Check Answer Open question page Que: (52). Which database operation is used to retrieve data from one or more tables? INSERT A. SELECT B. DELETE C. More than one of the above D. None of the above E. Check Answer Open question page Que: (53). Which database function is responsible for maintaining the correctness and validity of stored data? Code compilation C. Data compression B. Data integrity A. More than one of the above D. None of the above E. Check Answer Open question page Que: (54). Which database operation is used to arrange records in ascending or descending order? GROUP BY A. WHERE C. ORDER BY B. More than one of the above D. None of the above E. Check Answer Open question page Que: (55). Which SQL clause is used to filter records based on a specified condition? CREATE C. ORDER BY A. WHERE B. More than one of the above D. None of the above E. Check Answer Open question page Que: (56). Which database function allows multiple users to work with data while controlling conflicting operations? Image processing C. Code debugging B. Concurrency management A. More than one of the above D. None of the above E. Check Answer Open question page Que: (57). Which database function is used to combine related records from two or more tables? Indexing C. Sorting A. Joining B. More than one of the above D. None of the above E. Check Answer Open question page Que: (58). Which database function improves data retrieval speed by creating an efficient access structure? Transaction rollback C. Indexing A. Data deletion B. More than one of the above D. None of the above E. Check Answer Open question page Que: (59). Which database function is used to restore data after a database failure? Data sorting C. Query parsing A. Database recovery B. More than one of the above D. None of the above E. Check Answer Open question page Que: (60). Which database function is used to calculate values such as COUNT, SUM and AVG? String functions B. Date formatting functions C. Aggregate functions A. More than one of the above D. None of the above E. Check Answer Open question page Que: (61). What is information about data called? Asked in BPSC TRE 3.0 Relations C. Metadata B. Teradata A. More than one of the above D. None of the above E. Check Answer Open question page Que: (62). Which component of a DBMS stores information about database tables, columns and constraints? Query processor A. Transaction manager C. Data dictionary B. More than one of the above D. None of the above E. Check Answer Open question page Que: (63). Which of the following is an example of metadata in a student database? Actual student marks B. Actual student name A. Column data type and field size C. More than one of the above D. None of the above E. Check Answer Open question page Que: (64). Which SQL command is commonly used to display the structure of a table in MySQL? INSERT C. DELETE B. DESCRIBE A. More than one of the above D. None of the above E. Check Answer Open question page Que: (65). Which of the following is generally stored in a database data dictionary? Integrity constraints C. Column data types B. Table definitions A. More than one of the above D. None of the above E. Check Answer Open question page Que: (66). What is the main purpose of a database catalog? To store only user passwords A. To execute operating system programs C. To maintain metadata about database objects B. More than one of the above D. None of the above E. Check Answer Open question page Que: (67). Which type of metadata describes the meaning and business context of data? Technical metadata A. Operational metadata C. Business metadata B. More than one of the above D. None of the above E. Check Answer Open question page Que: (68). Which type of metadata describes database schemas, column names and data types? Technical metadata B. Descriptive business reports C. Business metadata A. More than one of the above D. None of the above E. Check Answer Open question page Que: (69). In a relational database, which metadata specifies the permitted values and type of a column? Query result C. Transaction log B. Data definition A. More than one of the above D. None of the above E. Check Answer Open question page Que: (70). Which language is primarily used to define database schemas and their objects? DDL B. DML A. DCL C. More than one of the above D. None of the above E. Check Answer Open question page Que: (71). The DBMS acts as an interface between ________ and ________ of an enterprise-class system. Asked in BPSC TRE 3.0 Data, the DBMS A. Database application, the database B. The user, the software C. More than one of the above D. None of the above E. Check Answer Open question page Que: (72). Which language is used by applications to communicate with a relational database? HTML A. CSS C. SQL B. More than one of the above D. None of the above E. Check Answer Open question page Que: (73). Which DBMS component is responsible for parsing and validating SQL queries? Buffer manager C. Query processor A. Storage manager B. More than one of the above D. None of the above E. Check Answer Open question page Que: (74). Which DBMS component is responsible for managing data stored on disk? SQL compiler C. Storage manager B. Query parser A. More than one of the above D. None of the above E. Check Answer Open question page Que: (75). Who is primarily responsible for defining database access permissions and managing database security? End user A. Database Administrator B. Application developer C. More than one of the above D. None of the above E. Check Answer Open question page Que: (76). Which type of database user interacts with a database through predefined application interfaces? Database designer B. System programmer C. Naive user A. More than one of the above D. None of the above E. Check Answer Open question page Que: (77). Which interface allows users to retrieve database information by writing SQL statements directly? Menu-based interface A. Forms-based interface B. Query interface C. More than one of the above D. None of the above E. Check Answer Open question page Que: (78). Which component converts SQL queries into an efficient execution plan? File manager B. Operating system scheduler C. Query optimizer A. More than one of the above D. None of the above E. Check Answer Open question page Que: (79). Which DBMS interface is commonly used by database administrators to execute administrative commands? Both command-line and graphical interfaces C. Graphical user interface B. Command-line interface A. More than one of the above D. None of the above E. Check Answer Open question page Que: (80). Which layer of a three-schema DBMS architecture describes how data is physically stored? Conceptual level B. Internal level C. External level A. More than one of the above D. None of the above E. Check Answer Open question page Que: (81). ________ is a set of one or more attribute(s) taken collectively to uniquely identify a record. Asked in BPSC TRE 3.0 Superkey 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: (82). Which key is a minimal superkey that uniquely identifies each record in a relation? Secondary 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: (83). A candidate key that is not selected as the primary key is called ________. Alternate key B. Composite key C. Foreign key A. More than one of the above D. None of the above E. Check Answer Open question page Que: (84). Which key consists of two or more attributes used together to uniquely identify a record? Composite key C. Simple key A. Foreign key B. More than one of the above D. None of the above E. Check Answer Open question page Que: (85). Which key is used to establish a relationship between two relational database tables? Primary key A. Foreign key B. Candidate key C. More than one of the above D. None of the above E. Check Answer Open question page Que: (86). Which key is selected from the candidate keys to uniquely identify records in a table? Primary key A. Foreign key B. Alternate key C. More than one of the above D. None of the above E. Check Answer Open question page Que: (87). Which type of key is generated by the database system and has no direct business meaning? Natural key A. Foreign key C. Surrogate key B. More than one of the above D. None of the above E. Check Answer Open question page Que: (88). Which key uses a real-world attribute, such as an email address or passport number, to identify a record? Natural key C. Surrogate key A. Foreign key B. More than one of the above D. None of the above E. Check Answer Open question page Que: (89). Which integrity constraint ensures that a primary key cannot contain NULL values? Entity integrity A. Referential integrity B. Domain integrity C. More than one of the above D. None of the above E. Check Answer Open question page Que: (90). Which integrity rule ensures that a foreign key value matches an existing referenced key value or is NULL when permitted? Domain integrity C. Referential integrity B. Entity integrity A. More than one of the above D. None of the above E. Check Answer Open question page Que: (91). Which of the following commands is correct to delete the values in the relation teaches? Asked in BPSC TRE 3.0 Delete from teaches where Id='Null'; B. Delete from teaches; A. Remove table teaches; C. More than one of the above D. None of the above E. Check Answer Open question page Que: (92). Which SQL statement deletes only those employees whose salary is less than 10000? DELETE FROM employees WHERE salary < 10000; B. DELETE FROM employees; A. DROP employees WHERE salary < 10000; C. More than one of the above D. None of the above E. Check Answer Open question page Que: (93). Which SQL condition is used to delete records where the value of a column is NULL? WHERE column = NULL A. WHERE column IS NULL B. WHERE column == NULL C. More than one of the above D. None of the above E. Check Answer Open question page Que: (94). Which SQL command removes all rows from a table while retaining its structure? ALTER TABLE C. DROP TABLE A. TRUNCATE TABLE B. More than one of the above D. None of the above E. Check Answer Open question page Que: (95). Which SQL command removes both the table structure and its stored records? TRUNCATE B. DELETE A. DROP TABLE C. More than one of the above D. None of the above E. Check Answer Open question page Que: (96). Which SQL statement can be used to remove a specific record identified by its primary key? DELETE FROM students WHERE student_id IS NULL; B. DELETE FROM students WHERE student_id = 101; A. DROP TABLE students; C. More than one of the above D. None of the above E. Check Answer Open question page Que: (97). Which SQL clause is used to restrict the records affected by a DELETE statement? GROUP BY B. ORDER BY A. WHERE C. More than one of the above D. None of the above E. Check Answer Open question page Que: (98). What happens when a DELETE statement is executed inside a transaction and then rolled back before commit? The entire table is permanently removed B. The database is automatically dropped C. Deleted records are restored A. More than one of the above D. None of the above E. Check Answer Open question page Que: (99). Which referential action automatically deletes related child records when a referenced parent record is deleted? ON INSERT CASCADE C. ON DELETE CASCADE A. ON UPDATE SET DEFAULT B. More than one of the above D. None of the above E. Check Answer Open question page Que: (100). Which statement correctly describes the difference between DELETE and TRUNCATE? DELETE can only remove one record, whereas TRUNCATE removes one column C. DELETE supports a WHERE clause, whereas TRUNCATE removes all rows A. TRUNCATE removes the table definition, whereas DELETE removes the table B. More than one of the above D. None of the above E. Check Answer Open question page Que: (101). The top level of the hierarchy consists of ________ each of which can contain ________. Asked in BPSC TRE 3.0 schemas, environment B. schemas, catalogs A. catalogs, schemas C. More than one of the above D. None of the above E. Check Answer Open question page Que: (102). Which of the following database objects is generally contained within a schema? Tables A. Views B. Indexes C. More than one of the above D. None of the above E. Check Answer Open question page Que: (103). What is the primary purpose of a database schema? To execute operating system commands C. To define the logical structure of database objects A. To store only backup files B. More than one of the above D. None of the above E. Check Answer Open question page Que: (104). Which of the following is an example of a database schema object? Stored procedure C. Table A. View B. More than one of the above D. None of the above E. Check Answer Open question page Que: (105). Which database component stores information about tables, columns and constraints? Data dictionary A. Query optimizer B. Transaction log C. More than one of the above D. None of the above E. Check Answer Open question page Que: (106). In a relational database, what does a table primarily consist of? Schemas and catalogs B. Files and folders only C. Rows and columns A. More than one of the above D. None of the above E. Check Answer Open question page Que: (107). Which SQL command is commonly used to create a new schema? ADD DATABASE OBJECT C. CREATE SCHEMA A. MAKE SCHEMA B. More than one of the above D. None of the above E. Check Answer Open question page Que: (108). Which of the following statements about a database catalog is correct? It is used only to store images B. It stores metadata about database objects A. It replaces the database management system C. More than one of the above D. None of the above E. Check Answer Open question page Que: (109). In which level of the three-schema architecture are individual user views defined? Conceptual level B. Internal level A. External level C. More than one of the above D. None of the above E. Check Answer Open question page Que: (110). Which term describes the actual organization of data stored on physical storage devices? Conceptual schema C. Internal schema B. External schema A. More than one of the above D. None of the above E. Check Answer Open question page Que: (111). The user IDs can be added or removed using which of the following fixed roles? Asked in BPSC TRE 3.0 db_accessadmin B. db_securityadmin C. db_sysadmin A. More than one of the above D. None of the above E. Check Answer Open question page Que: (112). Which fixed database role can manage database permissions and role membership? db_datareader A. db_backupoperator C. db_securityadmin B. More than one of the above D. None of the above E. Check Answer Open question page Que: (113). Which SQL Server fixed database role provides read access to all user tables and views? db_owner C. db_datawriter B. db_datareader A. More than one of the above D. None of the above E. Check Answer Open question page Que: (114). Which fixed database role allows members to insert, update and delete data in all user tables? db_accessadmin C. db_datareader A. db_datawriter B. More than one of the above D. None of the above E. Check Answer Open question page Que: (115). Which fixed database role has permission to perform database backups? db_ddladmin C. db_datareader B. db_backupoperator A. More than one of the above D. None of the above E. Check Answer Open question page Que: (116). Which fixed database role allows members to execute all database data definition language commands? db_backupoperator C. db_ddladmin A. db_datareader B. More than one of the above D. None of the above E. Check Answer Open question page Que: (117). Which fixed database role provides full control over a database? db_accessadmin C. db_owner A. db_datareader B. More than one of the above D. None of the above E. Check Answer Open question page Que: (118). Which SQL Server fixed server role has the highest level of administrative privileges? serveradmin A. sysadmin B. securityadmin C. More than one of the above D. None of the above E. Check Answer Open question page Que: (119). Which SQL Server fixed server role can manage server-wide security logins and their properties? securityadmin A. diskadmin C. processadmin B. More than one of the above D. None of the above E. Check Answer Open question page Que: (120). Which SQL Server statement is used to add an existing database user to a fixed database role? CREATE USER role_name; C. DROP ROLE role_name user_name; B. ALTER ROLE role_name ADD MEMBER user_name; A. More than one of the above D. None of the above E. Check Answer Open question page Que: (121). The traditional storage of data organized by the customer, stored in separate folders in filing cabinets is an example of Asked in BPSC TRE 3.0 Hierarchical database management system C. Relational database management system A. Network database management system B. More than one of the above D. None of the above E. Check Answer Open question page Que: (122). Which database model represents data in the form of tables consisting of rows and columns? 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: (123). Which database model allows a child record to have multiple parent records? Network model B. Hierarchical model A. Flat-file model C. More than one of the above D. None of the above E. Check Answer Open question page Que: (124). In which database model is data represented using parent-child relationships in a tree structure? Relational model A. Hierarchical model C. Network model B. More than one of the above D. None of the above E. Check Answer Open question page Que: (125). Who introduced the relational database model? Charles Babbage A. Alan Turing C. E. F. Codd B. More than one of the above D. None of the above E. Check Answer Open question page Que: (126). Which of the following is a major limitation of the hierarchical database model? It does not support parent-child relationships A. It does not support complex many-to-many relationships naturally B. It cannot store records C. More than one of the above D. None of the above E. Check Answer Open question page Que: (127). Which database model uses pointers or links to establish relationships between records? Flat-file model C. Network model A. Relational model B. More than one of the above D. None of the above E. Check Answer Open question page Que: (128). Which database model uses primary keys and foreign keys to establish relationships between tables? 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: (129). Which database model is most suitable for representing data with flexible and complex relationships such as social networks? Flat-file model C. Network model B. Hierarchical model A. More than one of the above D. None of the above E. Check Answer Open question page Que: (130). Which database model stores data in a simple file without defining relationships between multiple tables? Relational model A. Flat-file model C. Hierarchical model B. More than one of the above D. None of the above E. Check Answer Open question page Que: (131). After groups have been established, SQL applies predicates in the ________ clause, allowing aggregate functions to be used. Asked in BPSC TRE 3.0 HAVING A. GROUP BY B. WITH C. More than one of the above D. None of the above E. Check Answer Open question page Que: (132). Which SQL clause is used to arrange rows into groups based on one or more columns? ORDER BY A. HAVING C. GROUP BY B. More than one of the above D. None of the above E. Check Answer Open question page Que: (133). Which aggregate function returns the total number of rows in a table? COUNT(*) C. AVG() B. SUM() A. More than one of the above D. None of the above E. Check Answer Open question page Que: (134). Which aggregate function is used to calculate the average value of a numeric column? MAX() C. SUM() A. AVG() B. More than one of the above D. None of the above E. Check Answer Open question page Que: (135). Which SQL clause is used to filter individual rows before grouping takes place? HAVING A. ORDER BY C. WHERE B. More than one of the above D. None of the above E. Check Answer Open question page Que: (136). Which aggregate function returns the highest value from a specified column? MIN() A. MAX() B. COUNT() C. More than one of the above D. None of the above E. Check Answer Open question page Que: (137). Which aggregate function calculates the sum of values in a numeric column? AVG() B. SUM() C. COUNT() A. More than one of the above D. None of the above E. Check Answer Open question page Que: (138). Which SQL clause is generally used to sort the final result of a query in ascending or descending order? HAVING C. ORDER BY B. GROUP BY A. More than one of the above D. None of the above E. Check Answer Open question page Que: (139). Which SQL keyword is used to eliminate duplicate rows from a query result? DISTINCT B. UNIQUE A. DIFFERENT C. More than one of the above D. None of the above E. Check Answer Open question page Que: (140). Which SQL statement correctly displays departments having more than 10 employees? SELECT department_id FROM employees HAVING COUNT(*) > 10; C. SELECT department_id, COUNT(*) FROM employees WHERE COUNT(*) > 10 GROUP BY department_id; B. SELECT department_id, COUNT(*) FROM employees GROUP BY department_id HAVING COUNT(*) > 10; A. More than one of the above D. None of the above E. Check Answer Open question page Que: (141). Which of the following is not the utility of DBMS? I. Backup II. Loading III. Process organization IV. File organization Asked in BPSC TRE 3.0 I, II and III only B. I, II and IV only A. I, III and IV only C. More than one of the above D. None of the above E. Check Answer Open question page Que: (142). Which DBMS utility is used to recover database data after a system failure? Report generation C. Backup and recovery A. Data sorting B. More than one of the above D. None of the above E. Check Answer Open question page Que: (143). Which DBMS utility is used to import data from an external file into a database? Query optimization C. Data loading A. Data encryption B. More than one of the above D. None of the above E. Check Answer Open question page Que: (144). Which DBMS component is responsible for managing the physical storage of database files? Storage manager B. Application interface C. Query processor A. More than one of the above D. None of the above E. Check Answer Open question page Que: (145). Which DBMS facility helps prevent unauthorized users from accessing database information? Security and authorization A. Data loading B. File sorting C. More than one of the above D. None of the above E. Check Answer Open question page Que: (146). Which DBMS utility is used to reorganize database storage structures to improve performance? Database reorganization A. User authentication B. Data encryption C. More than one of the above D. None of the above E. Check Answer Open question page Que: (147). Which DBMS feature ensures that database changes are saved permanently after a successful transaction commit? Consistency B. Durability C. Atomicity A. More than one of the above D. None of the above E. Check Answer Open question page Que: (148). Which DBMS facility maintains a record of database operations for recovery and auditing purposes? Transaction logging A. File compression C. Data loading B. More than one of the above D. None of the above E. Check Answer Open question page Que: (149). Which DBMS utility is used to verify the correctness and consistency of stored database information? Database validation A. User interface design C. Data presentation B. More than one of the above D. None of the above E. Check Answer Open question page Que: (150). Which DBMS utility is used to reduce the storage space required for database backup files? Data compression A. Data sorting C. Data duplication B. More than one of the above D. None of the above E. Check Answer Open question page Que: (151). Which DBMS mechanism allows multiple transactions to access shared data safely without interfering with one another? File compression C. Concurrency control A. Data loading B. More than one of the above D. None of the above E. Check Answer Open question page Que: (152). For designing a normal RDBMS, which of the following normal forms is considered adequate? Asked in BPSC TRE 3.0 2NF C. 4NF A. 3NF B. More than one of the above D. None of the above E. Check Answer Open question page Que: (153). Which normal form requires every attribute in a relation to contain only atomic values? 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: (154). A relation is in Second Normal Form (2NF) if it is in 1NF and has no ________. Transitive dependency A. Multivalued dependency C. Partial dependency B. More than one of the above D. None of the above E. Check Answer Open question page Que: (155). Which type of dependency is eliminated when a relation is converted from 2NF to 3NF? Transitive dependency B. Partial dependency A. Multivalued dependency C. More than one of the above D. None of the above E. Check Answer Open question page Que: (156). Who introduced the concept of database normalization? Alan Turing C. E. F. Codd B. Charles Babbage A. More than one of the above D. None of the above E. Check Answer Open question page Que: (157). Which normal form is stricter than 3NF and requires every non-trivial functional dependency X → Y to have X as a superkey? BCNF C. 1NF A. 2NF B. More than one of the above D. None of the above E. Check Answer Open question page Que: (158). Which normal form is primarily concerned with eliminating non-trivial multivalued dependencies? 4NF C. 2NF A. 3NF B. More than one of the above D. None of the above E. Check Answer Open question page Que: (159). What is the main objective of database normalization? To increase unnecessary data duplication A. To eliminate all database tables C. To reduce data redundancy and update anomalies B. More than one of the above D. None of the above E. Check Answer Open question page Que: (160). A functional dependency X → Y means that ________. Y uniquely determines X in every case B. X and Y must always be primary keys C. X uniquely determines Y A. More than one of the above D. None of the above E. Check Answer Open question page Que: (161). Which of the following anomalies can occur in a poorly normalized database? Deletion anomaly B. Update anomaly C. Insertion anomaly A. More than one of the above D. None of the above E. Check Answer Open question page Que: (162). What happens if a piece of data is stored in two places in the db? Asked in BPSC TRE 3.0 Changing the data in one spot will cause data inconsistency B. Storage space is wasted C. Storage space is wasted and changing the data in one spot will cause data inconsistency A. More than one of the above D. None of the above E. Check Answer Open question page Que: (163). What is the term used to describe unnecessary duplication of data in a database? Data abstraction C. Data redundancy B. Data integrity A. More than one of the above D. None of the above E. Check Answer Open question page Que: (164). Which type of anomaly occurs when the same information must be modified in multiple records? Insertion anomaly A. Update anomaly C. Deletion anomaly B. More than one of the above D. None of the above E. Check Answer Open question page Que: (165). Which anomaly occurs when deleting one record unintentionally removes other useful information? Deletion anomaly B. Insertion anomaly A. Update anomaly C. More than one of the above D. None of the above E. Check Answer Open question page Que: (166). Which anomaly occurs when a new fact cannot be inserted into a table without adding unrelated information? Update anomaly C. Deletion anomaly B. Insertion anomaly A. More than one of the above D. None of the above E. Check Answer Open question page Que: (167). Which database property ensures that data remains accurate and consistent throughout its lifecycle? Data duplication C. Data redundancy A. Data integrity B. More than one of the above D. None of the above E. Check Answer Open question page Que: (168). Which database constraint prevents duplicate values in a specified column? UNIQUE C. CHECK A. DEFAULT B. More than one of the above D. None of the above E. Check Answer Open question page Que: (169). Which technique is commonly used to reduce unnecessary data duplication in relational databases? Data replication B. Normalization A. Data encryption C. More than one of the above D. None of the above E. Check Answer Open question page Que: (170). What is the primary purpose of a foreign key in a relational database? To sort records automatically C. To encrypt data A. To maintain referential integrity between related tables B. More than one of the above D. None of the above E. Check Answer Open question page Que: (171). Which of the following is a major disadvantage of excessive data redundancy? Possibility of inconsistent data B. Difficulty maintaining duplicate information C. Increased storage consumption A. More than one of the above D. None of the above E. Check Answer Open question page Que: (172). Which data type can store unstructured data in a column? Asked in BPSC TRE 3.0 RAW A. Numeric B. VARCHAR C. More than one of the above D. None of the above E. Check Answer Open question page Que: (173). Which SQL data type is commonly used to store large binary objects such as images, audio and video files? VARCHAR C. BLOB B. CLOB A. More than one of the above D. None of the above E. Check Answer Open question page Que: (174). What is the full form of CLOB in database systems? Compressed Large Object B. Character Large Object A. Common Large Object C. More than one of the above D. None of the above E. Check Answer Open question page Que: (175). Which data type is designed to store fixed-length binary data in SQL Server? VARCHAR A. VARBINARY B. BINARY C. More than one of the above D. None of the above E. Check Answer Open question page Que: (176). Which SQL Server data type is used to store variable-length binary data? CHAR A. NCHAR C. VARBINARY B. More than one of the above D. None of the above E. Check Answer Open question page Que: (177). Which data format is commonly used to represent semi-structured data using key-value pairs? JPEG B. MP3 C. JSON A. More than one of the above D. None of the above E. Check Answer Open question page Que: (178). Which markup language is used to store and transport structured data using user-defined tags? SQL C. CSS A. XML B. More than one of the above D. None of the above E. Check Answer Open question page Que: (179). Which of the following is an example of unstructured data? A plain numeric salary field B. An image or video file C. A relational table with fixed columns A. More than one of the above D. None of the above E. Check Answer Open question page Que: (180). Which SQL data type is commonly used to store very large amounts of Unicode character data in SQL Server? NVARCHAR(MAX) B. VARCHAR(MAX) A. INT C. More than one of the above D. None of the above E. Check Answer Open question page Que: (181). Which statement correctly describes the difference between BLOB and CLOB? Both are used only for integer values C. BLOB stores binary data, whereas CLOB stores character data A. BLOB stores only numeric data, whereas CLOB stores images B. More than one of the above D. None of the above E. Check Answer Open question page
