. Redundancy wastes space because you are storing multiple copies of the same data.
a.
True
b.
False
ANSWER:
POINTS:
1
DIFFICULTY:
Easy
REFERENCES:
BITS Company Background
2. Redundancy makes changing data more cumbersome and time-consuming.
3. An entity is a person, place, object, event, or idea for which you want to store and process data.
Database Terminology
4. A client is an example of an attribute.
5. An attribute is known as a row in most databases.
6. A database will not only hold information about multiple types of entities, but also information about the relationships among these multiple entities.
Storing Data
7. Each table in a database represents two or more entities.
8. The relationship between different entities (in different tables) is handled by their common columns.
9. Users never interact with a database directly; database interaction is always through the DBMS.
Moderate
Database Management Systems
10. Programs created with Visual Basic, Java, Perl, PHP, or C++ can interact with the database directly.
11. A spreadsheet is a screen object used to maintain and view data from a database.
12. Increased complexity is one advantage of database processing.
Advantages of Database Processing
13. An advantage of using the database approach to processing is that it facilitates consistency.
14. If a user is authorized to access database data, the user will always be able to make changes to the data.
15. There is a greater impact of failure in a nondatabase, file-oriented system.
Disadvantages of Database Processing
16. Which term can be described as the duplication of data and storing it in multiple locations?
data independence
redundancy
c.
data integrity
d.
security
b
17. Which of the following is called a field or column in many database systems?
attribute
entity
data file
relationship
a
18. Which database term is a person, place, object, event, or idea for which you want to store and process data?
DBMS
DBA
c
19. In database terms, what is the analogy to an ordinary paper file you might keep in a file cabinet or an accounting ledger?
database
spreadsheet
20. Which aspect of an entity becomes the columns in the database table?
attributes
relationships
data files
E-R diagrams
21. How are multiple entities stored in a database?
each entity is stored as a row
each entity is stored as an attribute
each entity is stored as a table
each entity is stored as a column
22. What tool can you use to visually represent and analyze a database?
multi-sheet workbook
DBMS table identifier
entity-relationship diagram
DBA column analyzer
23. What type of software programs are Access, Oracle, DB2, MySQL, and SQL Server?
DBAs
DBMSs
d
24. During which process does a database expert determine the structure of the required database?
data security
database integrity
database design
database selection
25. Which of the following are screen objects used to maintain, view, and print data from a database?
Fields
Forms
Data files
Entities
26. Which of the following statements is correct?
In a nondatabase, file-oriented environment, data is often partitioned into several disjointed systems with each system having its own collection of files.
User data cannot be combined and shared among authorized users.
Database users should not have access to the same information.
Controlling redundancy is easier with the nondatabase approach.
27. Which type of rule ensures that changes made to the database do not result in a loss of data consistency?
redundancy constraint
integrity constraint
conflict requirement
security requirement
28. How does the use of a database facilitate data consistency?
by controlling redundancy
by reducing security
by eliminating integrity constraints
by providing data independence
29. Which advantage of database processing makes it easier to make a change in the database structure?
integrity constraints
redundancy control
security controls
30. Which advantage of using a DBMS frees programmers who write database access programs from having to engage in mundane data manipulation activities, such as adding new data and deleting existing data?
controlling redundancy
referential integrity
increased productivity
31. Which factor can mitigate the problems of increased complexity that come with using a DBMS?
writing complex access rules
using large file sizes
sound database design
using no integrity constraints
32. Which of the following is true about big data?
unstructured big data doesn't contain metadata
a Twitter tweet is an example of structured big data
all big data can be handled with traditional DBMS tools
big data may be structured or unstructured
Big Data
33. What should an administrator use to more easily assign database access permissions to multiple users?
groups
classes
clusters
34. Which database property lets you change the structure of the database without requiring you to change the programs that access the database?
data dependence
Difficult
35. Which of the following is considered a disadvantage of a database system?
a larger file size
reduced integrity
reduced productivity
36. In a(n) ____________________ relationship between two entities, an entity is associated with multiple other entities such as when a consultant is associated with multiple clients.
one-to-many
37. A program, or collection of programs, through which users interact with a database is known as a(n)_________________________ management system.
38. In an E-R diagram rectangles represent _________________________.
entities
39. In an E-R diagram, lines represent _________________________ between connected entities.
40. _________________________ describes the large volume of data produced by every digital process, system, sensor, mobile device, and even social media exchange.
Big data
41. A good DBMS provides data _________________________, which is a property that lets you change the structure of a database without requiring you to change the programs that access the database.
independence
42. The problem of inconsistency in data is a direct result of ____________________.
43. ____________________ integrity is a relational database concept stating that table relationships must be consistent and follow integrity constraints.
Referential
44. _________________________ data is not organized or easily interpreted by traditional databases or data models.
Unstructured
45. A database file requires a large amount of disk space and internal ____________________.
memory
46. List the advantages of database processing.
Getting more information from the same amount of dataSharing dataBalancing conflicting requirementsControlling redundancyFacilitating consistencyImproving integrityExpanding securityIncreasing productivityProviding data independence
47. Explain why it is better to try to control redundancy rather than eliminate it.
Although eliminating redundancy is the ideal, it is not always possible. Sometimes, for reasons having to do with performance, you might choose to introduce a limited amount of redundancy into a database. However, even in these cases, you would be able to keep the redundancy under tight control, thus obtaining the same advantages. This is why it is better to say that you control redundancy rather than eliminate it.
48. Discuss how the database approach and the nondatabase approach differ in terms of ensuring the security of the database.
A DBMS has many features that help ensure the enforcement of security measures. For example, a DBA can assign passwords to authorized users; then only those users who enter an acceptable password can gain access to the data in the database. Further, a DBMS lets you assign users to groups, with some groups permitted to view and update data in the database and other groups permitted only to view certain data in the database. With the nondatabase approach, you have limited security features and are more vulnerable to intentional and accidental access and changes to data.
49. List the disadvantages of database processing.
Larger file sizeIncreased complexityGreater impact of failureMore difficult recovery
50. Explain why the impact of failure is greater in database processing, compared with the nondatabase approach.
In a nondatabase, file-oriented system, each user has a completely separate system; the failure of any single user's system does not necessarily affect any other user. On the other hand, if several users are sharing the same database, a failure on the part of any one user that damages the database in some way might affect all the other users.
This product has run out of stock. You may send us an inquiry about it.
This product is currently unavailable. You may send us an inquiry about it.
