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