Free IIA-CIA-PART3-3P Exam Braindumps
Certified Internal Auditor - Part 3, Business Analysis and Information Technology Questions 751–755 (page: 152)

Updated On: 10-Feb-2026

What language interface would a database administrator use to establish the structure of database tables?

  1. Data definition language.
  2. Data control language.
  3. Data manipulation language.
  4. Data query language.

Answer(s): A

Explanation:

The schema is a description of the overall logical structure of the database using data definition language DDL), which is the connection between the logical and physical structure of the database. DDL is used to define, or determine, the database.



Query facilities for a database system would most likely include all of the following except:

  1. Graphical output capability.
  2. Data dictionary access.
  3. A data validity checker.
  4. A query-by-example interface.

Answer(s): C

Explanation:

The least likely feature of a query tool would be a data validity checker because the database system has already enforced any validity constraints at the time the data were inserted in the database. Any further data validity checking would be a function of a user application program rather than a query.



Which of the following would be the most appropriate starting point for a compliance evaluation of software licensing requirements for an organization with more than 15,000 computer workstations?

  1. Determine if software installation is controlled centrally or distributed throughout the organization.
  2. Determine what software packages have been installed on the organization' s computers and the number of each package installed.
  3. Determine how many copies of each software package have been purchased by the organization.
  4. Determine what mechanisms have been installed for monitoring software usage.

Answer(s): A

Explanation:

The logical starting point is to determine the point(s) of control. Evidence of license compliance can then be assessed. For example, to shorten the installation time for revised software in a network, an organization may implement electronic software distribution ESD), which is the computer-to-- computer installation of software on workstations. Instead of weeks, software distribution can be accomplished in hours or days and can be controlled centrally. Another advantage of ESD is that it permits tracking or metering of PC program licenses.



Use of unlicensed software in an organization:

I). Increases the risk of introducing viruses into the organization
II). Is not a serious exposure if only low-cost software is involved
III). Can be detected by software checking routines that run from a network server

  1. I only.
  2. I and II only.
  3. I, II, and III.
  4. I and III only.

Answer(s): D

Explanation:

Antivirus measures should include strict adherence to software acquisition policies. Unlicensed software is less likely to have come from reputable vendors and to have been carefully tested. Special software is available to test software in use to determine whether it has been authorized.



The Internet consists of a series of networks that include:

  1. Gateways to allow personal computers to connect to mainframe computers
  2. Bridges to direct messages through the optimum data path
  3. Repeaters to physically connect separate local area networks LANs
  4. Routers to strengthen data signals between distant computers

Answer(s): A

Explanation:

The Internet facilitates information transfer between computers. Gateways are hardware or software products that allow translation between two different protocol families. For example, a gateway can be used to exchange messages between different email systems.



Viewing page 152 of 312
Viewing questions 756 - 760 out of 1555 questions


Post your Comments and Discuss IIA IIA-CIA-PART3-3P exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!