question

An advantage of using the database approach to processing is that it facilitates consistency.

answer

True

question

A program, or collection of programs, through which users interact with a database is known as a(n) _________________________.

answer

DBMS

question

Access automatically adds double quotation marks around values in the design grid that are formatted as Short Text fields when you run the query or move the insertion point to another cell in the design grid.

answer

True

question

QBE is a visual approach to writing queries.

answer

True

question

In Access, it is common to create a table using SQL.

answer

False

question

Dropping a table also deletes any data that you entered into the table.

answer

True

question

When you connect two or more simple conditions with the AND operator, each condition must be listed on a separate line.

answer

False

question

The HAVING clause is used to restrict groups that are included in a query result.

answer

True

question

For two tables to be union compatible, the columns of the two tables must be identical.

answer

False

question

You can join three tables together but not four tables.

answer

False

question

In a one-to-many relationship, the primary key of the "many" table becomes the foreign key of the "one" table.

answer

False

question

In DBDL, you represent a table by listing all columns and then underlining the primary key.

answer

True

question

To verify that the correct change was made to data in a table, use the DISPLAY command.

answer

False

question

When necessary, include a WHERE clause into the UPDATE command to indicate the column on which the change is to take place.

answer

False

question

Additional storage and memory space are not required to store timestamp values.

answer

False

question

To protect an organization's data against physical damage, the DBA creates a disaster recovery plan.

answer

True

question

The DBA creates security policies and procedures.

answer

False

question

When relational databases store complex objects, these special data types are known as VLOBs.

answer

False

question

The actions defined for a class are known as methods.

answer

True

question

To create forms to use with a database you must write a program.

answer

False

question

Software packages, called database management systems, can do the job of manipulating databases for you.

answer

True

question

In a relation, the order of rows is important.

answer

True

question

A relational database handles entities, attributes, and relationships by storing each entity in its own table.

answer

True

question

To list all the columns in a table, use the LIST COLUMNS command.

answer

False

question

When you enter a new row into a table or modify an existing row, the values for one or more columns can be unknown or unavailable.

answer

True

question

In a SELECT statement, the FROM clause and the WHERE clause (when used) must appear on separate lines.

answer

False

question

The WHERE clause applies to both rows and groups.

answer

False

question

For two tables to be union compatible, the columns of the two tables must be identical.

answer

False

question

Table A has 10 rows and table B has 7 rows. The product of Table A and Table B would have 70 rows.

answer

True

question

The basic relationships among entities are: one-to-many, many-to-many, and one-to-one.

answer

True

question

Nulls are used when a value is either unknown or inapplicable.

answer

True

question

It is a good idea to use a SELECT command to display the data you changed to verify that the correct update was made.

answer

True

question

The DROP TABLE command creates an empty table.

answer

False

question

A DBMS must provide ways to ensure that only authorized users can access the database.

answer

True

question

The most common security features used by DBMSs are batch processing, journaling, and timestamping.

answer

False

question

A shared lock permits other users to read the data in the database.

answer

True

question

To protect an organization's data against physical damage, the DBA creates a disaster recovery plan.

answer

True

question

In order to view and analyze higher levels of aggregate data, you must drill down the data.

answer

False

question

A local deadlock involves one transaction that requires a record held by a second transaction at one site, while the second transaction requires a record held by the first transaction at a different site.

answer

False

question

Programs created with Visual Basic, Java, Perl, PHP, or C++ can access the database directly, rather than having to access it through the DBMS.

answer

False

question

Sharing data is one advantage of database processing.

answer

True

question

A relational database handles entities, attributes, and relationships by storing each entity in its own table.

answer

True

question

In an AND criterion, the overall criterion is true if either of the individual criteria is true.

answer

False

question

To view data in a table, use the VIEW command.

answer

False

question

In Access, it is common to create a table using SQL.

answer

False

question

To sort records in descending order, follow the name of the sort key with the REVERSE operator.

answer

False

question

It is possible to use both a WHERE clause and a HAVING clause in a SELECT statement.

answer

True

question

The product operation is commonly used.

answer

False

question

There is only one approach to joining tables.

answer

False

question

The basic relationships among entities are: one-to-many, many-to-many, and one-to-one.

answer

True

question

The first step in creating a user view is to normalize the tables.

answer

False

question

You can create a new table using data in an existing table.

answer

True

question

In some cases, you might need to change a table's structure in ways that are beyond the capabilities of your DBMS. When that happens, use the RESTRUCTURE command to redesign the table.

answer

False

question

In some database systems, such as Microsoft Access, users can access and update metadata about fields, tables, relationships, and indexes.

answer

True

question

In a PC-based DBMS, as long as one program has a row or table locked, no other program may access that row or table.

answer

True

question

In most cases, access to every table and field in a database is a necessity for every user.

answer

False

question

An internal company network that uses software tools typically used on the Internet and World Wide Web is called an extranet.

answer

False

question

In order to view and analyze higher levels of aggregate data, you must drill down the data.

answer

False

question

If the client only performs the presentation functions (and not the business functions), then the client is known as a fat client.

answer

False

question

There is a greater impact of failure in a nondatabase, file-oriented system.

answer

False

question

A query is a question represented in a way that the DBMS can recognize and process

answer

True

question

The comparison operators are also known as relational operators.

answer

True

question

To change a value in a table, use the CHANGE command.

answer

False

question

The COUNT function only applies to columns with numeric values.

answer

False

question

A query is a question represented in a way that the DBMS can understand.

answer

True

question

There are three types of inner joins.

answer

False

question

The use of an "m" and an "n" in an E-R diagram indicates a many-to-many relationship.

answer

True

question

In an E-R diagram, a dashed line represents an identifying relationship and a solid line represents a nonidentifying relationship

answer

False

question

In a transaction, it is acceptable if some steps fail.

answer

False

question

The DBMS must successfully complete all transaction steps or none at all for the database to remain in a correct state.

answer

True

question

Another term for production system is the test system.

answer

False

question

If users are unaware of fragmentation, the DDBMS has fragmentation transparency.

answer

True

question

Each table in a database represents two or more entities.

answer

False

question

A DBA can assign passwords to prevent unauthorized users from accessing the data.

answer

True

question

An unnormalized relation is a table that has more than one row.

answer

False

question

In a relation, the order of the columns is important.

answer

False

question

To enter a null value into a table, you use a special format of the NULL command.

answer

False

question

You can use computed columns in comparisons.

answer

True

question

The WHERE clause applies to both rows and groups.

answer

False

question

For two tables to be union compatible, the columns of the two tables must be identical.

answer

False

question

You can perform special operations, such as self-joins, within SQL.

answer

True

question

You create a many-to-many relationship by creating a new table whose primary key is the combination of the primary keys of the original tables.

answer

True

question

In an E-R diagram, a dashed line represents an identifying relationship and a solid line represents a nonidentifying relationship.

answer

False

question

You can use REMOVE ROW to remove a row from a table.

answer

False

question

In a transaction, it is acceptable if some steps fail.

answer

False

question

When the DBMS locks more rows and releases none of the locks, this is called an expanding phase.

answer

False

question

The DBA is responsible for DBMS maintenance, data dictionary management, and training.

answer

True

question

The CEO of the company determines the database access privileges for all users.

answer

False

question

Seek delay refers to the fixed amount of time that is required for every message.

answer

False

question

On a client/server network, the server is a computer that provides data to the clients.

answer

True

question

The attributes of an entity become the fields or columns in a table.

answer

True

question

Access does not use script files.

answer

True

question

Unlike Oracle, Access does not support the DECIMAL data type.

answer

True

question

When data is sorted on two columns, the more important column is called the major sort key.

answer

True

question

One reason for using an alias is when you are joining a table to itself.

answer

True

question

When using a DBMS without an optimizer, the formulation of a query can make a difference in the speed with which the query is executed.

answer

True

question

The second step in creating a user view is to represent the user view as a collection of tables.

answer

False

question

Updates become permanent automatically when you exit from the DBMS.

answer

True

question

The successful completion of a transaction is known as an after image.

answer

False

question

A shared lock permits other users to read the data in the database.

answer

True

question

Management approval is not required before the security policies and procedures can be implemented.

answer

False

question

An XML document should begin with an XML declaration.

answer

True

question

A distributed database is a single logical database that is physically divided among computers at several sites on a network.

answer

True

question

An entity is also defined as an attribute.

answer

False

question

A column whose value uniquely identifies a given row in the table is the secondary key.

answer

False

question

The concept of grouping means that statistics will be calculated for individual records.

answer

False

question

Sometimes a condition involves a column that can accept null values.

answer

True

question

In small databases, there is a significant time difference between different query approaches.

answer

False

question

When you use an E-R diagram to represent a database, it visually illustrates all the information listed in the DBDL.

answer

True

question

In Access, use the Documenter tool to show the layout of a table.

answer

True

question

If you change the value of a column to NULL, you must enclose the NULL value in single quotation marks.

answer

False

question

One guideline for writing programs for concurrent updates in a PC-based DBMS states that if an update transaction must lock more than one row in the same table, the whole table must be locked.

answer

True

question

An internal company network that uses software tools typically used on the Internet and World Wide Web is called an extranet.

answer

False

question

In most cases, access to every table and field in a database is a necessity for every user.

answer

False

question

One approach you can use to model all the various aspects of software development for object-oriented systems is known as UML.

answer

True

question

Access to a data warehouse is accomplished through the use of OLAP software.

answer

True

question

The comparison operators are also known as relational operators.

answer

True

question

To run SQL commands in Access, you must first create a new query.

answer

True

question

It is possible to place one query inside another.

answer

True

question

SQL requires that you follow special formatting rules.

answer

False

question

You can join tables by using a condition in the WHERE clause.

answer

True

question

You can use the EXISTS operator to retrieve data from more than one table.

answer

True

question

In an entity-relationship diagram, rectangles represent foreign keys.

answer

False

question

In some cases, you might need to change a table's structure in ways that are beyond the capabilities of your DBMS. When that happens, use the RESTRUCTURE command to redesign the table.

answer

False

question

The data stored in tables changes only infrequently.

answer

False

question

Programmers monitor database usage to detect potential security violations.

answer

False

question

Another term for production system is the test system.

answer

False

question

Programs created with Visual Basic, Java, Perl, PHP, or C++ can access the database directly, rather than having to access it through the DBMS.

answer

False

question

In Access, use the Documenter tool to describe the tables in a database.

answer

True

question

Aggregate functions apply to groups of rows.

answer

True

question

Instead of including every column in the SELECT clause, you can use an ampersand (&) to indicate that you want to include all columns.

answer

False

question

When joining tables, it is always necessary to qualify a column name.

answer

False

question

Occasionally, a self-join might involve the primary key of a table.

answer

True

question

You cannot change the characteristics of existing columns.

answer

False

question

It is a good idea to use a SELECT command to display the data you changed to verify that the correct update was made.

answer

True

question

When relational databases store complex objects, these special data types are known as VLOBs.

answer

False

question

The relationship between different entities (in different tables) is handled by their common columns.

answer

True

question

Software packages, called database management systems, can do the job of manipulating databases for you.

answer

True

question

Each column in a table should have a unique name, and entries in each column should all "match" this column name.

answer

True

question

If you added a row that should not be in a table, use a REMOVE command to remove it.

answer

False

question

To specify that query results be listed in a specific order, use the SORT BY clause.

answer

False

question

When the OR operator connects simple conditions, the compound condition will be true whenever any one of the simple conditions is true.

answer

True

question

When the innermost subquery is evaluated, a permanent table is produced.

answer

False

question

The primary key is a unique identifier.

answer

True

question

The MIN function determines the minimum value in a column.

answer

False

question

Smart cards have built-in circuits containing processing logic to identify the cardholder.

answer

True

question

Each job that a user completes, such as filling an order, is called a user task.

answer

False

question

Each table in a database represents two or more entities.

answer

False

question

The data type indicates the type of data that a column can contain.

answer

True

question

In a nested query, the outer query is evaluated first.

answer

False

question

An arithmetic column is a column that does not exist in the database but can be computed using data in existing columns.

answer

False

question

You must join tables by finding rows in the two tables that have identical values in matching columns.

answer

True

question

When you combine third normal form tables, the result will always be in third normal form.

answer

False

question

To permanently remove both a table and its data, you must issue both a DROP TABLE command and a DELETE command.

answer

False

question

When a company decides to purchase a new DBMS, the CEO leads the DBMS evaluation and selection effort.

answer

False

question

In a DDBMS, the site where the user is located is called the remote site.

answer

False

question

An attribute is known as a row in most databases.

answer

False

question

A query is a question represented in a way that the DBMS can recognize and process.

answer

True

question

The DISTINCT operator is useful when used in conjunction with the COUNT function.

answer

True

question

To ensure that query results are listed in a desired order, use the ORDER BY clause.

answer

True

question

There is only one approach to joining tables.

answer

False

question

Nulls are used when a value is either unknown or inapplicable.

answer

True

question

There are table structure changes that are beyond the capabilities of SQL.

answer

True

question

The more important it is to avoid redoing work, the more often you should make backups.

answer

True

question

A characteristic of a DDBMS that states that users do not need to be aware of the location of the data in a database is known as replication transparency.

answer

False

question

In a full outer join, all rows from both tables will be included regardless of whether they match rows from the other table.

answer

True

question

When provided with a user view or some sort of stated requirement, you must develop a collection of tables that will support it.

answer

True

question

To add a new column, use the ADD NEW COLUMN clause of the ALTER TABLE command.

answer

False

question

Encrypted data can be read by a word processor program.

answer

False

question

SQL is an example of a nonprocedural language.

answer

False

question

The server is also known as a front-end processor or front-end machine.

answer

False

question

An attribute is a characteristic or property of an entity.

answer

True

question

The comparison operators are +, *, %, and /.

answer

False

question

The GROUP BY clause sorts the data in a particular order.

answer

False

question

A foreign key is a column or collection of columns in one table that is required to match the value of the primary key for some row in another table, or be null.

answer

True

question

The BETWEEN operator is an essential feature of SQL.

answer

False

question

If you decrease the size of a column, it is possible to lose some data currently in the column.

answer

True

question

A local deadlock involves one transaction that requires a record held by a second transaction at one site, while the second transaction requires a record held by the first transaction at a different site.

answer

False

question

A database will not only hold information about multiple types of entities, but also information about the relationships among these multiple entities.

answer

True

question

To sort records in descending order, follow the name of the sort key with the REVERSE operator.

answer

False

question

In a nested query, the outer query is evaluated first.

answer

False

question

You must use a comma or a period to separate a table name from its alias.

answer

False

question

Accessing data using messages over a network is substantially slower than accessing data on a disk.

answer

True

question

The product operation is commonly used.

answer

False

question

Careful planning in the early stages of the normalization process will usually avoid the need to consider fourth normal form.

answer

True

question

In a PC-based DBMS, as long as one program has a row or table locked, no other program may access that row or table.

answer

True

question

To implement and enforce security, the DBA uses such features as encryption and views.

answer

True

question

When you query a database, there is a defined order in which the results are displayed.

answer

False

question

If you specify NOT NULL for a column when you create a table, you are prohibited from changing a value in the column to null.

answer

True

question

You can use the existing value in a column and a calculation to update a value.

answer

True

question

Damage to a database can occur through a physical incident such as an abnormally terminated program.

answer

True

question

The command, CREATE TABLE AS LEVEL1_CUSTOMER USING CUSTOMER; creates a table called LEVEL1_CUSTOMER that has the same structure as CUSTOMER.

answer

False

question

There are two types of primary keys that you can use in your database design.

answer

False

question

You can increase the length of column but you cannot decrease the length of a column.

answer

False

question

A global deadlock occurs at a single site in a distributed database.

answer

False

question

SQL was developed as the data manipulation language for IBM's prototype relational model DBMS, System R.

answer

True

question

The WHERE clause is used to retrieve rows that satisfy some condition.

answer

True

question

Table A has 10 rows and table B has 7 rows. The product of Table A and Table B would have 70 rows.

answer

True

question

You cannot use a compound condition with an UPDATE command.

answer

False

question

The only arithmetic operators that can be used in SELECT statements are + for addition and - for subtraction.

answer

False

question

In two-phase locking, the second phase is the shrinking phase.

answer

True

question

QBE is an example of a procedural language.

answer

False

question

A simple condition has the form: column name, comparison operator, and then either another column name or a value.

answer

True

Database Class – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards