I have compiled final exam for IS361 Data Management Cocnepts Park University so that students can have an idea what types of questions will come in the final exam. This exam is specially for those who have secured less marks throughout the semester. Just avail this opportunity download it and boom...
1. A disadvantage of database management systems is the redundancy of data.
a. True
b. False
Answer: b
2. A set of tables could be in 2NF, but not in 1NF at the same time.
a. True
b. False
Answer: b
3. An un-normalized database model cannot be implemented in a database management
system.
a. True
b. False
Answer: b
4. Data warehouses can be used for managerial decisions as well as day-to-day business
operation in a company.
a. True
b. False
Answer: a
5. A client’s computer runs an application as a “thin” client if it loads most of the application
software inside the client’s computer, but it streamlines the processes to use fewer
resources.
a. True
b. False
Answer: a
6. Transforming data to fit requirements of a data warehouse is not part of the ETL process.
a. True
b. False
Answer: b
7. Metadata is data that goes beyond current data and is used for prescriptive analytics in big
data.
a. True
b. False
Answer: b
8. Primary keys in tables are never indexed because they are always in order.
a. True
b. False
Answer: b
9. NoSQL is only used when one does not want to use concerned with data that cannot be
accessed using SQL.
a. True
b. False
, Answer: a
10. A relationship that has attributes on its own can be represented in an ERD with a(n):
Weak entity
Ternary relationship
Associative entity
Answer: Ternary relationship
11. A flat file on paper with a list of students and their grades is an example of a:
Sequential file
Indexed file
Hashed file
Answer: Sequential file
12. A database has a laptop table with records for 20 laptops. Each one of these laptops is
assigned to only one and distinct user from a User table that also has 20 users. The
database is queried with the following command:
SELECT * FROM Laptops, Users;
How many records will this select command produce?
Less than 20
Exactly 20
More than 20
Answer: More than 20
13. The following are techniques to control data integrity in a database, EXECPT
Enforcing the use of data types in fields
Not allowing null values in fields that are part of primary keys
Not allowing null values in fields that reference foreign keys
Enforcing ranges of values in fields
Answer: Field < file < record
14. From the smallest to the largest piece of data which of the following is the correct order?
File < record < field
Field < record < file
Record < field < file
Field < file < record
Answer: Field < record < file
15. The following are types of attributes for entities in an ERD, EXCEPT:
Composite
Associative
Partial identifier
Derived
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 waseemikram. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $18.99. You're not tied to anything after your purchase.