Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Each table in a relational database must have a primary key.
____________________ is another name for table space.
UNION, INTERSECT, and MINUS work properly only if relations are
union-compatible, which means that the names of the relation attributes and their data
types must be different.
A data file can only contain rows from one single table.
The transaction recovery write-ahead-log protocol ensures that transaction logs are
always written before any database data are actually updated.
Character data can contain any character or symbol intended for mathematical
manipulation.
What is a subquery? When is it used? Does the RDBMS deal with subqueries any
differently from normal queries?
The scheduler establishes the order in which the operations within concurrent
transactions are executed.
Triggers can only be used to update table values.
When an end user uses a Web browser to dynamically query a database, the client
browser actually requests a Web page.
A weak entity must be ____________________-dependent.
The SQL cache stores the end-user written SQL.
The company ____________________ describes the general conditions in which a
company operates, its organizational structure, and its mission.
All relational tables satisfy the ____________________ requirements.
What are the factors affecting the purchasing decision for DBMS software?
Distributed processing shares the database's logical processing among two or more
physically independent sites that are connected through a network.
Database connectivity software is also known as database middleware because it
interfaces between the application program and the database.
A fully distributed database management system must perform all of the functions of a
centralized DBMS. What are these functions?
The basic SQL vocabulary has fewer than ____________________ words.
What is a data cube?
