CIS111 Week 2 Quiz with complete solutions

In an automobile manufacturing company, an object about which we might want to maintain data could be any of the following, except _____. - ANSWER a length A single piece of data is _____ the business environment. - A ...

In an automobile manufacturing company, an object about which we might want to maintain data could be any of the following, except _____. - ANSWER a length A single piece of data is _____ the business environment. - ANSWER a fact about An entity is _____ in the business environment. - ANSWER an object or event An entity set is _____. - ANSWER a collection of entities of the same type An attribute is _____. - ANSWER a characteristic of an entity Which of the following is a description of a particular entity? - ANSWER record occurrence Which of the following is a collection of descriptions of the entities in an entity set? - ANSWER file Which of the following is the unique identifier of an entity? - ANSWER key How many entities are described in the Course file? - ANSWER 5 In the Course file, the string "ENGL2540 Shakespeare 3 Duncan" can best be described as a _____. - ANSWER record occurrence In the Course file, the string "Anatomy" can best be described as a _____. - ANSWER field occurrence Each of the following is one of the fundamental operations that can be performed on stored data, EXCEPT_____. - ANSWER converge Which of the following does NOT change the contents of a file? - ANSWER retrieve Retrieving the records of a file in order based on a set of field values is referred to as _____. - ANSWER logical sequential retrieval Retrieving the records of a file in order based on the order in which they are stored on a disk is referred to as _____. - ANSWER physical sequential retrieval Retrieving a single record of a file based on a field value is an example of _____. - ANSWER direct retrieval Retrieving a subset of the records of a file based on a field value is an example of _____. - ANSWER direct retrieval Prior to the development of the database concept, redundant data ____. - ANSWER Could be found within individual files and across multiple files Prior to the development of the database concept ____. - ANSWER data was not regularly shared among applications All of the following are basic principles of the database concept, EXCEPT _____. - ANSWER maintaining redundant data that does not cause data integrity problems Which of the following is a basic principle of the database concept? - ANSWER The ability to achieve data integration without introducing redundant data. All of the following are corporate resources, EXCEPT _____. - ANSWER competitors Data integration _____. - ANSWER is the ability to tie together pieces of related data in an information system Which of the following is true? - ANSWER Data integration is desirable but data redundancy is not. Data redundancy _____. a. can occur across multiple files but not within a single file b. can occur within a single file but not across multiple files c. is a positive feature in the simple linear file environment but is a negative feature in the database environment d. is a negative feature in the simple linear file environment but is a positive feature in the database environment e. None of the above. - ANSWER e. None of the above. All of the following are problems caused by redundant data, EXCEPT_________. - ANSWER wasted network transmission time All of the following are true about data redundancy across multiple files, EXCEPT _____. - ANSWER it speeds updates when the redundant data must be updated Which of the following is true about data redundancy within one file? - ANSWER Data redundancy within one file occurs when different kinds of data (data about different entities) are merged in one file. When different kinds of data (data about different entities) are merged in one file, a deletion anomaly _____. - ANSWER causes a loss of data that may not be stored anywhere else When different kinds of data (data about different entities) are merged in one file, which of the following anomalies can occur? - ANSWER deletion, insertion, and update By definition, a database management system _____. - ANSWER permits data to be stored non-redundantly and provides for data integration A database management system is designed to handle _____ relationships without introducing data redundancy or causing other problems. - ANSWER unary, binary, and ternary Regarding the three data control issues of security, backup and recovery, and concurrency, a database management system _____. - ANSWER should be responsible for handling all of them Problems caused by two or more users trying to update the same data simultaneously fall primarily under the heading of _____. - ANSWER concurrency control Rebuilding a database after it is destroyed by a natural disaster is an aspect of _____. - ANSWER backup and recovery Protecting against hackers is primarily a matter of _____. - ANSWER computer security When data structures can be modified without affecting the programs that use the data, we say that the environment is highly _____. - ANSWER data independent All of the following are major DBMS approaches, except _____. - ANSWER index The navigational approaches to database management are _____. - ANSWER hierarchical and network The DBMS approach in primary use today is _____. - ANSWER Relational