Which of the following PL/SQL blocks requires the variable to always contain a particular value within the block?
A. DECLARE
order NUMBER(2) := 0;
departure DATE;
BEGIN
---- executable statements ---
END;
B. DECLARE
order NUMBER(2,2) := .06;
departure DATE;
BEGIN
---- executable statements ---
END;
C. DECLARE
order CONSTANT NUMBER(2,2) := .02;
departure DATE;
BEGIN
---- executable statements ---
END;
D. DECLARE
order NUMBER(2) CONSTANT := .03;
departure DATE;
BEGIN
---- executable statements ---
END;
Answer: C
You might also like to view...
Consider a programmer required to complete four work assignments. Assume an overhead rate of $1.50 and the cost per hour for the programmer’s services to be $35/hour. The programmer’s learning rate for coding is 0.85. The steady state for the fourth iteration (n = 4) to code is 50 hours. Determine the estimate of time needed for the first coding iteration.
a. 69.16 hours b. 97.43 hours c. 87.34 hours d. 78.43 hours
Garnishment is a method for satisfying a judgment against a defendant
Indicate whether the statement is true or false
Identify the major challenge of an ERP system
A) Connects business departments B) Connects to suppliers C) Connects to customers D) The systems are complex and expensive E) Reports are based on up to the minute information
A company receives a utility bill each month for services received. The company's policy is to pay the utility bill within 30 days of receipt. On December 31, 2021, the company receives a utility bill of $4,200 for the month of December and plans to pay the bill by January 30, 2022. What adjusting entry, if any, will the company record on December 31, 2021?
A. Debit Utilities Expense and credit Utilities Payable for $4,200. B. Debit Utilities Expense and credit Cash for $4,200. C. No adjusting entry is necessary at the end of the year. D. Debit Utilities Payable and credit Utilities Expense for $4,200.