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