DATABASE test
In the MySQL Query Browser, the ____ Browser allows you to save queries that you use frequently. A. Bookmarks B. Information C. Save D. Params
A
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
A
You can use the ____ command to create a new table using data in an existing table. A. CREATE TABLE B. NEW TABLE C. UPDATE D. ALTER TABLE
A
____ is the process of making multiple copies of the database. A. Replication B. Concurrency C. Distribution D. Redundancy
A
A(n) ____ can be viewed as a sequence of steps that accomplishes a single task. A. procedure B. transaction C. program D. method
B
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
B
In order to use the ROLLBACK commands in MySQL, you need to change the value for ____ to 0. A. AUTOROLL B. AUTOCOMMIT C. AUTOROLLBACK D. ENABLE
B
To change a column that currently rejects null values so that it accepts null values, use the ____ clause of the ALTER TABLE command A. ACCEPT NULLS B. MODIFY C. ADD NULLS D. CREATE
B
Which of the following commands executes a rollback? A. ROLLBACK TABLE; B. ROLLBACK; C. ROLLBACK ALL; D. ROLLBACK DB;
B
You can join tables by using a condition in the ____ clause. A. FROM B. WHERE C. SELECT D. JOIN
B
____ is defined as the speed or rate with which the DBMS supplies information to the user. A. Data optimization B. Database performance C. Database tuning D. Data analysis
B
If you have verified that the update you made is correct, you can use the ____ command to make the update permanent. A. UPDATE B. ROLL C. COMMIT D. SAVE
C
To delete data from the database, use the ____ command. A. ROLLBACK B. COMMIT C. DELETE D. UPDATE
C
You can use the ____ command to delete an entire table and its data. A. ROLLBACK B. DELETE TABLE C. DROP TABLE D. DELETE
C
The ____________________ command checks a table for errors, such as identifying corrupt tables resulting from not being closed properly.
CHECK TABLE
During your current work session you can save your changes immediately by executing the ____________________ command.
COMMIT
Before you can import data into a new table, you must use the ____ command to create the new table. A. NEW TABLE B. ADD TABLE C. ALTER TABLE D. CREATE TABLE
D
For an SQL implementation to truly support the union operation, it must remove____ rows automatically.. A. dependent B. no C. independent D. duplicate
D
How can you use the COMMIT and ROLLBACK commands to support transactions? A. You can use the COMMIT and ROLLBACK commands to support transactions as follows: B. Before beginning the updates for a transaction, commit any previous updates by executing the COMMIT command. C. Complete the updates for the transaction. If any update cannot be completed, execute the ROLLBACK command and discontinue the updates for the current transaction. D. If you can complete all updates successfully, execute the COMMIT command after completing the final update.
D
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
D
In the MySQL Query Browser, the ____ Browser lets you browse all the previously created queries during your session. A. Bookmarks B. Object C. Information D. History
D
The product of two tables is formally called the ____ Product. A. Oracle B. Outer C. SQL D. Cartesian
D
You can delete a table that is no longer needed by using the ____________________ TABLE command.
DROP
The ____________________ Browser displays all databases on the MySQL server to which you are connected.
Database
The ____________________ command examines a query statement before it is executed.
EXPLAIN
MySQL does not allow you to change the size of DECIMAL columns. TRUE OR FALSE
FALSE
MySQL supports the INTERSECT operator. TRUE OR FALSE
FALSE
The REPAIR TABLE command recovers unused space caused by fragmented files. TRUE OR FALSE
FALSE
The ROLLBACK command reverses changes made to a table's structure. TRUE OR FALSE
FALSE
To display query output vertically, include the \V command in the query. TRUE OR FALSE
FALSE
To produce the same results as the INTERSECT operator, use the BETWEEN operator and a subquery. TRUE OR FALSE
FALSE
To relate two tables, in the FROM clause list all columns involved in the query. TRUE OR FALSE
FALSE
When joining tables, it is always necessary to qualify a column name. TRUE OR FALSE
FALSE
When you use the Query Browser to create a query, you must enter a semi-colon at the end of the command. TRUE OR FALSE
FALSE
You can use the ROLLBACK command to return the column length to its original state. TRUE OR FALSE
FALSE
You cannot use a compound condition to update a row. TRUE OR FALSE
FALSE
The ____________________ Browser is a quick reference to the built-in functions available in MySQL.
Functions
If you had two separate tables for customers and the query requested customers in the first table having the same city as customers in the second table, you could use a normal ____________________ operation to find the answer.
JOIN
You can change the characteristics of existing columns by using the ____________________ clause of the ALTER TABLE command.
MODIFY
A subquery within a subquery is called a(n) ____________________ subquery.
NESTED
The ____________________ command recovers unused space caused by fragmented files.
OPTIMIZE TABLE
Sometimes you need to list all the rows from one of the tables in a join, regardless of whether they match any rows in the other table. This type of join is called a(n) ____________________ join.
OUTER
The ____________________ Browser provides parameters that can help you build queries.
Parameters
The UPDATE command contains the word ____________________, followed by the name of the column to be updated, an equals sign, and the new value.
SET
In the MySQL Query Browser, the ____________________ provides another way to create and edit scripts.
Script Editor
A text file might contain line breaks, commas, or tabs to distinguish one piece of data from another. TRUE OR FALSE
TRUE
In a full outer join, all rows from both tables will be included regardless of whether they match rows from the other table. TRUE OR FALSE
TRUE
In some cases, when you update the data in a table, you can reverse (cancel) them at any time during your current work session. TRUE OR FALSE
TRUE
In the Query Browser, you can resize columns to produce more readable output. TRUE OR FALSE
TRUE
MySQL does not support the MINUS operator. TRUE OR FALSE
TRUE
One of the nicest features of a relational DBMS, such as MySQL, is the ease with which you can change table structures. TRUE OR FALSE
TRUE
The Information Browser provides access to all information not directly related to actual data in the database. TRUE OR FALSE
TRUE
Updates become permanent automatically when you exit from MySQL. TRUE OR FALSE
TRUE
You can cancel updates at any time during your current work session. TRUE OR FALSE
TRUE
You can join tables by using a condition in the WHERE clause. TRUE OR FALSE
TRUE
You can perform special operations within SQL. TRUE OR FALSE
TRUE
You can use the ALL and ANY operators with subqueries to produce a single column of numbers. TRUE OR FALSE
TRUE
You can use the Query Browser to edit tables and create and run scripts. TRUE OR FALSE
TRUE
The ____________________ Browser lists all queries that make up a single transaction.
Transaction
When tables are listed in the FROM clause, you can give each table a(n) ____________________, or an alternate name.
alias
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
A(n) ____________________ file contains unformatted data.
text
A(n) ____________________ is a logical unit of work.
transaction
