Exam (elaborations)
ISA 245 Final Exam With 100% Correct And Verified Answers
- Course
- Institution
ISA 245 Final Exam With 100% Correct And Verified Answers
[Show more]
Content preview
ISA 245 Final Exam With 100% CorrectAnd Verified Answers
T/F- While creating a 'well-formed' database, functional
dependencies are identified before normalizing the tables -
Correct Answer-True
A relational database contains three entities - Correct
Answer-Customer, Order, and Product. The Customer is in
1NF, the Order is in 2NF, and the Product is in 3NF. What is
the normal form of the entire database?: 1NF
T/F- An entity in third normal form cannot have any
duplicate data - Correct Answer-False
T/F- Suppose the following dependency holds, (EmpID,
JobTitle) → Income, then, JobTitle alone can uniquely
determine Income - Correct Answer-False
T/F- Data Manipulation Language (DML) is used for
processing the data in a database using commands such as
INSERT, UPDATE, and DELETE - Correct Answer-True
Which data format can be used for storing values with two
decimal places in the PRICE attribute? - Correct Answer-
NUMBER(6,2)
T/F- Following command will show all the records of the
table ARTIST- DESCRIBE ARTIST - Correct Answer-
False
Vendarsol
,T/F- A CUSTOMER table contains a GENDER attribute
which can take only two values 'M' and 'F'. GENDER is the
ideal attribute for indexing - Correct Answer-False
T/F- User Tom gives the following privilege to user Jerry.
User Jerry is now able to update the attribute ProductPrice
in the PRODUCT table- GRANT SELECT ON
TOM.PRODUCT TO JERRY - Correct Answer-False
Why are operational data not useful for decision support
analysis? - Correct Answer-Operational data typically does
not contain historical data, Operational data is mostly
fragmented and inconsistent, and operational data does not
provide enterprise-wide view
T/F- The term ETL in data warehouse stands for Evaluate,
Track, and Leverage - Correct Answer-False
Which of the following is not an example of measure of fact
table? - Correct Answer-Patient Address
T/F- Snowflake schema is created when dimensions have
attribute hierarchy - Correct Answer-True
T/F- If you drill-down Product dimension from Department
to Category to Sub-Category to Brand then then you are
moving from coarsely granular data to finely granular data -
Correct Answer-True
Vendarsol
, MU wants to track the number of enrollments per course
number, per section for five years. MU created an OLAP
data cube with a measure and three dimensions. Which of
the following could be a side in the OLAP
cube? - Correct Answer-Years
T/F- Dimension models such as OLAP typically
are highly normalized - Correct Answer-False
T/F- Pivot operation of OLAP provides
alternate presentation of data by rotating the
OLAP cube - Correct Answer-True
Content - Correct Answer-
How to obtain "well-structured" data -
Correct Answer-Data redundancy causes data
anomalies. These are identified by functional
dependencies, which are removed by
normalization, and this leads to "well-
structured" data
Primary Key - Correct Answer-In the
relational model, an identifier composed of
one or more attributes that uniquely
identifies a row.
Key - Correct Answer-One or more attributes
that determine other attributes
Vendarsol
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 Vendarsol. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $19.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
67866 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now