- Description
DAT 380 Wk 1 – Practice: Pre-Course Assessment Quiz
Which of the following is true of spreadsheet applications?
- They enhance the user’s ability to understand the data.
- They provide enhanced security and robust data sharing features.
- They do not allow manipulation of data once entered.
- They are a better alternative to databases.
Disjoint subtypes are subtypes that contain nonunique subsets of the supertype entity set.
- True
- False
A data dictionary is sometimes described as “the database designer’s database” because it records the design decisions about tables and their structures.
- True
- False
A weak entity has a primary key that is partially or totally derived from the parent entity in the relationship.
- True
- False
The “_____” characteristic of a primary key states that the primary key should not have embedded semantic meaning.
- nonintelligent
- unique values
- preferably single-attribute
- security-compliant
Each row in the relational table is known as an entity instance or entity occurrence in the ER model.
- True
- False
In Oracle, you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.
- True
- False
Structure is based on the type of processing to be performed on the data.
- True
- False
In the context of total completeness, in a(n) _____, every supertype occurrence is a member of at least one subtype.
- disjoint constraint
- overlapping constraint
- unique constraint
- foreign key constraint
A(n) _____ is the attribute in the supertype entity that determines to which entity subtype each supertype occurrence is related.
- subtype discriminator
- entity supertype
- specialization hierarchy
- inheritance discriminator
The tables on which a view, or a virtual table derived from a SELECT query, are based are called _____ tables.
- indexed
- core
- base
- relation
One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions.
- True
- False
A _____ is a character or group of characters that has a specific meaning.
- file
- record
- database
- field
To implement a small database, a database designer must know the “1” and the “M” sides of each relationship and whether the relationships are mandatory or optional.
- True
- False
Database design is a(n) _____ process based on repetition.
- linear
- sequential
- intermittent
- iterative
A system is always at some stage of SDLC because every request for structural changes requires retracing the steps of the Systems Development Life Cycle (SDLC).
- True
- False
SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT.
- True
- False
In a(n) _____ diagram, the arrows above the attributes indicate all desirable dependencies.
- Chen
- ER
- functionality
- dependency
The term “database development” is used to describe the process of database design and implementation.
- True
- False
The hierarchical data model was developed in the _____.
- 1990s
- 1960s
- 1980s
- 1970s
In the _____ model, the basic logical structure is represented as an upside-down tree.
- entity relationship
- network
- relational
- hierarchical
Each table _____ represents an attribute.
- value
- dimension
- column
- row
When the specific cardinalities are not included on the diagram in Crow’s Foot notation, cardinality is implied by the use of _____.
- tables
- images
- symbols
- attributes
The most useful feature of PL/SQL blocks is that they let a designer create code that can be named, stored, and executed by the DBMS.
- True
- False
Field refers to a collection of related records.
- True
- False