CPT 242 Databases Final Exam
Most SQL implementations yield case-insensitive searches.
- True
- False
A _____ distributed database system will support different database management systems (DBMS) that may even support different models running under different computer systems.
- homogeneous
- fully homogeneous
- fully heterogeneous
- heterogeneous
_____ activities cover all tasks directly related to the day-to-day operations of the DBMS and its applications.
- Backup and recovery
- System support
- Performance monitoring and tuning
- Security auditing and monitoring
Distribution transparency is supported by a distributed data dictionary.
- True – correct
- False
The DBA is responsible for ensuring that the data are distributed to the right persons, at the right time, and in the right format.
- True
- False
A database management system (DBMS) must have validation, transformation, and mapping functions, as well as other functions, in order to be classified as distributed.
- True
- False
Within a specialization hierarchy, every subtype can have _____ supertype(s) to which it is directly related.
- one or many
- zero
- only one
- many
correct
See: Ch. 5: Advanced Data Modeling, Section – 5-1b Specialization Hierarchy
The _____ command restricts the selection of grouped rows based on a condition.
- HAVING
- DISPLAY
- CONVERT
- FROM
correct
See: Ch. 7: Introduction to Structured Query Language (SQL), Section – 7-1 Introduction to SQL
Distributed data access was needed to support geographically dispersed business units.
- True
- False
correct
See: Ch. 12: Distributed Database Management Systems, Section – 12-1 The Evolution of Distributed Database Management Systems
Distributed database systems do not require complex mechanisms to manage transactions and ensure the database’s consistency and integrity.
- True
- False
correct
See: Ch. 12: Distributed Database Management Systems, Section – 12-9 Transaction Transparency
A(n)_____ is a generic entity type that is related to one or more entity subtypes.
- subtype discriminator
- specialization hierarchy
- inheritance
- entity supertype
correct
See: Ch. 5: Advanced Data Modeling, Section – 5-1a Entity Supertypes and Subtypes
A distributed database management system (DDBMS) must be communications-media-dependent.
- True
- False
correct
See: Ch. 12: Distributed Database Management Systems, Section – 12-5 DDBMS Components
The DBA interacts with the end user by providing data and information support services to the organization’s departments.
- True
- False
correct
See: Ch. 16: Database Administration and Security, Section – 16-5a The DBA’s Managerial Role
_____ fragmentation refers to the division of a relation into attribute subsets.
- Vertical
- Mixed
- Horizontal
- Data
correct
See: Ch. 12: Distributed Database Management Systems, Section – 12-11a Data Fragmentation
Which of the following is a specialization hierarchy overlapping constraint scenario in case of partial completeness?
- Subtype discriminators cannot be null.
- Subtype sets are unique.
- Supertype has optional subtypes.
- Subtype does not have a supertype.
correct
See: Ch. 5: Advanced Data Modeling, Section – 5-1f Completeness Constraint
The DBA must supervise the installation of all software and hardware designated to support the data administration strategy.
- True
- False
correct
See: Ch. 16: Database Administration and Security, Section – 16-5b The DBA’s Technical Role
All SQL commands must be issued on a single line.
- True
- False
correct
See: Ch. 7: Introduction to Structured Query Language (SQL), Section – 7-2 Basic SELECT Queries
Performance transparency ensures that the system finds the most cost-effective path to access remote data.
- True
- False
correct
See: Ch. 12: Distributed Database Management Systems, Section – 12-7 Distributed Database Transparency Features
The default comparison condition for the subtype discriminator attribute is the _____ comparison.
- greater than
- nonequality
- equality
- less than
correct
See: Ch. 5: Advanced Data Modeling, Section – 5-1d Subtype Discriminator
Distributed processing shares a database’s logical processing among two or more physically independent sites that are connected through a network.
- True
- False
correct
See: Ch. 12: Distributed Database Management Systems, Section – 12-3 Distributed Processing and Distributed Databases
An entity supertype can have disjoint or overlapping entity subtypes.
- True
- False
correct
See: Ch. 5: Advanced Data Modeling, Section – 5-1e Disjoint and Overlapping Constraints
The most important characteristic of an entity is its _____ key, used to uniquely identify each entity instance.
- surrogate
- primary
- natural
- foreign
correct
See: Ch. 5: Advanced Data Modeling, Section – 5-3 Entity Integrity: Selecting Primary Keys
You can select partial table contents by naming the desired fields and by placing restrictions on the rows to be included in the output.
- True
- False
correct
See: Ch. 7: Introduction to Structured Query Language (SQL), Section – 7-6a Selecting Rows with Conditional Restrictions
A distributed database is composed of several parts known as database _____.
- fragments
- parts
- partitions
- sections
correct
See: Ch. 12: Distributed Database Management Systems, Section – 12-3 Distributed Processing and Distributed Databases