(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...
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.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller LectDan. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.49. You're not tied to anything after your purchase.
