OMIS 452 Final Exam Questions and Answers
Save
3
Terms in this set (100)
In the general division of labor False
between database applications
and the DBMS, the processing
of forms is considered a DBMS
task.
True False
By separating data into tables True
containing data on only one
theme each, making changes to
the data is simplified.
True False
,The statement SQL
SELECT
STUDENT.StudentNumber,
STUDENT.StudentName,
FROM STUDENT
WHERE
STUDENT.StudentNumber =
S12345678;
is an example of ________.
QBE
Java
C++
QLE
SQL
Theoretically, databases could TRUE
store instances in columns and
characteristics in rows, instead
of the other way around.
True False
Microsoft Access 2016 FALSE
databases are stored using the
file extension .accdb.
True False
,A possible problem with TRUE
keeping data in lists is that if you
delete a row of data from a list,
you may also delete some data
items that you want to keep.
True False
The default file format for Access 2007 format
Microsoft Access 2016 database
files is the ________.
Access XP format
Access 2007 format
SQL Server format
Access 2003 format
XBD format
, Microsoft Access is a personal the DBMS product taking the role of the DBMS and the database
database system, and a personal application generator
database system is
characterized by ________.
the DBMS product being limited
to a maximum of ten tables in
any given database
the DBMS not supporting
indexes
the DBMS removing the
metadata from the database
the database being stored
inside the DBMS
the DBMS product taking the
role of the DBMS and the
database application generator
Save
3
Terms in this set (100)
In the general division of labor False
between database applications
and the DBMS, the processing
of forms is considered a DBMS
task.
True False
By separating data into tables True
containing data on only one
theme each, making changes to
the data is simplified.
True False
,The statement SQL
SELECT
STUDENT.StudentNumber,
STUDENT.StudentName,
FROM STUDENT
WHERE
STUDENT.StudentNumber =
S12345678;
is an example of ________.
QBE
Java
C++
QLE
SQL
Theoretically, databases could TRUE
store instances in columns and
characteristics in rows, instead
of the other way around.
True False
Microsoft Access 2016 FALSE
databases are stored using the
file extension .accdb.
True False
,A possible problem with TRUE
keeping data in lists is that if you
delete a row of data from a list,
you may also delete some data
items that you want to keep.
True False
The default file format for Access 2007 format
Microsoft Access 2016 database
files is the ________.
Access XP format
Access 2007 format
SQL Server format
Access 2003 format
XBD format
, Microsoft Access is a personal the DBMS product taking the role of the DBMS and the database
database system, and a personal application generator
database system is
characterized by ________.
the DBMS product being limited
to a maximum of ten tables in
any given database
the DBMS not supporting
indexes
the DBMS removing the
metadata from the database
the database being stored
inside the DBMS
the DBMS product taking the
role of the DBMS and the
database application generator
