Important MCQ Test For IDB Student

VERY VERY IMPORTANT MCQ FOR 8TH EXAM :.

1. 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_BACK
D. PREVIOUS_BLOCK
ANS:B

2. 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.
ANS: A,B

1. When does transaction processing occur?
A. When the user selects Action --->Post from the menu.
B. When the user selects Action --->Rollback from the menu.
C. When the COMMIT_FORM built-in is called from a trigger.
D. When the POST_CHANGES built-in is called from a trigger.
ANS: C

2. When a user updates the Salary item, you want to ensure that the net value is higher than the existing value before it is inserted into the base table.
Which trigger would you use?
A. Pre-Commit
B. On-Commit
C. Post-Update
D. Pre-Update
E. Post-Form-Commit
ANS: D

3. What trigger is necessary for implementing a cascading delete in a master-detail relation?
A. PRE-CASCADE
B. POST-CASCADE
C. PRE-DELETE
D. PRE-POST
E. PRE-UPDATE
ANS: C

1. You are building a new application using generic code where possible, accessing Forms variable names at runtime.
Which two built-ins can you use to access the Form variables? (Choose two)
A. COPY
B. NAME_IN
C. DISPLAY_ITEM
D. GET_FORM_PROPERTY
E. GET_PARAMETER_LIST
F. GET_APPLICATION_PROPERTY
ANS:A, B

2. Which built-in subprogram can be used to return the contents of a variable as an indirect reference?
A. NAME_IN
B. FIND_ITEM
C. GET_ITEM_PROPERTY
D. SET_ITEM_PROPERTY
ANS: A

1. Which statement about object group is true?
A. Object groups can contain other object groups.
B. You cannot drag a program unit to an object group.
C. Object groups contain copies of the original objects.
D. You can delete the original objects without affecting the object group.
E. You can delete the object group without affecting the original objects.
F. Dragging a block to an object group does not place its triggers in the object group.

1. You are developing an application for use by meteorologists. Form1 contains a list of item based on a query of
cloud types that are stored in a database table. Users can add cloud types to the list by typing in new values that
are automatically inserted to the database table.
Form1 calls Form2, which contains an identical list item. You do not want to requery the database to obtain the
list of cloud types.
Which method can you use to pass the cloud types from Form1 to Form2?
A. Parameter list
B. Global variables
C. Global record group
D. Shared PL/SQL library
E. There is no way to pass such data between forms; you must require the data from the database.
Answer: C

2. Which built-in always starts a new Forms run-time session when you use it to invoke another form?
A. CALL_FORM
B. OPEN_FORM
C. NEW_FORM
D. WEB.SHOW_DOCUMENT
Answer: A

1. The combination of providing information and enabling additional investigation of that information is commonly referred to as
A. Business Rules
B. Business Functions
C. Business Intelligence
D. Business Integration
Answer: C

5. What are true about the Web Publishing? (Choose Two)
A. It does not have the limitation of page size
B. Images, color, JavaScript and animation are restricted
C. Bookmarks and hyperlinks can not performs on Web Publishing
D. Web specific features, such as bookmarks and hyperlinks, can also aid the user in navigation
Answer: A, D

8. Which three is Oracle10g Products that provides the complete solutions? (Choose Two)
A. Oracle10g e-business suite
B. Oracle10g Discoverer
C. Oracle10g Database
D. Oracle10g Developer Suite
Answer: C, D

9. Which services provides by Oracle10g DS Application Development? (Choose all that apply)
A. Modeling
B. Rapid Application Development(RAD)
C. J2EE and Web Services
D. Oracle connectivity for Java (OC4J)
Answer: A, B, C

Which can provides a graphical interface for mapping and transformation?
A. Orcle10g Application Server
B. Orcle10g Business Intelligence
C. Orcle10g Report Developer
D. Orcle10g Warehouse Builder
Answer: D

Which are not of Reports Developer?
A. User-friendly Wizard
B. Pluggable report templates
C. WYSIWYG live editor for paper reports
D. Customizable Forms templates
Answer: D

. In designing a report which one of the following supports the requirement & the most effective way to retrieve data
A. Style
B. Structure
C. Specification
D. Publishing medium.
Answer: B

10. Which should be considered in case of web reports?
A. Using no template
B. Using a predefined template
C. Using a Java template
D. Using an HTML template.
Answer: D

3. Which is/are report builder module? (Chose Three)
A. Data model
B. Template
C. Report level
D. PL/SQL library
E. Trigger
F. Report
G. Attached library
Answer: B, D,
F

5. In which view, the items in the layout menu are selectable only?
A. Data Model
B. Paper design
C. Paper layout
D. web source
Answer: C

8. We can make commonly required modification, such as spacing, formatting color, editing text in:
A. Paper layout
B. Paper design
C. Data model
D. Paper parameter form
Answer: B

15. In a report user wants to observe the parameter, where should he go to see the parameter)
A. Paper Parameter Form.
B. Database.
C. Object Navigator.
D. Data Model View.
Answer: C

17. What are the main layout object categories of the Paper Layout?
A. Parameter.
B. Field.
C. Column.
D. Boilerplate.
E. Frame.
Answer: B, D, E

2. Which of the following contains formatting information and standard information such as company logo?
A. Labels
B. Template
C. Fields
D. Data Source
Answer: B

7. Which extension is recommended format for storing paper reports?
A. RDF
B. PDF
C. JSP
D. XML
Answer: A

8. In which style each record appears on a new page?
A. Tabular
B. Form
C. Group left
D. Group above
Answer: B

9. When we choose the matrix report which three new tab page displays?
A. Rows
B. Column
C. Groups
D. Cell
Answer: A, B, D

7. Which is not in paper design window?
A. Main menu
B. Toolbar
C. Tool palate
D. Status bar
E. Style bar
Answer: A

3. To create a template image , the bitmaps supplied pixels are
A. 200 *200 pixels
B. 200 *250 pixels
C. 200 *350 pixels
D. 200 *150 pixels

3. How many types of JSP Tags?
A. One
B. Two
C. Three
D. Four
Answer: B

1. Which of the following is consists of data model? (Chose Three)
A. Group
B. Row
C. Column
D. Parameter
Answer: A, C, D

3. What is the color of the circle that shows above group object when a filter is activate?
A. Green
B. Layout color
C. No color
D. Purple
Answer: A