OMIS 452 Final Exam Questions and Answers

OMIS 452 Final Exam Questions and Answers

Save


Terms in this set (176)


The database management True
system (DBMS) is responsible
for inserting, modifying, reading,
and deleting data.


True
False

The purpose of a database is to True
help people keep track of
things.


True
False

A database is called "self- False
describing" because it reduces
data duplication.


True
False

,In a data warehouse, information False
is compiled, collected or pulled
only from internal sources.


True
False

The description of a database's True
structure that is stored within the
database itself is called the
"metadata."


True
False

In MS Access, SQL-92 (the False
industry standard for most
enterprise database systems) is
the default.


True
False

A database shows data in tables True
and the relationships among the
rows in those tables.


True
False

,Referential integrity constraints True
are rules about what data values
are allowed in certain columns.


True
False

In an SQL query, which SQL B. FROM
keyword is used to specify the
table(s) to be used?


A. EXISTS
B. FROM
C. SELECT
D. SET
E. WHERE

In an SQL query, which SQL B. IN
keyword is used to determine if
a column value is equal to any
one of a set of values?


A. OR
B. IN
C. HAVING
D. AND
E. EXISTS

, In an SQL query, which SQL D. ORDER BY
keyword is used to sort the
result table by the values in one
or more columns?


A. GROUP BY
B. SELECT
C. SORT BY
D. ORDER BY
E. WHERE

In an SQL query, which SQL E. HAVING
keyword is used with GROUP BY
to select groups meeting
specified criteria?


A. WHERE
B. IN
C. AND
D. EXISTS
E. HAVING