Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Exam
: Oracle 1Z0-131
Title
: Build Internet Applications i
Version : Demo
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
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
Answer: DF
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
Answer: AB
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
Answer: 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
Answer: BC
5. You are creating summary items that summarize the same item in a data block by performing different
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
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, a