The pre-defined exception TOO_MANY_ROWS is raised when
PL/SQL ran out of memory or memory was corrupted.
A cursor fetches value in a variable having incompatible data type.
SELECT INTO statement returns more than one row.
SELECT INTO statement returns one row.
Q.3.
Which of the following is not among the types of PL/SQL records?
Table-based
View-based
Cursor-based records
User-defined records
Q.4.
Which of the following is not true about the exception handling section of a PL/SQL block?
This section starts with the EXCEPTION keyword.
It is a mandatory section.
It contains exception(s) that handle errors in the program.
None of the above.
Q.5.
Identify whether the below statement is true or false “Payment terms can be overwritten at the Invoice Header Level”
True
False
Q.6.
Which of the following is not a subprogram?
Procedure
Function
Package
Anonymous PL/SQL block
Q.7.
What is a contract purchase agreement?
Agreement with your supplier on specific terms and conditions without indicating the goods and services that you will be purchasing
Agreement when you know the details of the goods or services you plan to buy from a specific supplier in a period, but you do not yet know the detail of your delivery schedules
Agreement when you know the details of the goods or services you plan to buy from a specific supplier in a period with detail of your delivery schedules
Q.8.
Intercompany transaction that is already approved by receiver will be created as AR Invoice by provider in which program
Transfer Journal
Transfer to payables
Transfer to Receivables
Transfer to invoice
Q.9.
What is status transaction that is passed the check funds processed
Funds Available
Reserved
Sufficient Funds
Insufficient Funds
Q.10.
Liability Transaction is recorded in which modules
Account Payable
Account Receivable
Cash Management
General Accounting
Q.11.
What is the syntax for exception handlers within an exception section?
WHEN (exception) THEN (action);
IF (exception) THEN (action);
WHEN (exception) statement;
WHEN (exception) (Action);
Q.12.
What is report name used to verify transaction before closing
Subledger closing report
Subledger period close exceptions report
Subledger period close create accounting
Subledger transactions report
Q.13.
Person who receipt the purhased items must be the requester of requisition
TRUE
FALSE
Q.14.
Which column that needs to filled so the tax can be calculate in the invoice
Distribution Set
Witholding Tax
Memo Line
Tax Classification Code
Q.15.
Which feature is used to cancel payment
Cancel
Void
Delete
Unreconcile
Q.16.
Which of the following subprogram is stored in the database?
Standalone subprogram
Nested subprogram in an anonymous block
Package subprogram
Standalone and nested subprogram
Q.17.
What is the required steps before invoice can be pay
Validated
Accounted
Workflow Approved
Available
Q.18.
What is written in the window behind Ms. Fregara in her “Give a Little Wave” photo?
Have a Great Summer!
Later Gators!
I Miss You!
#AdelphiIsHome
Q.19.
According to the article, what kinds of heroes have already been saluted as part of the #AdelphiHeroes social media campaign?
A Pilot
A Soldier
A Politician
None of the Above
Q.20.
According to experts, does blue light emitted from electronic devices increase the risk of macular degeneration?
Yes
No
Support mcqgeeks.com by disabling your adblocker.
Please disable the adBlock and continue. Thank you.