Database Final

Question 10 A(n) ____'s main function is to help you understand the complexities of the real-world environment. Question 10 options: A. constraint B. entity C. model D. database

C. model

Question 62 From a structural point of view, 2NF is better than ____. Question 62 options: A. 1NF B. 3NF C. 4NF D. BCNF

A. 1NF

Question 84 The ____ command would be used to delete the table row where the P_CODE is 'BRT-345'. Question 84 options: A. DELETE FROM PRODUCT WHERE P_CODE = 'BRT-345'; B. REMOVE FROM PRODUCT WHERE P_CODE = 'BRT-345'; C. ERASE FROM PRODUCT WHERE P_CODE = 'BRT-345'; D. ROLLBACK FROM PRODUCT WHERE P_CODE = 'BRT-345';

A. DELETE FROM PRODUCT WHERE P_CODE = 'BRT-345';

Question 5 ____ exists when different versions of the same data appear in different places. Question 5 options: A. Data inconsistency B. Data consistency C. Better data integration D. Improved decision making

A. Data inconsistency

Question 76 The SQL command that lets you insert rows into a table is ____. Question 76 options: A. INSERT B. SELECT C. COMMIT D. UPDATE

A. INSERT

Question 18 ____ logic, used extensively in mathematics, provides a framework in which an assertion (statement of fact) can be verified as either true or false. Question 18 options: A. Predicate B. Database C. Relational D. Index

A. Predicate

Question 89 Which query will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1? Question 89 options: A. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE <'1558-QW1'; B. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE = [1558-QW1] C. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE = (1558-QW1) D. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE = {1558-QW1}

A. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE <'1558-QW1';

Question 87 Which query will output the table contents when the value of V_CODE is not equal to 21344? Question 87 options: A. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <> 21344; B. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <= 21344; C. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344; D. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE => 21344;

A. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <> 21344;

Question 90 Which query will list all the rows in which the inventory stock dates occur on or after January 20, 2010? Question 90 options: A. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDATE >= '20-JAN-2010' B. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDATE >= $20-JAN-2010$ C. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDATE <= '20-JAN-2010' D. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDATE >= {20-JAN-2010}

A. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDATE >= '20-JAN-2010'

Question 8 ____ data are the result of formatting to facilitate storage, use and generation of information. Question 8 options: A. Structured B. Semistructured C. Unstructured D. Historical

A. Structured

Question 55 An entity cluster is formed by combining multiple interrelated entities into ____. Question 55 options: A. a single abstract entity object B. multiple abstract entity objects C. a single entity object D. multiple entity objects

A. a single abstract entity object

Question 72 Improving ____ leads to more flexible queries. Question 72 options: A. atomicity B. normalization C. denormalization D. derived attributes

A. atomicity

Question 40 A ____ attribute can be further subdivided to yield additional attributes. Question 40 options: A. composite B. simple C. single-valued D. multivalued

A. composite

Question 31 A ____ contains at least all of the attribute names and characteristics for each table in the system. Question 31 options: A. data dictionary B. relational schema C. logical schema D. join

A. data dictionary

Question 74 From a system functionality point of view, ____ attribute values can be calculated when they are needed to write reports or invoices. Question 74 options: A. derived B. atomic C. granular D. historical

A. derived

Question 66 Attribute A ____ attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B. Question 66 options: A. determines B. derives from C. controls D. owns

A. determines

Question 46 If an entity can exist apart from one or more related entities, it is said to be ____- independent. Question 46 options: A. existence B. relationship C. business D. weak

A. existence

Question 60 ____ keys work with primary keys to properly implement relationships in the relational model. Question 60 options: A. Foreign B. Composite C. Natural D. Surrogate

A. foreign

Question 48 The existence of a(n) ____ relationship indicates that the minimum cardinality is at least 1 for the mandatory entity. Question 48 options: A. mandatory B. optional C. multivalued D. single-valued

A. mandatory

Question 7 Most decision-support data are based on historical data obtained from ____. Question 7 options: A. operational databases B. data warehouses C. enterprise databases D. workgroup databases

A. operational databases

Question 22 A ____ is any key that uniquely identifies each row. Question 22 options: A. superkey B. special C. selective D. candidate

A. superkey

Question 49 A ____ relationship exists when an association is maintained within a single entity. Question 49 options: A. unary B. ternary C. binary D. weak

A. unary

Question 58 The "____" characteristic of a primary key states the following: The PK must uniquely identify each entity instance. A primary key must be able to guarantee unique values. It cannot contain nulls. Question 58 options: A. unique values B. nonintelligent C. preferably single-attribute D. security complaint

A. unique values

Question 33 The ____ relational type is the "relational model ideal." Question 33 options: A. 1:1 B. 1:M C. M:1 D. M:N

B. 1:M

Question 69 A table that is in 1NF and includes no partial dependencies is said to be in ____. Question 69 options: A. BCNF B. 2NF C. 3NF D. 4NF

B. 2NF

Question 70 Before converting a table into 3NF, it is imperative the table already be in ____. Question 70 options: A. 1NF B. 2NF C. 4NF D. BCNF

B. 2NF

Question 81 To delete a row from the PRODUCT table, use the ____ command. Question 81 options: A. COMMIT B. DELETE C. ERASE D. KILL

B. DELETE

Question 26 The ____ constraint can be placed on a column to ensure that every row in the table has a value for that column. Question 26 options: A. HAS VALUE B. NOT NULL C. MUST HAVE VALUE D.NOT EMPTY

B. NOT NULL

Question 77 The SQL command that lets you select attributes from rows in one or more tables is ____. Question 77 options: A. INSERT B. SELECT C. COMMIT D. UPDATE

B. SELECT

Question 78 To list all the contents of the PRODUCT table, you would use ____. Question 78 options: A. LIST * FROM PRODUCT; B. SELECT * FROM PRODUCT; C. DISPLAY * FROM PRODUCT; D. SELECT ALL FROM PRODUCT;

B. SELECT * FROM PRODUCT;

Question 88 Which query will output the table contents when the value of P_PRICE is less than or equal to 10? Question 88 options: A. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE P_PRICE <> 10; B. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE P_PRICE <= 10; C. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE P_PRICE => 10; D. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE P_PRICE = 10;

B. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE P_PRICE <= 10;

Question 28 ____ combines all rows from two tables, excluding duplicate rows. Question 28 options: A. INTERSECT B. UNION C. DIFFERENCE D. SELECT

B. UNION

Question 6 A(n) ____ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization. Question 6 options: A. desktop B. workgroup C. enterprise D. transactional

B. Workgroup

Question 4 The database structure in a DBMS is stored as a ____. Question 4 options: A. file B. collection of files C. set of key/value pairs D. collection of queries

B. collection of files

Question 43 A derived attribute is indicated in the Chen model by a ____. Question 43 options: A. single line B. dashed line C. circle D. double line

B. dashed line

Question 17 A(n) ____ enables a database administrator to define schema components. Question 17 options: A. extensible markup language (XML) B. data definition language (DDL) C. unified modeling language (UML) D. query language

B. data definition language (DDL)

Question 68 In a(n) ____ diagram, the arrows above the attributes indicate all desirable dependencies. Question 68 options: A. Chen B. dependency C. functionality D. ER

B. dependency

Question 37 Attributes may share a ____. Question 37 options: A. name B. domain C. location D. table

B. domain

Question 54 The extended entity relationship model (EERM) is sometimes referred to as the ____. Question 54 options: A. entity relationship model B. enhanced entity relationship model C. entity clustering relationship model D. extended entity relationship diagram

B. enhanced entity relationship model

Question 11 A(n) ____ is anything about which data are to be collected and stored. Question 11 options: A. attribute B. entity C. relationship D. constraint

B. entity

Question 57 The primary key's main function is to uniquely identify a(n) ____ within a table. Question 57 options: A. attribute B. entity instance or row C. entity subtype D. natural identifier

B. entity instance or row

Question 32 In a database context, the word ____ indicates the use of the same attribute name to label different attributes. Question 32 options: A. redundancy B. homonym C. duplicate D. synonym

B. homonym

Question 9 The organization of the data within the folders in a manual file system was determined by ____. Question 9 options: A. the date of creation B. its expected use C. the title of the documents in the folder D. the data processing specialist

B. its expected use

Question 20 In the relational model, ____ are important because they are used to ensure that each row in a table is uniquely identifiable. Question 20 options: A. relations B. keys C. indexes D. logical structures

B. keys

Question 56 A ____ key is a real-world, generally accepted identifier used to uniquely identify real-world objects. Question 56 options: A. primary B. natural C. foreign D. surrogate

B. natural

Question 59 The "____" characteristic of a primary key states the following: The PK should not have embedded semantic meaning. An attribute with embedded semantic meaning is probably better used as a descriptive characteristic of the entity rather than as an identifier. Question 59 options: A. unique values B. nonintelligent C. preferably single-attribute D. security compliant

B. nonintelligent

Question 30 In an outer join, the matched pairs would be retained and any unmatched values in the other table would be left ____. Question 30 options: A. in another table B. null C. out of the results D. with matching values from the original table

B. null

Question 42 A ____ should be a derived attribute. Question 42 options: A. person's name B. person's age C. person's social security number D. person's phone number

B. person's age

Question 61 Normalization works through a series of stages called normal forms. For most purposes in business database design, ____ stages are as high as you need to go in the normalization process. Question 61 options: A. two B. three C. four D. five

B. three

Question 47 A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship. Question 47 options: A. strong B. weak C. business D. relationship

B. weak

Question 71 A table that is in 2NF and contains no transitive dependencies is said to be in ____. Question 71 options: A. 1NF B. 2NF C. 3NF D. 4NF

C. 3NF

Question 75 For most business transactional databases, we should normalize relations into ____. Question 75 options: A. 1NF B. 2NF C. 3NF D. 6NF

C. 3NF

Question 2 ____ is the body of information and facts about a specific subject. Question 2 options: A. Data B. Information C. Knowledge D. A database

C. Knowledge

Question 3 ____ provide(s) a description of the data characteristics and the set of relationships that link the data found within the database. Question 3 options: A. Queries B. End-user data C. Metadata D. Information

C. Metadata

Question 83 Which of the following is used to select partial table contents? Question 83 options: A. SELECT <column(s)> FROM <Table name> BY <Conditions>; B. LIST <column(s)> FROM <Table name> BY <Conditions>; C. SELECT <column(s)> FROM <Table name> WHERE <Conditions>; D. LIST<column(s)> FROM <Table name> WHERE <Conditions>;

C. SELECT <column(s)> FROM <Table name> WHERE <Conditions>;

Question 86 Which query will output the table contents when the value of V_CODE is equal to 21344? Question 86 options: A. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <> 21344; B. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <= 21344; C. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344; D. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE => 21344;

C. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344;

Question 15 Which of the following is true of business rules? Question 15 options: A. They allow the designer to set company policies with regard to data. B. They allow the designer to develop business processes. C. They can serve as a communication tool between the users and designers. D. They provide a framework for the company's self actualization.

C. They can serve as a communication tool between the users and designers.

Question 39 A ____ identifier is composed of more than one attribute. Question 39 options: A. primary B. foreign C. composite D. domain

C. composite

Question 25 All primary key entries are unique, and no part of a primary key may be ____. Question 25 options: A. zero B. a foreign key C. null D. a candidate key

C. null

Question 34 Since it is used to link the tables that originally were related in a M:N relationship, the composite entity structure includes—as foreign keys—at least the ____ keys of the tables that are to be linked. Question 34 options: A. composite B. super C. primary D. unique

C. primary

Question 63 An attribute that is part of a key is known as a(n) ____ attribute. Question 63 options: A. important B. nonprime C. prime D. entity

C. prime

Question 12 A(n) ____ is bidirectional. Question 12 options: A. attribute B. entity C. relationship D. constraint

C. relationship

Question 16 A verb associating two nouns in a business rule translates to a(n) ____ in the data model. Question 16 options: A. entity B. attribute C. relationship D. constraint

C. relationship

Question 41 A ____ attribute can have only one value. Question 41 options: A. composite B. simple C. single-valued D. multivalued

C. single-valued

Question 85 A(n) ____ is a query that is embedded (or nested) inside another query. Question 85 options: A. alias B. operator C. subquery D. view

C. subquery

Question 19 The relational model's creator, E. F. Codd, used the term relation as a synonym for ____. Question 19 options: A. index B. key C. table D. relationship

C. table

Question 50 A ____ relationship exists when three entities are associated. Question 50 options: A. unary B. binary C. ternary D. weak

C. ternary

Question 38 In an ER diagram, primary keys are indicated by ____. Question 38 options: A. bolding B. italics C. underlining D. a special font

C. underlining

Question 13 ____ are important because they help to ensure data integrity. Question 13 options: A. Attributes B. Entities C. Relationships D. Constraints

D. Constraints

Question 65 Of the following normal forms, ____ is mostly of theoretical interest. Question 65 options: A. 1NF B. 3NF C. BCNF D. DKNF

D. DKNF

Question 1 ____ is used to reveal the meaning of data. Question 1 options: A. Raw facts B. Knowledge C. Formatting D. Information

D. Information

Question 73 The most likely data type for a surrogate key is ____. Question 73 options: A. Character B. Date C. Logical D. Numeric

D. Numeric

Question 27 ____, also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition. Question 27 options: A. INTERSECT B. UNION C. DIFFERENCE D. SELECT

D. SELECT

Question 79 The SQL command that modifies an attribute's values in one or more table's rows is ____. Question 79 options: A. INSERT B. SELECT C. COMMIT D. UPDATE

D. UPDATE

Question 80 An example of a command you would use when making changes to a PRODUCT table is ____. Question 80 options: A. CHANGE PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2'; B. ROLLBACK PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2'; C. EDIT PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2'; 22 D. UPDATE PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';

D. UPDATE PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';

Question 82 When you issue the DELETE FROM tablename command without specifying a WHERE condition, ____. Question 82 options: A. no rows will be deleted B. the first row will be deleted C. the last row will be deleted D. all rows will be deleted

D. all rows will be deleted

Question 52 The associative entity is also known as a ____ entity. Question 52 options: A. unary B. weak C. strong D. composite

D. composite

Question 36 The ERD represents the ____ database as viewed by the end user. Question 36 options: A. condensed B. physical C. logical D. conceptual

D. conceptual

Question 64 Data redundancy produces ____. Question 64 options: A. slower lookups B. robust design C. efficient storage use D. data integrity problems

D. data integrity problems

Question 21 The attribute B is ____ the attribute A if each value in column A determines one and only one value in column B. Question 21 options: A. logically dependent on B. owned by C. determined by D. functionally dependent on

D. functionally dependent on

Question 35 A(n) ____ is an ordered arrangement of keys and pointers. Question 35 options: A. table B. superkey C. relationship D. index

D. index

Question 14 Students and classes have a ____ relationship. Question 14 options: A. one-to-one B. one-to-many C. many-to-one D. many-to-many

D. many-to-many

Question 44 Knowing the ____ number of entity occurrences is very helpful at the application software level. Question 44 options: A. maximum B. minimum C. approximate D. maximum and minimum

D. maximum and minimum

Question 29 A(n) ____ join links tables by selecting only the rows with common values in their common attribute(s). Question 29 options: A. equal B. unique C. foreign D. natural

D. natural

Question 53 If Tiny College had some departments that were classified as "research only," they would not offer courses; therefore, the COURSE entity would be ____ to the DEPARTMENT entity. Question 53 options: A. existence-dependent B. independent C. weak D. optional

D. optional

Question 51 If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a ____ relationship. Question 51 options: A. self B. self-referring C. looping D. recursive

D. recursive

Question 23 Controlled ____ makes a relational database work. Question 23 options: A. relations B. logic C. chaos D. redundancy

D. redundancy

Question 67 A relational table must not contain a(n) ____. Question 67 options: A. entity B. attribute C. relationship D. repeating group

D. repeating group

Question 24 A ____ key is defined as a key that is used strictly for data retrieval purposes. Question 24 options: A. lookup B. foreign C. candidate D. secondary

D. secondary

Question 45 Another word for existence-independent is ____. Question 45 options: A. weak B. alone C. unary D. strong

D. strong