SQL Quiz Chap 7 and 8

Card Set Information

Author:
zlittlerabbit
ID:
83456
Filename:
SQL Quiz Chap 7 and 8
Updated:
2011-05-03 06:28:21
Tags:
SQL Structured Query Language Database
Folders:

Description:
SQL Structured Query Language Database
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user zlittlerabbit on FreezingBlue Flashcards. What would you like to do?


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

What would you like to do?

Home > Flashcards > Print Preview