CPT 242 Databases Final Exam

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