Creating Database Objects

Question 1

Data Types

Answer 1

specifies the type of a piece of data and what can be done to it

Question 2

Integer

Answer 2

a whole number

Question 3

Float

Answer 3

any real number

Question 4

Character

Answer 4

Stores A-Z and 0-9

Question 5

Boolean

Answer 5

True or False, 1 or 0

Question 6

ANSI SQL

Answer 6

grammar and rules of structure and content of statements

Question 7

View

Answer 7

a saved query that creates a virtual table from the result of the query

Question 8

Query

Answer 8

Specific set of instructions

Question 9

Graphical Designer

Answer 9

object oriented, drag and drop application

Question 10

T-SQL

Answer 10

Transact SQL, Microsoft extension to SQL

Question 11

Functions

Answer 11

One word command that return a single value

Question 12

Aggregate Functions

Answer 12

return a single value, calculated from values in a column

Question 13

Scalar Functions

Answer 13

returns a single value based on the input value of a single field

Question 14

User-Defined Functions

Answer 14

Compact Segments of user written SQL code

Question 15

Stored Procedure

Answer 15

precompiled groups of SQL statements saved in a database