Database Management System MCQ
Database Management System MCQ
1. In the internet, the movement from one network to another network is termed a _______.
Note: This Question is unanswered, help us to find answer for this one
2. Recovering a database via rollforward involves ________.
Answer
Correct Answer:
Restoring the database from the save and reprocessing all the transactions since the save
Note: This Question is unanswered, help us to find answer for this one
3. The way patient records are created, filed, and maintained is called a(n) ____.
Answer
Correct Answer:
Records managementsystem
Note: This Question is unanswered, help us to find answer for this one
4. Decision makers can access analytical databases using an executive __________.
Answer
Correct Answer:
DASHBOARD
Note: This Question is unanswered, help us to find answer for this one
5. Dbmss available for use on personal computers include ____ and corel paradox.
Answer
Correct Answer:
Microsoft Access
Note: This Question is unanswered, help us to find answer for this one
6. Data warehouses are sometimes called hypercubes because they _____.
Answer
Correct Answer:
Capture raw transaction data
Note: This Question is unanswered, help us to find answer for this one
7. Data integrity with real-time systems involves the acid test, which involves ________.
Answer
Correct Answer:
Atomicity, consistency, isolation, and durability
Note: This Question is unanswered, help us to find answer for this one
8. Current data distribution philosophy makes it easy for ____ end users to access the database.
Answer
Correct Answer:
Authorized
Note: This Question is unanswered, help us to find answer for this one
9. A(n) _____ is a logical storage area in oracle.
Answer
Correct Answer:
Tablespace.
Note: This Question is unanswered, help us to find answer for this one
10. In a database, bits can be organized into bytes, and each byte represents is a(n) ______.
Answer
Correct Answer:
Character
Note: This Question is unanswered, help us to find answer for this one
11. Ideally, an entity identifier is composed of _____ attribute(s).
Note: This Question is unanswered, help us to find answer for this one
12. A(n) ____ limits access to systems, such as computer databases.
Answer
Correct Answer:
Access control
Note: This Question is unanswered, help us to find answer for this one
13. You use the ____ clause to list data in a specific order.
Note: This Question is unanswered, help us to find answer for this one
14. ____ is an example of assistive output devices.
Answer
Correct Answer:
Screen reader software
Note: This Question is unanswered, help us to find answer for this one
15. To eliminate duplicate rows in a query, the ________ qualifier is used in the sql select command.
Note: This Question is unanswered, help us to find answer for this one
16. Oracle 11g is an example of a(n) ____.
Answer
Correct Answer:
XML/Hybrid data model
Note: This Question is unanswered, help us to find answer for this one
17. A table that contains a repeating group is called a(n) ____.
Answer
Correct Answer:
Unnormalized relation
Note: This Question is unanswered, help us to find answer for this one
18. A verb associating two nouns in a business rule translates to a(n) ____ in the data model.
Answer
Correct Answer:
Relationship
Note: This Question is unanswered, help us to find answer for this one
19. To add new data to a table, use the ____ command.
Note: This Question is unanswered, help us to find answer for this one
20. A total completeness constraint is represented by _____.
Answer
Correct Answer:
A double horizontal line under a circle
Note: This Question is unanswered, help us to find answer for this one
21. The extended entity relationship model (eerm) is sometimes referred to as the ____.
Answer
Correct Answer:
Enhanced entity relationship model
Note: This Question is unanswered, help us to find answer for this one
22. A(n) ____________________ is a specific request issued to the dbms for data manipulation.
Note: This Question is unanswered, help us to find answer for this one
23. A specialization hierarchy can have _____ level(s) of supertype/subtype relationships.
Note: This Question is unanswered, help us to find answer for this one
24. In a dataflow diagram (dfd), a(n) ___________ portrays the transformation of data.
Answer
Correct Answer:
Rounded box
Note: This Question is unanswered, help us to find answer for this one
25. ________ integrates data from various operational systems.
Answer
Correct Answer:
Data warehouse.
Note: This Question is unanswered, help us to find answer for this one
26. A ____ query creates a new table using the query results.
Answer
Correct Answer:
Make-table
Note: This Question is unanswered, help us to find answer for this one
27. A(n) ____ has a central security database that is used by all computers that are members of it.
Note: This Question is unanswered, help us to find answer for this one
28. The default orientation for printing a report many be changed using the ____ feature of access.
Answer
Correct Answer:
Print Preview
Note: This Question is unanswered, help us to find answer for this one
29. Knowing the ____ number of entity occurrences is very helpful at the application software level.
Answer
Correct Answer:
Maximum and minimum
Note: This Question is unanswered, help us to find answer for this one
30. A _____ is a central storehouse of information about a system's data.
Answer
Correct Answer:
data repository
Note: This Question is unanswered, help us to find answer for this one
31. A _____ attribute can be further subdivided to yield additional attributes.
Answer
Correct Answer:
Composite
Note: This Question is unanswered, help us to find answer for this one
32. _____ occurs when applications cannot access data associated with other applications.
Answer
Correct Answer:
Data isolation
Note: This Question is unanswered, help us to find answer for this one
33. The maintenance and evolution phase of the database life cycle (dblc) involves _____.
Answer
Correct Answer:
Introducing changes
Note: This Question is unanswered, help us to find answer for this one
34. _____ relationships occur when there are multiple relationship paths between related entities.
Answer
Correct Answer:
Redundant
Note: This Question is unanswered, help us to find answer for this one
35. A(n) ____ is responsible for setting up and managing large databases within an organization.
Answer
Correct Answer:
Database administrator.
Note: This Question is unanswered, help us to find answer for this one
36. A ________ check would be used to restrict the fines for speeding violations from $50 to $250.
Note: This Question is unanswered, help us to find answer for this one
37. A(n) _____ is a computer application that contains records or files.
Note: This Question is unanswered, help us to find answer for this one
38. ____ can describe any type of data.
Note: This Question is unanswered, help us to find answer for this one
39. The initial assessment and the feasibility study are part of the sdlc's ____ phase.
Note: This Question is unanswered, help us to find answer for this one
40. A _____ relationship exists when an association is maintained within a single entity.
Note: This Question is unanswered, help us to find answer for this one
41. A(n) _____ is bidirectional.
Answer
Correct Answer:
Relationship
Note: This Question is unanswered, help us to find answer for this one
42. The oracle equivalent to an ms access autonumber is a(n) _____.
Answer
Correct Answer:
Auto-number.
Note: This Question is unanswered, help us to find answer for this one
43. "union-compatible" means that the ____.
Note: This Question is unanswered, help us to find answer for this one
44. The one table in a one-to-many relationship is the ____________________ table.
Note: This Question is unanswered, help us to find answer for this one
45. The characteristics of an entity are called ____.
Answer
Correct Answer:
Attributes.
Note: This Question is unanswered, help us to find answer for this one
46. The acronym ____________ refers to software that manages data stored in a database.
Note: This Question is unanswered, help us to find answer for this one
47. The _____ relationship should be rare in any relational database design.
Note: This Question is unanswered, help us to find answer for this one
48. Microsoft's most powerful dbms is ________.
Answer
Correct Answer:
SQL Server
Note: This Question is unanswered, help us to find answer for this one
49. ______ are abstractions of reality that explain how things work.
Answer
Correct Answer:
Mental Models
Note: This Question is unanswered, help us to find answer for this one
50. The ____ command will create an application program's or individual user's picture of the database.
Answer
Correct Answer:
CREATE VIEW
Note: This Question is unanswered, help us to find answer for this one
51. Primary keys ensure that ____.
Answer
Correct Answer:
Duplicate records are not stored in the database
Note: This Question is unanswered, help us to find answer for this one
52. Data warehouse contains historical data obtained from the _____.
Answer
Correct Answer:
Operational databases
Note: This Question is unanswered, help us to find answer for this one
53. One way to locate records on a form is to use the find button on the ____ tab in the find group.
Note: This Question is unanswered, help us to find answer for this one
54. To change the caption for a form, use the ____ property in the property sheet.
Note: This Question is unanswered, help us to find answer for this one
55. The database structure in a dbms is stored as a _____.
Answer
Correct Answer:
Collection of files
Note: This Question is unanswered, help us to find answer for this one
56. A ________ is a member function that is automatically called when a class object is ________.
Answer
Correct Answer:
Constructor, created
Note: This Question is unanswered, help us to find answer for this one
57. Sql requires the use of the _____ command to enter data into a table.
Note: This Question is unanswered, help us to find answer for this one
58. Sql is an example of a ________ category programming language.
Note: This Question is unanswered, help us to find answer for this one
59. Microsoft azure sql is an example of a _________________ database.
Note: This Question is unanswered, help us to find answer for this one
60. In a star schema, dimensions are normally stored in ____.
Answer
Correct Answer:
Dimension tables
Note: This Question is unanswered, help us to find answer for this one
61. ________ represent the movement of data from one activity to another.
Answer
Correct Answer:
Data flows
Note: This Question is unanswered, help us to find answer for this one
62. The ____ data type is used to store integers
Note: This Question is unanswered, help us to find answer for this one
63. The ____ data type can store up to a gigabyte of text.
Answer
Correct Answer:
Long Text
Note: This Question is unanswered, help us to find answer for this one
64. One of the challenges with unsupervised data mining is ________.
Answer
Correct Answer:
The analyst must develop explanations for patterns after observing the pattern
Note: This Question is unanswered, help us to find answer for this one
65. Most data you encounter is best classified as ____.
Answer
Correct Answer:
Semistructured
Note: This Question is unanswered, help us to find answer for this one
66. A characteristic of operational data is ____.
Answer
Correct Answer:
High normalization
Note: This Question is unanswered, help us to find answer for this one
67. A characteristic of decision support data is ____.
Answer
Correct Answer:
High query activity
Note: This Question is unanswered, help us to find answer for this one
68. A(n) ____ is a data element containing the address of another data element.
Note: This Question is unanswered, help us to find answer for this one
69. Changing cardinalities ________.
Answer
Correct Answer:
Commonly occurs in database redesign
Note: This Question is unanswered, help us to find answer for this one
70. A table that displays data redundancies yields _____.
Answer
Correct Answer:
All of the above
Note: This Question is unanswered, help us to find answer for this one
71. A database is an organized collection of ________ related data.
Answer
Correct Answer:
Both of the above
Note: This Question is unanswered, help us to find answer for this one
72. Maximum cardinality refers to ________.
Answer
Correct Answer:
The most instances of one entity class that can be involved in a relationship instance with another entity class
Note: This Question is unanswered, help us to find answer for this one
73. ________ duplicates data across databases.
Answer
Correct Answer:
Data propagation.
Note: This Question is unanswered, help us to find answer for this one
74. To include all fields in a sql query, use the ____ symbol after the word select.
Answer
Correct Answer:
Asterisk (*)
Note: This Question is unanswered, help us to find answer for this one
75. To delete a row from the product table, use the ____ command.
Note: This Question is unanswered, help us to find answer for this one
76. To create a new table by using a select statement, you code the ___________________________ clause.
Note: This Question is unanswered, help us to find answer for this one
77. To change a table name, we ________.
Answer
Correct Answer:
Create a new table, move the data and drop the old table
Note: This Question is unanswered, help us to find answer for this one
78. There are two views for tables in access: datasheet view and ________ view.
Note: This Question is unanswered, help us to find answer for this one
79. The syntax for a left outer join is ____.
Answer
Correct Answer:
"SELECT column-list FROM table1 LEFT [OUTER] JOIN table2 ON join-condition"
Note: This Question is unanswered, help us to find answer for this one
80. The sql command ________ defines a logical table from one or more tables or views.
Answer
Correct Answer:
Create view
Note: This Question is unanswered, help us to find answer for this one
81. The sql aggregate function that gives the arithmetic mean for a specific column is _____.
Note: This Question is unanswered, help us to find answer for this one
82. The sql ________ statement allows you to combine two different tables.
Note: This Question is unanswered, help us to find answer for this one
83. The pl/sql block starts with the _____ section.
Note: This Question is unanswered, help us to find answer for this one
84. The pl/sql block starts with the ____ clause.
Note: This Question is unanswered, help us to find answer for this one
85. The comparison operator, < >, is used to insert a condition that means ____.
Answer
Correct Answer:
Not equal to
Note: This Question is unanswered, help us to find answer for this one
86. The _____ statement combines rows from two queries and excludes duplicates.
Note: This Question is unanswered, help us to find answer for this one
87. The _____ operator could be used in place of intersect if the dbms does not support it.
Note: This Question is unanswered, help us to find answer for this one
88. The _____ data type is compatible with number.
Note: This Question is unanswered, help us to find answer for this one
89. The _____ command replaces the ***** in the syntax of the update command, shown above.
Answer
Correct Answer:
SET columnname = expression
Note: This Question is unanswered, help us to find answer for this one
90. The ____ function calculates the number of entries in a table.
Note: This Question is unanswered, help us to find answer for this one
91. The ____ function calculates a total of the values in a column.
Note: This Question is unanswered, help us to find answer for this one
92. Sql queries that use exists and not exists are ________.
Answer
Correct Answer:
Constraint dependent subqueries
Note: This Question is unanswered, help us to find answer for this one
93. Sql is an example of a ________ style of programming language.
Note: This Question is unanswered, help us to find answer for this one
94. Oracle 11g is an example of the _____.
Answer
Correct Answer:
XML/Hybrid data model
Note: This Question is unanswered, help us to find answer for this one
95. In oracle, use the ____ command to display the structure of a table.
Note: This Question is unanswered, help us to find answer for this one
96. In oracle, the _____ function converts a date to a character string.
Answer
Correct Answer:
TO_CHAR()
Note: This Question is unanswered, help us to find answer for this one
97. Columns in a database table contain data with the same _________:
Note: This Question is unanswered, help us to find answer for this one
98. A group of similar rows or records is known as ________.
Note: This Question is unanswered, help us to find answer for this one
99. "lastname" is an example of ________.
Answer
Correct Answer:
Camel case
Note: This Question is unanswered, help us to find answer for this one
100. A _____ index is based on 0 and 1 bits to represent a given condition.
Answer
Correct Answer:
Bitmapped
Note: This Question is unanswered, help us to find answer for this one
101. When designing a database, you should _____.
Answer
Correct Answer:
Make sure that the table entities are normalized before table structures are created
Note: This Question is unanswered, help us to find answer for this one
102. A(n) ____ join will select only the rows with common values in the common attribute(s).
Note: This Question is unanswered, help us to find answer for this one
103. A(n) _____ is the set of possible values for a given attribute.
Note: This Question is unanswered, help us to find answer for this one
104. In the ________ step the data is either written to the file or read from the file.
Answer
Correct Answer:
Processing
Note: This Question is unanswered, help us to find answer for this one
105. A stored program that is attached to a table or view is called ________.
Note: This Question is unanswered, help us to find answer for this one
106. In a data model, a(n) ________ is something that a user wants to track.
Note: This Question is unanswered, help us to find answer for this one
107. Data in a multidimensional database is organized in a ________ format
Note: This Question is unanswered, help us to find answer for this one
108. To assign a conditional value, use the ____ function.
Note: This Question is unanswered, help us to find answer for this one
109. When using a hdfs, the _____ node creates new files by communicating with the ____ node.
Answer
Correct Answer:
Client, name
Note: This Question is unanswered, help us to find answer for this one
110. When a primary key combines two or more fields, it is called a ____ key.
Answer
Correct Answer:
Composite
Note: This Question is unanswered, help us to find answer for this one
111. To retrieve data from multiple tables in a query you can use the ____ operator with a subquery.
Note: This Question is unanswered, help us to find answer for this one
112. To make a specific database active, you must execute the ____ database statement.
Note: This Question is unanswered, help us to find answer for this one
113. To close the resultset, use ____.
Answer
Correct Answer:
Mysqli_free_result
Note: This Question is unanswered, help us to find answer for this one
114. The types of constraints supported in sql are ____.
Answer
Correct Answer:
All of the above
Note: This Question is unanswered, help us to find answer for this one
115. The syntax for the union query is ____.
Answer
Correct Answer:
Query UNION query
Note: This Question is unanswered, help us to find answer for this one
116. The statement, ____, removes the table smaller from a dbms.
Answer
Correct Answer:
DROP TABLE Smaller ;
Note: This Question is unanswered, help us to find answer for this one
117. The primary disadvantage of centralized database systems is ________.
Answer
Correct Answer:
Transmission delay when users are geo-dispersed
Note: This Question is unanswered, help us to find answer for this one
118. The basic form of an sql retrieval command is ____.
Answer
Correct Answer:
SELECT-FROM-WHERE
Note: This Question is unanswered, help us to find answer for this one
119. The _______________ constraint assigns a value to an attribute when a new row is added to a table.
Note: This Question is unanswered, help us to find answer for this one
120. The ____ operator uses one or more wildcard characters to test for a pattern match.
Note: This Question is unanswered, help us to find answer for this one
121. The ____ operator could be used in place of intersect if the rdbms does not support it.
Note: This Question is unanswered, help us to find answer for this one
122. Sql uses search operators such as ____ to form complex queries.
Answer
Correct Answer:
All of the above
Note: This Question is unanswered, help us to find answer for this one
123. Referential integrity prevents the creation of ____ records.
Note: This Question is unanswered, help us to find answer for this one
124. Popular ____ include access, oracle, db2, mysql, and sql server.
Note: This Question is unanswered, help us to find answer for this one
125. Oracle and sql server support the ____ operator but microsoft access does not.
Answer
Correct Answer:
INTERSECT
Note: This Question is unanswered, help us to find answer for this one
126. One of the important functions of a dbms is to provide the necessary tools for ________.
Answer
Correct Answer:
Administering the database
Note: This Question is unanswered, help us to find answer for this one
127. Normalization is normally done to ___ normal form.
Note: This Question is unanswered, help us to find answer for this one
128. In sql, you use the check clause to enforce ____ integrity.
Answer
Correct Answer:
Legal-values
Note: This Question is unanswered, help us to find answer for this one
129. In dbms, data are kept separate from the application's programming code. this means that ________.
Answer
Correct Answer:
Database does not need to be changed if a change is made to an application
Note: This Question is unanswered, help us to find answer for this one
130. In an sql query, a ____ clause is used to specify the table you want to access.
Note: This Question is unanswered, help us to find answer for this one
131. Data type helps a database management system (dbms) to ________.
Answer
Correct Answer:
Allocate storage space
Note: This Question is unanswered, help us to find answer for this one
132. From the performance point of view, _____ databases eliminate disk access bottlenecks.
Answer
Correct Answer:
In-memory
Note: This Question is unanswered, help us to find answer for this one
133. To insert a new field in a table, the ____ keyword should be used with the alter table command.
Note: This Question is unanswered, help us to find answer for this one
134. The most basic file ____ are characteristics such as filename, creation date, and modified date.
Note: This Question is unanswered, help us to find answer for this one
135. The last part of an sql query to be read is the ________ statement.
Note: This Question is unanswered, help us to find answer for this one
136. Dirty data is ________.
Answer
Correct Answer:
Inaccurate, incomplete data
Note: This Question is unanswered, help us to find answer for this one
137. You would use query by example, if _____.
Answer
Correct Answer:
You wish to use a visual approach to query building
Note: This Question is unanswered, help us to find answer for this one
138. The step, ____, occurs first in the process of building an erd.
Answer
Correct Answer:
Create a detailed narrative of the organization's description of operations
Note: This Question is unanswered, help us to find answer for this one
139. The response of the dbms to a query is the ____.
Answer
Correct Answer:
Query result set
Note: This Question is unanswered, help us to find answer for this one
140. The ________________ keeps track of all of the processes that update the database.
Note: This Question is unanswered, help us to find answer for this one
141. The ____ command within relational algebra takes a vertical subset of a table.
Note: This Question is unanswered, help us to find answer for this one
142. A supply chain driven by actual customer orders or purchases follows a ________ model.
Answer
Correct Answer:
Pull-based model
Note: This Question is unanswered, help us to find answer for this one
143. In order to summarize qualitative data, a useful tool is a __________.
Answer
Correct Answer:
Frequency distribiution
Note: This Question is unanswered, help us to find answer for this one
144. Most family therapists who work with couples concentrate on ______.
Answer
Correct Answer:
Improving the couple's patterns of communication so they can find better ways of solving their problems
Note: This Question is unanswered, help us to find answer for this one
145. School-age children would most admire _____.
Answer
Correct Answer:
Marla, who was punished for not telling the teacher who threw a paper airplane
Note: This Question is unanswered, help us to find answer for this one
146. A star schema contains both fact and ________ tables.
Answer
Correct Answer:
Dimension
Note: This Question is unanswered, help us to find answer for this one
147. A spelling mistake in a message is an example of ________
Answer
Correct Answer:
An encoding error
Note: This Question is unanswered, help us to find answer for this one
148. The total quiz points for a student for an entire semester is a(n) ________ attribute.
Note: This Question is unanswered, help us to find answer for this one
149. The ____ is responsible for providing training in the use of the dbms.
Note: This Question is unanswered, help us to find answer for this one
150. The definition for ____ also defines a candidate key.
Answer
Correct Answer:
primary key
Note: This Question is unanswered, help us to find answer for this one
151. The dbms provides applications for processing operations such as ________.
Answer
Correct Answer:
Inserting or deleting information
Note: This Question is unanswered, help us to find answer for this one
152. The dbms _____ the sql query and chooses the most efficient access/execution plan.
Note: This Question is unanswered, help us to find answer for this one
153. The dbms _____ the data and sends the result set back to the client.
Note: This Question is unanswered, help us to find answer for this one
154. The data ____ component is used to create and maintain the data dictionary.
Answer
Correct Answer:
Data definition
Note: This Question is unanswered, help us to find answer for this one
155. The data ____ component is used to add, delete, modify, and retrieve records from a database.
Answer
Correct Answer:
Manipulation
Note: This Question is unanswered, help us to find answer for this one
156. The ____ type of attribute cannot be created in a dbms.
Answer
Correct Answer:
Multivalued
Note: This Question is unanswered, help us to find answer for this one
157. You can restrict the output from a join to include only certain columns by using the ____ command.
Note: This Question is unanswered, help us to find answer for this one
158. The _____ special operator is used to check whether an attribute value is null.
Note: This Question is unanswered, help us to find answer for this one
159. The _____ process analyzes sql queries and finds the most efficient way to access data.
Answer
Correct Answer:
Optimizer
Note: This Question is unanswered, help us to find answer for this one
160. Special data that describe the data contained in a database are called ________.
Note: This Question is unanswered, help us to find answer for this one
161. Some databases use ______, which is a visual approach to developing queries and requests.
Answer
Correct Answer:
Query by Example (QBE)
Note: This Question is unanswered, help us to find answer for this one
162. Some attributes are classified as ____.
Note: This Question is unanswered, help us to find answer for this one
163. Relational tables need to be ______________ to help avoid duplicate data.
Answer
Correct Answer:
Normalized
Note: This Question is unanswered, help us to find answer for this one
164. Relational databases represent relationships using ________.
Answer
Correct Answer:
Foreign keys
Note: This Question is unanswered, help us to find answer for this one
165. Referential integrity is normally enforced by the ____.
Answer
Correct Answer:
Database management system
Note: This Question is unanswered, help us to find answer for this one
166. Reducing redundant data helps improve the _____ of the database.
Note: This Question is unanswered, help us to find answer for this one
167. Rather than deleting old data, it can be moved to a data __________.
Note: This Question is unanswered, help us to find answer for this one
168. Potential problems in the design of a relational database are known as ____.
Answer
Correct Answer:
Update anomalies
Note: This Question is unanswered, help us to find answer for this one
169. Opening a(n) ________ file creates a file on disk and allows the program to write data to it.
Note: This Question is unanswered, help us to find answer for this one
170. One of the important properties of a column is whether or not it is ________.
Note: This Question is unanswered, help us to find answer for this one
171. One column of a table in a relational database is called a(n) ____.
Answer
Correct Answer:
Attribute
Note: This Question is unanswered, help us to find answer for this one
172. Odbc works on the _____ operating system.
Note: This Question is unanswered, help us to find answer for this one
173. Most designers consider the bcnf as a special case of the ____.
Note: This Question is unanswered, help us to find answer for this one
174. Most decision-support data are based on historical data obtained from ____.
Answer
Correct Answer:
Operational databases
Note: This Question is unanswered, help us to find answer for this one
175. Microsoft access can best be described as ____ software.
Note: This Question is unanswered, help us to find answer for this one
176. Metadata are ________.
Answer
Correct Answer:
Data that are encrypted
Note: This Question is unanswered, help us to find answer for this one
177. Many programs today use ______ on a webpage as their front end.
Note: This Question is unanswered, help us to find answer for this one
178. Lock ____ indicates the level of lock use.
Answer
Correct Answer:
Granularity
Note: This Question is unanswered, help us to find answer for this one
179. Insert into is an example of ________ code.
Note: This Question is unanswered, help us to find answer for this one
180. Individual database tables are often referred to as ____.
Answer
Correct Answer:
Flat Files
Note: This Question is unanswered, help us to find answer for this one
181. In this text, boyce-codd normal form is the same as ____.
Answer
Correct Answer:
Third normal form
Note: This Question is unanswered, help us to find answer for this one
182. In the world of databases, a(n) ____ refers to a collection of data fields.
Note: This Question is unanswered, help us to find answer for this one
183. In the sql language, the ________ statement is used to make table definitions.
Answer
Correct Answer:
Create table
Note: This Question is unanswered, help us to find answer for this one
184. In the accompanying figure, any field that serves as a primary key is called a _____.
Answer
Correct Answer:
Candidate key
Note: This Question is unanswered, help us to find answer for this one
185. In indexed storage, when a file is created, the pointers in the index block are all set to ____.
Note: This Question is unanswered, help us to find answer for this one
186. In database systems, a _____ refers to a list of data.
Note: This Question is unanswered, help us to find answer for this one
187. In comparison with a flat file system, _____ in a database.
Answer
Correct Answer:
Storage space is reduced
Note: This Question is unanswered, help us to find answer for this one
188. In a student database, a good key field for a record would be a ______
Answer
Correct Answer:
Student ID#.
Note: This Question is unanswered, help us to find answer for this one
189. In a student database, a column called lastname would be an example of a(n) _____________.
Answer
Correct Answer:
Attribute
Note: This Question is unanswered, help us to find answer for this one
190. In a general sense, ____________ refers to all the non-hardware components of a digital device.
Note: This Question is unanswered, help us to find answer for this one
191. In a file-oriented information system, a work file ____.
Answer
Correct Answer:
Is a temporary file created by an information system for a single task
Note: This Question is unanswered, help us to find answer for this one
192. In a file oriented information system a security file ____
Answer
Correct Answer:
Is created and saved for backup and recovery purposes
Note: This Question is unanswered, help us to find answer for this one
193. In a database, when data items disagree with one another, it leads to a(n) ________.
Answer
Correct Answer:
Data integrity problem
Note: This Question is unanswered, help us to find answer for this one
194. In a database, the term ________ is synonymous with a category of information.
Note: This Question is unanswered, help us to find answer for this one
195. In a database, a table is formally referred to as a ________.
Note: This Question is unanswered, help us to find answer for this one
196. In a database, a collection of related records is referred to as a table or a ____.
Note: This Question is unanswered, help us to find answer for this one
197. In a client/server system, users access the database through ____.
Note: This Question is unanswered, help us to find answer for this one
198. If a primary key combines two or more fields, then it is called a _____.
Answer
Correct Answer:
Composite key
Note: This Question is unanswered, help us to find answer for this one
199. Granularity refers to ____.
Answer
Correct Answer:
The level of detail represented by the values stored in a table's row
Note: This Question is unanswered, help us to find answer for this one
200. From a structural point of view, 3nf is better than _____.
Answer
Correct Answer:
3NF and BCNF
Note: This Question is unanswered, help us to find answer for this one
201. File ______ refers to the procedures that keep data current.
Answer
Correct Answer:
Maintenance
Note: This Question is unanswered, help us to find answer for this one
202. Fields that contain numbers that are not used in calculations should be set to ________.
Answer
Correct Answer:
Short text
Note: This Question is unanswered, help us to find answer for this one
203. Field values related to records that contain those field values may be listed in a(n) ____.
Note: This Question is unanswered, help us to find answer for this one
204. Each table _____ represents an attribute.
Note: This Question is unanswered, help us to find answer for this one
205. Each category of information in a database is called a(n) ____.
Answer
Correct Answer:
Attribute
Note: This Question is unanswered, help us to find answer for this one
206. Each attribute of an entity becomes a(n) ________ of a table.
Note: This Question is unanswered, help us to find answer for this one
207. Design view is used to ____ a table.
Answer
Correct Answer:
Create or modify the structure of
Note: This Question is unanswered, help us to find answer for this one
208. Constraints on the minimum number of entities in a relationship are called ________ cardinalities.
Note: This Question is unanswered, help us to find answer for this one
209. Complete categories are represented by ____ line(s) below the category symbol.
Note: This Question is unanswered, help us to find answer for this one
210. Compared with character-based formats, a _____ offers a more efficient storage method.
Note: This Question is unanswered, help us to find answer for this one
211. Columns that are keys to different tables than the ones in which they reside are called ________.
Answer
Correct Answer:
Foreign keys
Note: This Question is unanswered, help us to find answer for this one
212. Browser-based applications ________.
Answer
Correct Answer:
Support querying using graphics
Note: This Question is unanswered, help us to find answer for this one
213. A ____ is a group of interrelated files.
Note: This Question is unanswered, help us to find answer for this one
214. Big data analytics is usually associated with ________ services.
Answer
Correct Answer:
Data warehouse
Note: This Question is unanswered, help us to find answer for this one
215. As part of a dbms, a(n) _________ documents information about a database.
Answer
Correct Answer:
Data dictionary
Note: This Question is unanswered, help us to find answer for this one
216. Another term for a database row is a(n) ________.
Note: This Question is unanswered, help us to find answer for this one
217. Another name for a composite entity is a(n) _____ entity.
Note: This Question is unanswered, help us to find answer for this one
218. An entity that exists to implement a many-to-many relationship is called a(n) ____.
Answer
Correct Answer:
Composite entity
Note: This Question is unanswered, help us to find answer for this one
219. An electronic storage file where firms keep customer information is known as a(n) ________.
Note: This Question is unanswered, help us to find answer for this one
220. An attribute is also referred to as a ________.
Note: This Question is unanswered, help us to find answer for this one
221. After a dbms detects a deadlock, the ____ should break the deadlock.
Note: This Question is unanswered, help us to find answer for this one
222. A(n) ______ is an item that contains data, as well as the actions that read or process the data.
Note: This Question is unanswered, help us to find answer for this one
223. A(n) ____ synonym is used by others to access an individual's database objects.
Note: This Question is unanswered, help us to find answer for this one
224. A distributed _____ can reference several different local or remote data processing sites.
Answer
Correct Answer:
Transaction
Note: This Question is unanswered, help us to find answer for this one
225. A database administrator (dba) is responsible for _____.
Answer
Correct Answer:
Developing recovery procedures in case data is lost or corrupted
Note: This Question is unanswered, help us to find answer for this one
226. A data ____ table describes the fields you plan to maintain in a table.
Answer
Correct Answer:
Definition
Note: This Question is unanswered, help us to find answer for this one
227. A consistent database is ____.
Answer
Correct Answer:
One in which all data integrity constraints are satisfied
Note: This Question is unanswered, help us to find answer for this one
228. A collection of related records in a database is referred to as a _____.
Note: This Question is unanswered, help us to find answer for this one
229. A ________ is a highly structured collection of data values organized into separate tables.
Note: This Question is unanswered, help us to find answer for this one
230. A ________ is a group of related data that can be stored, sorted, organized, and queried.
Note: This Question is unanswered, help us to find answer for this one
231. A ________ is a collection of related data that can be stored, sorted, organized, and queried.
Note: This Question is unanswered, help us to find answer for this one
232. A ______ is the highest level of data hierarchy.
Note: This Question is unanswered, help us to find answer for this one
233. A ____ is a program that lets computer users create and access a collection of organized data.
Answer
Correct Answer:
Database management system
Note: This Question is unanswered, help us to find answer for this one
234. A ____ database supports data distributed across several different sites.
Answer
Correct Answer:
Distributed
Note: This Question is unanswered, help us to find answer for this one
235. __________ are the most commonly used database clients.
Note: This Question is unanswered, help us to find answer for this one
236. _________ maintains information about various types of objects, events, people, and places.
Note: This Question is unanswered, help us to find answer for this one
237. ________ is used to ensure that data is organized most efficiently in a database.
Answer
Correct Answer:
Normalization
Note: This Question is unanswered, help us to find answer for this one
238. ________ involves searching for patterns and relationships among data.
Answer
Correct Answer:
Data mining
Note: This Question is unanswered, help us to find answer for this one
239. ________ databases are the most commonly used electronic databases.
Answer
Correct Answer:
Relational
Note: This Question is unanswered, help us to find answer for this one
240. ______ databases are the most frequently used electronic databases.
Answer
Correct Answer:
Relational
Note: This Question is unanswered, help us to find answer for this one
241. ____ is used to reveal the meaning of data.
Answer
Correct Answer:
Information
Note: This Question is unanswered, help us to find answer for this one
242. Which of the following in true regarding Referential Integrity?
Answer
Correct Answer:
Every foreign-key value must match a primary-key value in an associated table
Note: This Question is unanswered, help us to find answer for this one
243. Which of the following is not a level of data abstraction?
Answer
Correct Answer:
Critical Level
Note: This Question is unanswered, help us to find answer for this one
244. If every non-key attribute is functionally dependent on the primary key, the relation will be in
Answer
Correct Answer:
Third Normal Form
Note: This Question is unanswered, help us to find answer for this one
245. In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction?
Answer
Correct Answer:
CREATE SCHEMA
Note: This Question is unanswered, help us to find answer for this one
246. A _____ DBMS distributes data processing tasks between the workstation and a network server.
Answer
Correct Answer:
Client server
Note: This Question is unanswered, help us to find answer for this one
247. Which of the following in true regarding Null Value?
Answer
Correct Answer:
Null < > 0
Note: This Question is unanswered, help us to find answer for this one
248. How many types of keys in Database Design?
Answer
Correct Answer:
All of these
Note: This Question is unanswered, help us to find answer for this one
249. The attribute that can be divided into other attributes is called
Answer
Correct Answer:
Composite Attribute
Note: This Question is unanswered, help us to find answer for this one
250. In DBMS FD stands for _______
Answer
Correct Answer:
Functional dependency
Note: This Question is unanswered, help us to find answer for this one
251. A command to remove a relation from an SQL database
Answer
Correct Answer:
Drop table < table name >
Note: This Question is unanswered, help us to find answer for this one
252. Data integrity control
Answer
Correct Answer:
Has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files
Note: This Question is unanswered, help us to find answer for this one
253. What is ACID properties of Transactions?
Answer
Correct Answer:
Atomicity, Consistency, Isolation, Durability
Note: This Question is unanswered, help us to find answer for this one
254. A command that lets you change one or more fields in a record is
Note: This Question is unanswered, help us to find answer for this one
255. Snapshot of the dta in the database at a given instant of time is called
Answer
Correct Answer:
Database Instance
Note: This Question is unanswered, help us to find answer for this one
256. In SQL, which of the following is not a data definition language commands?
Note: This Question is unanswered, help us to find answer for this one
257. Administrate supervision of database activities is the responsibility of the
Answer
Correct Answer:
Database Administrator
Note: This Question is unanswered, help us to find answer for this one
258. The Primary key must be
Answer
Correct Answer:
Option Non Null and Unique
Note: This Question is unanswered, help us to find answer for this one
259. Database locking concept is used to solve the problem of?
Answer
Correct Answer:
All of these
Note: This Question is unanswered, help us to find answer for this one
260. Report generators are used to
Answer
Correct Answer:
Both retrieve information from files and answer queries
Note: This Question is unanswered, help us to find answer for this one
261. Data Manipulation Language (DML) is not to
Answer
Correct Answer:
Create information table in the Database
Note: This Question is unanswered, help us to find answer for this one
Database MCQs | Topic-wise