Quiz
Chapter 3 (Multiple Choice) CIS 3365
Questions in this quiz (41)
11) _______ logic, used extensively in mathematics, provides a framework in which an assertion (statement of fact) can be verified as either true or false.
- AA) Predicate
- BB) Database
- CC) Relational
- DD) Index
22) The relational database model enables you to view data _____ rather than ____.
- AA) relationally, hierarchically
- BB) hierarchically, relationally
- CC) physically, logically
- DD) logically, physically
33) The relational model's creator, E.F. Codd, used the term relation as a synonym for ____.
- AA) index
- BB) key
- CC) table
- DD) relationship
44) A(n) _____ is perceived as a two-dimensional structure composed of rows and columns.
- AA) table
- BB) rowset
- CC) attribute
- DD) intersection
55) Date attributes contain calendar dates stored in a special format known as the _____ date format.
- AA) Epoch
- BB) Calendar
- CC) Julian
- DD) Logical
66) ________ data can have only a true or false (yes or no) condition.
- AA) Logical
- BB) Chatacyer
- CC) Date
- DD) Numeric
77) In the relational model, _____ are important because they are used to ensure that each row in a table is uniquely identifiable.
- AA) relations
- BB) keys
- CC) indexes
- DD) logical structures
88) In the context of a database table, the statement "A ______ B" indicates that if you know the value of attribute A, you can look up the value of attribute B.
- AA) contains
- BB) is related to
- CC) owns
- DD) determines
99) The attribute B is _____ the attribute A if each value in column A determines one and only one value in column B.
- AA) logically dependent on
- BB) owned by
- CC) determined by
- DD) functionally dependent on
1010) Any attribute that is part of a key is known as a _____.
- AA) key attribute
- BB) logical attribute
- CC) key determiner
- DD) selector
1111) If the attribute (B) is functionally dependent on a composite key (A) but not on any subset of that _____ key, the attribute (B) is fully functionally dependent on (A).
- AA) foreign
- BB) unique
- CC) composite
- DD) complete
1212) A _____ is nay key that uniquely identifies each row.
- AA) superkey
- BB) special
- CC) selective
- DD) candidate
1313) No data entry at all is known as a(n) _______.
- AA) nil
- BB) null
- CC) empty
- DD) Zero
1414) Controlled _____ makes a relational database work.
- AA) relations
- BB) logic
- CC) chaos
- DD) redundancy
1515) Referential _____ means that if the foreign key contains a value, that value refers to an existing valid tuple (row) in another relation.
- AA) integrity
- BB) uniqueness
- CC) direction
- DD) Relations
1616) A _____ key is defined as a key that is used strictly for data retrieval purposes.
- AA) lookup
- BB_ foreign
- CC) candidate
- DD) Secondary
1717) A _____ key can be described as a super key without unnecessary attributes, that is, a minimal super key.
- AA) secondary
- BB) candidate
- CC) primary
- DD) Foreign
1818) All primary key entries are unique, and no part of a primary key may be _____.
- AA) zero
- BB) a foreign key
- CC) null
- DD) a candidate key
1919) A CUSTOMER table's primary key is CUS_CODE. The CUSTOMER primary key column has no null entries, and all entries are unique. This is an example of ______ integrity.
- AA) entity
- BB) referential
- CC) complete
- DD) Null
2020) The ______ constraint can be placed on a column to ensure that every row in the table has a value for that column.
- AA) HAS VALUE
- BB) NOT NULL
- CC) MUST HAVE VALUE
- DD) NOT EMPTY
2121) To be considered minimally relational, the DBMS must support the key relational operators _______, PROJECT, and JOIN.
- AA) INTERSECT
- BB) UNION
- CC) DIFFERENCE
- DD) SELECT
2222) ______, also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition.
- AA) INTERSECT
- BB) UNION
- CC) DIFFERENCE
- DD) SELECT
2322) ________ yields a vertical subset of a table.
- AA) PROJECT
- BB) SELECT
- CC) UNION
- DD) DIFFERENCE
2424) _______ combines all rows from two tables, excluding duplicate rows.
- AA) INTERSECT
- BB) UNION
- CC) DIFFERENCE
- DD) SELECT
2525) __________ yields only the rows that appear in both tables
- AA) INTERSECT
- BB) UNION
- CC) DIFFERENCE
- DD) SELECT
2626) A(n) ________ join links tables by selecting only the rows with common values in their common attribute(s).
- AA) equal
- BB) unique
- CC) foreign
- DD) natural
2727) The equijoin takes its name from the comparison operator ______ used in the condition.
- AA) *
- BB) <
- CC) =
- DD) >
2828) In an outer join, the matched pairs would be retained and any unmatched values in the other table would be left ______.
- AA) in another table
- BB) null
- CC) out of the results
- DD) with matching values from the original table
2929) A(n) __________ join only returns matched records from the tables that are being joined.
- AA) outer
- BB) inner
- CC) direct
- DD) union
3030) A ______ contains at least all of the attribute names and characteristics for each table in the system.
- AA) data dictionary
- BB) relational schema
- CC) logical schema
- DD) join
3131) The ______ is actually a system-created database whose tables store the user/designer-created database characteristics and contents.
- AA) meta dictionary
- BB) schema
- CC) dictionary
- DD) system catalog
3232) In a database context, the word ______ indicates the use of the same attribute name to label different attributes.
- AA) redundancy
- BB) homonym
- CC) duplicate
- DD) synonym
3333) In a database context, a(n) ________ indicates the use of different names to describe the same attribute.
- AA) entity
- BB) duplicate
- CC) synonym
- DD) homonym
3434) The _____ relational type is the "relational model ideal."
- AA) 1:1
- BB) 1:M
- CC) M:1
- DD) M:N
3535) The ______ relationship should be rare in any relational database design.
- AA) 1:1
- BB) 1:M
- CC) M:1
- DD) M:N
3636) Since it is used to link 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.
- AA) composite
- BB) super
- CC) primary
- DD) unique
3737) Another name for a composite entity is a ______ entity.
- AA) bridge
- BB) linked
- CC) directive
- DD) referring
3838) A(n) _________ is an ordered arrangement of keys and pointers.
- AA) table
- BB) superkey
- CC) relationship
- DD) index
3939) When you define a table's primary key, the DBMS automatically creates a(n) ______ index on the primary key column(s) you declared.
- AA) key
- BB) incomplete
- CC) unique
- DD) primary
4040) Codd's Rule of _____ states: Application programs and ad hoc facilities are logically unaffected when changes are made to the table structures that preserve the original table values (changing order of columns or inserting columns).
- AA) Nonsubversion
- BB) Logical Data Independence
- CC) Comprehensive Data Sublanguage
- DD) Integrity Independence
4141) Codd's Rule of ________ states: If the system supports low-level access to the data, users must not be allowed to bypass the integrity rules of the database.
- AA) Nonsubversion
- BB) Logical Data Independence
- CC) Comprehensive Data Sublanguage
- DD) Integrity Independence
Information
- Description
- asdf Quiz on Chapter 3 (Multiple Choice) CIS 3365, created by . . on 31/08/2016.
- Author
- . .
- Language
- English
- Views
- 853
- Tags
- Rating
- 5.0 out of 5 · 1 rating Rate this quiz