OMIS 452 FINAL EXAM QUESTIONS & ANSWERS
What is a database? - Answers - 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. - Answers - 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." - Answers - "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. -
Answers - False
SQL is a TLA (Three Letter Acronym). What do each of the letters in SQL stand for (ALL
letters MUST be correct)? - Answers - Structured Query Language
Identify and describe the basic framework of an SQL query (a.k.a. a properly formatted
query). - Answers - 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?
- Answers - 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
C) Microsoft SQL Server
D) IBM DB2 - Answers - B
This database component is used to maintain database accuracy and enforce data
constraints.
A) Stored procedures
B) Tables
C) Metadata
D) Triggers - Answers - 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 - Answers - C
Which of the following is not an XML Web service standard?
A) WSDL
B) UDDI
C) SOAP
D) Ethernet - Answers - D
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) - Answers - C
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 - Answers - B
Database professionals use ________ as specific data sources for studies and
analyses.
A) data models
, B) data marts
C) entity-relationship data modeling
D) normalization - Answers - B
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 - Answers - B
Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which
of the following would find all employees whose name begins with the letter "S" using
Microsoft Access?
A) SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S%';
B) SELECT *
FROM EMPLOYEE
WHERE Name IN ['S'];
C) SELECT EmpNo
FROM EMPLOYEE
WHERE Name LIKE 'S';
D) SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S*'; - Answers - D
When making an SQL query, we are using SQL as a(n) ________.
A) SET
B) embedded language
C) DDL
D) DML - Answers - D
SQL is a ________.
A) data definition language
B) data sublanguage
What is a database? - Answers - 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. - Answers - 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." - Answers - "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. -
Answers - False
SQL is a TLA (Three Letter Acronym). What do each of the letters in SQL stand for (ALL
letters MUST be correct)? - Answers - Structured Query Language
Identify and describe the basic framework of an SQL query (a.k.a. a properly formatted
query). - Answers - 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?
- Answers - 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
C) Microsoft SQL Server
D) IBM DB2 - Answers - B
This database component is used to maintain database accuracy and enforce data
constraints.
A) Stored procedures
B) Tables
C) Metadata
D) Triggers - Answers - 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 - Answers - C
Which of the following is not an XML Web service standard?
A) WSDL
B) UDDI
C) SOAP
D) Ethernet - Answers - D
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) - Answers - C
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 - Answers - B
Database professionals use ________ as specific data sources for studies and
analyses.
A) data models
, B) data marts
C) entity-relationship data modeling
D) normalization - Answers - B
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 - Answers - B
Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which
of the following would find all employees whose name begins with the letter "S" using
Microsoft Access?
A) SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S%';
B) SELECT *
FROM EMPLOYEE
WHERE Name IN ['S'];
C) SELECT EmpNo
FROM EMPLOYEE
WHERE Name LIKE 'S';
D) SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S*'; - Answers - D
When making an SQL query, we are using SQL as a(n) ________.
A) SET
B) embedded language
C) DDL
D) DML - Answers - D
SQL is a ________.
A) data definition language
B) data sublanguage
