100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
MIDTERM COP 4703 Questions with complete solution 2024 $13.49   Add to cart

Exam (elaborations)

MIDTERM COP 4703 Questions with complete solution 2024

 9 views  0 purchase
  • Course
  • COP
  • Institution
  • COP

MIDTERM COP 4703 Questions with complete solution 2024 MIDTERM COP 4703 1. Redundancy wastes space because you are storing different types of data in the same place. - correct answer False. Redundancy is data stored in different places not in the same place. 2. When you need to change da...

[Show more]

Preview 3 out of 27  pages

  • September 7, 2024
  • 27
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • COP
  • COP
avatar-seller
flyhigher329
MIDTERM COP 4703
1. Redundancy wastes space because you are storing different types of data
in the same place. - correct answer ✔False.
Redundancy is data stored in different places not in the same place.


2. When you need to change data, redundancy makes your changes more
cumbersome and time-consuming. - correct answer ✔TRUE


3. An entity is also defined as an attribute. - correct answer ✔False.
An entity is a person, place, object for which you want to store and process
data.


4. An attribute is a characteristic or property of an entity. - correct answer
✔TRUE


5. An attribute is known as a row in most databases. - correct answer
✔False.
Each column (attribute) contains describing characteristics of the rows. A
database attribute is a column name and the content of the fields under it in a
table in a database.


6. A database will not only hold information about multiple types of entities,
but also information about the relationships among these multiple entities. -
correct answer ✔TRUE


7. Each table in a database represents two or more entities. - correct answer
✔FALSE

,8. The relationship between different entities (in different tables) is handled by
their common columns. - correct answer ✔TRUE


9. Software packages, called database management systems, can do the job
of manipulating databases for you. - correct answer ✔TRUE


10. Programs created with Visual Basic, Java, Perl, PHP, or C++ can access
the database directly, rather than having to access it through the DBMS. -
correct answer ✔False
Only the DBMS actually access the database


11. To create forms to use with a database you must write a program. -
correct answer ✔FALSE


12. Sharing data is one advantage of database processing. - correct answer
✔TRUE


13. An advantage of using the database approach to processing is that it
facilitates consistency. - correct answer ✔TRUE


14. A DBA can assign passwords to prevent unauthorized users from
accessing the data. - correct answer ✔TRUE


15. There is a greater impact of failure in a nondatabase, file-oriented system.
- correct answer ✔False


16. Storing the same data in more than one place is called ___________ -
correct answer ✔redundancy

, 17. A(n)______________is also called a field or column in many database
systems. - correct answer ✔Attribute


18. A(n)__________ is a person, place, object, event, or idea for which you
want to store and process data. - correct answer ✔Entity


19. A(n) _____________ is the computer counterpart to an ordinary paper file
you might keep in a file cabinet or an accounting ledger. - correct answer
✔data file


20. The ____ of an entity become the columns in the database table. - correct
answer ✔Attributes


21. Unlike a typical data file, a database can store information about multiple
_________. - correct answer ✔Entities


22. A visual way to represent a database is with a(n) ____. - correct answer
✔Entity-relationship diagram


23. Popular _____________ include Access, Oracle, DB2, MySQL, and SQL
Server. - correct answer ✔Database Management Software


24. During the _______________ process, a database expert determines the
structure of the required database. - correct answer ✔Database design


25. __________are screen objects used to maintain, view, and print data from
a database. - correct answer ✔Forms

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

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

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

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 flyhigher329. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $13.49. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

67096 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$13.49
  • (0)
  Add to cart