CSCI 225 TEST 1
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
