MCQs > Database Management > Database MCQs > Database Management System MCQs

Database Management System MCQ

 Database Management System MCQ

1. In the internet, the movement from one network to another network is termed a _______.

Answer

Correct Answer: Hop

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).

Answer

Correct Answer: One

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.

Answer

Correct Answer: ORDER BY

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.

Answer

Correct Answer: Distinct

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.

Answer

Correct Answer: Insert

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.

Answer

Correct Answer: Query

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.

Answer

Correct Answer: Many

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.

Answer

Correct Answer: Domain

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.

Answer

Correct Answer: Range

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.

Answer

Correct Answer: Database

Note: This Question is unanswered, help us to find answer for this one

38. ____ can describe any type of data.

Answer

Correct Answer: XML

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.

Answer

Correct Answer: Planning

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.

Answer

Correct Answer: Binary

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 ____.

Answer

Correct Answer: UNION

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.

Answer

Correct Answer: Primary

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.

Answer

Correct Answer: DBMS

Note: This Question is unanswered, help us to find answer for this one

47. The _____ relationship should be rare in any relational database design.

Answer

Correct Answer: 1:1

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.

Answer

Correct Answer: HOME

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.

Answer

Correct Answer: Caption

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.

Answer

Correct Answer: INSERT

Note: This Question is unanswered, help us to find answer for this one

58. Sql is an example of a ________ category programming language.

Answer

Correct Answer: 4GL

Note: This Question is unanswered, help us to find answer for this one

59. Microsoft azure sql is an example of a _________________ database.

Answer

Correct Answer: Cloud

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

Answer

Correct Answer: INT

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.

Answer

Correct Answer: Pointer

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.

Answer

Correct Answer: DELETE.

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.

Answer

Correct Answer: INTO

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.

Answer

Correct Answer: Design

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 _____.

Answer

Correct Answer: AVG

Note: This Question is unanswered, help us to find answer for this one

82. The sql ________ statement allows you to combine two different tables.

Answer

Correct Answer: JOIN

Note: This Question is unanswered, help us to find answer for this one

83. The pl/sql block starts with the _____ section.

Answer

Correct Answer: DECLARE

Note: This Question is unanswered, help us to find answer for this one

84. The pl/sql block starts with the ____ clause.

Answer

Correct Answer: BEGIN

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.

Answer

Correct Answer: UNION

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.

Answer

Correct Answer: IN

Note: This Question is unanswered, help us to find answer for this one

88. The _____ data type is compatible with number.

Answer

Correct Answer: SMALLINT

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.

Answer

Correct Answer: COUNT

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.

Answer

Correct Answer: SUM

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.

Answer

Correct Answer: 4GL

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.

Answer

Correct Answer: DESC

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 _________:

Answer

Correct Answer: Type

Note: This Question is unanswered, help us to find answer for this one

98. A group of similar rows or records is known as ________.

Answer

Correct Answer: Table.

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).

Answer

Correct Answer: Natural

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.

Answer

Correct Answer: Domain

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 ________.

Answer

Correct Answer: Trigger.

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.

Answer

Correct Answer: Entity.

Note: This Question is unanswered, help us to find answer for this one

107. Data in a multidimensional database is organized in a ________ format

Answer

Correct Answer: Cube.

Note: This Question is unanswered, help us to find answer for this one

108. To assign a conditional value, use the ____ function.

Answer

Correct Answer: IIF

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.

Answer

Correct Answer: IN

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.

Answer

Correct Answer: USE

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.

Answer

Correct Answer: DEFAULT

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.

Answer

Correct Answer: LIKE

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.

Answer

Correct Answer: IN

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.

Answer

Correct Answer: Orphan

Note: This Question is unanswered, help us to find answer for this one

124. Popular ____ include access, oracle, db2, mysql, and sql server.

Answer

Correct Answer: DBMSs

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.

Answer

Correct Answer: 2nd

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.

Answer

Correct Answer: FROM

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.

Answer

Correct Answer: ADD

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.

Answer

Correct Answer: Metadata

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.

Answer

Correct Answer: Select

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.

Answer

Correct Answer: DBMS

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.

Answer

Correct Answer: PROJECT

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.

Answer

Correct Answer: Derived

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.

Answer

Correct Answer: ​DBA

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.

Answer

Correct Answer: Parses

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.

Answer

Correct Answer: Fetches

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.

Answer

Correct Answer: PROJECT

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.

Answer

Correct Answer: 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 ________.

Answer

Correct Answer: Metadata

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 ____.

Answer

Correct Answer: Simple

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.

Answer

Correct Answer: Accuracy

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 __________.

Answer

Correct Answer: Archive

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.

Answer

Correct Answer: Output

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 ________.

Answer

Correct Answer: Required

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.

Answer

Correct Answer: Windows

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 ____.

Answer

Correct Answer: 3NF

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.

Answer

Correct Answer: Database

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.

Answer

Correct Answer: Forms

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.

Answer

Correct Answer: DML

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.

Answer

Correct Answer: Record *

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 ____.

Answer

Correct Answer: Null

Note: This Question is unanswered, help us to find answer for this one

186. In database systems, a _____ refers to a list of data.

Answer

Correct Answer: File

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.

Answer

Correct Answer: Software

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.

Answer

Correct Answer: Field

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 ________.

Answer

Correct Answer: Relation

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 ____.

Answer

Correct Answer: File

Note: This Question is unanswered, help us to find answer for this one

197. In a client/server system, users access the database through ____.

Answer

Correct Answer: Clients

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) ____.

Answer

Correct Answer: Index

Note: This Question is unanswered, help us to find answer for this one

204. Each table _____ represents an attribute.

Answer

Correct Answer: Column

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.

Answer

Correct Answer: Column

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.

Answer

Correct Answer: Minimum

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.

Answer

Correct Answer: Two

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.

Answer

Correct Answer: Binary

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.

Answer

Correct Answer: Database

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) ________.

Answer

Correct Answer: Record

Note: This Question is unanswered, help us to find answer for this one

217. Another name for a composite entity is a(n) _____ entity.

Answer

Correct Answer: Bridge

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) ________.

Answer

Correct Answer: Database

Note: This Question is unanswered, help us to find answer for this one

220. An attribute is also referred to as a ________.

Answer

Correct Answer: Field

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.

Answer

Correct Answer: DBMS

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.

Answer

Correct Answer: Object

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.

Answer

Correct Answer: PUBLIC

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 _____.

Answer

Correct Answer: Table

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.

Answer

Correct Answer: Database

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.

Answer

Correct Answer: Database

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.

Answer

Correct Answer: Database

Note: This Question is unanswered, help us to find answer for this one

232. A ______ is the highest level of data hierarchy.

Answer

Correct Answer: Database

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.

Answer

Correct Answer: Browsers

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.

Answer

Correct Answer: Database

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

Answer

Correct Answer: Modify

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?

Answer

Correct Answer: UPDATE

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

search