Unit 1 MC
In a one-to-many relationship, what is the entity on the one side of a relationship sometimes called? A. Child B. Instance C. Parent D. Subtype
A
What is the command to remove rows from a table 'CUSTOMER'? A. DELETE FROM CUSTOMER WHERE ... B. DROP FROM CUSTOMER ... C. REMOVE FROM CUSTOMER ... D.UPDATE FROM CUSTOMER ...
A
What Database product was an early implementation of the relational model developed by E.F. Codd of IBM? A. IDMB B. DB2 C. dBase-C D. MS Access
B
What is the purpose of the SQL WHERE clause? A. filters the column data that are returned. B. filters the row data that are returned. C. Both A and B are correct. D. Neither A nor B are correct.
B
What term is used for an actual occurrence of an associated generalized Entity Type? A. Example B. Instance C. Occurrence D. Subtype
B
What term refers to something that can be identified in the users' work environment, something that the users want to track? A. Attribute B. Entity Type C. Identifier D. Relationship
B
An RDBMS contains a description of its own structure, what is this characteristic of a database called? A. documented B. metadata enhanced C. self-describing D. structure bound
C
The Database Management System (DBMS) acts as an interface between what two components of an enterprise-class database system? A. Database application and the database B. Data and the database C. The user and the database application D. Database application and SQL
C
A recursive relationship is a relationship between an entity and what? A. an attribute B. an instance C. another entity D. itself
D
What entity type cannot exist in the database unless another type of entity also exists in the database and requires that the identifier of that other entity be included as part of its own identifier? A. Dependent entity B. Strong entity C. Weak entity D. Both A and C E. All of the above.
D
What is an application called where only one user can access the database at a given time? A. data mining database application B. e-commerce database application C. multiuser database application D. single-user database application
D
Which of the following is NOT generally considered a component of a database management system (DBMS)? A. Client software B. Data Access Language C. Data D. Network
D
