OMIS 452 FINAL EXAM (Study Guide) Questions with Correct
Answers (Grade A+)
Question 1: 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.
Question 2: T or F: Databases are rarely used in the real world.
Answer: False
Question 3: 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.
Question 4: T or F: The database project is completely contrived and has no bearing on the
real-world.
Answer: False
Question 5: 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
Question 6: Identify and describe the basic framework of an SQL query (a.k.a. a properly formatted
query).
Answer: Select Columns From Table Where Conditions;
Question 7: 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;
Question 8: Which of the following database systems is not enterprise-class? A) Oracle Database B)
Page 1
, Microsoft Access C) Microsoft SQL Server D) IBM DB2
Answer: B
Question 9: This database component is used to maintain database accuracy and enforce data
constraints. A) Stored procedures B) Tables C) Metadata D) Triggers
Answer: D
Question 10: 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
Question 11: Which of the following is not an XML Web service standard? A) WSDL B) UDDI C)
SOAP D) Ethernet
Answer: D
Question 12: The industry standard supported by all major DBMSs that allows tables to be joined
together is called____ _. A) Sequential Query Language (SQL) B) Standard Question Language
(SQL) C) Structured Query Language (SQL) D) Structured Question Language (SQL)
Answer: C
Question 13: A sales contact manager used by a salesperson is an example of a(n) _____. A)
e-commerce database application B) single-user database application C) data mining application D)
multiuser database application
Answer: B
Question 14: Database professionals use _ ___ as specific data sources for studies and analyses. A)
data models B) data marts C) entity-relationship data modeling D) normalization
Answer: B
Question 15: In an SQL query, which built-in function is used to compute the number of rows in a
table? A) MAX B) COUNT C) AVG D) SUM
Answer: B
Question 16: Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate),
Page 2
Answers (Grade A+)
Question 1: 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.
Question 2: T or F: Databases are rarely used in the real world.
Answer: False
Question 3: 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.
Question 4: T or F: The database project is completely contrived and has no bearing on the
real-world.
Answer: False
Question 5: 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
Question 6: Identify and describe the basic framework of an SQL query (a.k.a. a properly formatted
query).
Answer: Select Columns From Table Where Conditions;
Question 7: 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;
Question 8: Which of the following database systems is not enterprise-class? A) Oracle Database B)
Page 1
, Microsoft Access C) Microsoft SQL Server D) IBM DB2
Answer: B
Question 9: This database component is used to maintain database accuracy and enforce data
constraints. A) Stored procedures B) Tables C) Metadata D) Triggers
Answer: D
Question 10: 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
Question 11: Which of the following is not an XML Web service standard? A) WSDL B) UDDI C)
SOAP D) Ethernet
Answer: D
Question 12: The industry standard supported by all major DBMSs that allows tables to be joined
together is called____ _. A) Sequential Query Language (SQL) B) Standard Question Language
(SQL) C) Structured Query Language (SQL) D) Structured Question Language (SQL)
Answer: C
Question 13: A sales contact manager used by a salesperson is an example of a(n) _____. A)
e-commerce database application B) single-user database application C) data mining application D)
multiuser database application
Answer: B
Question 14: Database professionals use _ ___ as specific data sources for studies and analyses. A)
data models B) data marts C) entity-relationship data modeling D) normalization
Answer: B
Question 15: In an SQL query, which built-in function is used to compute the number of rows in a
table? A) MAX B) COUNT C) AVG D) SUM
Answer: B
Question 16: Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate),
Page 2
