mis 431

Question 1

data

Answer 1

building blocks of information

Question 2

information

Answer 2

reveals meaning of data

Question 3

database’s house:

Answer 3

• end user data

- metadata

Question 4

database models

Answer 4

collection of logical constructs used to represent data structure & relationships within the database

Question 5

In

Answer 5

checks for the value in a set

Question 6

between

Answer 6

in the range

Question 7

BETWEEN

Answer 7

defines limits

Question 8

IS NULL

Answer 8

checks for nulls

Question 9

LIKE

Answer 9

checks for similar string

Question 10

IN

Answer 10

checks for value in a set

Question 11

EXISTS

Answer 11

opposite of ‘IS NULL’

Question 12

information

Answer 12

reveals meaning of data

Question 13

database’s house:

Answer 13

• end user data

- metadata

Question 14

Database Management Systems

Answer 14

• Manage database structure
• controls access to data
• contains query language

Question 15

poor database design

Answer 15

results in unwanted data redundancy

Question 16

rollback command

Answer 16

restores database back to previous condition if COMMIT hasn’t been used

Question 17

order by

Answer 17

groups the data as a single summary row

(be at the end of the query)

Question 18

Having clause

Answer 18

provides a condition that is applied to each group of entities (as created by the GROUP BY), & only the groups that satisfy the condition are kept (after GROUP BY)

Question 19

self join

Answer 19

compares different data in same query. Must rename tables

Question 20

union

Answer 20

is the output of multiple queries

Question 21

VIEW

Answer 21

relation that you define based on the underlying relations available to you in your database schema

Question 22

DISTINCT

Answer 22

must not be specified

Question 23

end user data

Answer 23

• data provided by a data warehouse

- data created by end users for query processing

Question 24

metadata

Answer 24

data that describes and summarizes basic info about other data

Question 25

conceptual models

Answer 25

logical nature of data representation

Question 26

primary key

Answer 26

identifies each record in a database

Question 27

referential integrity

Answer 27

multiple tables share a relationship based on the data stored in the tables if they have a relationship

Question 28

select statemen

Answer 28

allows table contents to be listed

Question 29

commit command

Answer 29

saves changes to a disk

Answer 30

less than

Question 31

> =

Answer 31

greater than

Question 32

where

Answer 32

filters out entities from a relation

Question 33

view table

Answer 33

virtual table based on the result of actual data you have

Question 34

subquery

Answer 34

query that is inside a SELECT statement