OCA OCP Oracle Certification Exam Braindumps

7.You created a form that has two data blocks. Which two default navigation methods can a user employ to move the cursor from the first block to the second block? (Choose two.)
A.Press the [NEXT BLOCK] function key.
B.Click an item in the second block with the mouse.
C.Click the single right-arrow icon on the menu toolbar.
D.Right-click an item in the first block, and choose Next Block from the pop-up menu.
Correct:A B
8.You have created a form that has a block to create an address and perform a mail merge with a selected Word document. You would like to use this block in other forms. How could you package this block and its canvas for reuse?
A.Smart Class
B.Object Group
C.Record Group
D.Property Class
E.PL/SQL Library
Correct:B
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.
Correct:C
10.You created the EMP_DATA data block in the EMPLOYEE form based on all the columns of the EMP table. After viewing the prototype, users are asking that you remove the SALARY column from the layout. This column is used in the data block to perform bonus calculations. How would you remove this column from the layout while leaving it in the data block?
A.You must delete the EMP_DATA data block and recreate it.
B.Select the Salary item in the Layout Editor and press DELETE.
C.You must remove the column from the data block to remove it from the layout.
D.Select the frame surrounding the EMP_DATA data block in the Layout Editor, click the Layout Wizard tool, and remove the SALARY column from the Displayed Items list.
E.Select the EMP_DATA data block in the Object Navigator, choose Tools->Data Block Wizard, and remove the SALARY column from the included list. The SALARY column will automatically be removed from the layout.
F.Double-click the EMP_DATA data block in the Object Navigator to launch the Data Block Wizard, remove the SALARY column from the included columns, enter the Layout Wizard, and remove the SALARY column from the Displayed Items list.
Correct:D
11.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 Date_Ordered item displays the current date in DD-MON-YYYY format?
A.In the Date_Ordered Item Property Palette, set the Initial Value property to $$date$$.
B.In the Date_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.
Correct:A
12.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
Correct:B