1z0-131 Exam

- Covers the entire recommended syllabus
- Comprehensive questions and answers about 1z0-131 exam
- Verified Answers Researched by Industry Experts and almost 100% correct
- 1z0-131 exam questions updated on regular basis
- Same type as the certification exams, 1z0-131 exam preparation is in multiple-choice questions (MCQs)
- Tested by multiple times before publishing
- Try free 1z0-131 exam demo before you decide to buy it in Hiexam
- Technical support through Live Chat or Email

　
　
Exam : Oracle 1Z0-131
Title : Build Internet Applications i


1. 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.
Answer: A

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. 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

4. 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

5. 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

http://www.Hiexam.com The safer.easier way to get 9i Internet Application Developer Certification.