Oracle 1z0-151 問題集

質問 1：
The Employees database table contains more columns than can be displayed at one time in a form. You create a data block that uses all the columns. How can you enable users to interact with all the items and switch between them without scrolling or closing anything?
A. This is not possible because items from a single block must be displayed on the same canvas and window.
B. Define multiple content canvases and display them in multiple modeless windows.
C. Define multiple content canvases and display them in multiple modal windows.
D. Define multiple content canvases; display one in a modeless window and the others in modal windows.
E. Define multiple content canvases and display them in the same modeless window.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
A user at a remote location reports a problem that occurs when the Orders; form runs and the user clicks the invoice button. You are not able to reproduce the problem, so you decide to use remote debugging.
The steps involved in diagnosing the problem are listed below, but they are ordered incorrectly. What is the correct sequence of Steps?
1. You set a breakpoint in the When Button-Pressed trigger for the invoice button.
2. The user's screen goes blank.
3. The user reports the host and port to you.
4. You uses the debugger to step through the code.
5. The user clicks a button that calls DEBUG.ATTACH.
6. You attach to the user's process.
7. You open the Orders.fmb file from which the running .fmx was generated.
8. The user clicks the invoice button.
A. 8, 3, 6, 5, 4, 7, 1, 2
B. 7, 1, 3, 6, 5, 1, 8, 4
C. 3, 6, 5, 7, 8, 1, 2, 4
D. 5, 3, 6, 7, 1, 8, 2, 4
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
What happens when you click Run Form Debug in Forms Builder?
A. The form runs in a simulated three-tier environment by using an applet viewer that is included with the product to enable debugging.
B. The form runs on your local machine by using a debug executable client.
C. The form runs in a three-tier environment by using the application server URL that you specify in runtime preferences.
D. The form runs in a three tier environment by using the [debug] configuration in the FORMSWEB.CFG file.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
You have created a complex menu structure with several types of menu objects. To which objects would you assign menu commands?
A. menu items
B. individual menus
C. all of the above
D. submenus
E. main menus
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which three statements are true about the PL/SQL Packages panel in the Forms debugger?
A. You ran select an option button to view the packages that have not yet been instantiated.
B. You can view packages only while the runtime process executes PL/SQL.
C. You can view the values of variables that are defined in the package specification.
D. You can select an option button to view server packages.
正解：B,C,D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
To avoid overloading the database during busy times, you decide to restrict the queries that are executed on the Orders form so that users query by either Order ID or Customer ID during these times. Which trigger is most appropriate for the code to enforce this restriction?
A. Post-Query
B. On-Query
C. When-New-Form-instance
D. Pre-Query
E. When-New-Block-instance
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 7：
You have a form that called a database stored procedure. You do not want processing to continue, so immediately after the call to the stored procedure, you add the following code:
IF NOT FORM_SUCCESS THEN
MESSAGE ('Stored Procedure failure');
RAISE FORM_TRIGGER_FAILURE;
END IF;
You test the code and input some data that intentionally causes the stored procedure to fail. However, the message that you defined does not appear. What are two possible reasons for this?
A. You must handle database errors in an exception clause of the trigger.
B. You cannot test for failure of a stored procedure, because database errors are transparent to Forms.
C. You must test for FORM_FATAL when testing for failure of a stored procedure.
D. You must test for FORM_FAILURE when testing for failure of a stored procedure.
E. FORM_SUCCESS tests for failure of Forms built-ins, not stored procedures.
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Yon have created a list item for the Credit__Rating field in the Customers form, the Finance department usually determines a range of scores that pertain to the customer, the values in the list are Excellent, Good, Fair, and Poor, corresponding to the ranges provided by Finance. The default value Fair, because that is the range that applies to most customers.
Sometimes, Finance can provide an exact credit score; so users must be able to enter the exact numerical value if it is known. Often clerks enter the customer data before the performance of a credit check, so they must be able to enter a blank value if the credit rating is not yet determined.
Users want to be able to select a blank value from the list, but the list does not display a blank line for them to select. How can you meet this requirement without changing the default value of the list item?
A. Set Mapping of other Values for the Credit_Rating Item to NULL.
B. You cannot change this type of list item to display a blank value; users must delete the default value records if the credit rating is not known.
C. Add a blank line to the list item when you define the static values.
D. Delete the NOT NULL constraint for the Credit_Rating Column in the database.
E. Set the Required property of the Credit_Rating item to No.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 9：
View the Exhibit.

You have placed the following code in a Post insert trigger on the Orders block:
SELECT orders_seq.NEXTVAL
INTO :orders.order_id
FORM SYS.dual;
You have also set Item properties for the Order_Id Item in the form so that users cannot directly enter an Order ID.
As the SUMMIT user, you run the form to test it. Yon are able to insert a record in the block, but when you click Save, you have a database error as shown in the Exhibit.
What is the probable cause of this error?
A. You should create the sequence in the database, because the runtime error is an indication that is does not exist.
B. You should assign a temporary value to the Order_Id item before saving the form.
C. The code should be in a database trigger instead
D. The code should be in Pre_insert trigger instead
E. You should change the code to select the sequence number from SUMMIT.dual instead.
正解：B
解説: (Topexam メンバーにのみ表示されます)