OMIS 452 Quiz 2 (Ch.1/2) Exam Questions and Answers
100% Solved
3
Save
Practice questions for this set
Learn 1 /7 Study with Learn
Help people keep track of things
Choose an answer
Identify and describe the basic In an SQL query, which SQL keyword is
1 2
framework of an SQL query. used to implement a subquery?
The predecessor(s) of database According to the text, what is the
3 4
processing was (were) ________. purpose of a database?
Don't know?
, Terms in this set (23)
According to the text, what is Help people keep track of things
the purpose of a database?
The SQL SELECT clause specifies which columns are to be listed
in the query results.
Identify and describe the basic The SQL FROM clause specifies which tables are to be used in
framework of an SQL query. the query.
The SQL WHERE clause specifies which rows are to be listed in
the query results.
Create a properly formatted Select Vendor, Price
SQL Query which answers the From Stock
following question: Where Description Like '%FOO%'
What are the names of the And QOH > 0;
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?
A sales contact manager used single-user database application
by a salesperson is an example
of a(n) ________.
Which statement is not true It was developed at Oracle.
about the relational model?
100% Solved
3
Save
Practice questions for this set
Learn 1 /7 Study with Learn
Help people keep track of things
Choose an answer
Identify and describe the basic In an SQL query, which SQL keyword is
1 2
framework of an SQL query. used to implement a subquery?
The predecessor(s) of database According to the text, what is the
3 4
processing was (were) ________. purpose of a database?
Don't know?
, Terms in this set (23)
According to the text, what is Help people keep track of things
the purpose of a database?
The SQL SELECT clause specifies which columns are to be listed
in the query results.
Identify and describe the basic The SQL FROM clause specifies which tables are to be used in
framework of an SQL query. the query.
The SQL WHERE clause specifies which rows are to be listed in
the query results.
Create a properly formatted Select Vendor, Price
SQL Query which answers the From Stock
following question: Where Description Like '%FOO%'
What are the names of the And QOH > 0;
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?
A sales contact manager used single-user database application
by a salesperson is an example
of a(n) ________.
Which statement is not true It was developed at Oracle.
about the relational model?
