OMIS 452 Quiz 2 (Ch.1/2) Exam
Questions and Answers 100% Solved
According to the text, what is the purpose of a database? - 🧠 ANSWER
✔✔Help people keep track of things
Identify and describe the basic framework of an SQL query. - 🧠 ANSWER
✔✔The SQL SELECT clause specifies which columns are to be listed in
the query results.
The SQL FROM clause specifies which tables are to be used in the query.
The SQL WHERE clause specifies which rows are to be listed in the query
results.
Create a properly formatted SQL Query which answers the following
question:
, What are the names of the Vendor and the Price from Stock table which
have a Description containing the word FOO and where the Quantity On
Hand (QOH) is greater than zero? - 🧠 ANSWER ✔✔Select Vendor, Price
From Stock
Where Description Like '%FOO%'
And QOH > 0;
A sales contact manager used by a salesperson is an example of a(n)
________. - 🧠 ANSWER ✔✔single-user database application
Which statement is not true about the relational model? - 🧠 ANSWER ✔✔It
was developed at Oracle.
The predecessor(s) of database processing was (were) ________. - 🧠
ANSWER ✔✔file managers
Database professionals use ________ as specific data sources for studies
and analyses - 🧠 ANSWER ✔✔data marts
For database development, a challenge to the relational model and the use
of SQL is known as ________. - 🧠 ANSWER ✔✔the NoSQL movement
Questions and Answers 100% Solved
According to the text, what is the purpose of a database? - 🧠 ANSWER
✔✔Help people keep track of things
Identify and describe the basic framework of an SQL query. - 🧠 ANSWER
✔✔The SQL SELECT clause specifies which columns are to be listed in
the query results.
The SQL FROM clause specifies which tables are to be used in the query.
The SQL WHERE clause specifies which rows are to be listed in the query
results.
Create a properly formatted SQL Query which answers the following
question:
, What are the names of the Vendor and the Price from Stock table which
have a Description containing the word FOO and where the Quantity On
Hand (QOH) is greater than zero? - 🧠 ANSWER ✔✔Select Vendor, Price
From Stock
Where Description Like '%FOO%'
And QOH > 0;
A sales contact manager used by a salesperson is an example of a(n)
________. - 🧠 ANSWER ✔✔single-user database application
Which statement is not true about the relational model? - 🧠 ANSWER ✔✔It
was developed at Oracle.
The predecessor(s) of database processing was (were) ________. - 🧠
ANSWER ✔✔file managers
Database professionals use ________ as specific data sources for studies
and analyses - 🧠 ANSWER ✔✔data marts
For database development, a challenge to the relational model and the use
of SQL is known as ________. - 🧠 ANSWER ✔✔the NoSQL movement
