|
Home > Archive > Oracle certifications > October 2002 > passed 132....
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]
|
|
| priya_raj 2002-09-15, 5:16 pm |
| I passed 132 by 54/60 and am a certified Application Developer now.I studied guide,sts for both 132 and 122 and just back questions from oracle press book.The guide had almost covered more than 90% of the test.
I gave 121 instead of 131 and many questions were kind of straight from sts with exactly same kind of wording but this is not happening in 132,I mean there are questions directing to sts but not in a direct way. | |
| Sakina 2002-09-19, 2:09 am |
| COngratulations, Priya
I am preparaing for 131 with Sybex and sts. Request you to inform me which study guide did you use?
Thanks
Sakina | |
| Margus 2002-09-19, 6:42 am |
| Gongratulations!
Is it possible that You could share/trade some studymaterials You used? | |
| priya_raj 2002-09-23, 1:20 pm |
| The Guide is actually the oracle student guide.You can have access to it by taking OCP prep class with Oracle Univ or Oracle Certified Institutes.
There are many forums on which people sell or exchange their study material,you should check those forums to see if anybody is selling or exchanging their material and then contact them. | |
| rsuresh13 2002-09-23, 11:15 pm |
| 01. The users request that [F2], [F3], and [F4] be used to commit, rollback, and exit, respectively. How do you accomplish this?
a. Add the appropriate PL/SQL code for each key
b. Map the logical keys to the physical keys, then add the appropriate PL/SQL code for each key
c. Create an object library to define the key triggers, then reference the object library in the form
d. This cannot be accomplished because other function keys provide this functionality by default
02. You want to provide a tool that allows users quick access to form modules, by listing them in an Explorer-style interface.
Which reusable component do you use?
a. ActiveX controls
b. Calendar class
c. Standard Object Library
d. Picklist Class
e. Wizard Class
f. Navigator Class
03. Examine this code:
BEGIN
IF :SYSTEM.EVENT_WINDOW = 'WELCOME' THEN
DO_KEY('EXIT_FORM');
ELSE MESSAGE('ILLEGAL OPERATION');
END IF;
END;
In which form level trigger would you implement this?
a. WHEN-WINDOW-CLOSED
b. WHEN-WINDOW-CHANGED
c. WHEN-WINDOW-RESIZED
d. WHEN-WINDOW-ACTIVATED
04. What are three characteristics of the CALL_FORM built-in? (choose three.)
a. It is an unrestricted procedure
b. It is valid in Enter Query mode
c. It invokes a form in a modal window
d. It can only invoke a form in Query Only mode
e. It enables you to start a new database session
f. It enables free navigation between all opened forms in an application
05. Which value is valid for the iterate parameter in the CREATE_TIMER built-in function?
a. CYCLE
b. ITERATE
c. NO_REPEAT
d. REUSE
06. Which statement about windows and blocks is true?
a. Transaction management is window-oriented rather than block-oriented
b. Forms automatically navigates to an item located in an activated window
c. Windows may contain items from multiple blocks, and the block's items may be located on several windows
d. A window can contain multiple canvases, and an item can be located on multiple canvases
07. What is an example of a dynamic SELECT statement?
a. a query whose object names change during its execution
b. a query whose object names are not known until run time
c. a query whose bind variable values change during execution
d. a query whose bind variable values are not known until run time
08. Which two triggers are mouse movement triggers? (choose two.)
a. When-Mouse-Up
b. When-Mouse-Move
c. When-Mouse-Down
d. When-Mouse-Click
e. When-Mouse-Leave
09. What is a use for the SET_TIMER built-in?
a. retrieve the timer ID
b. change the timer name programmatically
c. determine what to do upon timer expiration
d. set the repeat behavior without changing the time interval
10. Which trigger property applies to Key triggers?
a. Hide Keys
b. Show Menu Keys
c. Hide Menu Keys
d. Display in 'Keyboard Help'
e. Hide Keys Description | |
| priya_raj 2002-09-24, 11:14 am |
| I can answer some of these,
2.f Navigator Class
4.a.It is an unrestricted built in.
b.it is valid in enter query mode.
c.It invokes a form in modal window.
5 c. no_repeat
create_timer(timer_name,millis
econds,iterate)
The value for milliseconds should be between 1 and 2147483648,approx 25 days.
The value for iterate should be repeat(default) and no_repeat.
8.b when-mouse-move
e.when-mouse-leave
There is one more mouse movement trigger and that is when-mouse-enter.Rest are mouse button action triggers.
9.d set the repeat behaviour without changing the time interval.
set_timer(timer_name,milliseco
nds,iterate)
set_timer(timer_id,millisecond
s,iterate)
Here values for milliseconds can be either between 1 and 2147483648 or it must be no_change if we do not want to change the time interval but just want to modify the repeat behaviour.
The values for iterate can be repeat,no_repeat and no_change(if we just want to change the time interval keeping the repeat behaviour as it is.)
10.d. display in 'keyboard help'
there are only two trigger properties that belong to the key triggers.
display in 'keyboard help': specifies whether a key trigger description is displayed in the run-time keys help window.
keyboard help text: specifies the text that is displayed in the run time keys help window if the display in the keyboard help property is set to yes(if you want the default description to be displayed ,leave property blank) | |
|
| How much questions (percentage)concerning reports were in exam?
Were there "ActiveX Control" and "Managing Project with Project Builder" questions?
Are there many differences between 1Z0-122 and 1Z0-132?
Thank you | |
| Margus 2002-10-26, 8:17 pm |
| quote:
Originally posted by priya_raj
The Guide is actually the oracle student guide.You can have access to it by taking OCP prep class with Oracle Univ or Oracle Certified Institutes.
Im just wondering if You took the Oracle prep class in Oracle Univ?
For future I would like to know if its worth to spend money in Oracle Univ classes (regularly they are about 2-4 more expensive from similar courses) | |
| priya_raj 2002-10-27, 7:33 pm |
| There were 4 questions for charts and reports for me in the exam.
The active x controls and project builder was in 122 not in 132 syllabus,so no question for those.
I dont know much about 122 except for the sts for 122 i did and the difference between 122 sts and 132 sts were that there were some extra topic questions which are not in the syllabus for 132 like project builder and the active x controls and i found an extra topic on the help class in reusable components also but we just have calender class in the reusable components for 132.there were some extra questions for menu modules also based on parameters but it is also not in the syllabus for 132. | |
| priya_raj 2002-10-27, 7:37 pm |
| Yes,i know the oracle classes are very expensive but i took those in India and they were comparitively at a very reasonable price.These classes really helped me and i just passed all my exams based on the material provided by them. | |
|
| To: priya_raj
Were there some extra topic questions that were in 132 exam and weren't in 122 sts?
Thank you. | |
| priya_raj 2002-10-29, 11:05 am |
| To: ONKA
Yes there is one topic which is not included in STS 122 and that is WORKING WITH ORACLE8 OBJECTS IN FORM BUILDER. | |
|
| can u answer these questions please
1.)You are creating the DEPTJSAL data block from the PAYHIST form. Users should be able to enter a valid department ID number, which will then display the employee salary information for that department. This data block could potentially retrieve a large number of records. Since users will probably only view a small number of these records, only 10 records should be fetched at one time. How would you create the data block?
A. Select The Data Blocks node in the Object Navigator and clock the Create button. Choose to build the data block manually, enter the procedure name in the Query Data
Source Columns property, and the procedure code in the Query Data Source Arguments property.
B. Choose Tools -> Data Block Wizard, select Table as the data source type, and base the
block on the columns from the tables.
C. Choose Tools -> Data Block Wizard, Select, View as the data source type, and base the block on the columns from the tables.
D. Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to
'FROM clause query', and enter the SELECT statement in the Query Data Source Name property.
E. Select the Data Block node in the Object Navigator and click the Create button.
Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a ref cursor.
2.) Which three statements describe the functionality of the DO_KEY built-in? (Choose three)
A. It accepts both a built-in and a key name as argument.
B. If no key trigger is defined, the specified built-in executes.
C. Its parameter must be specified in upper case, enclosed in single quotation marks.
D. It performs the same task as if you pressed the function key associated with the
specified argument.
E. It executes the key trigger that corresponds to the built-in specified as its parameter.
3.) You are building two forms. Each form has a button and a non-base table field. When the button is pressed, a complicated calculation is executed. The calculation is the same for both forms. The calculation code does not query or change the data in the database. When the calculation completes, it returns a single value to the non-base table field. To optimize performance and maintainability, which PL/SQL structure should be used?
A. A trigger in each form.
B. A subprogram in each form.
C. A stored subprogram in the database.
D. A subprogram in a library that is attached to each form.
4.) You CUSTOMERS module has a When-Button-Pressed trigger with this code:
OPEN FORM('stock', no__activate) ;
The STOCK module contains a When-New-Form-Instance trigger. Which statement is true when you press the button in the CUSTOMERS module?
A. The input focus switches to the STOCK module, and the When-New-Form-Instance
trigger fires.
B. The input focus remains in the CUSTOMERS module, and the When-New-Form-Instance trigger fires.
C. The inout focus remains in the CUSTOMERS module, and the When-New-Form-Instance trigger does not fire.
D. The input focus switches to the STOCK module, but the When-New-Form-Instance
trigger does not fire.
5.)Which three scenarios describe appropriate uses for key triggers? (Choose three)
A. Alter data in a database table.
B. Add custom item validation code.
C. Disable the Next Block key and menu item.
D. Display a custom form in place of a List of Values.
E. Change the navigational order of the blocks in a form.
F. Perform a complex calculation each time the F10 key is pressed.
6.) The record group in the EMP form is populated using a SELECT statement that is constructed programmatically at runtime. Five employee records are displayed at one time, and a user chooses item two from the record group. Which built-in would you use to determine which rows were flagged in the record group?
A. GET_GROUP_ROW_COUNT
B. GET_GROUP_SELECTION_COUNT
C. GET GROUP SELECTION
D. FIND_GROUP
E. FIND_COLUMN
F. ADD GROUP ROW
7.) Form_A invokes Form_B in Post-Only mode.
Which statement must be true?
A. Form_A has updates or deletes that have not been posted or committed, and Form_A
invokes Form_B with the OPEN_FORM built-in.
B. Form_A has updates or deletes that have not been posted or committed, and Form_A
invokes Form_B with the CALL_FORM built-in.
C. Form_A has inserts that have not been posted or committed, and Form_A invokes
Form_B with the OPEN_FORM built-in.
D. Form_A has inserts that have not been posted or committed, and Form_A invokes
Form_B with the CALL_FORM built in.
8.) You are developing the Payroll application that contains the SALARY and COMMISSION forms. When a user invoked the COMMISSION form from the SALARY form, the SAL value should be passed to the COMMISSION form. In which data form and at what time should you define the parameter to accept the value?
A. SALARY form at runtime.
B. SALARY form at design time.
C. COMMISSION form at runtime.
D. COMMISSION form at design time.
9.) You need to create a data block for DML operations in the NEW_EMPLOYEE form module.
Which data source can you use for this block?
A. REF cursor query.
B. Stored function.
C. From clause query.
D. Transactional trigger.
10.) You need to create a form for Payroll application that will allow the user to view all information for any employee ID queried. This data should be displayed to the user in a grouped format. The user should be able to choose which information they want to see from a pull down list containing the values PERSONAL and PAYROLL. Which format should you use to create this form?
A. One content canvas and multiple stacked canvases.
B. One content and one stacked canvas.
C. Tab canvas with several tab pages.
D. One content canvas.
E. A horizontal and vertical toolbar.
11.) The system analysts have requested heavy use of object features. The database design makes use of PL/SQL8 object types, methods, and LOB types. How do you work with these features on the client?
A. Write client-side subprograms containing the PL/SQL8 constructs, and move them into an object group.
B. Write server-side subprograms, and call the subprograms from the form application.
C. Store the PL/SQL8 constructs in a PL/SQL library, and attack the library to each form
muddle in your application.
D. You cannot reference PL/SQL8 object types in your application.
12.) You want to implement a master-detail relation between data blocks based on object tables. How would you do this?
A. Create the relation manually and coordinate the blocks using triggers.
B. Base the relation on a REF pointer using the Data Block Wizard.
C. Base the relation on a foreign key using the Data Block Wizard.
D. This task is not possible because master-detail relations can be implemented only for
blocks based on relation tables.
13.) You established access to menu modules using roles. You have allowed the sales role to access the menu module, but prevented access to the Updete menu item. Which item property would you later to grey out the menu option for the role?
A. Item Roles
B. Menu Item Roles.
C. Display without Privilege.
D. Use Security.
E. Command Type.
14.) At design time, you create a query record group for the LOV associated with the HOTEL text item in a form module for the Travel Planner Application. When is the record group deleted?
A. When the user navigates to the HOTEL item.
B. When the form module successfully compiles.
C. After Form Builder validates the SELECT statement and dismisses the New Record
Group dialog box.
D. When the user enters data in the HOTEL item, and the Validate from List property for
the HOTEL item is set to YES. | |
|
| To: priya_raj
Maybe you can send me sts 1Z0-132.
I want take the 1Z0-132 exam in a mounth.
I passed all the other exams, it's a last one for me.
I have 1Z0-122. I realy need help with this.
If you can answer me here or mail me to: elena_zelitchenko@yahoo
.com
Thank you for you help. |
|
|
|
|