(Answered) CIST 1220 Final Review: CIST 1220 SQL -
Gwinnett Technical College.
WHERE
You can join tables by using a condition in the ____ clause.
period (.)
To qualify a column name, precede the name of the column with the name of the table,
followed by a(n) ____.
IN
To retrieve data from multiple tables in a query you can use the ____ operator with a
subquery.
EXISTS
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.
correlated
When a subquery involves a table listed in the outer query, the subquery is called a(n)
____ subquery.
SELECT
A(n) ____ clause can include statistics calculated for only the groups or columns whose
values are identical for each row in a group
Spacebar
You create an alias by typing the name of the table, pressing the ____, and then typing
the name of the alias.
union
The ____ of two tables is a table containing every row that is in either the first table, the
second table, or both tables
intersect
The ____ of two tables is a table containing all rows that are in both tables.
difference
The ____ of two tables is the set of all rows that are in the first table but that are not in
the second table.
union
Two tables are ____ compatible if they have the same number of columns and if their
corresponding columns have identical data types and lengths
duplicate
For an SQL implementation to truly support the union operation, it must remove ____
rows automatically.
INTERSECT
Oracle and SQL Server support the ____ operator but Microsoft Access does not
ALL
If you precede the subquery by the ____ operator, the condition is true only if it satisfies
all values produced by the subquery
ANY
, 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.
inner
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?
full outer
In a(n) ____ join, all rows from both tables are included regardless of whether they
match rows from the other table.
left outer join
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).
right outer join
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
Cartesian
The product of two tables is formally called the ____ Product
DECIMAL
Access does not support the ____ data type
CREATE TABLE
You can use the ____ command to create a new table using data in an existing table
UPDATE
To change rows for which a specific condition is true, use the ____ command
INSERT
To add data from an existing table to a new table, use a SELECT command in a(n)
____ command
COMMIT
If you have verified that the update you made is correct, you can use the ____
command to make the update permanent
ROLLBACK
If you have not run the COMMIT command, executing the ____ command will reverse
all updates made during the current work session
Autocommit
In order to use the COMMIT command in Oracle, you need to clear the check mark from
the ____ check box.
Autocommit
____ is the default transaction mode in Oracle and commits each action query as soon
as the user executes the query
ROLLBACK;
Which of the following commands executes a rollback?
COMMIT;
Which of the following is a valid SQL command?
COMMIT
The ____ command is permanent
transaction
A(n) ____ can be viewed as a sequence of steps that accomplishes a single task.
Gwinnett Technical College.
WHERE
You can join tables by using a condition in the ____ clause.
period (.)
To qualify a column name, precede the name of the column with the name of the table,
followed by a(n) ____.
IN
To retrieve data from multiple tables in a query you can use the ____ operator with a
subquery.
EXISTS
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.
correlated
When a subquery involves a table listed in the outer query, the subquery is called a(n)
____ subquery.
SELECT
A(n) ____ clause can include statistics calculated for only the groups or columns whose
values are identical for each row in a group
Spacebar
You create an alias by typing the name of the table, pressing the ____, and then typing
the name of the alias.
union
The ____ of two tables is a table containing every row that is in either the first table, the
second table, or both tables
intersect
The ____ of two tables is a table containing all rows that are in both tables.
difference
The ____ of two tables is the set of all rows that are in the first table but that are not in
the second table.
union
Two tables are ____ compatible if they have the same number of columns and if their
corresponding columns have identical data types and lengths
duplicate
For an SQL implementation to truly support the union operation, it must remove ____
rows automatically.
INTERSECT
Oracle and SQL Server support the ____ operator but Microsoft Access does not
ALL
If you precede the subquery by the ____ operator, the condition is true only if it satisfies
all values produced by the subquery
ANY
, 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.
inner
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?
full outer
In a(n) ____ join, all rows from both tables are included regardless of whether they
match rows from the other table.
left outer join
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).
right outer join
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
Cartesian
The product of two tables is formally called the ____ Product
DECIMAL
Access does not support the ____ data type
CREATE TABLE
You can use the ____ command to create a new table using data in an existing table
UPDATE
To change rows for which a specific condition is true, use the ____ command
INSERT
To add data from an existing table to a new table, use a SELECT command in a(n)
____ command
COMMIT
If you have verified that the update you made is correct, you can use the ____
command to make the update permanent
ROLLBACK
If you have not run the COMMIT command, executing the ____ command will reverse
all updates made during the current work session
Autocommit
In order to use the COMMIT command in Oracle, you need to clear the check mark from
the ____ check box.
Autocommit
____ is the default transaction mode in Oracle and commits each action query as soon
as the user executes the query
ROLLBACK;
Which of the following commands executes a rollback?
COMMIT;
Which of the following is a valid SQL command?
COMMIT
The ____ command is permanent
transaction
A(n) ____ can be viewed as a sequence of steps that accomplishes a single task.
