SQL Quiz Chap 5 and 6

Card Set Information

Author:
zlittlerabbit
ID:
83193
Filename:
SQL Quiz Chap 5 and 6
Updated:
2011-05-02 07:28:28
Tags:
SQL Structured Query Language Database
Folders:

Description:
SQL Quiz Chap 5 and 6
Show Answers:

Home > Flashcards > Print Preview

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


  1. In order to use the COMMIT command in Oracle, you need to clear the check mark from the ____ check box.
    Autocommit
  2. If you have verified that the update you made is correct, you can use the ____ command to make the update permanent.
    COMMIT
  3. In a(n) ____ join, all rows from both tables are included regardless of whether they match rows from the other table.
    full outer
  4. 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.
    EXISTS
  5. ____ is the default transaction mode in Oracle and commits each action query as soon as the user executes the query.
    Autocommit
  6. Access does not support the ____ data type.
    DECIMAL
  7. Two tables are ____ compatible if they have the same number of columns and if their corresponding columns have identical data types and lengths.
    union
  8. To retrieve data from multiple tables in a query you can use the ____ operator with a subquery.
    IN
  9. The ____ of two tables is a table containing all rows that are in both tables.
    intersect
  10. 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?
    inner
  11. You can join tables by using a condition in the ____ clause.
    WHERE
  12. To add data from an existing table to a new table, use a SELECT command in a(n) ____ command.
    INSERT
  13. Which of the following is a valid SQL command?
    COMMIT;
  14. To delete data from the database, use the ____ command.
    DELETE
  15. You can use the ____ command to create a new table using data in an existing table.
    CREATE TABLE
  16. Oracle and SQL Server support the ____ operator but Microsoft Access does not.
    INTERSECT
  17. If you have not run the COMMIT command, executing the ____ command will reverse all updates made during the current work session.
    ROLLBACK
  18. The ____ of two tables is the set of all rows that are in the first table but that are not in the second table.
    difference
  19. The ____ of two tables is a table containing every row that is in either the first table, the second table, or both tables.
    union
  20. Which of the following commands executes a rollback?
    ROLLBACK;
  21. You create an alias by typing the name of the table, pressing the ____, and then typing the name of the alias.
    Spacebar
  22. The product of two tables is formally called the ____ Product.
    Cartesian
  23. In MySQL, use the ____ command to show the revised structure of a table.
    SHOW COLUMNS
  24. In MySQL, use the ____ data type for variable-length character columns.
    VARCHAR
  25. The ____ command is permanent.
    COMMIT
  26. A(n) _____ can be views as a sequence of steps that accomplishes a single task.
    transaction
  27. What happens if you run a DELETE command that does not contain a WHERE clause?
    All rows will be deleted from the table.
  28. In order to use the ROLLBACK commands in MySQL, you need to change the value for _____ to 0.
    AUTOCOMMIT
  29. 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.
    ANY
  30. If you precede the subquery by the ____ operator, the condition is true only if it satisfies all values produced by the subquery.
    ALL
  31. Which of the following set operators are not supported by MySQL?
    MINUS and INTERSECT
  32. The ____ of two tables is a table containing every row that is in either the first table, the second table, or both tables.
    union
  33. To make the same update for all rows in a table, omit the _____ clause.
    WHERE
  34. If you specified ____ for a column when you created a table, then changing a value in a column to null is prohibited.
    NOT NULL
  35. 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).
    left outer join
  36. To qualify a column name, precede the name of the column with the name of the table, followed by a(n) _____.
    period .
  37. To change a column that currently rejects null values so that it accepts null values, use the ____ clause of the ALTER TABLE command.
    MODIFY
  38. In order to use the COMMIT command in MySQL, you need to change the value for AUTOCOMMIT to ____.
    0
  39. Retrieve data from two or more tables you should...
    Join tables
  40. Use this format to _____ tables
    SELECT clause
    List all columns to display
    FROM clause
    List all tables involved in query
    WHERE clause
    Restrict to rows that have common values in matching columns
    Join
  41. you can join tables using:
    • WHERE clause
    • IN operator with a subquery
    • EXISTS operator with a subquery
  42. SELECT MARINA_NUM, SLIP_NUM, RENTAL_FEE, BOAT_NAME, LAST_NAME

    FROM MARINA_SLIP, OWNER

    WHERE MARINA_SLIP.OWNER_NUM = OWNER.OWNER_NUM

    is an example of a ---
    Join
  43. This is an example of a _____ join table

    SELECT F.CUSTOMER_NUM, F.CUSTOMER_NAME, S.CUSTOMER_NUM, S.CUSTOMER_NAME, F.CITY

    FROM CUSTOMER F, CUSTOMER S

    WHERE F.CITY = S.CITY

    AND F.CUSTOMER_NUM < S.CUSTOMER_NUM
    self

What would you like to do?

Home > Flashcards > Print Preview