DB CS 331
True
A candidate key is an attribute, or combination of attributes, that uniquely identifies a row in a relation
False
A part object that belongs to only one whole object and lives and dies with the whole object is called composting.
True
A partial functional dependency is a functional dependency in which one or more nonkey attributes are functionally dependent on part (but not all) of the primary key.
False
A subquery in which processing the inner query depends on data from the outer query is called a codependent query
True
A transaction is the complete set of closely related update commands that must all be done, or none of them done, for the database to remain valid.
True
A transaction that requires reference to data at one or more nonlocal sites to satisfy the request is a global transaction.
True
Aggregation is a part-of relationship between a component object and an aggregate object.
True
CASE tool-generated information should be fed into repositories
True
Clustering allows for adjacent secondary memory locations to contain rows from several tables.
False
Data integrity consists of powerful operations to manipulate data stored in relations.
True
Data localization involves transforming a query into fragments that explicitly reference data at one site.
True
Data reconciliation occurs in two stages, an initial load and subsequent updates.
True
Denormalization almost always leads to more storage space for raw data.
False
Horizontal partitioning refers to the process of combining several smaller relations into a larger table.
True
JDBC is the industry standard call-level API for Java access to SQL databases
True
Joining tables or using a subquery may produce the same result.
False
Object-oriented environments and relational environments have the same navigational model for accessing persistent data.
True
Object-oriented environments typically do not have an inherent, built-in concept of boundaries between transactions.
True
One of the primary differences between the while statement and the for statement is that in addition to a conditional expression, the for statement can also include code that initializes a counter and changes its value with each iteration.
True
Replication transparency s a design goal in distributed database systems, which says that even though a data item may be replicated at several nodes throughout the network, a user may treat the data item as if it were a single data item at a single node
True
Requirements for response time, data security, backup and recovery are all requirements for physical design.
True
Serialization is not a realistic method for storing large amounts of structured data
False
Static extract is a method of capturing only the changes that have occurred in the source data since the last capture.
False
The DELETE TABLE DLL command is used to remove a table from the database.
False
The Information Resource Lexicon System (IRLS) is a computer software tool used to manage and control access to the information repository
True
The allowable range of values for a given attribute is part of the domain constraint.
False
The entity integrity rule states that a primary key attribute can be null
False
The following command would work fine:insert into budget values 121,222,111;
False
The following query totals sales in state= 'MA' for each salesperson. {Select salesperson_id, sum(sales) from salesperson group by salesperson_id having state = 'MA';}
False
The following two SQL statements will produce different results.Select last_name, first_name from customer where state = 'MA' or state = 'NY' or state = 'NJ' or state = 'NH' or state = 'CT';Select last_name, first_name from customer where state in ('MA','NY','NJ','NH','CT');
True
The major advantage of the data propagation approach to data integration is the near real-time cascading of data changes throughout the organization
False
There can be multivalued attributes in a relation
True
To keep your database from growing too large, you should choose the smallest data type possible for each field
AGGREGATE
To summarize data in a set of records, you use a family of functions called ____ functions.
True
Two-phase locking results in a growing phase where locks are acquired and a shrinking phase where locks are released
SELECT
What privilege allows the user to select records?
True
When a regular entity type contains a multivalued attribute, two relations are created.
True
When normalizing, the goal is to decompose relations with anomalies to produce smaller, well-structured relations
False
When transforming a weak entity, one should create one relation with both the attributes of the strong entity and the attributes of the weak entity.
False
With a two-phase commit strategy for synchronizing distributed data, committing a transaction is faster than if the originating location were able to work alone.
