-
In order to use the COMMIT command in Oracle, you need to clear the check mark from the ____ check box.
Autocommit
-
If you have verified that the update you made is correct, you can use the ____ command to make the update permanent.
COMMIT
-
In a(n) ____ join, all rows from both tables are included regardless of whether they match rows from the other table.
full outer
-
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
-
____ is the default transaction mode in Oracle and commits each action query as soon as the user executes the query.
Autocommit
-
Access does not support the ____ data type.
DECIMAL
-
Two tables are ____ compatible if they have the same number of columns and if their corresponding columns have identical data types and lengths.
union
-
To retrieve data from multiple tables in a query you can use the ____ operator with a subquery.
IN
-
The ____ of two tables is a table containing all rows that are in both tables.
intersect
-
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
-
You can join tables by using a condition in the ____ clause.
WHERE
-
To add data from an existing table to a new table, use a SELECT command in a(n) ____ command.
INSERT
-
Which of the following is a valid SQL command?
COMMIT;
-
To delete data from the database, use the ____ command.
DELETE
-
You can use the ____ command to create a new table using data in an existing table.
CREATE TABLE
-
Oracle and SQL Server support the ____ operator but Microsoft Access does not.
INTERSECT
-
If you have not run the COMMIT command, executing the ____ command will reverse all updates made during the current work session.
ROLLBACK
-
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
-
The ____ of two tables is a table containing every row that is in either the first table, the second table, or both tables.
union
-
Which of the following commands executes a rollback?
ROLLBACK;
-
You create an alias by typing the name of the table, pressing the ____, and then typing the name of the alias.
Spacebar
-
The product of two tables is formally called the ____ Product.
Cartesian
-
In MySQL, use the ____ command to show the revised structure of a table.
SHOW COLUMNS
-
In MySQL, use the ____ data type for variable-length character columns.
VARCHAR
-
The ____ command is permanent.
COMMIT
-
A(n) _____ can be views as a sequence of steps that accomplishes a single task.
transaction
-
What happens if you run a DELETE command that does not contain a WHERE clause?
All rows will be deleted from the table.
-
In order to use the ROLLBACK commands in MySQL, you need to change the value for _____ to 0.
AUTOCOMMIT
-
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
-
If you precede the subquery by the ____ operator, the condition is true only if it satisfies all values produced by the subquery.
ALL
-
Which of the following set operators are not supported by MySQL?
MINUS and INTERSECT
-
The ____ of two tables is a table containing every row that is in either the first table, the second table, or both tables.
union
-
To make the same update for all rows in a table, omit the _____ clause.
WHERE
-
If you specified ____ for a column when you created a table, then changing a value in a column to null is prohibited.
NOT NULL
-
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
-
To qualify a column name, precede the name of the column with the name of the table, followed by a(n) _____.
period .
-
To change a column that currently rejects null values so that it accepts null values, use the ____ clause of the ALTER TABLE command.
MODIFY
-
In order to use the COMMIT command in MySQL, you need to change the value for AUTOCOMMIT to ____.
0
-
Retrieve data from two or more tables you should...
Join tables
-
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
-
you can join tables using:
- WHERE clause
- IN operator with a subquery
- EXISTS operator with a subquery
-
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
-
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
|
|
