Consider the following PL/SQL procedure designed to retrieve customer information and handle potential errors:

If get_customer_info(0) is executed, what will be the output?

Question

Consider the following PL/SQL procedure designed to retrieve customer information and handle potential errors:

If get_customer_info(0) is executed, what will be the output?

BlackTom AI · Accepted Answer

To analyze what get_customer_info(0) would output, I’ll walk through how the procedure handles the input and exceptions step by step.
Option 1: 'Error: Invalid customer ID. Must be greater than zero.' If the input p_customer_id is 0, the conditional IF p_customer_id <= 0 THEN RAIS ex_invalid_id; END IF; will trigger. This is designed to raise the user-defined exception ex_invalid_id, which the EXCEPTION block catches and responds with the message 'Error: Invalid customer ID. Must be greater than zero.' Thus this option correctly matches the behavior for a zero or negative ID.
Option 2: 'Error: Customer ID 0 not found.' This would be plausible if the code tried to query the database for a row with CUS_CODE = 0 and then raised NO_DATA_FOUND, but the flow shown first raises a custom exception for invalid IDs before attempting the SELECT. Since the NO_DATA_FOUND handler is only reached if the SELECT fails to return a row and the invalid-id path has not been taken, this option does not reflect the actual control flow for p_customer_id = 0.
Option 3: 'An unexpected error occurred: ORA-06510: PL/SQL: unhandled user-defined exception.' This would occur if a user-defined exception was raised but not properly handled in the EXCEPTION section. The code explicitly handles ex_invalid_id, so there is a defined path for this scenario, and ORA-06510 would not be produced here.
Option 4: 'An unexpected error occurred: ORA-01403: no data found.' ORA-01403 would arise from a NO_DATA_FOUND exception raised by a SELECT when no rows are returned. However, in this procedure, no_data_found is explicitly handled, and the code raises a separate ex_invalid_id before any SELECT occurs for zero or negative IDs. Therefore ORA-01403 would not be the actual outcome for p_customer_id = 0.
In summary, the only path that correctly describes the runtime behavior for get_customer_info(0) is the first option, because the function raises the custom ex_invalid_id for invalid IDs and the EXCEPTION block prints the corresponding message.

Consider the following PL/SQL procedure designed to retrieve customer information and handle potential errors: If get_customer_info(0) is executed, what will be the output?单项选择题

类似问题

Which of the following trees corresponds to a potential parse of the ambiguous sentence below, with correct syntactic categories? Some diagnostics are provided.

Which of the following sentences contain two non-finite verbs? Select all that apply.

Analyze the following sentence: The sentence contains [ Select ] 8 6 5 7 3 4 functional words, [ Select ] 2 3 1 4 5 count nouns, [ Select ] 4 5 2 1 3 mass nouns, and [ Select ] 1 5 2 3 4 adjectives.

You own a bond that pays $64 in interest annually. The face value is $1,000 and the current market price is $1,021.61. The bond matures in 11 years. What is the yield to maturity?

更多留学生实用工具

智能学习助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单