CSCI 225 TEST 1

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

b. B) The resulting foreign key cannot have null (empty) values

"If a 1:M relationship is mandatory on the 1 side and optional on the M side, which of the following is true?" Select one: a. A) The resulting foreign key can have null (empty) values b. B) The resulting foreign key cannot have null (empty) values c. C) The resulting foreign key must have null (empty) values d. D) No foreign key is created as a result of mapping such a relationship

c. A) 0

"If a 1:M relationship is optional on the M side and mandatory on the 1 side, and if the table resulting from the 1 side has 3 records, then the table resulting from the M side CANNOT have less than ________ records."Select one: a. B) 1 b. C) 2 c. A) 0 d. D) 3

b. C) 3

"If an M:N relationship is mandatory on one side and optional on the other side, and if both relations resulting from the entities involved in the relationship each have 3 records, then the resulting bridge relation cannot have less than ________ records." Select one: a. A) 0 b. C) 3 c. D) 9 d. B) 1

b. A) 0

"If an M:N relationship is optional on both sides, and if both relations resulting from the entities involved in the relationship each have 3 records, then the resulting bridge relation cannot have less than ________ records." Select one: a. D) 9 b. A) 0 c. B) 1 d. C) 3

False

"When an entity has multiple unique attributes, each one of them is mapped as a primary key of the resulting relation." Select one: True False

False

A DBMS is a presentation software (such as MS Power Point). Select one: True False

a. Unique attribute

A candidate key is an attribute that is Select one: a. Unique attribute b. Composite attribute c. Multivalued attribute d. Primary key

False

A foreign key column must have the same name as the primary key column it refers to. Select one: True False Feedback

a. Identifying relationship

A multivalued composite attribute can be used to depict which of the following weak entity concepts? Select one: a. Identifying relationship b. A regular (non-identifying) one-to-many relationship between a weak entity and a regular entity c.Partially unique attribute d. A regular (non-identifying) many-to-many relationship between a weak entity and a regular entity

d. Unique attribute

A regular entity must have at least one of the following attributes: Select one: a. Multivalued attribute b. Derived attribute c. Composite attribute d. Unique attribute

True

A relational schema is a visual depiction of the relational database model. Select one: True False

True

A restriction specifying that no salary entered in the salary column can be higher than $300,000 is an example of a business rule." Select one: True False

d.Weak entity with two owners

An M:N relationship that can have multiple occurrences between the same instances of involved entities can be depicted as a: Select one: a. Multivalued composite attribute b. Unary M:N relationship c.Weak entity with one owner d.Weak entity with two owners

a. C) 3

An entity with two multivalued attributes will be mapped as how many relations? Select one: a. C) 3 b. A) 1 c. D) 4 d. B) 2

False

An optional attribute occurs only in an entity that is involved in a relationship with optional participation. Select one: True False

False

An optional attribute of an entity is not mapped as a column of a relation. Select one: True False

c. C) Enables automatic generation of consecutive numeric data values in a column

Autonumber data type option: Select one: a. B) Assigns a number to each of the used data types b. D) Enables automatic counting of columns in a table c. C) Enables automatic generation of consecutive numeric data values in a column d. A) Automatically converts the existing data type into a number type Feedback

c. all of the above

DBMS is software used for the following purpose: Select one: a.Insertion, storage, retrieval, update, and deletion of the data in the database b.Maintenance of databases c. all of the above d. Creation of databases

False

ER modeling is a widely used logical database modeling method. Select one: True False

False

Each weak entity has one owner entity. Select one: True False

False

Every ER notation uses the same rule for placement of cardinality constraints in the relationships of the ER diagram. Select one: True False

d. Metadata

FirstName is an example of Select one: a. Data b. Data Type c. DBMS d. Metadata

False

For each employee middle initial is optional is an example of an implicit database constraint. Select one: True False

b. indirect use

Front-end applications facilitate Select one: a. Direct use b. Indirect use c. Both direct and indirect use d. Neither direct nor indirect use

c. D) 3

If a 1:M relationship is mandatory on both sides, and if the table resulting from the 1 side has 3 records, then the table resulting from the M side CANNOT have less than ________ records." Select one: a. A) 0 b. C) 2 c. D) 3 d. B) 1

a. A) The resulting foreign key can have null (empty) values

If a 1:M relationship is optional on both sides, which of the following is true?" Select one: a. A) The resulting foreign key can have null (empty) values b. C) The resulting foreign key must have null (empty) values c. D) No foreign key is created as a result of mapping such a relationship d. B) The resulting foreign key cannot have null (empty) values

d. C) 3

If an M:N relationship is mandatory on both sides, and if both relations resulting from the entities involved in the relationship each have 3 records, then the resulting bridge relation cannot have less than ________ records." Select one: a. B) 1 b. D) 9 c. A) 0 d. C) 3

c. implicit changes of requirements are not permitted

Implicit changes of requirements are permitted during: Select one: a. Database use b. Logical modeling c. Implicit changes of requirements are not permitted d. Database deployment

a. Data

Joe is an example of: Select one: a. Data b. Data Type c. DBMS d. Metadata

b. One or many

Maximum cardinality can be: Select one: a. Optional or many b. One or many c. Zero or many d. Optional or mandatory

False

Minimum cardinality can be many. Select one: True False

d. Optional or mandatory

Minimum cardinality can be: Select one: a. Optional or many b. Zero or many c. One or many d. Optional or mandatory

b. D) Table

Relation is a synonym for Select one: a. B) Field b. D) Table c. A) Column d. C) Row Feedback

d. Metadata

The description of the structure and the properties of the data fits into which category? Select one: a. Information b. Data c. DBMS d. Metadata

b. B) Composite attribute

The following attribute represents a collection of attributes: Select one: a. D) Derived attribute b. B) Composite attribute c. C) Multivalued attribute d. A) Unique attribute

False

The logical database model is created prior to the conceptual database model. Select one: True False

a. D) Derived attribute

The values of the following attribute are NOT permanently stored in a database. Select one: a. D) Derived attribute b. C) Multivalued attribute c. A) Unique attribute d. B) Composite attribute Feedback

a. C) Row

Tuple is a synonym for Select one: a. C) Row b. A) Column c. B) Field d. D) Table

False

Two columns of a relational table can have the same names. Select one: True False

False

Two columns of a relational table can have the same values. Select one: True False

True

Two columns of two different tables in the same relational database can have the same names. Select one: True False

b. Typically a graphical depiction of the essential business process information.

Which of the following best describes a business model? Select one: a. An evaluation of potential business process improvements. b. Typically a graphical depiction of the essential business process information. c. A sequence of business activities. d. None of the above. Feedback

b. B) Optional zero

Which of the following is NOT a possible cardinality constraint? Select one: a. A) Optional one b. B) Optional zero c. C) Optional many d. D) Mandatory one

d. D) Two tables can have the same names

Which of the following is NOT true? In a relational database: Select one: a. B) Two tables can have the same number of columns b. A) Two tables can be a part of the same database c. C) Two tables can have the same number of rows d. D) Two tables can have the same names

b. C) Two rows can have the same values

Which of the following is NOT true? In a relational table: Select one: a. D) All values in a column are from the same domain b. C) Two rows can have the same values c. B) All column names are different d. A) Two columns can have the same values

a. modeling data

Which of the following is a database use action? Select one: a. Modeling data b. Modifying data c. Storing data d. Securing data

b. all of the above

Which of the following is a format in which data can appear? Select one: a. Image b. All of the above c. Numbers d. Text

a. Conceptual modeling

Which of the following is a part of the database requirements step? Select one: a. Conceptual modeling b. Database implementation c. Database deployment d. Logical modeling

b. A) One-to-one

Which of the following is a possible type of relationship (maximum cardinality-wise)? Select one: a. C) Zero-to-one b. A) One-to-one c. B) Zero-to-zero d. D) Zero-to-many

d. Information showing which airline routes in the United States have the most sales WW

Which of the following is an example of analytical information? Select one: a. Information about the amount of money in a checking account b. Information showing the destination and origin of a particular airline route in the United States c. Information about the cost of a product d. Information showing which airline routes in the United States have the most sales WW

D. data types

Which of the following is typically found in the database metadata? Select one: a. Product prices b. Employee names c. Student ages d. Data types

True

Within an ER diagram, each entity must be related to at least one other entity via a relationship." Select one: True False

False

Within one relation, two rows can be identical." Select one: True False

database developers

are in charge of implementing the database model as a functioning database using DBMS software


Ensembles d'études connexes

Chapter 3: Exploring Global Business

View Set

Principles of Finance- Chapter 7

View Set

高職龍騰英文 B3 (B版) L1 It's in Our Blood 單字&片語

View Set

Corporate Risk Management Exam 1

View Set

AM History Semester 2 Final Exam

View Set

CGDR- Child Growth and Development

View Set

Porth Pathophysiology Chapter 37: Disorders of Brain Function

View Set