SQL Quiz Chap 7 and 8

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

The system catalog is also called the ____.

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

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

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

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.

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

The types of constraints supported in SQL are ____.

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

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

The privilege ____ can be granted to change the table structure.

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

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

A function can have more than one argument.

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

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

The privilege ____ can be granted to change data.

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

The command to delete a view is ____.

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

Which of the following commands lists all the privileges granted to a user?

The privilege _____ can be granted to retrieve data.

______ is the process of making multiple copies of the databse.

To import a text file into MySQL, the text file must be _____ and the data should not be enclosed to quotation marks.

MySQL _____ is a tool for performing administrative operations, such as monitoring the status and performance of MySQL.

_____ is a data interchange format that allows you to exchange data between dissimilar systems or applications.

In the MySQL Query Browser, the _____ Browser has three tabbed pages entitled Schemata, Bookmarks, and History.

A(n) ____ is a built-in program or routine that the DBMS uses to monitor and improve database performance.

The general form for assigning a foreign key is ADD FOREIGN KEY, the column name(s) of the foreign key, the ______ clause, and then the table name that the foreign key must match.

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

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

In the MySQL Query Browser, the ____ Browser allows you to save queries that you use frequently.

The _____ command analyze the data in a table and creates statistics that the MySQL optimizer uses.

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

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

The ______ command lists all tables in the default database.

To list all the indexes associated with a table, use the ____ command.

In the MySQL Query Browser, the _____ Browser lets you brows all the previously created queries during your session.

The ______ command fixes damaged or corrupted tables.

In MySQL Administrator, you can perform table maintenance using the ____ section.

What is this?
Speeds up the searching of tables
Similar to an index in a book

Use ____ ____command
Name the index
Identify the table
Identify the column or columns

How do you delete an index?

____ ______ contains information about tables in database; also called data dictionary

Use ______ to list all tables in database

Use _______ to list all columns in a table

Use _______ to list information about views

Use ____ ____ _____ clause on ALTER TABLE command to add after creating a table

When specifying a foreign key, table containing foreign key is the _____

what are the 3 Integrity constraints?