(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.
Voordelen van het kopen van samenvattingen bij Stuvia op een rij:
√ Verzekerd van kwaliteit door reviews
Stuvia-klanten hebben meer dan 700.000 samenvattingen beoordeeld. Zo weet je zeker dat je de beste documenten koopt!
Snel en makkelijk kopen
Je betaalt supersnel en eenmalig met iDeal, Bancontact of creditcard voor de samenvatting. Zonder lidmaatschap.
Focus op de essentie
Samenvattingen worden geschreven voor en door anderen. Daarom zijn de samenvattingen altijd betrouwbaar en actueel. Zo kom je snel tot de kern!
Veelgestelde vragen
Wat krijg ik als ik dit document koop?
Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.
Tevredenheidsgarantie: hoe werkt dat?
Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.
Van wie koop ik deze samenvatting?
Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper LectDan. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor €10,90. Je zit daarna nergens aan vast.
