题目内容

Which two statements about the overloading feature of packages are true?

A. Only local or packaged subprograms can be overloaded
B. Overloading allows different functions with the same name that differ only in their return types
C. Overloading allows different subprograms with the same name, number, type and order of parameters
D. Overloading allows different subprograms with the same name and same number or type of parameters
E. Overloading allows different subprograms with same name, but different in either number, type or order of parameters

查看答案

搜索结果不匹配？点我反馈

更多问题

Which two statements about packages are true?

A. Packages can be nested
B. You can pass parameters to packages
C. A package is loaded into memory each time it is invoked
D. The contents of packages can be shared by many applications
E. You can achieve information hiding by making package constructs private

查看答案

Which two statements about packages are true?

A. Both the specification and body are required components of a package
B. The package specification is optional, but the package body is required
C. The package specification is required, but the package body is optional
D. The specification and body of the package are stored together in the database
E. The specification and body of the package are stored separately in the database

查看答案

You have a row level BEFORE UPDATE trigger on the EMP table. This trigger contains a SELECT statement on the EMP table to ensure that the new salary value falls within the minimum and maximum salary for a given job title. What happens when you try to update a salary value in the EMP table?

A. The trigger fires successfully
B. The trigger fails because it needs to be a row level AFTER UPDATE trigger
C. The trigger fails because a SELECT statement on the table being updated is not allowed
D. The trigger fails because you cannot use the minimum and maximum functions in a BEFORE UPDATE trigger

查看答案

Which part of a database trigger determines the number of times the trigger body executes?

A. trigger type
B. trigger body
C. trigger event
D. trigger timing

查看答案