Advanced ITT Audit Software Quiz
42 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is the term for networks that operate within a confined geographic area, often used in homes or offices?

  • WAN
  • MAN
  • Virtual Networks
  • LAN (correct)
  • Which term refers to the practice of ensuring that security records are adequately maintained over time?

  • Database Management
  • Review Management
  • IT Audit
  • Log management (correct)
  • What technology ensures that different servers in a data center are logically grouped and separated?

  • LANs
  • MANs
  • VLANs (correct)
  • VPNs
  • Which process ensures that the data entered into a system meets specific prerequisite conditions?

    <p>Validation (D)</p> Signup and view all the answers

    What is the name of the file sent to an ATM when a central database is busy?

    <p>Central Data File (A)</p> Signup and view all the answers

    Which of the following methods is NOT a popular method of capital budgeting?

    <p>Cash flow forecasting (A)</p> Signup and view all the answers

    What does net present value represent?

    <p>Future cash inflows minus future cash outflows as of today (D)</p> Signup and view all the answers

    Which type of analysis does NOT involve numerical probabilities or predictions of loss?

    <p>Qualitative risk analysis (C)</p> Signup and view all the answers

    Risk analysis in business typically involves which of the following?

    <p>Assessing potential adverse events (D)</p> Signup and view all the answers

    What is typically used to present information in a clear and analytical manner?

    <p>Graphs and charts (B)</p> Signup and view all the answers

    Which graph technique is used to visualize data trends?

    <p>Both A &amp; B (A)</p> Signup and view all the answers

    What stage involves gathering and listing all necessary fields for a database project?

    <p>Data Definition (A)</p> Signup and view all the answers

    What analysis technique determines how variations in an independent variable affect a dependent variable?

    <p>Sensitivity Analysis (A)</p> Signup and view all the answers

    What happens to a dependent query when a table gets updated?

    <p>It updates automatically (D)</p> Signup and view all the answers

    During which stage do we analyze our tables closely and create relationships between them?

    <p>Design Phase (B)</p> Signup and view all the answers

    Which type of analysis computes various reinvestment rates for expected returns?

    <p>Scenario Analysis (D)</p> Signup and view all the answers

    What is the main purpose of the Switchboard Manager in Microsoft Access 2010?

    <p>To build a main switchboard form (C)</p> Signup and view all the answers

    What function is specifically used to calculate payments for loans over time?

    <p>PMT (B)</p> Signup and view all the answers

    How does a query-based report differ from a report based on just one table?

    <p>It has more design options (D)</p> Signup and view all the answers

    Which analysis is used to break down the Return on Equity?

    <p>Du Pont Analysis (A)</p> Signup and view all the answers

    What common financing method can be used for properties and facilities?

    <p>All the above (D)</p> Signup and view all the answers

    Which method is used to include plain text in a mailing label report?

    <p>Use the Mailing label wizard text option (C)</p> Signup and view all the answers

    What is the function of a relationship in database design?

    <p>To link data between tables (D)</p> Signup and view all the answers

    What method is used to split windows into four in Excel 2010?

    <p>View -&gt; Window -&gt; Split (C)</p> Signup and view all the answers

    Which of the following best describes what a join does in a database?

    <p>Combines data from different tables (D)</p> Signup and view all the answers

    How can you restrict cell values to allow only a predetermined list in Excel?

    <p>Data Validation (A)</p> Signup and view all the answers

    In IDEA, summarization accumulates the values of numeric fields for each ____________.

    <p>Unique Key (C)</p> Signup and view all the answers

    Which type of sampling involves selecting sampling units using a fixed interval?

    <p>Systematic Sampling (D)</p> Signup and view all the answers

    What method ensures that all combinations of sampling units in the population have an equal chance of selection?

    <p>Random Sampling (A)</p> Signup and view all the answers

    Is Input Control method a part of Application Control Group?

    <p>True (B)</p> Signup and view all the answers

    Which type of check can be run when data is input through a terminal?

    <p>Field Check (D)</p> Signup and view all the answers

    In which system are money transfers done on a one-to-one basis while in another system transfers are done in batches?

    <p>RTGS, NEFT (D)</p> Signup and view all the answers

    Which system of money transfer is primarily used for large transactions?

    <p>RTGS (A)</p> Signup and view all the answers

    What does STP generate for every outbound RTGS transaction?

    <p>Reference Number (C)</p> Signup and view all the answers

    What action should you take to update a Pivot Table report data after modifications to the source data?

    <p>All of the above (D)</p> Signup and view all the answers

    Which of the following options are views available to display a Table?

    <p>All of the above (D)</p> Signup and view all the answers

    Which tool in a database creates a drop-down list of values to choose from?

    <p>Lookup Wizard (B)</p> Signup and view all the answers

    What does a Query do in a database context?

    <p>Enables you to view data based on a specific criterion (B)</p> Signup and view all the answers

    Which of the following is a database language that allows access or maintenance of data?

    <p>DML (B)</p> Signup and view all the answers

    Which of the following is NOT a command provided by DCL?

    <p>Change the structure of tables (C)</p> Signup and view all the answers

    Which of the following is not a recognized database model?

    <p>Structured Database Model (C)</p> Signup and view all the answers

    Which type of field typically has a width of 8 bytes?

    <p>Double (A)</p> Signup and view all the answers

    Study Notes

    Advanced ITT Question Bank Study Notes

    • Question 1: In IDEA, statistical functions can be applied to both numeric and date data.
    • Question 2: In IDEA, the increment value in stratification can be fixed or free interval. This is TRUE.
    • Question 3: In IDEA, stratified random functions are part of the Analysis menu.
    • Question 4: ACL and IDEA are audit software. Unix is not an audit software. SOFTCAAT is not an audit software.
    • Question 5: Equation Editor and Function Editor are used in IDEA for complex calculations and exception testing.
    • Question 6: Categories of computer audit functions include items of audit interest, data analysis, and system validation. All of the above are categories.
    • Question 7: Stratification is an audit function.
    • Question 8: In source code review methodology, the steps are: Reviewing programming standards; Understanding program specifications; Formulating flaw hypotheses; All of the above steps may be used.
    • Question 9: In IDEA, use sequence, checking and filtering functions to find repeated values.
    • Question 10: In IDEA, stratification can be applied to numeric and date data.
    • Question 11: In IDEA, summarization accumulates numeric data for each primary key, unique key, or secondary key, or composite key.
    • Question 12: Systematic sampling uses a fixed interval between selections.
    • Question 13: Random sampling ensures equal chances for all combinations of sampling units in a population.
    • Question 14: Input Control method is part of Application Control Group. This statement is TRUE.
    • Question 15: Field check can be performed when inputting data through a terminal.
    • Question 16: Money transfers are one-to-one in a system. Transfers are done in batches in another system.
    • Question 17: Money transfers in the books of the beneficiary bank, central bank (RBI), or remitting bank.

    Studying That Suits You

    Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

    Quiz Team

    Related Documents

    Advanced ITT Question Bank PDF

    Description

    Test your knowledge on the advanced functionalities of ITT audit software, including IDEA and its statistical functions. This quiz covers key concepts like stratification, audit categories, and source code review methodology. Perfect for students and professionals looking to reinforce their understanding of audit software tools.

    More Like This

    Use Quizgecko on...
    Browser
    Browser