Exam (elaborations)
OMIS 452 FINAL EXAM (Study Guide) questions well answered to pass
- Course
- Institution
OMIS 452 FINAL EXAM (Study Guide) questions well answered to pass
[Show more]
Content preview
OMIS 452 FINAL EXAM (Study Guide)What is a database? - correct answer ✔✔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. - correct answer ✔✔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." -
correct 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.
T or F:
The database project is completely contrived and has no bearing on the real-world. - correct answer
✔✔False
SQL is a TLA (Three Letter Acronym). What do each of the letters in SQL stand for (ALL letters MUST be
correct)? - correct answer ✔✔Structured Query Language
Identify and describe the basic framework of an SQL query (a.k.a. a properly formatted query). - correct
answer ✔✔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? - correct answer ✔✔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 - correct answer ✔✔B
This database component is used to maintain database accuracy and enforce data constraints.
A) Stored procedures
B) Tables
C) Metadata
D) Triggers - correct answer ✔✔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 - correct answer ✔✔C
Which of the following is not an XML Web service standard?
A) WSDL
B) UDDI
C) SOAP
D) Ethernet - correct answer ✔✔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) - correct answer ✔✔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 - correct answer ✔✔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 - correct answer ✔✔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 - correct answer ✔✔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 *
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller BravelRadon. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $19.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
82191 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now