CIST 1220 Final Review

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

To qualify a column name, precede the name of the column with the name of the table, followed by a(n) ____.

To retrieve data from multiple tables in a query you can use the ____ operator with a subquery.

You can precede a subquery with the ____ operator to create a condition that is true if one or more rows are obtained when the subquery is executed.

When a subquery involves a table listed in the outer query, the subquery is called a(n) ____ subquery.

A(n) ____ clause can include statistics calculated for only the groups or columns whose values are identical for each row in a group

You create an alias by typing the name of the table, pressing the ____, and then typing the name of the alias.

The ____ of two tables is a table containing every row that is in either the first table, the second table, or both tables

The ____ of two tables is a table containing all rows that are in both tables.

The ____ of two tables is the set of all rows that are in the first table but that are not in the second table.

Two tables are ____ compatible if they have the same number of columns and if their corresponding columns have identical data types and lengths

For an SQL implementation to truly support the union operation, it must remove ____ rows automatically.

Oracle and SQL Server support the ____ operator but Microsoft Access does not

If you precede the subquery by the ____ operator, the condition is true only if it satisfies all values produced by the subquery

If you precede the subquery by the ____ operator, the condition is true only if it satisfies any value (one or more) produced by the subquery.

Which of the following joins compares the tables in the FROM clause and lists only those rows that satisfy the condition in the WHERE clause?

In a(n) ____ join, all rows from both tables are included regardless of whether they match rows from the other table.

In a ____, all rows from the table on the left (the table listed first in the query) will be included regardless of whether they match rows from the table on the right (the table listed second in the query).

In a ____, all rows from the table on the right will be included regardless of whether they match rows from the table on the left

The product of two tables is formally called the ____ Product

Access does not support the ____ data type

You can use the ____ command to create a new table using data in an existing table

To change rows for which a specific condition is true, use the ____ command

To add data from an existing table to a new table, use a SELECT command in a(n) ____ command

If you have verified that the update you made is correct, you can use the ____ command to make the update permanent

If you have not run the COMMIT command, executing the ____ command will reverse all updates made during the current work session

In order to use the COMMIT command in Oracle, you need to clear the check mark from the ____ check box.

____ is the default transaction mode in Oracle and commits each action query as soon as the user executes the query

Which of the following commands executes a rollback?

Which of the following is a valid SQL command?

The ____ command is permanent

A(n) ____ can be viewed as a sequence of steps that accomplishes a single task.

To delete data from the database, use the ____ command

What happens if you run a DELETE command that does not contain a WHERE clause?

If you specified ____ for a column when you created a table, then changing a value in a column to null is prohibited

In Oracle, use the ____ command to display the structure of a table.

You can use the ____ clause of the ALTER TABLE command to change a column that currently rejects null values so that it will accept null values

In SQL, use the ____ data type for variable-length character columns

You can use the ____ command to delete an entire table and its data

Which of the following is a valid SQL command?

The UPDATE command contains the word ____________________, followed by the name of the column to be updated, an equals sign, and the new value.

The ROLLBACK command reverses changes made to the ____________________ only.

To sort rows in a specific order, use the ____________________ clause with the desired sort key(s).

Before beginning the updates for a transaction, commit any previous updates by executing the ____________________ command.

To add a new column, use the ____________________ clause of the ALTER TABLE command.

In a business organization, a person or an entire group known as the ____ is charged with managing the database.

The CREATE VIEW command includes the words CREATE VIEW, followed by the name of the view, the word ____, and then a query

A(n) ____ is an application program's or an individual user's picture of the database

When renaming columns, you include the new column names in ____ following the name of the view

A view is updatable when it is derived from joining two base tables on the ____ of each table

The command to delete a view is ____

The main mechanism for providing access to a database is the ____ command

The correct command to allow user Thompson to delete rows in the CUSTOMER table would be: GRANT ____ ON CUSTOMER TO THOMPSON.

When you specify a foreign key, the table referenced by the foreign key is the ____.

The privilege ____ can be granted to change data.

The privilege ____ can be granted to change the table structure

The database administrator uses the ____ command to revoke privileges from users

Which of the following commands deletes an index?

To ensure the uniqueness of values in a nonprimary key column, use the ____ command to create an index

The system catalog is also called the ____.

In Oracle, the ____ table contains information about the tables known to SQL.

The types of constraints supported in SQL are ____.

A view is defined by creating a defining ____________________, which indicates the rows and columns to include in the view.

To add a primary key after creating a table, you can use the ____________________ clause of the ALTER TABLE command.

"Item classes for parts must be AP, HW, or SG because these are the only valid item classes." is an example of an _________________.

In Oracle and SQL Server, the ____ function displays a value in uppercase letters

In Oracle and SQL Server, the ____ function displays a value in lowercase letters.

In Microsoft Access, the ____ function displays a value in lowercase letters.

In Microsoft Access, the ____ function displays a value in uppercase letters

In Oracle, SQL Server, and Microsoft Access, use the ____ function to round a numeric value to a desired number of decimal places

In Oracle and SQL Server, use the ____ function to truncate everything to the right of the decimal point

In Oracle, to add a specific number of months to a date, use the ____ function.

In SQL Server and Microsoft Access, to add a specific number of months to a date, use the ____ function

In Oracle, you can use the ____ function to obtain today's date.

In Microsoft Access, you can use the ____ function to obtain today's date

In SQL Server, you can use the ____ function to obtain today's date.

To remove extra spaces to the right of a value, for example, the value in a FIRST_NAME column, use the ____ function.

To create a stored procedure in Oracle, use the ____ command.

Variable names in PL/SQL must start with a letter and can contain letters, dollar signs, underscores, and number signs, but cannot exceed ____ characters

In PL/SQL, you can ensure that a variable has the same data type as a particular column by using the ____ attribute

A(n) ____ is a pointer to a row in the collection of rows retrieved by an SQL command

When you use a cursor in a procedure, the ____ command advances the cursor to the next row in the set of rows retrieved by the query and places the contents of the row in the indicated variables

To call a procedure in SQL Server, use the ____ command

In Microsoft Visual Basic, use the ____ statement to create a string variable

A(n) ____ is a procedure that is executed automatically in response to an associated database operation