Quiz
Data Management
This quiz has a time limit, so it opens in the usual player.
Questions in this quiz (16)
1[blank_start]Entity integrity[blank_end] describes a condition in which all of the tuples within a table are uniquely identified by their [blank_start]primary key[blank_end].
- AEntity integrity
- BRelational integrity
- CDistinct Values
- Dprimary key
- Esecondary key
- Frelational key
2[blank_start]Referential integrity[blank_end] describes a condition in which a foreign key has a match in the corresponding table or in which the foreign key value is [blank_start]null[blank_end].
- AReferential integrity
- BDatabase integrity
- CEntity integrity
- Dnull
- Ezero
- Fgreater than one
3Entity integrity and relational integrity are important in a database because they are the basis for expressing and implementing relationships in the entity relationship model.
- ATrue
- BFalse
4What are the requirements that two relations must satisfy to be considered union-compatible?
- ABoth must have the same number of attributes (columns)
- BBoth must have the same attribute (column) names
- CBoth must have the same attribute data types
- DCorresponding attributes (columns) must have the same domain
5Which relational algebra operators can be applied to a pair of tables that are not union-compatible?
- APRODUCT
- BPROJECT
- CDIVIDE
- DINTERSECT
- EJOIN
6In relational algebra, the [blank_start]SELECT[blank_end] relational set operator is denoted by the lowercase Greek letter sigma (σ)
- ASELECT
- BPROJECT
- CDIVIDE
- DJOIN
7In relational algebra, the relational set operator [blank_start]PROJECT[blank_end] is denoted by the Greek letter pi (π).
- APROJECT
- BSELECT
- CBASE
- DJOIN
8[blank_start]Homonyms[blank_end] appear when more than one attribute has the same name.
- AHomonyms
- BSynonyms
9[blank_start]Synonyms[blank_end] exist when the same attribute has more than one name.
- ASynonyms
- BHomonyms
10A set of instructions generated at application compilation time that is created and managed by a DBMS.
- Aaccess plan
- Busage diagram
- Cmerge plan
11[blank_start]_____[blank_end] is a process or set of operations in a calculation.
- AAlgorithm
12A(n) [blank_start]alias[blank_end] is a(n) alternative name for a column or table in a SQL statement.
- Aalias
13The [blank_start]ALTER TABLE[blank_end] SQL command is used to make changes to table structure. When the command is followed by a keyword (ADD or MODIFY), it adds a column or changes column characteristics.
- AALTER TABLE
14The [blank_start]AND[blank_end] SQL logical operator is used to link multiple conditional expressions in a WHERE or HAVING clause. It requires that all conditional expressions evaluate to true.
- AAND
15In DB2, a(n) [blank_start]AREA[blank_end] is a named section of permanent storage space that is reserved to store the database.
- AAREA
16An entity designed to transform an M:N relationship into two 1:M relationships. The composite entity's primary key comprises at least the primary keys of the entities that it connects. Also known as a bridge entity or associative entity. See also linking table.
- AAssociative entity
- BRelational entity
- CComposite entity
- DBridge entity
- ELinking table
Information
- Description
- Information Technology Quiz on Data Management, created by Jason Shanks on 07/03/2021.
- Author
- Jason Shanks
- Language
- English
- Views
- 0
- Tags
- Rating
- No ratings yet Rate this quiz