OCA OCP Oracle Certification Exam Braindumps

1.Which two data block properties can be set to abort a long running query? (Choose two.)
A.Number of Records Buffered
B.Numbers of Records Displayed
C.Query Array Size
D.Maximum Query Time
E.Query All Records
F.Maximum Records Fetched
Correct:D F
2.You have written some generic PL/SQL code which loops through the invoked form, getting and setting the global variables in the form. Which two built-ins would you use in this code to get and set these variables and their values? (Choose two.)
A.COPY
B.NAME_IN
C.GET_ITEM_PROPERTY
D.GET_BLOCK_PROPERTY
E.GET_PARAMETER_LIST
F.GET_APPLICATION_PROPERTY
Correct:A B
3.Which built-in subprogram can you use to navigate to the instance of the current item in the previous record?
A.PREVIOUS_RECORD
B.UP
C.SCROLL_UP
D.PREVIOUS_BLOCK
Correct:B
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 level
Correct:B C

9i Internet Application Developer Oracle9i, Build Internet Applications I

5.You are creating summary items that summarize the same item in a data block by performing different functions, such as Sum, Avg, Max, and Min. Design rules require you to place summary items in a control block. Which properties should be set in the control and data blocks to enable your task?
A.The Single Record property must be set to Yes for the control block, and the Query All Records property must be set to Yes for the data block.
B.The Number of Records Displayed property must be set to Yes for the control block, and the Number of Records Buffered property must be set to All for the data block.
C.The Query All Records property must be set to Yes for the data block, and the Precompile Summaries property must be set to Yes for the control block.
D.The Query All Records property must be set to Yes for the control block, and the Precompile Summaries property must be set to Yes for the data block.
Correct:A
6.Which two item properties' settings affect the standard checks performed during item validation? (Choose two.)
A.Font Name
B.Format Mask
C.Conceal Data
D.Case Restriction
E.Lowest Allowed Value
F.Number of Items Displayed
Correct:B E