Chapter 3 Database Administration

Front 1

Definition

Back 1

Term

Front 2

return all rows from one table along with all rows from the other table. WHERE conditions should always be included.

Back 2

Cross Join

Front 3

eliminates individual or groups of rows from the table.

Back 3

delete

Front 4

clause returns any distinct values not found on both the left and right sides of this operand.

Back 4

INTERSECT

Front 5

combine columns from 2 different tables.

Back 5

join

Front 6

does not allow deletion of tables unless all of the related tables are deleted using a cascading delete; helps prevent the accidental deletion of entire tables.

Back 6

referential integrity

Front 7

Name 3 elements of a SELECT QUERY

Back 7

what columns to retrieve, what tables to retrieve them from, and what conditions, if any, the data must satisfy.

Front 8

Inserting a simple begin tran before an actual SQL statement is a good place to start, and if you have executed everything correctly, a COMMIT statement is issued from SQL. If there is an error in any of the statements, a ROLLBACK is issued from SQL.

Back 8

transactions

Front 9

statement removes data from within a table but leaves the table structure in place for future use.

Back 9

TRUNCATE

Front 10

clause returns any distinct values from the left query that are not also found on the right query,

Back 10

EXCEPT

Front 11

occurs when you define more than one column as your primary key

Back 11

composite primary key

Front 12

One important feature of SQL Server is its automatic creation of a clustered index when the primary key is defined for a table; a clustered index is a physical construct, unlike most indexes, which are logical or software-based. Defines how the data will be sorted inside of a table

Back 12

clustered index

Front 13

The number and order of the columns must be the same in all queries and the data types must be compatible.

Back 13

Name 2 requirements of EXCEPT & INTERSECT

Front 14

removes all rows from a table.

Back 14

DROP TABLE

Front 15

What happens at this juncture is that you would verify that what you did really did happen and then issue a __________ statement to save those changes, or else issue a ___________ to undo them.

Back 15

COMMITT, ROLLBACK