NAME

Question types


Start with


Question limit

of 80 available terms

Print test

65 Matching questions

  1. In MySQL, use the ________ function to truncate everything to the right of the decimal point.
    A) TRUNCATE
    B) LTRIM
    C) REMOVE
    D) TRIM
  2. If you specified ____ for a column when you created a table, then changing a value in a column to null is prohibited.
    A) NOT NULL
    B) NULL
    C) CHAR
    D) NUMBER
  3. In a business organization, a person or an entire group known as the ____ is charged with managing the database.
    A) process manager
    B) developer
    C) database administrator
    D) programmer
  4. If you have verified that the update you made is correct, you can use the ____ command to make the update permanent.
    A) UPDATE
    B) ROLLBACK
    C) COMMIT
    D) SAVE
  5. You can use the ____ command to delete an entire table and its data.
    A) ROLLBACK
    B) DELETE TABLE
    C) DROP TABLE
    D) DELETE
  6. To create a stored procedure in MySQL, use the ____________ command.
    A) CREATE ROUTINE
    B) CREATE SCRIPT
    C) CREATE PROCEDURE
    D) CALL
  7. The correct command to allow user Thompson to delete rows in the CUSTOMER table would be:
    GRANT ____ ON CUSTOMER TO THOMPSON.
    A) DROP
    B) REMOVE
    C) UPDATE
    D) DELETE
  8. The CREATE VIEW command includes the words CREATE VIEW, followed by the name of the view, the word ____, and then a query.
    A) AC
    B) SA
    C) AS
    D) IN
  9. In MySQL, use the ____ command to display the structure of a table.
    A) SHOW TABLE
    B) SHOW LAYOUT
    C) DESC
    D) DISPLAY LAYOUT
  10. A(n) ____ is an application program's or an individual user's picture of the database.
    A) transaction
    B) view
    C) catalog
    D) index
  11. The command to delete a view is ____.
    A) DROP VIEW
    B) DELETE VIEW
    C) REMOVE VIEW
    D) REVOKE VIEW
  12. Which of the following is a valid SQL command?
    A) COMMIT TABLE;
    B) COMMIT CHANGES;
    C) COMMIT DB;
    D) COMMIT;
  13. If you precede the subquery by the ____ operator, the condition is true only if it satisfies all values produced by the subquery.
    A) TRUE
    B) ALL
    C) IS ALL
    D) ALWAYS
  14. What happens if you run a DELETE command that does not contain a WHERE clause?
    A) The database will be deleted.
    B) All rows will be deleted from the table.
    C) All values would be replaced by nulls.
    D) None of the above.
  15. 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?
    A) inner
    B) outer
    C) nested
    D) product
  16. 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.
    A) IS SOME
    B) IS ANY
    C) SOME
    D) ANY
  17. Which of the following is a valid SQL command?
    A) DROP TABLE LEVEL1_CUSTOMER;
    B) DROP LEVEL1_CUSTOMER;
    C) DELETE LEVEL1_CUSTOMER;
    D) All of the above
  18. You can join tables by using a condition in the _____ clause.
    A) FROM
    B) WHERE
    C) AND
    D) PLUS
  19. The database administrator uses the ____ command to revoke privileges from users.
    A) DROP
    B) REMOVE
    C) REVOKE
    D) CANCEL
  20. A type of constraint supported in SQL is ____.
    A) grants
    B) foreign key
    C) indexes
    D) none of the above
  21. In MySQL, the __________ function displays a value in all lowercase letters.
    A) REGULAR
    B) LOWER
    C) SMALL
    D) LCASE
  22. To ensure the uniqueness of values in a nonprimary key column, use the ____ command to create an index.
    A) CREATE UNIQUE INDEX
    B) CREATE NONPRIMARY INDEX
    C) CREATE INDEX
    D) CREATE ONLY INDEX
  23. You can use the ____ command to create a new table.
    A) CREATE TABLE
    B) NEW TABLE
    C) UPDATE
    D) ALTER TABLE
  24. In MySQL, the _________ function displays a value in all uppercase letters.
    A) CAPITOL
    B) UPPER
    C) LARGE
    D) UCASE
  25. When a subquery involves a table listed in the outer query, the subquery is called a(n) ____ subquery.
    A) inner outer
    B) correlated
    C) reverse
    D) parameter
  26. The product of two tables is formally called the ____ Product.
    A) Oracle
    B) Outer
    C) SQL
    D) Cartesian
  27. The system catalog is also called the ____.
    A) system database
    B) data dictionary
    C) master data table
    D) transaction database
  28. 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.
    A) RETRIEVE
    B) FETCH
    C) GET
    D) READ
  29. Two tables are ____ compatible if they have the same number of columns and if their corresponding columns have identical data types and lengths.
    A) union
    B) minus
    C) difference
    D) intersect
  30. The privilege ____ can be granted to change data.
    A) WRITE
    B) UPDATE
    C) ALTER
    D) READ AND WRITE
    Correct Answer(s): B
  31. In MySQL, to add a specific number of months to a date, use the ___________ function.
    A) DATE_ADD
    B) ADD_DATE
    C) ADD-MONTHS
    D) CALC-MONTHS
  32. The main mechanism for providing access to a database is the ____ command.
    A) PERMIT
    B) ACCESS
    C) GRANT
    D) REVOKE
  33. To delete data from the database, use the ____ command.
    A) ROLLBACK
    B) COMMIT
    C) DELETE
    D) UPDATE
  34. In MySQL, you can use the _________ function to obtain today's date.
    A) TODAYS_DATE
    B) DATE_ADD
    C) NOW-DATE
    D) SYSDATE
  35. You create an alias by typing the name of the table, pressing the ____, and then typing the name of the alias.
    A) Tab
    B) Backspace
    C) Enter
    D) Spacebar
  36. 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.
    A) ADD
    B) MODIFY
    C) UPDATE
    D) NULL
  37. 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).
    A) left inner join
    B) left outer join
    C) right inner join
    D) right outer join
  38. In a(n) ____ join, all rows from both tables are included regardless of whether they match rows from the other table.
    A) normal
    B) inner
    C) full outer
    D) combined
  39. The ____ command is permanent.
    A) SELECT
    B) COMMIT
    C) SAVE
    D) AND
  40. When renaming columns using a CREATE VIEW command, you include the new column names in ____ following the name of the view.
    A) single quotes
    B) double quotes
    C) parentheses
    D) square brackets
  41. To qualify a column name, precede the name of the column with the name of the table, followed by a(n)_____.
    A) comma (,)
    B) period (.)
    C) percent sign (%)
    D) asterisk (*)
  42. The privilege ____ can be granted to change the table structure.
    A) WRITE
    B) UPDATE
    C) ALTER
    D) MODIFY
  43. A(n) _________ is a pointer to a row in the collection of rows retrieved by an SQL command.
    A) cursor
    B) trigger
    C) waypoint
    D) fetchpoint
  44. The ____ of two tables is a table containing all rows that are in both tables.
    A) intersect
    B) union
    C) difference
    D) minus
  45. Which of the following deletes an index?
    A) DELETE INDEX
    B) REMOVE INDEX
    C) UNINDEX
    D) DROP INDEX
  46. If you have not run the COMMIT command, executing the ____ command will reverse all updates made during the current work session.
    A) UPDATE
    B) REVERSE
    C) ROLLBACK
    D) ROLL
  47. To change rows for which a specific condition is true, use the ____ command
    A) CHANGE
    B) MODIFY
    C) UPDATE
    D) ALTER
  48. To execute (run) a procedure in MySQL, use the EXEC command.
    A) True
    B) False
  49. For an SQL implementation to truly support the union operation, it must remove ____ rows automatically.
    A) dependent
    B) no
    C) independent
    D) duplicate
  50. When you specify a foreign key, the table referenced by the foreign key is the ____.
    A) super
    B) sibling
    C) parent
    D) child
  51. In MySQL the __________ symbol is used as a wildcard in LIKE operations.
    A) %
    B) +
    C) CONCAT
    D) *
  52. Which of the following commands executes a rollback?
    A) ROLLBACK TABLE;
    B) ROLLBACK;
    C) ROLLBACK ALL;
    D) ROLLBACK DB;
  53. A(n) _________ is a procedure that is executed automatically in response to an associated database operation.
    A) cursor
    B) trigger
    C) fetchpoint
    D) read
  54. 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.
    A) left inner join
    B) left outer join
    C) right outer join
    D) right inner join
  55. 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.
    A) IS NULL
    B) IS TRUE
    C) IS EXIST
    D) EXISTS
  56. Microsoft Access does not support the ____ data type.
    A) DECIMAL
    B) CURRENCY
    C) CHAR
    D) INT
  57. When using COMMIT and ROLLBACK, a(n) ____ can be viewed as a sequence of steps that accomplishes a single task.
    A) procedure
    B) transaction
    C) program
    D) method
  58. Oracle and SQL Server support the ____ operator but Microsoft Access does not.
    A) UNION
    B) INTERSECT
    C) MINUS
    D) ALL
  59. In MySQL, use the __________ function to round a numeric value to a desired number of decimal places.
    A) INT
    B) INTEGER
    C) ROUND
    D) TRUNCATE
  60. Microsoft Access does not support COMMIT and ROLLBACK.
    A) True
    B) False
  61. In SQL, use the ____ data type for character columns.
    A) INT
    B) VARCHAR
    C) VARIABLE
    D) CHARLENGTH
  62. To remove extra spaces to the right of a value, for example, the value in a FIRST_NAME column, use the _______ function.
    A) TRUNCATE
    B) TRIM_RIGHT
    C) RIGHT
    D) RTRIM
  63. To add data from an existing table to a new table, use a SELECT command in a(n) ____ command.
    A) SET
    B) ADD
    C) INSERT
    D) UPDATE
  64. The ____ of two tables is the set of all rows that are in the first table but that are not in the second table.
    A) union
    B) intersect
    C) intersection
    D) difference
  65. To retrieve data from multiple tables in a query you can use the _____ operator with a subquery.
    A) AND
    B) IN
    C) OR
    D) NOT
  1. a A) True
  2. b B) False
  3. c B) MODIFY
  4. d D) Spacebar
  5. e D) Cartesian
  6. f C) DROP TABLE
  7. g B) trigger
  8. h C) CREATE PROCEDURE
  9. i C) ROUND
  10. j C) full outer
  11. k C) right outer join
  12. l B) data dictionary
  13. m C) AS
  14. n B) COMMIT
  15. o B) WHERE
  16. p B) All rows will be deleted from the table.
  17. q B) FETCH
  18. r A) cursor
  19. s A) DROP TABLE LEVEL1_CUSTOMER
  20. t C) REVOKE
  21. u A) union
  22. v B) UPDATE
  23. w B) ROLLBACK
  24. x D) duplicate
  25. y B) LOWER
  26. z D) SYSDATE
  27. aa B) transaction
  28. ab A) TRUNCATE
  29. ac C) DELETE
  30. ad B) UPPER
  31. ae A) NOT NULL
  32. af A) CREATE UNIQUE INDEX
  33. ag C) COMMIT
  34. ah B) foreign key
  35. ai D) ANY
  36. aj C) DESC
  37. ak B) left outer join
  38. al A) Decimal
  39. am C) INSERT
  40. an B) correlated
  41. ao B) intersect
  42. ap A) DROP VIEW
  43. aq C) child
  44. ar D) RTRIM
  45. as A) %
  46. at B) period (.)
  47. au C) database administrator
  48. av D) COMMIT
  49. aw B) IN
  50. ax D) difference
  51. ay D) DROP INDEX
  52. az A) intersect
  53. ba C) parentheses
  54. bb B) VARCHAR
  55. bc B) View
  56. bd B) ALL
  57. be D) EXISTS
  58. bf D) DELETE
  59. bg A) CREATE TABLE
  60. bh C) UPDATE
  61. bi A) inner
  62. bj C) GRANT
  63. bk A) DATE_ADD
  64. bl C) ROLLBACK
  65. bm C) ALTER