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