CPTR 424 Review 1

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

105. The software that controls the database is called the A. DBMS B. DBA C. file controller D. MIS

A. DBMS

9. All of the following are record-based models EXCEPT A. E-R B. relational C. network D. hierarchical

A. E-R

40. In dynamic SQL, the command to parse and compile a host-language string containing an SQL command is A. PREPARE B. EXECUTE C. COMPILE D. UPDATE

A. PREPARE

45. In the E-R model, a relationship among three entity sets is described as A. unary B. binary C. ternary D. many-valued

C. ternary

42. In mapping a relationship to a relational schema, which of the following always requires a separate table? A. a many-to-many relationship B. a weak relationship C. a recursive relationship D. a one-to-many relationship

A. a many-to-many relationship

5. A subschema is the same as A. an external schema B. a logical schema C. an internal schema D. a virtual schema

A. an external schema

102. The relation schema shows the table name for each relation and column headings for each of its _______. A. attributes B. unions C. entities D. subsets

A. attributes

54. In the E-R model, the defining properties or qualities of an entity are called A. attributes B. members C. fields D. objects

A. attributes

19. Database users who enter their own queries are called A. casual users B. naive users C. programmers D. DBAs

A. casual users

44. In the E-R model, a key that consists of more than one attribute is described as A. composite B. derived C. a superkey D. a foreign key

A. composite

49. In the E-R model, an attribute that can be broken down into smaller attributes is called A. composite B. derived C. null D. a superattribute

A. composite

65. In the ER model, an attribute such as Address that can be broken up into smaller elements is said to be A. composite B. multi-valued C. normalized D. derived

A. composite

133. Which type of relational table constraint cannot be specified as a column-level constraint? A. composite primary key B. uniqueness C. check D. default

A. composite primary key

112. The _______ model extends the E-R model to allow various types of abstraction to be included and to express constraints more clearly. A. extended entity-relationship B. recursive C. relational D. enterprise

A. extended entity-relationship

129. Which of the following models was a predecessor of the relational model? A. hierarchical B. semi-structured C. object-oriented D. functional

A. hierarchical

17. Data that has been processed for decision-making is called A. information B. a miniworld C. operational data D. metadata

A. information

38. In an EE-R diagram, the specialization circle is sometimes called a(n) A. isa relationship symbol B. aggregation symbol C. subset symbol D. object symbol

A. isa relationship symbol

100. The phase in which the conceptual model is mapped to the DBMS is the development of the A. logical model B. physical model C. prototype D. internal model

A. logical model

92. The data storage technology used in the 1890 census was A. punched cards B. punched paper tape C. magnetic tape D. MICR

A. punched cards

111. The symbol that represents an entity in an E-R diagram is a(n) A. rectangle B. oval C. diamond D. triangle

A. rectangle

117. When an entity set is related to itself, we have a _______ relationship. A. recursive B. optional C. mandatory D. extended

A. recursive

57. In the E-R model, when an entity set is related to itself, we call the relationship A. recursive B. dominant C. role-defined D. weak

A. recursive

73. In the relational model, which of the following operations is performed on a single table? A. select B. natural join C. product D. union

A. select

132. Which of the following types of attributes can be represented directly as a column in a relational model? A. single-valued, non-composite B. multiple-valued, non-composite C. derived, single-valued D. composite, single-valued

A. single-valued, non-composite

78. On an E-R diagram, the primary key of an entity is indicated by A. underlining B. italics C. bold font D. a double oval

A. underlining

31. In a JDBC application, query results can be returned using an object of which class? A. the DatabaseConnection class B. the ResultSet class C. the QueryObject class D. the GetConnection class

B. the ResultSet class

41. In embedded SQL, the tuple at which a cursor is positioned is referred to as A. the current of the table B. the current of the cursor C. the cursor position D. the user string

B. the current of the cursor

52. In the E-R model, if every member of an entity set must participate in a relationship, the participation is described as A. complete B. total C. partial D. constrained

B. total

10. All of the following are SQL DDL commands except A. CREATE TABLE B. DROP INDEX C. ADD TABLE D. ALTER TABLE

C. ADD TABLE

75. Most relational DBMSs use what structure to store indexes? A. linked lists B. hashed files C. B trees or B+ trees D. red-black trees

C. B trees or B+ trees

15. An SQL index specification that causes records with the same values on the indexed field to be stored close together is A. NOT NULL B. UNIQUE C. CLUSTER D. DISTINCT

C. CLUSTER

107. The SQL command to advance a cursor to obtain the next row of results is A. NEXT B. ADVANCE C. FETCH D. SCROLL

C. FETCH

108. The SQL option HAVING can only be used with the option A. ORDER BY B. DISTINCT C. GROUP BY D. LIKE

C. GROUP BY

130. Which of the following statements about mapping a union in an EE-R diagram to a relational schema is true? A. It is not possible to represent a union in a relational schema B. A surrogate key is always required C. The union can be represented as a table, with additional tables for the supersets D. The union can be represented using a single table can be includes all the supersets

C. The union can be represented as a table, with additional tables for the supersets

114. To find rows of the Employee table that have no value for rating, use the SQL predicate A. WHERE RATING =' ' B. WHERE RATING = 0 C. WHERE RATING IS NULL D. WHERE RATING = NULL

C. WHERE RATING IS NULL

83. Since the result of an SQL SELECT statement can have duplicates, the result is referred to as A. a table B. a set C. a multi-set D. a relation

C. a multi-set

47. In the E-R model, a weak entity requires the presence of another entity that is depends on, referred to as A. an independent entity B. a dependent entity C. a strong entity D. a composite entity

C. a strong entity

101. The problem caused by the difference between the set-oriented SQL SELECT statement and the host language record-at-a-time capabilities is referred to as A. a dynamic variation B. a type mismatch C. an impedance mismatch D. a typecast

C. an impedance mismatch

123. Which of the following is an example of data rather than information? A. a student grade report B. an alphabetical class roster C. an unordered list of grades for a test D. a faculty schedule

C. an unordered list of grades for a test

109. The standard components of ODBC/JDBC architecture are A. driver manager, driver, database, server B. application, driver manager, driver, view C. application, driver manager, driver, data source D. driver manager, driver, database, user

C. application, driver manager, driver, data source

46. In the E-R model, a superkey in which all the attributes are necessary for uniqueness is called a A. foreign key B. composite key C. candidate key D. alternate key

C. candidate key

53. In the E-R model, if the value of an attribute is determined by a calculation on the value of another attribute in a relation, we call the first attribute A. weak B. strong C. derived D. null

C. derived

62. In the EE-R model, if entity instances cannot belong to more than one subclass, we say the subclasses are A. complete B. partial C. disjoint D. total

C. disjoint

56. In the E-R model, what symbol is used to represent an attribute that can have multiple values for an entity instance? A. dashed oval B. solid oval C. double oval D. oval with smaller ovals attached to it

C. double oval

106. The SQL ALTER TABLE command can be used to do all of the following except A. add new columns B. drop columns C. drop the table D. add a constraint

C. drop the table

24. If A has 20 rows and B has 30 rows, the number of rows in their product A. equals 50 B. depends on how many rows of A match rows of B on a common column C. equals 600 D. equals 20

C. equals 600

71. In the relational model, the table in which a foreign key appears as the primary key is called its A. root relation B. child relation C. home relation D. foreign relation

C. home relation

119. Which of the following activities is performed during the conceptual model design phase? A. evaluating alternative DBMSs B. planning layout of data C. identifying entities, attributes, and relationships D. doing system tuning

C. identifying entities, attributes, and relationships

14. An important advantage of the relational model compared to earlier database models was that A. it was more efficient B. it used familiar file systems C. it provided data independence D. it was cheaper

C. it provided data independence

97. The middle level of the three-level database architecture, containing the entire information structure as seen by the DBA is the A. external B. internal C. logical D. physical

C. logical

8. All of the following are potential advantages of using a database EXCEPT A. control of redundancy B. improved data integrity C. lower cost D. better data consistency

C. lower cost

131. Which of the following storage technologies first offered direct access to stored records? A. paper tape B. magnetic tape C. magnetic disk D. punched cards

C. magnetic disk

120. Which of the following cannot be done using just a PROJECT operator in the relational model A. eliminating duplicate values B. operating on more than one column C. picking out target rows D. picking out a vertical subset of a table

C. picking out target rows

50. In the E-R model, connections or interactions between entities are called A. attributes B. links C. relationships D. tuples

C. relationships

36. In an E-R diagram, the function that each entity has in a relationship is called its A. context B. participation C. role D. constraint

C. role

122. Which of the following is an advantage of a database compared to a file processing system? A. fast processing of sequential data B. lower cost C. sharing of data D. simpler recovery

C. sharing of data

33. In a university, students can get at most one parking permit for one car. Not every student has a car. No car is allowed on campus without a parking permit. In the E-R model, the participation constraint for car in the relationship to student is A. partial B. total C. strong D. many

C. strong

90. The customary way to indicate a primary key in a relation schema is to A. make it bold B. use italics C. underline it D. use an arrow

C. underline it

72. In the relational model, the type of time in a temporal relation that corresponds to the time that events occur in the real world is called A. system time B. correct time C. user valid time D. transaction time

C. user valid time

138. Some DBMSs allow an optional ___________ specification for only one index for each table. With this option, the system will store records in physical order by the values of the indexed field.

CLUSTER

141. The SQL command to create a table is _______.

CREATE TABLE

139. The number of rows in a table, called the __________ of the relation, changes as new tuples are added or old ones are deleted.

Cardinality

134. A __________________ of two sets, written D1 X D2, is the set of all ordered pairs such that the first element is a member of D1 and the second element is a member of D2.

Cartesian product

39. In an EE-R diagram, the symbol placed on the line connecting a subclass to the specialization circle is a(n) A. triangle B. set membership symbol C. aggregation symbol D. inheritance symbol

D. inheritance symbol

28. In a bank, if we assume that savings accounts can be jointly owned by two or more customers, and that a customer can have more than one savings accounts, the relationship between the savings accounts entity set and the customer entity set is A. one-to-one B. one-to-many C. many-to-one D. many-to-many

D. many-to-many

7. All of the following are examples of data standards EXCEPT A. data naming conventions B. update procedures C. documentation rules D. query optimization

D. query optimization

94. The E-R model is classified as A. external B. hierarchical C. seminal D. semantic

D. semantic

104. The repository of information about the logical structure of the database is called the A. universe of discourse B. miniworld C. user view D. system catalog

D. system catalog

110. The standard three-level database architecture was proposed by A. IBM B. the W3C committee C. Chen D. the CODASYL DBTG

D. the CODASYL DBTG

98. The organization for which the database is designed is referred to as A. the universe of discourse B. the metadata C. the entity D. the enterprise

D. the enterprise

142. _______ are persons, places, events, objects, or concepts about which data is collected.

Entities

143. A semi-structured database must be described in an XML schema.

FALSE

149. An ER diagram is used to represent the physical model of a database

FALSE

150. Batch processing requires a direct access storage device.

FALSE

151. CREATE TABLE is one of the most important SQL Data Manipulation Language (DML) commands.

FALSE

156. In the object-oriented data model, encapsulation refers to the fact that objects remain in existence even after an application program terminates.

FALSE

160. Like a shared subset, an instance of a union inherits attributes from all the supersets.

FALSE

162. NoSQL systems do not permit the use of SQL in the user interface.

FALSE

163. Once a database schema is created, it cannot be changed.

FALSE

164. Relation schemas are represented by giving the name of each relation, followed by the attribute names in parentheses, with the foreign key underlined.

FALSE

165. Repetition of data should never be allowed in a database.

FALSE

167. The Hadoop Distributed File System divides data into blocks, each of which is assigned to only one cluster.

FALSE

168. The hierarchical model is usually categorized as a semantic model.

FALSE

169. The most important development in the database field during the past decade is the development of relational databases.

FALSE

170. The recognition of data as a corporate resource is not important in developing an integrated database environment.

FALSE

173. To prevent errors, database users are never allowed to access the database simultaneously.

FALSE

174. UML was originally created as a tool for database modeling.

FALSE

177. When designing an E-R diagram, you should consult with potential users of the database.

FALSE

178. Writing the code for creating a database structure is normally the responsibility of application programmers.

FALSE

136. Relational database management systems support the standard _______ architecture for databases.

Three-level

137. Relational views can be either windows or __________ tables, not permanently stored but created when the user needs to access them.

Virtual

69. In the relational model, relations are represented physically as A. rectangles B. tables C. records D. objects

B. tables

67. In the relational model, if we combine all the tuples of one table with all the tuples of a second table, the result is the A. PRODUCT B. UNION C. NATURAL JOIN D. SUM

A. PRODUCT

81. Routines created using an extension of SQL and stored in the database space are called A. PSMs B. ODBCs C. APIs D. scripts

A. PSMs

115. To retrieve all columns in a SQL SELECT operation, the SELECT line should read A. SELECT * B. SELECT ALL C. SELECT ALL COLUMNS D. SELECT

A. SELECT *

103. The relational algebra operator that takes rows of a single table that meet a specified condition is the A. SELECT operator B. PROJECT operator C. JOIN operator D. UNION operator

A. SELECT operator

22. Given an Employee table with columns for salary and dept, to raise the salaries of all employees in the sales department by 10%, we could write A. UPDATE Employee SET salary = salary*1.10 WHERE dept='sales'; B. UPDATE salary SET salary = salary*1.10 WHERE dept='sales'; C. UPDATE Employee SET salary = 1.10 WHERE dept='sales'; D. UPDATE Employee LET salary = salary*1.10 WHERE dept='sales';

A. UPDATE Employee SET salary = salary*1.10 WHERE dept='sales';

96. The language that is a standard for data exchange between diverse data sources is A. XML B. SQL C. OQL D. SML

A. XML

32. In a JDBC application, which of the following types of objects is used to execute stored procedure? A. a CallableStatement object B. a ResultSet object C. a PL/SQL object D. a PreparedStatement object

A. a CallableStatement object

124. Which of the following is another term for the system data dictionary? A. ALL view B. system catalog C. DBA view D. CONSTRAINTS

B. system catalog

27. If S = {a,b} and T = {1,2,3} then the Cartesian product S X T has how many ordered pairs? A. 5 B. 6 C. 8 D. 9

B. 6

113. To eliminate duplicates in the results of an SQL query, use the option A. UNIQUE B. DISTINCT C. NO REPEATS D. ORDER BY

B. DISTINCT

126. Which of the following is NOT usually identified as a big data technology? A. Hadoop B. IDS C. NoSQL D. NewSQL

B. IDS

127. Which of the following is NOT valid in an SQL subquery?</div>{ A. ...WHERE empId IN ( SELECT empId... B. ...WHERE empid = (SELECT empId.. C. ...WHERE NOT EXISTS ( SELECT * D. ...WHERE empId IN ( SELECT *

D. ...WHERE empId IN ( SELECT *

121. Which of the following is a project management tool that shows tasks, resources, task dependencies, and timelines for a project A. spreadsheet B. project chart C. E-R diagram D. Gantt chart

D. Gantt chart

125. Which of the following is not part of a trigger. A. Action B. Event C. Condition D. Relationship

D. Relationship

116. When a recursive relationship is mapped in a relational schema, which of the following is true? A. a separate relationship table is always required B. the relationship is impossible to represent C. the relationship can always be represented in the original table for the entity D. a separate relationship table may or may not be required

D. a separate relationship table may or may not be required

118. When mapping a hierarchy from an EE-R diagram to a relational model, which of the following methods can be used? A. create a single table that includes all attributes of the superset and the subsets B. create a table for the superset and one for each of the subsets C. create tables for the subsets, but include the attributes of the superset in each D. all of these

D. all of these

128. Which of the following is the best method for representing a weak entity in a relational schema? A. include the weak entity in the table for the owner entity B. create a table for the weak entity itself by mapping its own attributes to columns C. create tables for the strong entity and the weak entity, and another table for their relationship D. create a table for the strong entity and one for the weak entity, but include the primary key of the owner in the weak entity table

D. create a table for the strong entity and one for the weak entity, but include the primary key of the owner in the weak entity table

135. Column constraints are also called _________ constraints because they are defined on the same line as the column.

In-line

144. A single ER diagram can be mapped to several different logical models

TRUE

145. A solution to mapping unions is to create a surrogate key that will be the primary key of the union.

TRUE

146. A star schema consists of a fact table and dimension tables.

TRUE

147. A temporal database is one that includes some representation of time.

TRUE

148. Although the E-R model is sufficient to represent data needs for traditional applications in business, it is not semantically rich enough to model the more complex environments used for more advanced applications.

TRUE

152. DML commands can be embedded within a program in a host language.

TRUE

153. In the example EE-R diagram (Figure 3.22) the Trainer and Jockey have a common subset, consisting of people who fit into both specializations, called TrainerJockey.

TRUE

154. In the Hadoop Distributed File System, data can be represented using (key, value) pairs.

TRUE

155. In the hierarchical model, relationships are represented by relative placement of nodes in a tree.

TRUE

157. In the relational model, a view can be a subset of a base table.

TRUE

158. In the relational model, each row is called a tuple.

TRUE

159. In the sample database which includes the following tables: Student, Faculty, Class, and Enroll, the Enroll table represents the relationship between the Student and Class.

TRUE

161. NoSQL systems are designed to provide real-time query processing.

TRUE

166. SQL includes a data definition language and a data manipulation language.

TRUE

171. The SQL language can be used for creating and manipulating object-relational databases.

TRUE

172. The use of punched cards in data processing was inspired by their use in looms for weaving.

TRUE

175. Unified Modeling Language (UML) was originally developed as a modeling language for software engineering.

TRUE

176. VARCHAR2 is an Oracle data type that stores varying lengths of strings.

TRUE

140. The relational model is based on the concept of a relation, which is physically represented as a _______ or two-dimensional array.

Table

18. Database access by two or more users at the same time is described as A. concurrent B. independent C. dependent D. serial

A. concurrent

23. Having multiple copies of the same data is called A. data redundancy B. data integrity C. data consistency D. data standards

A. data redundancy

74. Logical data independence refers the immunity of the A. external model to changes in the logical model B. logical model to changes in the internal model C. internal model to changes in the physical model D. logical model to changes in the conceptual model

A. external model to changes in the logical model

80. On the logical level, the data about data is described as A. metadata B. data instances C. the miniworld D. enterprise data

A. metadata

20. Faster development of new applications is often possible in a database environment because A. no file creation phase is needed B. new applications are independent of old ones C. no program planning is required D. the database administrator does all programming

A. no file creation phase is needed

87. The base tables in a relational database correspond to which level in the standard three-level database architecture? A. the external level B. the logical level C. the internal level D. the conceptual level

B. the logical level

16. Data consistency means A. all users see exactly the same data B. all data is shared C. all occurrences of the same data item agree D. there is no redundancy of data

C. all occurrences of the same data item agree

60. In the EE-R model, if a specialization uses the same attribute in the defining predicate for a specialization, it is called A. user-defined B. predicate-defined C. attribute-defined D. exhaustive

C. attribute-defined

63. In the EE-R model, if subclass membership can be determined by examining a condition for each subclass, we describe the specialization as A. relation-defined B. conditional C. predicate-defined D. complete

C. predicate-defined

70. In the relational model, the integrity rules that states that a foreign key must match a value in the home relation or be completely null is A. entity integrity B. referential integrity C. domain integrity D. relational integrity

B. referential integrity

13. An attribute or set of attributes used for accessing records, but whose values are not unique is called a A. candidate key B. secondary key C. superkey D. primary key

B. secondary key

61. In the EE-R model, if an entity set is a subclass of two or more superclasses, it is called a(n) A. aggregation B. shared subclass C. union D. dependent subclass

B. shared subclass

64. In the EE-R model, the process of identifying subsets of existing entity set is called A. generalization B. specialization C. abstraction D. aggregation

B. specialization

88. The boundary between the DBMS and the operating system in a database environment is called the A. user interface B. stored record interface C. logical record interface D. physical record interface

B. stored record interface

4. A relational database stores data in the form of A. objects B. tables C. indexes D. windows

B. tables

25. If a sequence called stuId_seq has already been created and used to insert records into the Student table, and we want to insert a new record, incrementing the value of the sequence, we write A. INSERT INTO Student VALUES(stuId_seq.CURRVAL,&hellip;); B. INSERT INTO Student VALUES(stuId_seq.NEXTVAL,&hellip;); C. INSERT INTO Student VALUES(CURRVAL(stuId_seq),&hellip;); D. INSERT INTO Student VALUES(NEXTVAL(stuId_seq),&hellip;);

B. INSERT INTO Student VALUES(stuId_seq.NEXTVAL,&hellip;);

51. In the E-R model, if a relationship R is ternary, it means A. every entity in one entity set is related to three entities in another entity set B. R is a relationship among three entity sets C. R is a recursive relationship D. R must have three descriptive attributes of its own

B. R is a relationship among three entity sets

37. In an EE-R diagram, a total specialization is indicated by A. the letter t in the specialization circle B. a double line connecting the circle to the superclass C. a single line connecting the circle to the superclass D. a double arrow to the circle

B. a double line connecting the circle to the superclass

93. The data stored in the database at any given moment is called A. a user view of the database B. an extension of the database C. an intension of the database D. an evolution of the database

B. an extension of the database

55. In the E-R model, the number of entities that can map to one another under a relationship is called the A. degree of the relationship B. cardinality of the relationship C. order of the relationship D. descriptor of the relationship

B. cardinality of the relationship

91. The data model level that an E-R diagram best describes is the A. external B. conceptual C. physical D. internal

B. conceptual

79. On an E-R diagram, the symbol that shows the relationship between a weak entity and its associated strong entity is a(n) A. oval B. double diamond C. double rectangle D. double oval

B. double diamond

58. In the E-R model, which of the following is true about weak entities</div>{ A. every existence dependent entity is weak B. every weak entity is an existent dependent C. every weak entity has an attribute called a discriminator D. every existence dependent entity is missing a key

B. every weak entity is an existent dependent

48. In the E-R model, all the entity instances that belong to an entity set at a given moment form the A. intension B. extension C. domain D. range

B. extension

1. A data dictionary that is part of the DBMS is described as A. freestanding B. integrated C. compound D. user-friendly

B. integrated

82. Since database data items are stored in compatible formats and logical connections among them are also stored, we describe database data as A. independent B. integrated C. redundant D. isolated

B. integrated

12. All the entity instances that fulfill the definition at the moment form the _______ of the entity. A. entity set B. intension C. record D. extension

B. intension

3. A data model that can handle complex data such as that needed for multimedia is the A. relational B. object-oriented C. network D. hierarchical

B. object-oriented

29. In a business, if a department can have many workers, but each worker belongs to only one department, the cardinality of the department-to-worker relationship is A. one-to-one B. one-to-many C. many-to-one D. many-to-many

B. one-to-many

34. In an E-R diagram, a single line between an entity set rectangle and a relationship diamond indicates what participation constraint? A. total participation B. partial participation C. complete participation D. no participation

B. partial participation

2. A data manipulation language in which the user tells the system how to manipulate the data is said to be A. graphical B. procedural C. natural D. declarative

B. procedural

21. For a relational view to be updatable, which of the following must be true? A. the view must have all the same attributes as the base table it is defined on B. the view table itself must be permanently stored C. the view must contain the primary key of the base table it is defined on D. all of these must be true

C. the view must contain the primary key of the

84. Software engineering tools that can be used in designing the data model include</div>{ A. SE maps B. trees C. spreadsheets D. CASE tools

D. CASE tools

95. The entity-relationship model was proposed by A. Bachman B. Codd C. Peterlee D. Chen

D. Chen

99. The person who designs, creates, and manages the database is the A. end user B. sophisticated user C. DBMS D. DBA

D. DBA

89. The Census Bureau employee who proposed the use of punched cards for data storage was A. Thomas Watson B. Thomas Edison C. John von Neumann D. Herman Hollerith

D. Herman Hollerith

11. All of the following used the relational data model EXCEPT A. System R B. Ingres C. Oracle D. IDS

D. IDS

66. In the relational model, a view can be used A. in the FROM line of an SQL query B. in the INTO line in an SQL INSERT command C. as the basis of a derived view D. all of these

D. all of these

77. On an E-R diagram using (min,max) notation, if the line from the entity set Employee to the relationship Assign has (0,M) it indicates A. every employee has exactly 1 assignment B. every employee has at least 1 assignments, but can have multiple assignments C. an employee may or may not have an assignment, but has at most 1 D. an employee may or may not have an assignment, but can have multiple assignments

D. an employee may or may not have an assignment, but can have multiple assignments

86. The actual tables in the schema for a relational database, the logical-level tables, are called _______. A. views B. queries C. files D. base-tables

D. base-tables

43. In SQL, when creating a view, columns from the original table can be A. renamed, but not reordered B. reordered, but not renamed C. neither renamed nor reordered D. both renamed and reordered

D. both renamed and reordered

6. All of the following are examples of constraints on relations in the relational model EXCEPT A. referential integrity B. entity integrity C. domain constraints D. boundary constraints

D. boundary constraints

35. In an E-R diagram, lines are used for all these connections EXCEPT A. attribute to entity B. entity to relationship C. attribute to relationship D. entity to entity

D. entity to entity

85. Systems that use natural language are referred to as A. declarative B. graphical C. fourth-generation D. fifth-generation

D. fifth-generation

76. Of the following types of keys, the one that does not appear in the Entity-Relational model is A. superkey B. candidate key C. primary key D. foreign key

D. foreign key

26. If complex data types and methods are added to a relational model, we categorize it as A. semantic B. object-oriented C. functional D. object-relational

D. object-relational

30. In a database system, a question such as 'Find the names of all students who take class ENG210' is called a A. report B. form C. statement D. query

D. query

59. In the EE-R model, a collection of superclasses with a subclass such that each member of it belongs to only one of them is called a A. group B. generalization C. consolidation D. union

D. union


Kaugnay na mga set ng pag-aaral

The Family: Chapter 2 the Family in History

View Set

Managerial Accounting, 4e (Whitecotton) Chapter 3 Process Costing

View Set

Quiz 8 covers Lecture 12 Blood Vessels and Blood Pressure.

View Set