|
Home > Archive > Oracle certifications > October 2002 > please help me with these 131questions
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
please help me with these 131questions
|
|
|
| 1)Which built-in subprogram can be used to create global variables?
A. NAME_IN
B. COPY
C. DEFAULT_VALUE
D. LIST_VALUES
2) Which property group in the Property Palette of a text item would you expand to show the properties that control the way the data is displayed and entered?
A. Data
B. Editor
C. Records
D. Database
E. Functional
F. Calculation
3) What happens when a user clicks the red X icon on the default menu toolbar?
A. The current record is removed from the block.
B. The current record is deleted from the database.
C. The current record is blanked out to enable entry of new data.
D. The current record is placed at the end of the block’s list of records.
4) In Form Builder you attempt to compile a trigger. You receive a compilation error that gives no clear indication of the problem. What are two likely causes? (Choose two)
A. Dividing by zero.
B. Missing semicolon.
C. Mismatched quotes.
D. Mistyped variable name.
E. Trigger defined on wrong item.
F. Trigger defined at wrong item.
5) In the Customer application, you want to display the salesperson’s name for each
customer. In the CUST block, you create a display item, salesperson. The display item
will be populates using a WHEN-VALIDATE-ITEM trigger on the Cust_id text item.
This is the trigger code:
SELECT name
INTO ________
FROM employee
WHERE id = :cust.cust_id;
Choose the option that best completes the INTO clause.
A. sales_person
B. :sales_person
C. cust.sales_person
D. :cust.sales_person
6) Which built-in allows you to dynamically change the alert message text?
A. SET_ALERT_MESSAGE
B. SET_ALERT_PROPERTY
C. CHANGE_ALERT_PROPERTY
D. CHANGE_MESSAGE_ALERT
7)When does transaction processing occur?
A. When the user selects Action --->Post from the menu.
B. When the user selects Action --->Rollback from the menu.
C. When the COMMIT_FORM built-in is called from a trigger.
D. When the POST_CHANGES built-in is called from a trigger.
8) You are creating the ORDERS form that contains a text item called Date_Ordered. How could you ensure that when a new record is entered, the Data_Ordered item displays the current data in DD-MON-YYYY format?
A. In the Data_Ordered Item Property Palette, set the Initial Value property to $$date$$.
B. In the Data_Ordered Item Property Palette, set the Default Value property to
SYSDATE.
C. You must use a Pre-Insert trigger to accomplish this task.
D. You must use a Pre-Commit trigger to accomplish this task.
9) The EMPLOYEE form contains the CV_SALARY, CV_EMP, and CV_HELP content canvases. Each canvas is displayed in its own window. How could you toggle between the CV_SALARY and CV_EMP canvases without closing the CV_HELP canvas?
A. Create the CV_HELP canvas in a modal window.
B. Create the CV_SALARY and CV_EMP canvases in modal windows.
C. Create all three canvases in modeless windows.
D. A canvas must be dismissed before another canvas can become active.
10) There is a column in the EMPLOYEE database table that indicates whether an
employee is salaried or paid by the hour. This column has a NOT NULL constraint, and
is currently a text item in a form that you are developing.
You are converting the existing text item to a check box. You change the Item Type
property to Check Box in the item’s Property Palette. To make the check box look and
function as needed, what are three of the other properties you should set? (Choose
three)
A. Label
B. Data Type
C. Initial Value
D. Maximum Length
E. Copy Value from Item
F. Value When Unchecked | |
|
| Hi samb,
I look forward to enter the exam next week..and this my answers for the questions :
1- C.DEFAULT_VALUE
2- E.FUNCTIONAL
3- A.THE CURRENT RECORD IS REMOVED FROM THE BLOCK.
4- B. MISSING SEMICOLON
C. MISMATCHED QUOTES
5- B. :SALES_PERSON
6- B. SET_ALERT_PROPERTY
7- D. WHEN THE POST_CHANGES BUILT-IN IS CALLED FROM A TRIGGER.
8- A. IN THE DATA_ORDERED ITEM PROPERTY PALETTE, SET THE INITIAL VALUE PROPERTY TO $$DATE$$
9- C. CREATE ALL THREE CANVASES IN MODELESS WINDOWS.
10- B. DATA TYPE
C.INITIAL VALUE
F.VALUE WHEN UNCHECKED
WITH REGARDS |
|
|
|
|