Intro to Database Final.pdf 2026//2027!!
Intro to Database Final
Study online at https://quizlet.com/_hlqmnp
1. A (An) index is a separate physical data structure that True
enables queries to access one or more rows fast.
2. A view is a virtual object not stored mostly on a drive. True
3. The two types of SQL server authentication are Win- False
dows security and Database Engine security.
4. @@identity is an example of a local variable. False
5. To remove a row from a table use the DROP keyword. False
6. A DML trigger is used to specify actions that are per- True
formed automatically by the server when and INSERT,
UPDATE, or DELETE statement is executed.
7. An important function of handling data that is stored Backup
on a computer system is_______.
8. ________________ functions are functions that are used Aggregate, SUM, MAX,
to get summary values. VAR, STDEV
Examples are _________, __________, ___________,
_________.
9. USE sample; The SQL statement cre-
SELECT project_no, project_name ates a local temporary
INTO #project_temp1 table and populates it with
FROM project; the data from the project
table.
10. The JOIN operators can be: CROSS JOIN, INNER JOIN,
LEFT JOIN, RIGHT JOIN,
FULL JOIN
Page 1 of 12 9/15/2026, 7:27:11 AM
, Intro to Database Final.pdf 2026//2027!!
Intro to Database Final
Study online at https://quizlet.com/_hlqmnp
11. USE sample JOIN, ON
SELECT dept_no
FROM employee ___________ works_on1
________ employee. emp_no = works_on1.emp_no
WHERE enter_date = '10.15.2007'.
The missing words in the select statement that gets
the dept_no for all employees who entered their pro-
jects on October 15, 2007 are:
12. USE sample; The SQL statement in-
UPDATE project creases each budget by
SET budget = CASE (20, 10, or 5) % de-
WHEN budget > 0 and budget < 100000 THEN budget pending on its previous
*1.2 amount.
WHEN budget >= 100000 and budget < 200000 THEN
budget*1.1
ELSE budget*1.05
END
13. Generally, only three SQL statements ___________, INSERT, UPDATE, DELETE
___________, and __________ can be used to modify a
table.
14. A ______________ index determines the physical order of Clustered
the data in a table.
15. The Database Engine allows only one ______________ Clustered
index per table because the rows of the table cannot
be physically ordered more than one way.
16. A _________________ index is like the index in the back of Non-clustered
a book.
Page 2 of 12 9/15/2026, 7:27:11 AM
Intro to Database Final
Study online at https://quizlet.com/_hlqmnp
1. A (An) index is a separate physical data structure that True
enables queries to access one or more rows fast.
2. A view is a virtual object not stored mostly on a drive. True
3. The two types of SQL server authentication are Win- False
dows security and Database Engine security.
4. @@identity is an example of a local variable. False
5. To remove a row from a table use the DROP keyword. False
6. A DML trigger is used to specify actions that are per- True
formed automatically by the server when and INSERT,
UPDATE, or DELETE statement is executed.
7. An important function of handling data that is stored Backup
on a computer system is_______.
8. ________________ functions are functions that are used Aggregate, SUM, MAX,
to get summary values. VAR, STDEV
Examples are _________, __________, ___________,
_________.
9. USE sample; The SQL statement cre-
SELECT project_no, project_name ates a local temporary
INTO #project_temp1 table and populates it with
FROM project; the data from the project
table.
10. The JOIN operators can be: CROSS JOIN, INNER JOIN,
LEFT JOIN, RIGHT JOIN,
FULL JOIN
Page 1 of 12 9/15/2026, 7:27:11 AM
, Intro to Database Final.pdf 2026//2027!!
Intro to Database Final
Study online at https://quizlet.com/_hlqmnp
11. USE sample JOIN, ON
SELECT dept_no
FROM employee ___________ works_on1
________ employee. emp_no = works_on1.emp_no
WHERE enter_date = '10.15.2007'.
The missing words in the select statement that gets
the dept_no for all employees who entered their pro-
jects on October 15, 2007 are:
12. USE sample; The SQL statement in-
UPDATE project creases each budget by
SET budget = CASE (20, 10, or 5) % de-
WHEN budget > 0 and budget < 100000 THEN budget pending on its previous
*1.2 amount.
WHEN budget >= 100000 and budget < 200000 THEN
budget*1.1
ELSE budget*1.05
END
13. Generally, only three SQL statements ___________, INSERT, UPDATE, DELETE
___________, and __________ can be used to modify a
table.
14. A ______________ index determines the physical order of Clustered
the data in a table.
15. The Database Engine allows only one ______________ Clustered
index per table because the rows of the table cannot
be physically ordered more than one way.
16. A _________________ index is like the index in the back of Non-clustered
a book.
Page 2 of 12 9/15/2026, 7:27:11 AM
