OMIS 452 FINAL EXAM (Study Guide)
Questions and Answers 100% Solved
What is a database? - 🧠 ANSWER ✔✔A database is a complied set of data
or information contained with a system to assist in finding solutions to
problems.
T or F:
Databases are rarely used in the real world. - 🧠 ANSWER ✔✔False
Briefly describe the concept of "WHY" as defined in the video "Start with
why" shown during the first week of class. If you were NOT present when
the video was shown, simply answer "Not Present." - 🧠 ANSWER
✔✔"WHY" is a different way of thinking most people think and do outside
,within, whereas this video showed that if you think and do inside and then
out you will start with "WHY" and understand fully why you are doing
something and the goals of such act, then there is HOW and WHAT which
most people start with instead of actually understanding why it is important
and why it matters.
T or F:
The database project is completely contrived and has no bearing on the
real-world. - 🧠 ANSWER ✔✔False
SQL is a TLA (Three Letter Acronym). What do each of the letters in SQL
stand for (ALL letters MUST be correct)? - 🧠 ANSWER ✔✔Structured
Query Language
Identify and describe the basic framework of an SQL query (a.k.a. a
properly formatted query). - 🧠 ANSWER ✔✔Select Columns
From Table
,Where Conditions;
Create a properly formatted SQL Query which answers the following
question:
What are the VendorNames and Prices from Stock table which have a
Description containing the word FOO and where the Quantity On Hand
(QOH) is greater than zero? - 🧠 ANSWER ✔✔Select VendorNames, Prices
From Stock
Where Description = 'FOO'
And QOH > 0;
Which of the following database systems is not enterprise-class?
A) Oracle Database
B) Microsoft Access
COPYRIGHT©PROFFKERRYMARTIN 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE.
PRIVACY STATEMENT. ALL RIGHTS RESERVED
, C) Microsoft SQL Server
D) IBM DB2 - 🧠 ANSWER ✔✔B
This database component is used to maintain database accuracy and
enforce data constraints.
A) Stored procedures
B) Tables
C) Metadata
D) Triggers - 🧠 ANSWER ✔✔D
Which statement is not true about the relational model?
A) It was first proposed in 1970.
B) It resulted in the DBMS product DB2.
C) It was developed at Oracle.
D) It was developed by E. F. Codd - 🧠 ANSWER ✔✔C
Which of the following is not an XML Web service standard?
Questions and Answers 100% Solved
What is a database? - 🧠 ANSWER ✔✔A database is a complied set of data
or information contained with a system to assist in finding solutions to
problems.
T or F:
Databases are rarely used in the real world. - 🧠 ANSWER ✔✔False
Briefly describe the concept of "WHY" as defined in the video "Start with
why" shown during the first week of class. If you were NOT present when
the video was shown, simply answer "Not Present." - 🧠 ANSWER
✔✔"WHY" is a different way of thinking most people think and do outside
,within, whereas this video showed that if you think and do inside and then
out you will start with "WHY" and understand fully why you are doing
something and the goals of such act, then there is HOW and WHAT which
most people start with instead of actually understanding why it is important
and why it matters.
T or F:
The database project is completely contrived and has no bearing on the
real-world. - 🧠 ANSWER ✔✔False
SQL is a TLA (Three Letter Acronym). What do each of the letters in SQL
stand for (ALL letters MUST be correct)? - 🧠 ANSWER ✔✔Structured
Query Language
Identify and describe the basic framework of an SQL query (a.k.a. a
properly formatted query). - 🧠 ANSWER ✔✔Select Columns
From Table
,Where Conditions;
Create a properly formatted SQL Query which answers the following
question:
What are the VendorNames and Prices from Stock table which have a
Description containing the word FOO and where the Quantity On Hand
(QOH) is greater than zero? - 🧠 ANSWER ✔✔Select VendorNames, Prices
From Stock
Where Description = 'FOO'
And QOH > 0;
Which of the following database systems is not enterprise-class?
A) Oracle Database
B) Microsoft Access
COPYRIGHT©PROFFKERRYMARTIN 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE.
PRIVACY STATEMENT. ALL RIGHTS RESERVED
, C) Microsoft SQL Server
D) IBM DB2 - 🧠 ANSWER ✔✔B
This database component is used to maintain database accuracy and
enforce data constraints.
A) Stored procedures
B) Tables
C) Metadata
D) Triggers - 🧠 ANSWER ✔✔D
Which statement is not true about the relational model?
A) It was first proposed in 1970.
B) It resulted in the DBMS product DB2.
C) It was developed at Oracle.
D) It was developed by E. F. Codd - 🧠 ANSWER ✔✔C
Which of the following is not an XML Web service standard?
