The correct command to allow user Thompson to delete rows in the CUSTOMER table would be:
GRANT ____ ON CUSTOMER TO THOMPSON.
DELETE
The system catalog is also called the ____.
data dictionary
In SQL Server and Microsoft Access, to add a specific number of months to a date, use the ____ function.
DATEADD()
In a business organization, a person or an entire group known as the ____ is charged with managing the database.
database administrator
A(n) ____ is an application program’s or an individual user’s picture of the database.
view
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.
FETCH
In Oracle and SQL Server, the ____ function displays a value in uppercase letters
UPPER
The types of constraints supported in SQL are ____.
All of the above
To create a stored procedure in Oracle, use the ____ command.
CREATE PROCEDURE
The main mechanism for providing access to a database is the ____ command.
GRANT
The privilege ____ can be granted to change the table structure.
ALTER
In SQL Server, you can use the ____ function to obtain today’s date.
GETDATE()
In Oracle, SQL Server, and Microsoft Access, use the ____ function to round a numeric value to a desired number of decimal places.
ROUND
A function can have more than one argument.
True
In Oracle, you can use the ____ function to obtain today’s date.
SYSDATE
The database administrator uses the ____ command to revoke privileges from users
REVOKE
The privilege ____ can be granted to change data.
UPDATE
To call a procedure in SQL Server, use the ____ command.
EXEC
The command to delete a view is ____.
DROP VIEW
A(n) ____ is a procedure that is executed automatically in response to an associated database operation
trigger
Which of the following commands lists all the privileges granted to a user?
SHOW GRANTS
The privilege _____ can be granted to retrieve data.
SELECT
______ is the process of making multiple copies of the databse.
Replication
To import a text file into MySQL, the text file must be _____ and the data should not be enclosed to quotation marks.
tab-delimited
MySQL _____ is a tool for performing administrative operations, such as monitoring the status and performance of MySQL.
Administrator
_____ is a data interchange format that allows you to exchange data between dissimilar systems or applications.
XML
In the MySQL Query Browser, the _____ Browser has three tabbed pages entitled Schemata, Bookmarks, and History.
Object
A(n) ____ is a built-in program or routine that the DBMS uses to monitor and improve database performance.
optimizer
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.
REFERENCES
A view is updatable when it is derived from joining two base tables on the ____ of each table.
primary key
When you specify a foreign key, the table referenced by the foreign key is the _____.
parent
In the MySQL Query Browser, the ____ Browser allows you to save queries that you use frequently.
Bookmarks
The _____ command analyze the data in a table and creates statistics that the MySQL optimizer uses.
ANALYZE TABLE
The CREATE VIEW command includes the words CREATE VIEW, followed by the name of the view, the word _____, and then a query.
AS
The main mechanism for providing access to a database is the _____ command.
GRANT
The ______ command lists all tables in the default database.
SHOW TABLES
To list all the indexes associated with a table, use the ____ command.
SHOW INDEX
In the MySQL Query Browser, the _____ Browser lets you brows all the previously created queries during your session.
History
The ______ command fixes damaged or corrupted tables.
REPAIR TABLE
In MySQL Administrator, you can perform table maintenance using the ____ section.
Catalogs
What is this?
Speeds up the searching of tables
Similar to an index in a book
Indexes
Use ____ ____command
Name the index
Identify the table
Identify the column or columns
CREATE INDEX
How do you delete an index?
DROP INDEX
____ ______ contains information about tables in database; also called data dictionary
System Catalog
Use ______ to list all tables in database
SYSTABLES
Use _______ to list all columns in a table
SYSCOLUMNS
Use _______ to list information about views
SYSVIEWS
Use ____ ____ _____ clause on ALTER TABLE command to add after creating a table
ADD PRIMARY KEY
When specifying a foreign key, table containing foreign key is the _____