Oracle 1Z0-241 問題集

質問 1：
You have a query that retrieves data for employees who took vacation for a specific duration (for example, two weeks). You want to change this query so that it will prompt the user to enter a value for the duration of the vacation. To achieve this result, which action would you take?
A. Define a HAVING criterion to display the duration of a vacation.
B. Apply aggregate functions to determine the duration of a vacation.
C. Define expressions to calculate the duration of a vacation.
D. Add a prompt to further refine the query when it is run.
正解：D

質問 2：
Select four field definition types that appear in the Field Definition Type drop-down list box when you create a new field definition in Application Designer. (Choose four.)
A. Binary
B. Number
C. BLOB
D. Attachment
E. Integer
F. Character
G. Signed Number
正解：B,D,F,G

質問 3：
What is the order of precedence for logical operators in PeopleCode conditional statements?
A. AND, NOT, OR
B. AND, OR, NOT
C. NOT, AND, OR
D. OR, AND, NOT
E. NOT, OR, AND
正解：C

質問 4：
You are building an application for a global company with separate business units in Asia, North America, and Africa. Select the type of validation you should configure to enable the users in each of the three continents to use the same tables, but to see different data based on business unit.
A. Prompt validation
B. Security views
C. Effective dating
D. Tableset sharing
正解：D

質問 5：
View this PeopleCode snippet:
If &MyVar = 0 then
&MyVar = 1;
End-if;
The &MyVar variable is not declared. What will be the result?
A. The program will not pass the syntax checker.
B. &MyVar willbe automatically declared with a type of Any.
C. The program will run but will produce undefined results.
D. &MyVar will be automatically declared with a scope of Global.
E. The program will fail at run time.
F. &MyVar will be automatically declared as Local Number.
正解：B