Auditors making database queries often need to combine several tables to get the information they want. One approach to combining tables is known as:
Answer(s): B
In data management terminology, joining is the combining of data files based on a common data element. For example, if rows in a table containing information about specified parts have been selected, the result can be joined with a table that contains information about suppliers. The join operation may combine the two tables using the supplier number assuming both tables contained this element) to provide information about the suppliers of particular parts.
Users making database queries often need to combine several tables to get the information they want. One approach to combining tables is:
Answer(s): A
Joining is the combining of two or more relational tables based on a common data element. For example, if a supplier table contains information about suppliers and a parts table contains information about parts, the two tables can be joined using the supplier number assuming both tables contain this attribute) to give information about the supplier of particular parts.
All of the following are methods for distributing a relational database across multiple servers except:
Answer(s): C
A distributed database is stored in two or more physical sites. The two basic methods of distributing a database are partitioning and replication_ However. normalization is a process of database design, not distribution. Normalization is the term for determining how groups of data items in a relational structure are arranged in records in a database. This process relies on "normal forms," that is. conceptual definitions of data records and specified design rules_ Normalization is intended to prevent inconsistent updating of data items. It is a process of breaking down a complex data structure by creating smaller, more efficient relations, thereby minimizing or eliminating the repeating groups in each relation.
In a database system, locking of data helps preserve data integrity by permitting transactions to have control of all the data needed to complete the transactions. However, implementing a locking procedure could lead to:
Answer(s): D
In a distributed processing system, the data and resources a transaction may update or use should be held in their current status until the transaction is complete. A deadly embrace occurs when two transactions need the same resource at the same time. If the system does not have a method to cope with the problem efficiently, response time worsens or the system eventually fails. The system should have an algorithm for undoing the effects of one transaction and releasing the resources it controls so that the other transaction can run to completion.
One advantage of a database management system DBMS) is:
A fundamental characteristic of databases is that applications are independent of the database structure; when writing programs or designing applications to use the database. Only the name of the desired item is necessary. Programs can be developed for the user's specific needs without concern for data capture problems. Reference can be made to the items using the data manipulation language, after which the DBMS takes care of locating and retrieving the desired items. The physical or logical structure of the database can be completely altered without having to change any of the programs using the data items, only the schema requires alteration.
Post your Comments and Discuss IIA IIA-CIA-PART3-3P exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the IIA-CIA-PART3-3P content, but please register or login to continue.