ACP Mock Exams Set 1

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Alquintosjr
A
Alquintosjr
Community Contributor
Quizzes Created: 2 | Total Attempts: 3,732
| Attempts: 2,973
SettingsSettings
Please wait...
  • 1/278 Questions

    In which field do you define, if a classification is mandatory or not?

Please wait...
ACP Mock Exams Set 1 - Quiz
About This Quiz

Reviewer in preparation for the upcoming ACP Exams Jan. 23, 2013


Quiz Preview

  • 2. 

    __________________________ are implemented by AVALOQ or predefined by the order.

    Explanation
    The given answer "Primary Bookings" is the correct answer because it directly matches the term mentioned in the question. The question asks for the type of implementations that are done by AVALOQ or predefined by the order, and the term "Primary Bookings" fits this description. Therefore, it can be inferred that Primary Bookings are the implementations carried out by AVALOQ or predefined by the order.

    Rate this question:

  • 3. 

    Also called event packets

  • 4. 

    ________________________ table defines the different kinds of bookings for a bank.

  • 5. 

    What do you need to do to load a chart of accounts?

  • 6. 

    Which keyword must you use to implement a field level event?

    Explanation
    To implement a field level event, the keyword "Notify" must be used. This keyword is likely used as a way to trigger or activate the event associated with a specific field. By using the "Notify" keyword, the system can be instructed to send a notification or perform a specific action whenever a change or event occurs at the field level. This allows for more granular control and customization of events based on specific fields within a system or application.

    Rate this question:

  • 7. 

    Is it possible to execute AVALOQ Script through events?

    • True

    • False

    Correct Answer
    A. True
    Explanation
    True. You can execute scripts.

    Rate this question:

  • 8. 

    Identify the red-marked letters with the proper description or label (Answer with an equal "=" symbol with no space character before and after Example  A=Business Partner B=Container )

    Correct Answer
    A=CODE_OBJ_TYPE B=DOC_DFLT_FLD_VAL_RULE_LD
  • 9. 

     Identify the red-marked letters with the proper description or label (Answer with an equal "=" symbol with no space character before and after Example  A=Business Partner B=Container )

    Correct Answer
    A=Jobs B=Task C=PRCQ D=Mail E=File F=Background Processes(BGP)
    A=Jobs B=Task C=PRCQ D=Mail E=File F=BGP
  • 10. 

          Identify the red-marked letters with the proper description or label       (Answer with an equal "=" symbol with no space character before and after Example  A=Business Partner B=Container )

    Correct Answer
    A=External Message Interface B=Avaloq Forms C=Report Writer D=Avaloq Message Interface(AMI) E=Market Data API
    A=EMI B=Avaloq Forms C=Report Writer D=AMI E=Market Data API
  • 11. 

    Correct Answer
    366
  • 12. 

     Identify with right description or label

    Correct Answer
    Reuters
    Thomson Reuters
    Explanation
    Reuters and Thomson Reuters are both well-known news agencies. Reuters is a global news organization that provides news, analysis, and commentary on various topics, including politics, business, and technology. Thomson Reuters is a multinational media and information company that operates in various industries, including financial services, legal, and tax and accounting. It is a parent company of Reuters and provides financial and risk solutions to its clients. Therefore, both Reuters and Thomson Reuters are correct labels for the given description.

    Rate this question:

  • 13. 

      Identify the red-marked letters with the proper description or label         (Answer with an equal "=" symbol with no space character before and after Example  A=Business Partner B=Container )

    Correct Answer
    A=CODE_UI_ERR.SENT B=CONSTRAINTS
  • 14. 

      Identify the red-marked letters with the proper description or label   (Answer with an equal "=" symbol with no space character before and after Example  A=Business Partner B=Container )

    Correct Answer
    A=RULE SET B=VALUATION CONSTRAINTS C=ERROR
    A=RULE SET B=VALUATION CONSTRAINTS C=ERROR/ADMIN
  • 15. 

    Identify the red-marked letters with the proper description or label (Answer with an equal "=" symbol with no space character before and after Example  A=Business Partner B=Container )

    Correct Answer
    A=AVALOQ(only) B=CUSTOMER and AVALOQ C=Flat Datamart Definition(DDIC) E=dtm_obj...dtm_doc... F=task_obj.mdb$test G=Heirarchical Datamart Definition(REP DTM) H=REP SCREEN I=REP REPORT J=REP FILE K=REP TABLE L=REP SCRIPT M=task_obj[Report] task_doc(Orderbook)
    Explanation
    The red-marked letters in the given answer correspond to specific descriptions or labels. A is labeled as "AVALOQ (only)", B is labeled as "CUSTOMER and AVALOQ", C is labeled as "Flat Datamart Definition (DDIC)", E is labeled as "dtm_obj...dtm_doc...", F is labeled as "task_obj.mdb$test", G is labeled as "Heirarchical Datamart Definition (REP DTM)", H is labeled as "REP SCREEN", I is labeled as "REP REPORT", J is labeled as "REP FILE", K is labeled as "REP TABLE", L is labeled as "REP SCRIPT", and M is labeled as "task_obj[Report] task_doc(Orderbook)".

    Rate this question:

  • 16. 

    What are the two columns in Rule Loader Table that uses AVALOQ Script? Answers should be separated by ','  e.g. SOURCE_TYPE, META_TYP, OBJ

    Correct Answer
    COND,RESULT
    Explanation
    The two columns in the Rule Loader Table that use AVALOQ Script are COND and RESULT. These columns are used to define the conditions and the corresponding results for a rule. The COND column contains the AVALOQ Script code that defines the conditions that need to be met for the rule to be applied. The RESULT column contains the AVALOQ Script code that specifies the actions or outcomes that should be executed if the conditions are met.

    Rate this question:

  • 17. 

    Entry points of Parameterisation Answers should be separated by ','  e.g. SOURCE_TYPE, META_TYP, OBJ

    Correct Answer
    OMD,API,TOAD,Sources
    Explanation
    The entry points of parameterization in this scenario are OMD, API, TOAD, and Sources. These are the different sources or platforms where parameterization can be implemented. Parameterization allows for the customization and adaptation of variables or inputs in a system or program, and these entry points represent the areas where this customization can take place.

    Rate this question:

  • 18. 

    Where does the compiler add information during the compilation of addition sources?

    Correct Answer
    CODE_OBJ_ADD,OUT_TEX_NORM,DDIC:OBJ_xxx_EXTN
    Explanation
    During the compilation of additional sources, the compiler adds information to CODE_OBJ_ADD, OUT_TEX_NORM, and DDIC:OBJ_xxx_EXTN. These are the locations where the compiler includes the necessary data and code for the additional sources being compiled.

    Rate this question:

  • 19. 

    Write down the data access expression which gets you: 'he name of the reference currency of the issuer of the asset of your position'. Start with the 'obj_pos' root object.

    Correct Answer
    obj_pos.asset.issuer.ref_curry.name
    Explanation
    The given data access expression starts with the root object "obj_pos" and accesses the "asset" property. From there, it accesses the "issuer" property of the asset, followed by the "ref_curry" property of the issuer. Finally, it accesses the "name" property of the reference currency. This expression retrieves the name of the reference currency of the issuer of the asset in the given position.

    Rate this question:

  • 20. 

    In which database table do we find the messages that were exported via the Business Bus?

    Correct Answer
    MSG_EXTL_OUT
    Explanation
    The messages that were exported via the Business Bus can be found in the MSG_EXTL_OUT database table. This table likely stores the messages that have been sent out or exported from the system using the Business Bus functionality.

    Rate this question:

  • 21. 

    Two static structures of form at compile time

    Correct Answer
    Form Layout Structure,Form Controller Structure
    Explanation
    The correct answer is Form Layout Structure and Form Controller Structure. These two static structures are used during compile time for organizing and managing the layout and control of a form. The Form Layout Structure determines the arrangement and positioning of various elements within the form, such as labels, input fields, and buttons. On the other hand, the Form Controller Structure handles the logic and behavior of the form, including event handling, validation, and data processing. Both structures play a crucial role in creating a well-designed and functional form.

    Rate this question:

  • 22. 

    Doc Level Events give six

    Correct Answer
    On new,Before Calc,After Calc,On Get,On WFC_Action,On Put
    Explanation
    This answer suggests that "Doc Level Events" are a set of events that occur in a specific order during a document's lifecycle. These events include "On new" (which happens when a new document is created), "Before Calc" (which occurs before any calculations are performed on the document), "After Calc" (which happens after the calculations are completed), "On Get" (which occurs when the document is accessed), "On WFC_Action" (which happens during a specific action in the document), and "On Put" (which occurs when the document is saved or updated).

    Rate this question:

  • 23. 

    In datamart _____________________ is use to create data levels.

    Correct Answer
    Group By
    Explanation
    In datamart, the "Group By" clause is used to create data levels. This clause is commonly used in SQL queries to group rows based on one or more columns. It allows for the aggregation of data and the creation of summary information at different levels of granularity. By specifying the "Group By" clause, the data in the datamart can be organized and grouped according to specific criteria, enabling easier analysis and reporting.

    Rate this question:

  • 24. 

    Actions on Sources (name three)

    Correct Answer
    Create,New Version,Override
    Explanation
    This question is asking for three actions that can be performed on sources. The correct answer is "Create, New Version, Override." These actions allow users to create new sources, create new versions of existing sources, and override existing sources with new information.

    Rate this question:

  • 25. 

    What API stands for?

    Correct Answer
    Application Programming Interface
    Explanation
    An API stands for Application Programming Interface. It is a set of rules and protocols that allows different software applications to communicate and interact with each other. APIs define the methods and data formats that can be used to request and exchange information between different systems. They provide a standardized way for developers to access the functionality of a software component or service, without needing to understand the underlying implementation details. APIs are commonly used in web development, allowing developers to integrate third-party services, access databases, and create custom functionality in their applications.

    Rate this question:

  • 26. 

    What does a workflow in AVALOQ symbolize in a bank? ______________

    Correct Answer
    Business Process
    Explanation
    A workflow in AVALOQ symbolizes a business process in a bank. This means that it represents the sequence of tasks and activities that need to be performed in order to complete a specific business operation or function within the bank. Workflows in AVALOQ help to streamline and automate these processes, ensuring efficiency and accuracy in the bank's operations. They provide a visual representation of the steps involved in a business process, allowing for better coordination and collaboration among different teams and departments.

    Rate this question:

  • 27. 

    Does the system stop me if I forgot to enter information that is needed?

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The correct answer is True because typically, a system is designed to prevent users from proceeding if they have not entered all the required information. This is done to ensure that the system functions properly and to avoid any errors or incomplete data. By stopping users from moving forward without providing necessary information, the system promotes accuracy and completeness in data entry.

    Rate this question:

  • 28. 

    ________________ are symbolic references to objects.

    Correct Answer
    Keys
    Explanation
    Keys are symbolic references to objects. In computer science, keys are used to uniquely identify or access specific objects or data. They serve as a way to associate values with specific identifiers, allowing for efficient retrieval and manipulation of data. Keys are commonly used in data structures such as dictionaries, hash tables, and databases, where they play a crucial role in organizing and accessing information.

    Rate this question:

  • 29. 

    Can changes to orders be traced?

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Yes, with the attributes auditing and transitions which can be parameterized by the concept around orders.

    Rate this question:

  • 30. 

    ___________ is the character you need to type to enter the last value date of a month into a date field?

    Correct Answer
    u
    Explanation
    The character "u" is the correct answer because it represents the last day of the month when typing into a date field. This is a commonly used convention where "u" serves as a shorthand for "ultimate" or "ultimate day". By entering "u", the system will automatically recognize and input the correct last day of the current month into the date field.

    Rate this question:

  • 31. 

    ____________________ means the enhancement of functionality, usually with AVALOQ Script.

    Correct Answer
    Scripting
    Explanation
    Scripting refers to the process of writing and executing scripts, which are sets of instructions or commands that automate tasks or enhance the functionality of a system. In the context of AVALOQ, scripting involves using AVALOQ Script, a programming language specifically designed for the AVALOQ Banking System. With scripting, users can customize and extend the capabilities of the AVALOQ system by writing scripts that perform specific functions or automate repetitive tasks. Therefore, the correct answer is "Scripting".

    Rate this question:

  • 32. 

    Customisation is done by

    • DDIC and Task Loading

    • APIs

    • Creating Source, Compile and Deliver

    • Parameterisation and Scripting

    Correct Answer
    A. Parameterisation and Scripting
    Explanation
    Customisation is typically done through parameterisation and scripting. Parameterisation allows users to modify the behavior of a software system by adjusting certain parameters or settings. Scripting, on the other hand, involves writing scripts or code to automate tasks or modify the functionality of a system. Both parameterisation and scripting provide flexibility and allow users to tailor the software to their specific needs and requirements.

    Rate this question:

  • 33. 

    _____________________ status is set if the source contains a syntax error.

    Correct Answer
    ERROR
    Explanation
    The given correct answer is "ERROR". This is because when the source contains a syntax error, the status is set to "ERROR". This indicates that there is a mistake or issue in the code structure or syntax, which prevents it from being executed correctly. It is important to identify and fix these errors in order to ensure the proper functioning of the source code.

    Rate this question:

  • 34. 

    What is the naming convention for tables which contain a predefined "list of data"?

    Correct Answer
    CODE_
    Explanation
    The naming convention for tables which contain a predefined "list of data" is to start the table name with "CODE_". This convention helps to easily identify and differentiate these tables from other tables in the database.

    Rate this question:

  • 35. 

    A kind of order that creates or modifies objects is __________________

    Correct Answer
    Static Data Order
    Explanation
    The correct answer is "Static Data Order" because this term refers to a type of order that involves the creation or modification of objects. It suggests that there is a specific sequence or arrangement in which objects are instantiated or altered. This order is typically predetermined and remains consistent throughout the execution of a program or system.

    Rate this question:

  • 36. 

    Order that generates booking is called _________________

    Correct Answer
    Transaction Order
    Transaction
    Transactional Order
    Explanation
    The order that generates a booking is called a transaction order. A transaction is a process or event that involves the transfer of goods, services, or funds between two or more parties. In the context of bookings, a transaction order refers to the specific order or request made by a customer to book a product or service. Therefore, a transaction order is the correct term to describe the order that generates a booking.

    Rate this question:

  • 37. 

    ____________ provides business data fields not available in the standard entry forms.

    Correct Answer
    Additions
    Addition
    Explanation
    Additions provide additional business data fields that are not available in the standard entry forms. These additional fields allow businesses to collect and store specific information that is relevant to their operations and requirements. By using Additions, businesses can customize their data collection process and ensure that they capture all the necessary information for their specific needs. This flexibility helps in improving data accuracy and completeness, as well as enabling businesses to make more informed decisions based on the additional data fields provided by Additions.

    Rate this question:

  • 38. 

    Is it true that you always have to use parameterisation and scripting simultaneously?

    • True

    • False

    Correct Answer
    A. False
    Explanation
    False. It depends on the area of customisation and on that what you want to have as a result.

    Rate this question:

  • 39. 

    Sources are always written in PL/SQL

    • True

    • False

    Correct Answer
    A. False
    Explanation
    Sources are never written in PL/SQL

    Rate this question:

  • 40. 

    ______________ status is set if the source is not accepted by Oracle

    Correct Answer
    CORRUPT
    Explanation
    If the source is not accepted by Oracle, it means that it is considered corrupt. The term "corrupt" implies that the source is damaged, flawed, or unreliable in some way. Therefore, if the status is set as "CORRUPT," it indicates that the source has been deemed unacceptable by Oracle due to its compromised state.

    Rate this question:

  • 41. 

    What does OMD stand for?

    Correct Answer
    Object Modelling Definition
    Explanation
    OMD stands for Object Modelling Definition. This acronym refers to the process of defining and representing objects in a system or software through various modeling techniques. Object modeling involves identifying the objects, their attributes, relationships, and behaviors, and creating a visual representation of these elements. It helps in understanding the structure and behavior of the system, facilitating effective communication between stakeholders, and guiding the development process.

    Rate this question:

  • 42. 

    __________________ are the ones that groups objects and use these groups for lookup, reporting etc.

    Correct Answer
    Classes/Classifications
    Classifications/Classes
    Classes
    Classifications
    Explanation
    Classes/Classifications are the ones that groups objects and use these groups for lookup, reporting, etc. This means that both classes and classifications can be used to organize and categorize objects in a system. They provide a way to group similar objects together and perform operations on these groups. Whether using the term "classes" or "classifications", the concept remains the same - grouping objects for specific purposes.

    Rate this question:

  • 43. 

    Business Partner can have two or more containers.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true because a business partner can have multiple containers. In business, a container is a term used to refer to a unit of work or a process that can be assigned to a business partner. Since a business partner can handle multiple tasks or projects simultaneously, it is possible for them to have two or more containers. This allows for efficient management of workload and allocation of tasks based on the partner's capabilities and availability.

    Rate this question:

  • 44. 

    Can orderbooks be individualized?

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Yes, you can set up, store and manage individual filter criteria with the use of templates, layouts and parameters in the task and reporting desk.

    Rate this question:

  • 45. 

    _________________ is where data is stored, which are part of a database.

    Correct Answer
    Table
    Explanation
    A table is where data is stored in a database. It is a collection of related data organized in rows and columns. Tables are used to store and organize data in a structured manner, making it easier to retrieve and manipulate the data. Tables are an essential component of a database system, allowing for efficient storage and retrieval of information.

    Rate this question:

  • 46. 

    ____________________ is a script which contain elements of PL/SQL and SQL and is stored in AVALOQ ICE

    Correct Answer
    BTC
    Business Type Config
  • 47. 

    ________________ are forms to search for objects and/or use to enter something into input fields.

    Correct Answer
    Lookups
  • 48. 

    The currency is defined through the _______________________

    Correct Answer
    Contract of the Money Account
    Contract of Money Account
    Contract
    Explanation
    The currency is defined through the contract of the Money Account. This contract outlines the terms and conditions for the use and management of the Money Account, which is a financial account that holds and transacts in a specific currency. By entering into this contract, individuals or organizations agree to abide by the rules and regulations set forth by the Money Account provider, which ultimately defines the currency that can be used within the account.

    Rate this question:

  • 49. 

    ____________________ are exclusively for order and serves as additional information for an order.

    Correct Answer
    Post-It
    Post it
    Explanation
    Post-It and Post it are both correct answers because they both refer to the same thing - small pieces of paper with adhesive on one side that are used for writing notes or reminders. They are exclusively for order and serve as additional information for an order. The question is asking for the correct term or name for these items, and both "Post-It" and "Post it" accurately describe them.

    Rate this question:

Quiz Review Timeline (Updated): Mar 22, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 22, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jan 22, 2013
    Quiz Created by
    Alquintosjr
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.