Category: REPORTS MCQ

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

2.What is the Oracle’s set of integrated Business Intelligence (BI) tools that allow you to seamlessly move between the roles of information consumer and information investigator? (Choose Two)

A. Oracle9i Warehouse Builder

B. Orcle9i Forms Developer

C. Orcle9i E-Business Suite

D. Orcle9i AS Discoverer

Answer: A, D

3.Enterprise reporting provides and organization with significant benefits. In order to obtain those benefits however, a number of challenges need to be met, including (Choose three)

A. High performance and scalability

B. Low performance and high scalability

C. High quality reports

D. Reduce time to market

Answer: A, C, D

4.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’t performs on Web Publishing

D. Web specific features, such as bookmarks and hyperlinks, can also aid the user in navigation

Answer: A, D

5. A paper report has characteristics that include rigid geometric restrictions, headers, and footers repeated on each page, and higher resolution allowing more details to be presented to the end user as once, giving the end user the option of printing the output and the ability to “study” the data.

A. True

B. False

Answer: A

6. Which three are benefits of Oracle9i reports? (Choose three)

A. Publish data from any source, in any format, with high fidelity

B. Develop one time and deploy anywhere

C. Open, standards-based, modular architecture

D. Provides all Oracle9i tools to production database

Answer: A, B, C

7. Which three is Oracle9i Products that provides the complete solutions? (Choose Two)

A. Oracle9i e-business suite

B. Oracle9i Discoverer

C. Oracle9i Database

D. Oracle9i Developer Suite

Answer: C, D

8. Which services provides by Oracle9i 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

9. Oracle9i Application Server consists of a set of services and utilities that can be used to implement applications in a distributed environment for scalability and reliability. These are (Choose all that apply)

A. Communication Services

B. Presentation Services

C. Business Logic Services

D. Data Management Services

Answer: A, B, C , D

10. Which can provides a graphical interface for mapping and transformation?

A. Orcle9i Application Server

B. Orcle9i Business Intelligence

C. Orcle9i Report Developer

D. Orcle9i Warehouse Builder

Answer: D

11. Which can enable you to access any data, publish it in any format, and send it to any destination?

A. Orcle9i Business Manager Console

B. Orcle9i Discoverer

C. Orcle9i Report Developer

D. Orcle9i Warehouse Builder

Answer: C

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

13. Oracle9i AS Reports Services can provide to? (Choose Three)

A. Flexible Reporting

B. Reduced Overhead

C. Fast Distribution

D. Complex Coding, but easy uses

Answer: A, B, C

14. In a Web environment, Oracle9i AS Reports Services can consists of four tiers. What are these? (Choose four)

A. The Remote Server Tier

B. The Client Tier (a Web Browser)

C. The Web Server Tier

D. The Oracle9i AS Reports Services Tier

E. The Data Tier (Databases and Pluggable date services)

Answer: B, C, D, E

15. What are the major components of Oracle 9i AS Reports Services? (Choose Three)

A. Oracle 9i AS HTTP Server

B. Reports Servlet and JSP

C. Forms Servlet

D. Reports Server

Answer: A, B, D

16.Enterprise reporting offers a number of important benefits. These are includes (Choose three)

A. Widening the reach of information access

B. Lower the cost of computing

C. Higher the computing cost, but performance is excellent.

D. Allowing for extensible business intelligence

Answer: A, B, D

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

18. The major component of oracle 9iAS Report Service are_

a) Report server

b) Report engine

c) Application server

d) Application engine

19. Oracle 9i DS Business Intelligence Include_

a) ELT

b) ETL

c) End user query and analyses

d) Enterprise reporting

20. Oracle 9i Application Development are_

a) Modeling

b) J2EE

c) RAD

d) Team Support

e) PL/SQL

21. Benefits of report developer are_

a) Publish data from any source.

b) Develop your report once.

c) Reports use a modular architecture.

d) None of the above is benefit, they are features.

22. Oracle 9i AS reports Service can consist of _

a) Two tiers

b) Three tiers

c) Four tiers

d) Five tiers

23. The ________ report style is the only style in which a detail group is related to two different master group that the same group

a) Tabular

b) Master-detail

c) Master and multiple details

d) Matrix

24. Which type of report considers using an HTML template for your reports?

a) Paper reports

b) Web reports

c) Paper and Web reports

25. You can call a report from ……….. (Chose all that apply)

a) A button in a Forms application

b) A database trigger

c) A Web browser

d) A Java application

26. Which is not true for web page (web publishing)-

a) Is very fluid. Limitation of page size.

B. comes alive with images.

c. Can contain as much or as little data as you wish.

d. None of above

27.J2EE stands for –

A) Java 2 Platform Enterprise Edition.

B) Java 2 Enterprise Edition.

c) Java Platform Enterprise Edition.

D) Java for Platform Enterprise Edition.

28. Which abbreviations correct

A . BC4J- Business Components for java.

B. XML- Extended Markup language.

C– Enterprise Java Server Beans.

D.GIF- Graphical Interface for Java

29. Oracle9iAS Reports Services-(choose three)

a. a component of oracle 9iAS

b. fast distribution

c. Reduce Cost

A component of oracle form builder.

Designing A Running Report Lesson –2

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

2. In a master detail report, the heading of the master group appear

A. To the left of field

B. To the right of field

C. Above field

D. Beside the field.

Answer: A

3. To run a web layout (Choose two)

A. Select program> web layout

B. Select Start> Program> Run web layout

C. Select program> Run web layout from the menu

D. Click the Run web layout iconic button on the horizontal toolbar.

Answer: C, D

4. Which one of the following statement is true?

A. The matrix style is the only style in which a master group is related to two different detail groups at the same level.

B. The matrix style is the only style in which a detail group is related to a master group at the same level.

C. The matrix style is the only style in which a master group is related to a detail group at the same level.

D. The matrix style is the only style in which a detail group is related to two different master groups at the same level.

Answer: D

5. To run a paper layout (Choose all that apply)

A. Select program> Paper layout

B. Select program> Run paper layout from the menu

C. Select program> Run paper layout

D. Click the run paper layout iconic button on the vertical toolbar

E. Click the run paper layout iconic button on the horizontal toolbar.

Answer: B, E

6. Which are the ways of running report?

A. A button in a Forms application

B. The Oracle 9i AS Report Queue Manager

C. A Java application

D. A database trigger

E. The command line, using the start> Run option in Windows NT.

Answer: A, B, C, D, E

7. By selecting Tools > File Conversion from the menu, we can convert a

A. .xml file to a .htm file

B. .jsp file to a .rep file

C. .rex file to a .rdf file

D. .htm file to a .xml file

Answer: C

8. Select the true statement / statements

A. RDF- binary file with source code

B. REP- binary file without source code

C. RDF- binary file without source code

D. REP- binary file containing source code

Answer: A, B

9. We can preview a report in Reports Builder using (Choose all that apply)

A. Run Web Layout

B. Run Paper Layout

C. Run Preview

D. Run Print Preview

Answer: A, B, D

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

Working With Report Developer Lesson –3

1. What is the Oracle 9i report executable pattern in Windows NT?

A. rw <?>.exe

B. rw(<?>

C. rwcgi

D. rvorgm

Answer: A

2. Servlet is a

A. report builder

B. Java application

C. Server application

D. Developer executables

Answer: B

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

4. Data model can be shared by the paper and web layouts?

A. False

B. True

Answer: B

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

6. Which wizard enables to create JSP report?

A. Data wizard

B. Graph wizard

C. Report block wizard

D. Report wizard

Answer: C

7. Which views provide/display a structural representation of the data in a report?

A. Web source

B. Data model

C. Paper design

D. Paper layout

Answer: B

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

9. What is syntax palette?

A. Modeless window

B. Program

C. Programming Tool

D. Application

Answer: C

10. How many categories are there in report model object?

A. Three

B. Four

C. Five

D. Two

Answer: B

11. PL/SQL program units contain functions and procedures which can be called from report level objects in the same report?

A. True

B. False

Answer: A

12. With the exception of parameters, where can a developer create all objects?

A. Object navigator.

B. Syntax Palette.

C. Relevant Editor.

D. Property Instructor.

Answer: C

13. In IDB database, a user wants to create or modify a parameter. As a developer where you suggest him to create or modify it?

A. Property Inspector.

B. Object Navigator.

C. Relevant Editor.

D. Paper layout.

Answer: B

14. In which path a report searches to locate ‘java objects’?

A. REPORTS_RESOURCES.

B. REPORTS_PATH.

C. REPORTS_CLASSPATH.

D. REPORTS_TMP.

Answer: C

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

16. In the “Preference” use changes the ‘unit of measurement’. Does the alternation of this setting affect an existing report definition?

A. No.

B. Yes.

Answer: A

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

18. You want to maintain the ‘Report builder Preference Tools’, but where?

A. init.ora.

B. cagrefs.ora.

C. prefs.ora.

D. cauprefs.ora.

Answer: D

19. In command line which command invoke Report Builder

rwrun.exe

rwclient.exe

rwserver.exe

rwbuilder.exe

20.The report builder interface enables you to create number of different type of modules. The modules are (Choose all that apply)

Menu

b. Report

c. Templates

Object Library

e. PL/SQL Library

21.A report can consist of: (Choose Three)

f. A data model and a paper layout.

g. A data model and a Web layout.

A data model, a paper layout and no Web layout

A data model, no paper layout and a Web layout

j. A data model, a paper layout, and a Web layout.

22.Report Builder components are (Choose Four)

k. PL/SQL Editor

l. Report Editor

Object Library

Menu Editor

o. Object Navigator

p. Property Inspector

23.The wizard in Report Builder is (are) : (Choose all that apply)

q. Report Wizard

r. Report Block Wizard

s. Data Wizard

Data Block Wizard

u. Graph Wizard

24.Which one is true for the report editor contains views to handle the data objects and layout objects separately

27. _______ help you quickly define or modify a query for a multi query data models.

e) Report Wizard

a) Data Wizard

b) Graph Wizard

c) Report block Wizard

28.You are creating an application on a Windows PC, and you want to test a form.

What are two ways to start an OC4J instance on the PC? (Choose two)

A. From the Forms Builder menu.

B. From the Windows Start menu.

C. By executing a batch file that is included with Oracle9iDS.

D. From the test form that is included with Oracle9iDS.

E. From the HTML front end (runform.htm) that is included with Oracle9iDS.

F. By running a Forms Builder form, which automatically starts OC4J.

Answer: B, C

29.You have started an instance of OC4J to test a Forms application on your development PC.

How should you cleanly shut down the OC4J instance?

A. Close the window from which OC4J started.

B. Make a section from the Forms Builder menu.

C. Execute a batch file that is included with Oracle9iDS.

D. Close Forms Builder, which automatically shuts down OC4J.

E. Exit all running forms and close the browser, which automatically shuts down OC4J.

Answer: C

30.You start an OC4J instance on your development PC and then run a form from the Forms Builder.

Which statement describes the behavior of OJ4J?

A. It appears in the Forms Builder window, which you can minimize after OC4J starts.

B. It appears in a separate window, which you can close after OC4J starts.

C. It appears in the Forms Builder window, which you can close after OC4J starts.

D. It appears in a separate window, which you should not close or the OC4J instance will abort.

E. It appears in a separate window, which you should not minimize of the OC4J instance will abort.

Answer: D

31.Memory conservation is a priority. One application that may allow memory to be conversed is Payroll, because users rarely will use all the Forms items in the Payroll application.

How can you set up the Payroll application to lead only the items needed?

A. Create one form with several data blocks, and limit the navigation cycle to keep less used data blocks from loading.

B. Create one form with several data blocks, map each data block to a different database table, and display only the items needed.

C. Allow the Human Resources Department users access only to items that will require updates.

D. Modularize the application by creating many small forms and grouping frequently used items.

Answer: D

Creating A Paper Report Lesson –4

1. Which is not report module component?

A. Data model

B. Web source

C. Report trigger

D. Program units

Answer: C

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

3. Which is not the valid data source type?

A. JDBC query

B. Sql query

C. Text query

D. HTM query

Answer: D

4. If we define the same table more than once, what does query builder create?

A. View

B. Alias

C. Synonym

D. None of this

Answer: B

5. We can’t alter the sequence of displayed fields by dragging one field above or below another in the list.

A. True

B. False

Answer: B

6. In tabular report if the initial label is wider than the field what happens

A. Report builder generates an error

B. Report builder don’t allows enough space

C. Report builder displays it on multiple lines

D. Report builder removes additional part

Answer: C

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

10. Which two output we need to generate of our report in order to display in web browser?

A. HTML

B. RDF

C. PDF

D. JSP

Answer: A, C

11. Which of the following have to use for HTML style sheets?

A. Paginated XML

B. Paginated PDF

C. Paginated HTML

D. Paginated HTMLCSS

Answer: D

12. At query builder we have to double-click the table title bar to select all columns.

A. True

B. False

Answer: A

13.You want to create a new data block. You click the Data Blocks node in the Object Navigator, and then

you click Create to invoke the Create Data Block dialog box. As you click through the pages of the

wizard, the page shown in the exhibit appears.

After looking at the exhibit, what do you know is true about this form?

A. The block you are creating is based on a view.

B. The block you are creating is based on a stored procedure.

C. The form contains at least one block in addition to the block you are creating.

D. In addition to the block you are creating, the form contains at least two other blocks that are master-detail blocks.

E. The block you are creating is based on a table that has at least one foreign key relationship to another table.

Answer: C

14..Which circumstance will cause the Data Block Wizard to display the Master-Detail page?

A. When you are creating a control block.

B. When there is an existing block in the form.

C. When you check the Enforce Data Integrity check box.

D. When a foreign key exists in the database which relates to the table you are using as a Data source.

Answer: B

15.. How would you associate Database Tables with form objects in order to access the tables from a form?

A. Create a data block and base it on all database tables you need to access.

B. Create a control block and associate its items with columns from database tables.

C. Create a data block for each database table you need to access.

D. Create a control block and associate its items with data blocks that are based on database tables.

Answer: C

16. Which three options does the Data Block Wizard allow you to select as a data source for a block? (Choose three)

A. View

B. Table

C. No Data Source

D. Stored Procedure

E. Table of Records

F. From Clause Query

G. Transactional Trigger

Answer: A, B, D

Enhancing A Basic Report Lesson –5

1. The Paper Design is a view of report output that

A. Allows live editing of page

B. Allows live editing of text and paper layout attributes:

C. Allows live editing of text and graphics

D. All of above

Answer: A, B

2. A Report’s Common modifications are (Choose Three)

A. Modify visual attributes

B. Align rows

C. Align columns

D. Set format masks

Answer: A, C, D

3. Which are effects of visual attribute?

A. Fill, patterns

B. Colors

C. Text colors and fonts

D. All of above

Answer: D

4. By clicking insert menu, you can not insert in a report

A. Header and footer

B. Page number

C. Date and time

D. Graph

E. Report block

Answer: A

5. Manipulating Objects you can (Chose Three)

A. Clear fields

B. Move fields

C. Resize fields

D. Delete fields

Answer: A, B, C

6. Flex mode button in the

A. Menu bar

B. Spacebar

C. Style bar

D. Toolbar

Answer: C

7. Which is not in paper design window?

A. Main menu

B. Toolbar

C. Tool palate

D. Status bar

E. Style bar

Answer: A

8. Paper design window has a horizontal toolbar that contain

A. Frame

B. New function

C. Database table

D. Common function

Answer: D

9. How to change field and boilerplate font

A. Select one or more objects then use the font pop-up list in the Status bar to change font face and size

B. Select one or more objects then use the font pop-up list in the Stylebar to change font face and size

C. Select one or more fields then use the font pop-up list in the Toolbar to change font face and size

D. Select one or more objects then use the font size drop-down list in the

Style bar to change font face and size

Answer: B

10. How can you describe the format mask of date and time?

A. Select Help>Find>Time Syntax, and then select Date and Time

Format mask Syntax from the list of Format

B. Select Help>Find>Date Syntax, and then select Date and Time

Format mask Syntax from the list of Format

C. Select Help>Find>Date Syntax, and then select Date and Time

Format mask Syntax from the list of topics

D. Select Help>Find>Time Syntax, and then select Date and Time

Format mask Syntax from the list of topics

Answer: C

11. We use lexical reference to

A. Specify a where clause as one parameter at run time

B. Specify a order by clause as one parameter at run time

C. Both a and b

D. Specify two column names and the table names at run time

E. Both C and D

Answer: A

12. What is important to use lexical reference?

A. Always use a column alias when substituting column names with lexical reference

B. Common function

C. Both of the above

D. None of the above

Answer: A

13.Why would you want to create a control block in a Forms module?

A. To control all items in other blocks that are not base table items.

B. To control relationship between a master block and its detail block.

C. To control the way additional forms are opened and to track the call stack.

D. To control navigation within the form so that users cannot randomly navigate to any item.

E. To place various control items (such as buttons) on a single block that is not related to a table in the database.

Answer: E

14.You want to standardize the appearance of certain text items in a particular form, so you create a Visual

Attribute called TEXT_ITEM_VA and define values for all of its properties.

Which four properties can you set by applying TEXT_ITEM_VA to the items? (Choose four)

A. Width

B. Height

C. Prompt

D. Font Weight

E. Fill Pattern

F. Font Spacing

G. Foreground Color

Answer: D,E,F,G

15.What is an indication that the Data Block Wizard is in reentrant mode?

A. There is a tabbed interface.

B. The Finish button is disabled.

C. There are no Next> or <Back buttons.

D. The page to create relations does not appear.

E. You cannot switch between different types of data sources.

Answer: A

16.You are developing and testing a Forms application on a machine that has plenty of memory. The Customers

block, whose Property Palette is shown in the exhibit, is based on a table that contains a large number of

records.

The initial query on the block appears quickly. However, after scrolling through hundreds of records in

the block, you notice that it is taking longer and harder to retrieve the next set of records.

What can you do to improve performance without losing the fast initial response?

A. Set Single Record to Yes.

B. Set Query All Records to Yes.

C. Set Query Array Size to a larger number.

D. Set Number of Records Buffered to a larger number.

E. Set Number of Records Buffered to a smaller number.

F. Set Number of Records Displayed to a smaller number.

Answer: D

17.The DBA has informed you that two new columns have been added to the ORDERS table. The blocks in the Order Entry form were created manually.

How can you use a wizard to modify the Orders block to include items that corresponds to these columns?

A. You cannot use wizards to add a new items to add data block that was created manually.

B. Select the last item in the Orders block, then invoke the Layout Wizard from the menu.

C. Select the Orders block in the Object Navigator, then invoke the Data Block Wizard from the menu.

D. Select the Data Block node in the Object Navigator, then invoke the Data Block Wizard from the menu.

Answer: C

18.The Name text item is subclassed from a property class.

Which two statements are true about the Keyboard Navigable property of the Name text item whose Property Palette is shown in the exhibit? (Choose two)

A. It is a variant property.

B. It is a default property.

C. It is a changed property.

D. It is an inherited property.

E. It was inherited from the property class.

If the value of Keyboard Navigable changes in the property class, it will change in the Name item also.

F. It was inherited from the property class and has been changed from the value in the property class.

G. It was not inherited from the property class and has been modified from the default Keyboard Navigable value for a text item.

H. It was not inherited from the property class and is the default Keyboard Navigable value for a text item.

Answer: A,F

19. You modify the layout of a block using the Layout Wizard. When you are finished, you notice that there is an additional frame on your canvas and in the Object Navigator.

Why did this frame appear?

A. You did not specify a frame title in the Layout Wizard.

B. You did not select a frame before invoking the Layout Wizard.

C. You clicked the Finish button in the Layout Wizard without navigating through all the screens.

D. You invoked the Layout Wizard from the top menu, rather than from the popup menu that appears when you right-click the canvas.

Answer: B

20. 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: D, F

21. A control blocks is a form block that _____.

A. Does not have items that allow input from users.

B. Can have items relates to columns within database tables.

C. Is a main block in the form, and it controls other blocks in the form.

D. Is not associated with any database table, and its items do not relate to any columns within any database table.

Answer: D

22. The Navigation Style property is set to Change Record for a data block.

What happens to the cursor when you reach the end of the current record in the block?

A. The cursor moves to the first record of the previous adjacent data block.

B. The cursor moves to the previous record of the same data block.

C. The cursor moves to the next record at the same data block.

D. The cursor moves to the first record of the next adjacent data block.

Answer: C

Managing Report Template Lesson –6

1.Open an existing template; modify the template objects as required. What type of file format should appropriate to save the file?

A. .pdf file

B. .tdf file

C. .sql file

D. .pll file

Answer: B

2.Registering a customized template in the predefine list of the wizard, what directory should you move the template and the image file to register?

A. <oracle_home>\reports\server

B. <oracle_home>\reports\plugins\resource

C. <oracle_home>\reports\templates

D. <oracle_home>\forms90\server

E. <oracle_home>\forms90\j2ee

Answer: C

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

Answer: D

4.Customizing the template margin, what type of objects can you copy, create or import into the margin of the template? (Choose all that apply)

A. Images

B. Text

C. Page number

D. Date

Answer: A, B, C, D

5.A template is divided into regions, what section into the regions we can customize or add other reports objects: parameters, report-level triggers, program units, attached PL-SQL libraries? (Choose two)

d.Click the margin button in the layout model and use the tool bar button.

4. A human resources department requested a report to show the total number of employees working in each department. To begin you created this query :

SELECT dept_id, count(employee_id),

FROM employees

GROUP BY dept_id

You defaulted the layout and choose a tabular report style. In the layout model which object will enclose all the other layout objects?

a.Field

b.Master group frames

c.Repeating frame

d.Boiler plate

5. Which tool in the layout model could you use to create an external boiler plate object?

A.Field

B.Frame

C.Button

D.Rectangle

E.File Link

6. When you defaulted you tabular report, you chose a Down print direction for the repeating frame. What is the default vertical size for the group frame?

Fixed

Expand

Contract

Variable

7. You are developing an Inventory report that has a boilerplate and a rectangle. The rectangle is anchored to the boilerplate. Which Pagination Property would you use on the rectangle to ensure that is the two objects cannot print on the same page; the objects will be printed on the next page?

Page Protect

Page Break After

Page Break Before

Keep with Anchoring Object

8. When you defaulted the layout of the master/detail report, what is the default Horizontal Field Size?

A. Fixed

B.Expand

c.Contract

D.Variable

9. Which Property determines whether the parent object is the Enclosing Object or the anchoring Objects?

Sizing

Pagination

Printer Codes

D. Print Condition

10. Which Pagination property would cause a page break after the last occurrence of a repeating frame?

a.Page Protect

b.Page Break After

c.Page Break Before

d.Keep with Anchoring Object

11. You are developing an Inventory report that has boilerplates that display bitmapped images. The boilerplates are anchored together so that the second boilerplate is a child of the first boilerplate. Which Pagination property would you use on the first boilerplate to ensure that the two objects are formatted on the next page?

a.Page Protect

b.Page Break After

C. Page Break Before

d.Keep with anchoring Object

12. What is the default Vertical Field size for a Tabular report?

a.Fixed

b. Expand

c.Contract

d.Variable

13.

15. For which two print directions would it be irrelevant to use the repeating frame Column Mode property?

A.Down

B.Across

C.Down/Across

D.Across/Down

16. Which repeating frame property would prevent more then six employee records appearing on any body page?

A.Source

B.Column Mode

C.Print Direction

D.Spacing Vertical

E.Minimum Windows Records

F.Maximum Records per Page

17. Which repeating frame property would you use to allow the next repeating frame to begin formatting before the previous instance completes?

A.Source

B.Column Mode

C.Print Direction

D.Spacing Vertical

E.Minimum Windows Records

F.Maximum Records per page

18. You are developing a Group above Inventory report with a Manufacturer break group. The Print Direction of both repeating frames id down. Which child repeating frame property would you alter to increase the amount of space between records?

A.Column Mode

B.Print Direction

C.Minimum Window Records

D.Maximum Records per Page

E.Vertical Space between Frames

F.Horizontal Space between Frames.

19. Which type of boilerplate displays the contents of an image file by importing the file contents at runtime?

A.Default

B.Link File

C.Text and drawing tools

D.Anchor

20. Which System variable would you use to display the current page number?

A.Panel Number

B.Current Date

C.Total Panels

D.Total Logical Pages

E. Physical Page Number

21. Which Sizing value for a graphical object will format faster?

A.Fixed

B.Expand

C.Contract

D. Variable

22. How would you increase the amount of white space between records in a tabular report that pints down each page?

A.Expand each field in the layout.

B.Turn the Confine Mode Setting off.

C.Increase the size of the group frame.

D.Alter the Horizontal Space between frames property of each field.

E.Alter the Vertical Space between Frames property of the repeating frame.

23. Which window would you use to create a user parameter?
A.Data Model
B.Layout Model
C.Parameter FormD.Object Navigator

24. Which system parameter would you assign the name of the file to send the output for DESTYPE=file?
A.CopiesB.DESNAME
C.CURRENCY
D.PRINTJOB
E.DESFORMAT
F.BACKGROUND

25. Which system parameter stores the location of the reports ASCII driver for a character mode report that prints?
A.MODEB.DESNAME
C.PRINTJOB
D.DESFORMAT
E.ORIENTATION

26. You created a list of parameter values for a user to select from at runtime. How would you prevent a user form entering any value not in the list?
A.Select the Static Values radio button on the report property palette.
B.Select the Static Values radio button on the parameter property palette.
C.Select the Static Values radio button on the parameter form property palette.
D.Check the Restrict list to predetermined values check box on the report property palette.
E.Check the Restrict list to predetermined values check box on the parameter property palette.
F.Check the restrict list to predetermined values check box on the parameter form property palette.

27. You need to provide a list of parameter for users to select from at runtime. How would you accomplish this task?
A.Alter the list of values property on the parameter Property Palette.
B.Alter the report properties sheet to allow for a static list of values.
C.Click the select statement radio button on the parameter property palette and enter the list of values.
E.Click the static values radio button on the parameter property palette and enter the select statement that will query the database values.
F.Click the Select statement radio button on the parameter property palette and enter the
select statement that will query the database values.

28. Which system parameter stores the location of the printer definition file for a character mode report that prints?
A.MODE
B.DESNAME
C.PRINTJOBD.DESFORMAT
E.ORIENTATION

29. You want to show users of the Inventory report a prototype of the display in both Portrait and landscape. Which system parameter would you alter to change the print direction?
A.MODE
B.DESTYPE
C.PRINTJOB
D.DESFORMAT
E.BACKGROUNDF.ORIENTATION

30. How would you create a default parameter form?
A.Select the menu Option Tools> Default Layout
B.Click the Default layout tool in the parameter form
C.Select the menu option Tools> Default layout in the parameter form.
D.Select the Parameter node in the Object Navigator and click the Create button
E.Select the menu Option Tools> Parameter form Builder in the Object Navigator.

31. You are developing an Inventory report that allows a clerk to enter either an ID, Name or Description value. You need to restrict the values retrieved to the values entered by the user. Which Where clause would you use in the select statement to achieve these results?A. &p_where_clause
B.:p_where_clause
C.where id=:p_id or Name=:p_name or description =:p_description
D.where id=&p_id or Name=&p_name or description =&p_description

32. In which Property Palette would you change the height and width of a parameter form?A. Report
B.Parameter
C.Parameter form
D.Parameter field

33. Which system parameter lists the name of the printer that a user selects to send the output of a character mode report at runtime?
A.MODEB.DESNAME
C.PRINTJOB
D.DESFORMAT
E.ORIENTATION

34. Which objects property Palette would you alter to specify a default value for the ID parameter on the Parameter Form?
A.ReportB.User parameter
C.Parameter form
D.Parameter field

35. You are developing a report and need to restrict the values retrieved to the value entered by the user. Which clause would you use in the select statement to achieve these results?
A.&p_where_clause
B.:p_where_clauseC.Where id = :p_id
D.Where id = p_id

36. How would you change the color of a parameter filed from white to yellow?
A.Use the Fill tool in the parameter form
B.Use the menu option format > Drawing OptionsC.The color of a parameter field cannot be altered
D.Double-click the parameter field in the Parameter form and alter the Property Palette.

37. Where could you find the Data Model and Business logic?A.rw:object
B.rw:field
C.rw:data
D.rw:foreach

38. Which are the optional attributes in rw:field tag?A. BreaklevelB. BreakValueC. NullValue
D. StyleE. ContainsHTMLF. FormatMasKG. FormatTrigger
H. All of the above

39. The Manager of the sales department requested all the sales data report execution daily at 5P.M. The result should be sent to her via e-mail. Which destination type would you use 0 send the output using your company’s MAPI-compliant system?
A.Screen
B.Preview
C.File
D.Printer
E.E-mail
F.The destination type depends on how the manager prevents to preview the result.

40. The ales report uses an embedded chart in the report definition. You need to pass values to the chart to modify the values displayed based on the value entered at run time. Which chart property would you modify to achieve these results?
A.Parameters and columns
B.Value
C.Category
D.File Name
E.Data Group

41.You need to add an existing graph to your report to represent the percentage of the total summary column. Which tools would you use to create this layout object?