DBMS & SQL

1. Which of the following is not a type of database? TRE 4.0 DBMS Quiz Practice Set 2 2. Which of the following is not an example of DBMS? TRE 4.0 DBMS Quiz Practice Set 2 3. Which of the following is not a feature of DBMS? TRE 4.0 DBMS Quiz Practice Set 2 4. Which of the following is not a function of the database? TRE 4.0 DBMS Quiz Practice Set 2 5. What is information about data called? TRE 4.0 DBMS Quiz Practice Set 2 6. The DBMS acts as an interface between ________ and ________ of an enterprise-class system. TRE 4.0 DBMS Quiz Practice Set 2 7. ________ is a set of one or more attribute(s) taken collectively to uniquely identify a record. TRE 4.0 DBMS Quiz Practice Set 2 8. Which of the following commands is correct to delete the values in the relation teaches? TRE 4.0 DBMS Quiz Practice Set 2 9. The top level of the hierarchy consists of ________ each of which can contain ________. TRE 4.0 DBMS Quiz Practice Set 2 10. The user IDs can be added or removed using which of the following fixed roles? TRE 4.0 DBMS Quiz Practice Set 2 11. The traditional storage of data organized by the customer, stored in separate folders in filing cabinets is an example of TRE 4.0 DBMS Quiz Practice Set 2 12. After groups have been established, SQL applies predicates in the ________ clause, allowing aggregate functions to be used. TRE 4.0 DBMS Quiz Practice Set 2 13. Which of the following is not the utility of DBMS? I. Backup II. Loading III. Process organization IV. File organization TRE 4.0 DBMS Quiz Practice Set 2 14. For designing a normal RDBMS, which of the following normal forms is considered adequate? TRE 4.0 DBMS Quiz Practice Set 2 15. What happens if a piece of data is stored in two places in the db? TRE 4.0 DBMS Quiz Practice Set 2 16. Which data type can store unstructured data in a column? TRE 4.0 DBMS Quiz Practice Set 2 17. Which of the following is NOT a type of DBMS? TRE 4.0 DBMS Quiz Practice Set 1 18. In a relational database, what is a primary key? TRE 4.0 DBMS Quiz Practice Set 1 19. Which normal form ensures that every non-prime attribute in a table is fully functionally dependent on the primary key? TRE 4.0 DBMS Quiz Practice Set 1 20. Which normal form ensures that every non-prime attribute in a table is fully functionally dependent on the primary key? TRE 4.0 DBMS Quiz Practice Set 1 21. Which of the following is a disadvantage of using a distributed database system? TRE 4.0 DBMS Quiz Practice Set 1 22. Which SQL command is used to add new rows to a database table? TRE 4.0 DBMS Quiz Practice Set 1 23. What is a database? TRE 4.0 DBMS Quiz Practice Set 2 24. Which type of data can be stored in the database? TRE 4.0 DBMS Quiz Practice Set 2 25. Which database model allows a record to have multiple parent records? TRE 4.0 DBMS Quiz Practice Set 2 26. Which of the following is an open-source relational database management system? TRE 4.0 DBMS Quiz Practice Set 2 27. Which DBMS feature allows multiple users to access the database at the same time? TRE 4.0 DBMS Quiz Practice Set 2 28. Which database operation is used to retrieve data from one or more tables? TRE 4.0 DBMS Quiz Practice Set 2 29. Which component of a DBMS stores information about database tables, columns and constraints? TRE 4.0 DBMS Quiz Practice Set 2 30. Which language is used by applications to communicate with a relational database? TRE 4.0 DBMS Quiz Practice Set 2 31. Which key is a minimal superkey that uniquely identifies each record in a relation? TRE 4.0 DBMS Quiz Practice Set 2 32. Which SQL statement deletes only those employees whose salary is less than 10000? TRE 4.0 DBMS Quiz Practice Set 2 33. Which of the following database objects is generally contained within a schema? TRE 4.0 DBMS Quiz Practice Set 2 34. Which fixed database role can manage database permissions and role membership? TRE 4.0 DBMS Quiz Practice Set 2 35. Which database model represents data in the form of tables consisting of rows and columns? TRE 4.0 DBMS Quiz Practice Set 2 36. Which SQL clause is used to arrange rows into groups based on one or more columns? TRE 4.0 DBMS Quiz Practice Set 2 37. Which DBMS utility is used to recover database data after a system failure? TRE 4.0 DBMS Quiz Practice Set 2 38. Which DBMS utility is used to import data from an external file into a database? TRE 4.0 DBMS Quiz Practice Set 2 39. Which normal form requires every attribute in a relation to contain only atomic values? TRE 4.0 DBMS Quiz Practice Set 2 40. What is the term used to describe unnecessary duplication of data in a database? TRE 4.0 DBMS Quiz Practice Set 2 41. Which SQL data type is commonly used to store large binary objects such as images, audio and video files? TRE 4.0 DBMS Quiz Practice Set 2 42. Which data model organizes data in the form of a tree structure? TRE 4.0 DBMS Quiz Practice Set 1 43. Which key is used to establish a relationship between two relational database tables? TRE 4.0 DBMS Quiz Practice Set 1 44. Which normal form requires that all attribute values in a relation be atomic? TRE 4.0 DBMS Quiz Practice Set 1 45. Which normal form requires that all attribute values in a relation be atomic? TRE 4.0 DBMS Quiz Practice Set 1 46. What is a distributed database system? TRE 4.0 DBMS Quiz Practice Set 1 47. Which SQL statement correctly inserts a new record into a table named students? TRE 4.0 DBMS Quiz Practice Set 1 48. What is the primary purpose of a Database Management System (DBMS)? TRE 4.0 DBMS Quiz Practice Set 2 49. Which data type is commonly used to store binary large objects such as images and audio files in a database? TRE 4.0 DBMS Quiz Practice Set 2 50. Which database model represents data using a tree-like structure? TRE 4.0 DBMS Quiz Practice Set 2 51. Which company develops Oracle Database? TRE 4.0 DBMS Quiz Practice Set 2 52. Which property of DBMS ensures that committed transaction changes are not lost after a system failure? TRE 4.0 DBMS Quiz Practice Set 2 53. Which database function is responsible for maintaining the correctness and validity of stored data? TRE 4.0 DBMS Quiz Practice Set 2 54. Which of the following is an example of metadata in a student database? TRE 4.0 DBMS Quiz Practice Set 2 55. Which DBMS component is responsible for parsing and validating SQL queries? TRE 4.0 DBMS Quiz Practice Set 2 56. A candidate key that is not selected as the primary key is called ________. TRE 4.0 DBMS Quiz Practice Set 2 57. Which SQL condition is used to delete records where the value of a column is NULL? TRE 4.0 DBMS Quiz Practice Set 2 58. What is the primary purpose of a database schema? TRE 4.0 DBMS Quiz Practice Set 2 59. Which SQL Server fixed database role provides read access to all user tables and views? TRE 4.0 DBMS Quiz Practice Set 2 60. Which database model allows a child record to have multiple parent records? TRE 4.0 DBMS Quiz Practice Set 2 61. Which aggregate function returns the total number of rows in a table? TRE 4.0 DBMS Quiz Practice Set 2 62. Which DBMS component is responsible for managing the physical storage of database files? TRE 4.0 DBMS Quiz Practice Set 2 63. A relation is in Second Normal Form (2NF) if it is in 1NF and has no ________. TRE 4.0 DBMS Quiz Practice Set 2 64. Which type of anomaly occurs when the same information must be modified in multiple records? TRE 4.0 DBMS Quiz Practice Set 2 65. What is the full form of CLOB in database systems? TRE 4.0 DBMS Quiz Practice Set 2 66. Which of the following is the primary purpose of a DBMS? TRE 4.0 DBMS Quiz Practice Set 1 67. What is a candidate key in a relational database? TRE 4.0 DBMS Quiz Practice Set 1 68. Which normal form eliminates transitive functional dependencies? TRE 4.0 DBMS Quiz Practice Set 1 69. Which normal form eliminates transitive functional dependencies? TRE 4.0 DBMS Quiz Practice Set 1 70. Which technique is used to maintain copies of data at multiple sites in a distributed database? TRE 4.0 DBMS Quiz Practice Set 1 71. Which SQL command is used to modify existing records in a table? TRE 4.0 DBMS Quiz Practice Set 1 72. Who is responsible for managing and maintaining a database system? TRE 4.0 DBMS Quiz Practice Set 2 73. Which of the following is an example of structured data? TRE 4.0 DBMS Quiz Practice Set 2 74. In which database model is data primarily organized into tables consisting of rows and columns? TRE 4.0 DBMS Quiz Practice Set 2 75. Which DBMS is developed by Microsoft? TRE 4.0 DBMS Quiz Practice Set 2 76. Which DBMS feature provides different views of the same database to different users? TRE 4.0 DBMS Quiz Practice Set 2 77. Which database operation is used to arrange records in ascending or descending order? TRE 4.0 DBMS Quiz Practice Set 2 78. Which SQL command is commonly used to display the structure of a table in MySQL? TRE 4.0 DBMS Quiz Practice Set 2 79. Which DBMS component is responsible for managing data stored on disk? TRE 4.0 DBMS Quiz Practice Set 2 80. Which key consists of two or more attributes used together to uniquely identify a record? TRE 4.0 DBMS Quiz Practice Set 2 81. Which SQL command removes all rows from a table while retaining its structure? TRE 4.0 DBMS Quiz Practice Set 2 82. Which of the following is an example of a database schema object? TRE 4.0 DBMS Quiz Practice Set 2 83. Which fixed database role allows members to insert, update and delete data in all user tables? TRE 4.0 DBMS Quiz Practice Set 2 84. In which database model is data represented using parent-child relationships in a tree structure? TRE 4.0 DBMS Quiz Practice Set 2 85. Which aggregate function is used to calculate the average value of a numeric column? TRE 4.0 DBMS Quiz Practice Set 2 86. Which DBMS facility helps prevent unauthorized users from accessing database information? TRE 4.0 DBMS Quiz Practice Set 2 87. Which type of dependency is eliminated when a relation is converted from 2NF to 3NF? TRE 4.0 DBMS Quiz Practice Set 2 88. Which anomaly occurs when deleting one record unintentionally removes other useful information? TRE 4.0 DBMS Quiz Practice Set 2 89. Which data type is designed to store fixed-length binary data in SQL Server? TRE 4.0 DBMS Quiz Practice Set 2 90. Which of the following is an example of a Relational Database Management System? TRE 4.0 DBMS Quiz Practice Set 1 91. What is a super key in a relational database? TRE 4.0 DBMS Quiz Practice Set 1 92. Which normal form is based on the condition that every determinant must be a candidate key? TRE 4.0 DBMS Quiz Practice Set 1 93. Which normal form is based on the condition that every determinant must be a candidate key? TRE 4.0 DBMS Quiz Practice Set 1 94. What is horizontal fragmentation in a distributed database? TRE 4.0 DBMS Quiz Practice Set 1 95. Which SQL command is used to remove specific records from a table? TRE 4.0 DBMS Quiz Practice Set 1 96. What is metadata in a database? TRE 4.0 DBMS Quiz Practice Set 2 97. Which of the following is an example of unstructured data? TRE 4.0 DBMS Quiz Practice Set 2 98. Which type of database stores data at multiple physical locations but provides a unified logical view? TRE 4.0 DBMS Quiz Practice Set 2 99. Which DBMS is commonly used as an embedded database in applications? TRE 4.0 DBMS Quiz Practice Set 2 100. Which feature of DBMS protects data from unauthorized access? TRE 4.0 DBMS Quiz Practice Set 2 101. Which SQL clause is used to filter records based on a specified condition? TRE 4.0 DBMS Quiz Practice Set 2 102. Which of the following is generally stored in a database data dictionary? TRE 4.0 DBMS Quiz Practice Set 2 103. Who is primarily responsible for defining database access permissions and managing database security? TRE 4.0 DBMS Quiz Practice Set 2 104. Which key is used to establish a relationship between two relational database tables? TRE 4.0 DBMS Quiz Practice Set 2 105. Which SQL command removes both the table structure and its stored records? TRE 4.0 DBMS Quiz Practice Set 2 106. Which database component stores information about tables, columns and constraints? TRE 4.0 DBMS Quiz Practice Set 2 107. Which fixed database role has permission to perform database backups? TRE 4.0 DBMS Quiz Practice Set 2 108. Who introduced the relational database model? TRE 4.0 DBMS Quiz Practice Set 2 109. Which SQL clause is used to filter individual rows before grouping takes place? TRE 4.0 DBMS Quiz Practice Set 2 110. Which DBMS utility is used to reorganize database storage structures to improve performance? TRE 4.0 DBMS Quiz Practice Set 2 111. Who introduced the concept of database normalization? TRE 4.0 DBMS Quiz Practice Set 2 112. Which anomaly occurs when a new fact cannot be inserted into a table without adding unrelated information? TRE 4.0 DBMS Quiz Practice Set 2 113. Which SQL Server data type is used to store variable-length binary data? TRE 4.0 DBMS Quiz Practice Set 2 114. In a relational database, a row is also known as: TRE 4.0 DBMS Quiz Practice Set 1 115. Which of the following statements is correct about a composite key? TRE 4.0 DBMS Quiz Practice Set 1 116. What is the main purpose of database normalization? TRE 4.0 DBMS Quiz Practice Set 1 117. What is the main purpose of database normalization? TRE 4.0 DBMS Quiz Practice Set 1 118. What is vertical fragmentation in a distributed database? TRE 4.0 DBMS Quiz Practice Set 1 119. Which SQL command is used to create a new table in a database? TRE 4.0 DBMS Quiz Practice Set 1 120. What does a database schema primarily describe? TRE 4.0 DBMS Quiz Practice Set 2 121. Which of the following formats is commonly used to represent semi-structured data? TRE 4.0 DBMS Quiz Practice Set 2 122. Which database architecture maintains the database at a single central location? TRE 4.0 DBMS Quiz Practice Set 2 123. Which of the following is a document-oriented NoSQL database? TRE 4.0 DBMS Quiz Practice Set 2 124. Which DBMS feature helps restore database information after accidental data loss? TRE 4.0 DBMS Quiz Practice Set 2 125. Which database function allows multiple users to work with data while controlling conflicting operations? TRE 4.0 DBMS Quiz Practice Set 2 126. What is the main purpose of a database catalog? TRE 4.0 DBMS Quiz Practice Set 2 127. Which type of database user interacts with a database through predefined application interfaces? TRE 4.0 DBMS Quiz Practice Set 2 128. Which key is selected from the candidate keys to uniquely identify records in a table? TRE 4.0 DBMS Quiz Practice Set 2 129. Which SQL statement can be used to remove a specific record identified by its primary key? TRE 4.0 DBMS Quiz Practice Set 2 130. In a relational database, what does a table primarily consist of? TRE 4.0 DBMS Quiz Practice Set 2 131. Which fixed database role allows members to execute all database data definition language commands? TRE 4.0 DBMS Quiz Practice Set 2 132. Which of the following is a major limitation of the hierarchical database model? TRE 4.0 DBMS Quiz Practice Set 2 133. Which aggregate function returns the highest value from a specified column? TRE 4.0 DBMS Quiz Practice Set 2 134. Which DBMS feature ensures that database changes are saved permanently after a successful transaction commit? TRE 4.0 DBMS Quiz Practice Set 2 135. Which normal form is stricter than 3NF and requires every non-trivial functional dependency X → Y to have X as a superkey? TRE 4.0 DBMS Quiz Practice Set 2 136. Which database property ensures that data remains accurate and consistent throughout its lifecycle? TRE 4.0 DBMS Quiz Practice Set 2 137. Which data format is commonly used to represent semi-structured data using key-value pairs? TRE 4.0 DBMS Quiz Practice Set 2 138. Which key uniquely identifies each record in a database table? TRE 4.0 DBMS Quiz Practice Set 1 139. Which constraint prevents duplicate values in a database column? TRE 4.0 DBMS Quiz Practice Set 1 140. Which of the following is NOT a type of database anomaly? TRE 4.0 DBMS Quiz Practice Set 1 141. Which of the following is NOT a type of database anomaly? TRE 4.0 DBMS Quiz Practice Set 1 142. Which property ensures that a distributed transaction is completed entirely or not at all? TRE 4.0 DBMS Quiz Practice Set 1 143. Which SQL command is used to add a new column to an existing table? TRE 4.0 DBMS Quiz Practice Set 1 144. What is data redundancy in a database? TRE 4.0 DBMS Quiz Practice Set 2 145. Which type of database is specifically designed to manage multimedia objects such as images, audio and video? TRE 4.0 DBMS Quiz Practice Set 2 146. Which type of database stores information in the form of objects? TRE 4.0 DBMS Quiz Practice Set 2 147. MariaDB was originally developed as a fork of which database system? TRE 4.0 DBMS Quiz Practice Set 2 148. Which concept allows changes in the physical storage of data without affecting the logical structure of the database? TRE 4.0 DBMS Quiz Practice Set 2 149. Which database function is used to combine related records from two or more tables? TRE 4.0 DBMS Quiz Practice Set 2 150. Which type of metadata describes the meaning and business context of data? TRE 4.0 DBMS Quiz Practice Set 2 151. Which interface allows users to retrieve database information by writing SQL statements directly? TRE 4.0 DBMS Quiz Practice Set 2 152. Which type of key is generated by the database system and has no direct business meaning? TRE 4.0 DBMS Quiz Practice Set 2 153. Which SQL clause is used to restrict the records affected by a DELETE statement? TRE 4.0 DBMS Quiz Practice Set 2 154. Which SQL command is commonly used to create a new schema? TRE 4.0 DBMS Quiz Practice Set 2 155. Which fixed database role provides full control over a database? TRE 4.0 DBMS Quiz Practice Set 2 156. Which database model uses pointers or links to establish relationships between records? TRE 4.0 DBMS Quiz Practice Set 2 157. Which aggregate function calculates the sum of values in a numeric column? TRE 4.0 DBMS Quiz Practice Set 2 158. Which DBMS facility maintains a record of database operations for recovery and auditing purposes? TRE 4.0 DBMS Quiz Practice Set 2 159. Which normal form is primarily concerned with eliminating non-trivial multivalued dependencies? TRE 4.0 DBMS Quiz Practice Set 2 160. Which database constraint prevents duplicate values in a specified column? TRE 4.0 DBMS Quiz Practice Set 2 161. Which markup language is used to store and transport structured data using user-defined tags? TRE 4.0 DBMS Quiz Practice Set 2 162. Which database model allows a record to have multiple parent records? TRE 4.0 DBMS Quiz Practice Set 1 163. Which type of key can contain NULL values in a relational database? TRE 4.0 DBMS Quiz Practice Set 1 164. Which normal form deals with multivalued dependencies? TRE 4.0 DBMS Quiz Practice Set 1 165. Which normal form deals with multivalued dependencies? TRE 4.0 DBMS Quiz Practice Set 1 166. Which protocol is commonly used to ensure atomic commitment of distributed transactions? TRE 4.0 DBMS Quiz Practice Set 1 167. Which SQL command permanently removes a table along with its structure? TRE 4.0 DBMS Quiz Practice Set 1 168. Which database concept allows changes in the schema at one level without requiring changes at the next higher level? TRE 4.0 DBMS Quiz Practice Set 2 169. Which database data type is used to store large amounts of character-based text data? TRE 4.0 DBMS Quiz Practice Set 2 170. Which type of database is generally designed to handle flexible schemas and large-scale distributed data? TRE 4.0 DBMS Quiz Practice Set 2 171. Which database system is primarily known as an in-memory key-value data store? TRE 4.0 DBMS Quiz Practice Set 2 172. Which DBMS component is responsible for managing concurrent transactions and maintaining consistency? TRE 4.0 DBMS Quiz Practice Set 2 173. Which database function improves data retrieval speed by creating an efficient access structure? TRE 4.0 DBMS Quiz Practice Set 2 174. Which type of metadata describes database schemas, column names and data types? TRE 4.0 DBMS Quiz Practice Set 2 175. Which component converts SQL queries into an efficient execution plan? TRE 4.0 DBMS Quiz Practice Set 2 176. Which key uses a real-world attribute, such as an email address or passport number, to identify a record? TRE 4.0 DBMS Quiz Practice Set 2 177. What happens when a DELETE statement is executed inside a transaction and then rolled back before commit? TRE 4.0 DBMS Quiz Practice Set 2 178. Which of the following statements about a database catalog is correct? TRE 4.0 DBMS Quiz Practice Set 2 179. Which SQL Server fixed server role has the highest level of administrative privileges? TRE 4.0 DBMS Quiz Practice Set 2 180. Which database model uses primary keys and foreign keys to establish relationships between tables? TRE 4.0 DBMS Quiz Practice Set 2 181. Which SQL clause is generally used to sort the final result of a query in ascending or descending order? TRE 4.0 DBMS Quiz Practice Set 2 182. Which DBMS utility is used to verify the correctness and consistency of stored database information? TRE 4.0 DBMS Quiz Practice Set 2 183. What is the main objective of database normalization? TRE 4.0 DBMS Quiz Practice Set 2 184. Which technique is commonly used to reduce unnecessary data duplication in relational databases? TRE 4.0 DBMS Quiz Practice Set 2 185. Which of the following is an example of unstructured data? TRE 4.0 DBMS Quiz Practice Set 2 186. What is the full form of SQL? TRE 4.0 DBMS Quiz Practice Set 1 187. What is an alternate key in a relational database? TRE 4.0 DBMS Quiz Practice Set 1 188. Which normal form is concerned with join dependencies? TRE 4.0 DBMS Quiz Practice Set 1 189. Which normal form is concerned with join dependencies? TRE 4.0 DBMS Quiz Practice Set 1 190. What is the main purpose of a distributed database transparency? TRE 4.0 DBMS Quiz Practice Set 1 191. Which SQL command removes all rows from a table while retaining its table structure? TRE 4.0 DBMS Quiz Practice Set 1 192. Which key uniquely identifies each record in a relational database table? TRE 4.0 DBMS Quiz Practice Set 2 193. Which type of system is primarily designed for analytical processing and storing large amounts of historical data? TRE 4.0 DBMS Quiz Practice Set 2 194. What is the full form of XML, which is commonly used for storing and exchanging structured information? TRE 4.0 DBMS Quiz Practice Set 2 195. Which database type is specifically designed to represent data using nodes and edges? TRE 4.0 DBMS Quiz Practice Set 2 196. Which of the following database systems is developed by IBM? TRE 4.0 DBMS Quiz Practice Set 2 197. Which DBMS facility maintains information about tables, columns, constraints and other database objects? TRE 4.0 DBMS Quiz Practice Set 2 198. Which database function is used to restore data after a database failure? TRE 4.0 DBMS Quiz Practice Set 2 199. In a relational database, which metadata specifies the permitted values and type of a column? TRE 4.0 DBMS Quiz Practice Set 2 200. Which DBMS interface is commonly used by database administrators to execute administrative commands? TRE 4.0 DBMS Quiz Practice Set 2 201. Which integrity constraint ensures that a primary key cannot contain NULL values? TRE 4.0 DBMS Quiz Practice Set 2 202. Which referential action automatically deletes related child records when a referenced parent record is deleted? TRE 4.0 DBMS Quiz Practice Set 2 203. In which level of the three-schema architecture are individual user views defined? TRE 4.0 DBMS Quiz Practice Set 2 204. Which SQL Server fixed server role can manage server-wide security logins and their properties? TRE 4.0 DBMS Quiz Practice Set 2 205. Which database model is most suitable for representing data with flexible and complex relationships such as social networks? TRE 4.0 DBMS Quiz Practice Set 2 206. Which SQL keyword is used to eliminate duplicate rows from a query result? TRE 4.0 DBMS Quiz Practice Set 2 207. Which DBMS utility is used to reduce the storage space required for database backup files? TRE 4.0 DBMS Quiz Practice Set 2 208. A functional dependency X → Y means that ________. TRE 4.0 DBMS Quiz Practice Set 2 209. What is the primary purpose of a foreign key in a relational database? TRE 4.0 DBMS Quiz Practice Set 2 210. Which SQL data type is commonly used to store very large amounts of Unicode character data in SQL Server? TRE 4.0 DBMS Quiz Practice Set 2 211. Which property of a DBMS ensures that data remains accurate and consistent? TRE 4.0 DBMS Quiz Practice Set 1 212. Which key is formed by combining two or more foreign keys? TRE 4.0 DBMS Quiz Practice Set 1 213. What is a partial functional dependency in database normalization? TRE 4.0 DBMS Quiz Practice Set 1 214. What is a partial functional dependency in database normalization? TRE 4.0 DBMS Quiz Practice Set 1 215. Which type of distributed database has a single logical schema but multiple physical data locations? TRE 4.0 DBMS Quiz Practice Set 1 216. Which SQL command is primarily used to retrieve data from a database table? TRE 4.0 DBMS Quiz Practice Set 1 217. Which database model organizes data in a tree-like structure with parent-child relationships? TRE 4.0 DBMS Quiz Practice Set 2 218. Which of the following is a valid category of data commonly supported by database systems? TRE 4.0 DBMS Quiz Practice Set 2 219. Which database model combines features of relational databases and object-oriented databases? TRE 4.0 DBMS Quiz Practice Set 2 220. Which of the following is a desktop database management system? TRE 4.0 DBMS Quiz Practice Set 2 221. Which DBMS feature ensures that a transaction is executed completely or has no effect at all? TRE 4.0 DBMS Quiz Practice Set 2 222. Which database function is used to calculate values such as COUNT, SUM and AVG? TRE 4.0 DBMS Quiz Practice Set 2 223. Which language is primarily used to define database schemas and their objects? TRE 4.0 DBMS Quiz Practice Set 2 224. Which layer of a three-schema DBMS architecture describes how data is physically stored? TRE 4.0 DBMS Quiz Practice Set 2 225. Which integrity rule ensures that a foreign key value matches an existing referenced key value or is NULL when permitted? TRE 4.0 DBMS Quiz Practice Set 2 226. Which statement correctly describes the difference between DELETE and TRUNCATE? TRE 4.0 DBMS Quiz Practice Set 2 227. Which term describes the actual organization of data stored on physical storage devices? TRE 4.0 DBMS Quiz Practice Set 2 228. Which SQL Server statement is used to add an existing database user to a fixed database role? TRE 4.0 DBMS Quiz Practice Set 2 229. Which database model stores data in a simple file without defining relationships between multiple tables? TRE 4.0 DBMS Quiz Practice Set 2 230. Which SQL statement correctly displays departments having more than 10 employees? TRE 4.0 DBMS Quiz Practice Set 2 231. Which DBMS mechanism allows multiple transactions to access shared data safely without interfering with one another? TRE 4.0 DBMS Quiz Practice Set 2 232. Which of the following anomalies can occur in a poorly normalized database? TRE 4.0 DBMS Quiz Practice Set 2 233. Which of the following is a major disadvantage of excessive data redundancy? TRE 4.0 DBMS Quiz Practice Set 2 234. Which statement correctly describes the difference between BLOB and CLOB? TRE 4.0 DBMS Quiz Practice Set 2 235. Which of the following is a major advantage of using a DBMS? TRE 4.0 DBMS Quiz Practice Set 1 236. Which of the following is NOT a property of a primary key? TRE 4.0 DBMS Quiz Practice Set 1 237. Which of the following is a valid requirement for a relation to be in Third Normal Form (3NF)? TRE 4.0 DBMS Quiz Practice Set 1 238. Which of the following is a valid requirement for a relation to be in Third Normal Form (3NF)? TRE 4.0 DBMS Quiz Practice Set 1 239. Which of the following can improve the availability of a distributed database? TRE 4.0 DBMS Quiz Practice Set 1 240. Which SQL clause is used to filter records based on a specified condition? TRE 4.0 DBMS Quiz Practice Set 1 241. What is a database instance? TRE 4.0 DBMS Quiz Practice Set 2