BUS 112 practice quiz questions

Choose the correct answer. A customer may generate many invoices; each invoice is generated by one customer. a) 1:M relation b) none of these c) M:N relation d) 1:1 relation

1:M relation

The PRODUCT of STUDENT table and INSTRUCTOR table will produce a table with a) 10 rows b) 6 rows c) 24 rows d) 4 rows

24 rows - multiply the number of students by instructors: 6*4=24

A recursive join is joining a table to itself. true or false?

true

Choose the correct answer. An academic department is chaired by one professor; a professor may chair only one academic department. a) none of these b) 1:M relation c) 1:1 relation d) M:N relation

1:1 relationship

Table A has 9 records and 5 attributes. Table B has 5 records and 6 attributes. When a CROSS JOIN is performed between A and B, how many records would the resultant set have? a) 54 b) 81 c) 45 d) 30

45 - asking for records: 9*5= 45

A ____ consists of a group of programs that manipulate the database and provide an interface between the database and its users and other application programs. a) DBMS b) Referential Integrity c) data model d) ERD

DBMS

A student may have earned many degrees; a degree may have been earned by many students. a) 1:1 relation b) M:N relation c) none of these d) 1:M relation

M:N relation

Consider an entity called EMPLOYEE. An EMPLOYEE may manage many EMPLOYEEs, and each EMPLOYEE is managed by one EMPLOYEE. This is an example of ____. a) Binary relationship b) composite relationship c) derived relationship d) recursive relationship

Recursive relationship - can also be unary relationship

A relation is in 1NF if it doesn't contain any ____________. a) functional dependencies b) repeating groups c) partial dependencies d) null values in primary key fields

Repeating groups

Which join retrieves all the rows from both the tables that satisfy the join condition along with the unmatched rows of the right table? a) inner join b) full outer join c) right outer join d) left outer join

Right Outer Join

A table is in 2NF if the table is in 1NF and what other condition is met? a) all primary keys are identified b) there are no multivalued attributes c)there are no repeating groups d) there are no partial dependencies

There are no partial dependencies

The attribute WAGE is calculated from multiplying HOURLY_RATE with HOURS_WORKED. The attribute WAGE is ____. a) strong attribute b) derived attribute c)composite attribute d) multi-valued attribute

derived attribute

For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute. a) schema b) set c) domain d) relation

domain

In which normal form, a multivalued attribute is converted to individual attributes? a) fourth b) third c) first d) second

first

The method of joining tables so that the result includes unmatched rows of both tables is called ____. a) full outer join b) right join c) left join d) natural

full outer join

Which join returns all records from the left table, and the matched records from the right table? a) natural join b) right outer join c) inner join d) left outer join

left outer join

Which one is the natural join of the following tables?

only includes the items that connects the tables together//the common value

Which key consists of an attribute or combination of attributes that uniquely identifies a row? a) fundamental key b) original key c) primary key d) composite key

primary key

A foreign key is used to maintain ___________. a) referential integrity b) uniqueness of record c) null value in the field d) none of the above

referential integrity

A ____ is a database model that describes data in which all data elements are placed in two-dimensional tables, called relations. a) relational model b) temporal mode c) flat file d) schema

relational model

_______is logical grouping of database objects, such as tables, indexes, views, and queries that are related to each other. a) schema b) ERD c) SQL d) Entity

schema

For a weak entity to be meaningful, it must be associated with another entity, called ___. a) conditional entity b) derived entity c) composite entity d) strong entity

strong entity

CROSS JOIN returns the Cartesian product of rows from tables in the join. In other words, it will produce rows which combine each row from the first table with each row from the second table. true or false?

true

Natural join eliminates duplicate columns in the resulting set after join is performed. true or false?

true

In order to perform a join between two tables, there must be a common attribute among those two tables. true or false?

False

Relational databases are suitable for storing unstructured data. true or false?

False

_____ is a process for evaluating and correcting table structures to minimize data redundancies, thereby reducing the likelihood of data anomalies. a) normalization b) referential integrity c) denormalization d) ERM

Normalization

A DOCTOR writes one or more PRESCRIPTIONs. A PATIENT may receive one or more PRESCRIPTIONs. This is an example of ____. a) recursive relationship b) unary relationship c) ternary relationship d) binary relationship

Ternary relationship

Which of the following is true about strong entity? a) strong entity must have composite keys b) there is only one strong entity that entirely characterizes a DMBS c) an entity that is existence dependent on some other entity d) an entity that is not existence dependent on some other entity type

an entity that is not existence dependent on some entity type

M:N relationships in a relational model are implemented by using a _____ entity. a) conditional b) composite c) strong d) fundamental

composite