When the same attribute in related data file has different values?
Answer: Data redundancy occurs when different divisions, functional areas, and groups in an organization independently collect the same piece of information. Because it is collected and maintained in so many different places, the same data item may have:1.
Which of the following occurs when the same attribute in related data files has different values *?
|When the same attribute in related data files has different values, this is called data:||Inconsistency|
|In associations, a data mining tool discovers different groupings within data, such as finding affinity groups for bank cards.||False|
Which of the following occurs when the same data is duplicated in multiple files of a database?
Data redundancy in the database implies that a few information fields are repeated in the database. This information reiteration may happen either if a field is repeated in at least two tables or if the field is repeated inside the table.
Which of the following enables users to view the same data in different ways using multiple dimensions?
OLAP enables users to view data from different perspectives. Which of the following is an example of a company whose business model is based on access to large databases through the web?
Which of the following is an automated or manual file that stores?
An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the: data dictionary.
Which of the following is a global network that uses universal standards?
The Internet is a global network that uses universal technology standards to connect many private and public networks.
What is the logical view of a database?
The logical database view is how the data appear to the user to be stored. This view represents the structure that the user must interface with in order to extract data from the database.
When an organization has inconsistent duplicated data it is said to have an <UNK> Group of answer choices?
MIS 101 Exam 2
|When an organization has inconsistent duplicated data, it is said to have a(n) ________.||data integrity problem|
What is the most prominent data manipulation language today?
The most prominent data manipulation language today is Structured Query Language, or SQL. End users and information systems specialists can use SQL as an interactive query language to access data from databases, and SQL commands can be embedded in application programs written in conventional programming languages.
What are the three general problems associated with data redundancy?
Problems caused due to redundancy are: Insertion anomaly, Deletion anomaly, and Updation anomaly. If a student detail has to be inserted whose course is not being decided yet then insertion will not be possible till the time course is decided for student.
Is an automated or manual file that stores definitions of data elements and their characteristics?
The third element of a DBMS is a data dictionary. This is an automated or manual file that stores definitions of data elements and data characteristics, such as usage, physical representation, ownership (who in the organization is responsible for maintaining the data), authorization, and security.
What is data integrity and its types?
There are two types of data integrity: physical integrity and logical integrity. Both are a collection of processes and methods that enforce data integrity in both hierarchical and relational databases.
Which of the following is a device that sends packets of data through different networks?
To communicate with another network, the network would use a device called a router. A router is a special communications processor used to route packets of data through different networks, ensuring that the message sent gets to the correct address.
Which of the following tool enables users to view the same data?
Question: The Tool That Enables Users To View The Same Data In Different Ways Using Multiple Dimensions Is SQL.
Which of the following is a type of optical drive storage?
There are three main types of optical media: CD, DVD, and Blu-ray disc. CDs can store up to 700 megabytes (MB) of data, and DVDs can store up to 8.4 GB of data. Blu-ray discs, which are the newest type of optical media, can store up to 50 GB of data.