Oracle database 10g interview questions and answers

Oracle database download

Oracle Database 11g download for 32bit

Oracle Database 11g download for 64 bit

Basic or beginner SQL database Tutorial

Basic Java™ Tutorials for click here

Free Oracle Database 100 Video Tutorials

Oracle database 10g interview questions and answers

Oracle database 10g interview questions and answers


Most Common Oracle interview questions and answers for Reports Builder

Oracle 10g Reports Builder Qus and Ans
1. Which is/are true? (Choose all that apply)
a. The combination of providing information and enabling additional investigation of that information is commonly referred to as business intelligence (BI).
b. Enterprise Reporting provides lowering the cost of computing but not Uses integrated business intelligence
c. Reduced time to market is one of the benefits of Enterprise Reporting
d. Oracle9i Reports supports HTML, HTMLCSS, TDF, XML, RTF, Postscript, and PDF format

2. Choose the correct answers.
a. A Web page is very fluid.
b. Web specific features, such as bookmarks and hyperlinks, can also aid the user in navigation
c. Oracle Reports has historically done a very good job of publishing high fidelity paper reports.
d. Develop one time and deploy anywhere

3. Features of Reports Developer

a. User-friendly wizards
b. Dynamic SQL execution
c. Run-time customization
d. Pluggable data sources

4. In command line which command invoke Report Builder

a. rwrun.exe
b. rwclient.exe
c. rwserver.exe
d. rwbuilder.exe

5. A report can consist of: (Choose Three)
a. A data model and a paper layout.
b. A data model and a Web layout.
c. A data model, a paper layout and no Web layout
d. A data model, no paper layout and a Web layout
e. A data model, a paper layout, and a Web layout.

Chapter-Two
1. The Common Report Styles are:

a. Tabular
b. Master and multiple details
c. Matrix
d. Master and details

2. Choose the correct answers.
a. Tabular report structure contains a single group.
b. Master-Detail Report Style contains two groups
c. The matrix style is the only style in which a detail group is related to two same master groups at the different 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.
e. We can split web report Horizontally & Vertically

3. We can run a report from:

a. browser
b. Command line
c. Button in a Forms application
d. Oracle9iAS Reports Queue Manager

4. Which are building a paper report?

a. use a reports builder
b. data wizard
c. The report in XML

5. A report can consist of:

a. A data model and a paper layout.
b. A data model, a paper layout, and a Web layout.
c. A paper layout and a Web layout.
d. A data model and a Web layout.

Chapter Three

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

a. Menu
b. Report
c. Templates
d. Object Library
e. PL/SQL Library

2. Report Builder components are (Choose Four)

a. PL/SQL Editor
B. Report Editor
c. Object Library
D. Menu Editor
e. Object Navigator
f. Property Inspector

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

a. Report Wizard
b. Report Block Wizard
c. Data Wizard
d. Data Block Wizard
e. Graph Wizard

4. ——–contains a parameter value?

a. Frame
b. Boilerplate
c. Field
d. Item

5. Reports Builder Modules are:

a. Report
b. Template
c. Data
d. PL/SQL Library

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

a. Report Wizard
b. Data Wizard
c. Graph Wizard
d. Report block Wizard

Chapter Four

1. You want to create a new report from wizard; in the data source page you can select the following data sources to create it?

a. SQL-based
b. XML
c. JDBC
d. Flat Files

2. You need to create a boilerplate object in Paper Design Window. Which group of tool would you use?

A. Toolbar
B. Style bar
C. Tool palette
D. Status bar

3. Most commonly used numeric format symbols are available on the style bar are-
i) Currency
ii) Percentage
iii) thousand separator
iv) Decimal places
Choose one of the following.

a. i & ii
b. i, ii,iii & iv
c. i, iiv & iii
d. i & iii

4. Flex Mode adjusts layout during changes

a. True
b. False

5. The style bar includes a Parent Frame tool you can use to select the outer object surrounding the currently selected object.

a. True
b. False

6. Which menu can you use to insert Date and Time, Page Number?

a. File
b. Insert
c. Format
d. Layout

7. For paper reports, you have ______ template options

a. 1
B. 2
C. 3
D. 4

8. Which options can you use in Template Wizard to use the report the default settings instead of a template file?

a. Predefined
B. Template File
C. No Template

9. Template regions are-

a. Body
b Margin
C. Report
D. Template

10. In which region you can include objects

a. Body
B. Margin
C. Body & Margin

Chapter 5, 6, 7:

1. You are creating a financial report to be represented to board of directories. The accounting manager has asked you to change the number format to show a thousand separators. What is the best method to make this change to the report quickly?
A. Open the property plate and set the format mask for all the numeric items in the report
B. Select the data to be free formatted in the live previewed and click on the thousand-separator Icon on the style bar
C. Go to the layout model and change the field attributes for the data to be changed on the report
D. Rebuild the report using the report wizard setting this format on creation

2. You created a department report and preview it in live preview. The font for the department name is too small and you want to enlarge it but do not want to change the font for any other fields. What is the easiest way to make this change?
A. Select the text to be enlarged in the live previewed and makes the size change using the style bar.
B. Select the text to be enlarged in the layout mode and make the change.
C. Open the report wizard in the re-entrant mode and make the change.
D. Make the copy of the report, open the copy, make the changes and then delete the original report.

3. You created a tabular report for human resources department. After viewing layout users have requested that you change the label of the dept column to something more meaningful. How would you change the label in the live previewed?

A. Use the report wizard to change the column label.
B. Click and highlight the column label and replace it with desired text.
C. Click the column label and alter its property palette.
D. Click the dept column and alter its property palette.

4. What are the most commonly used numeric format symbols on the Style bar?

A. Currency Symbol
B. Percentage Symbol
C. Thousand Separator
D. Add Decimal Separator
E. Add Decimal Places
F. All of the above

5. The file extension for paper templates is

a. .pdf
b. .bmp
c. .tdf
d. .pal

6. For an inventory report, you created a work_in_progress that contains two columns, ID_number and quantity. The parent group of the work_in_progress is in_inventory which contains one column, dept_no. You added a filter of the first fifteen to total_inventory and a filter of last 20 work_in_progress. Which records will the report return?
A. First 15 dept_no values.
B. Last 20 ID_number and quantity values with the first 15 dept_no values for each work_in_progress value.
C. First 15 dept_no values with last 20 ID_number and quantity values for each total_inventory value.
D. First 15 dept_no values and last 20 ID_number and quantity values.
E. The last 20 ID_number and quantity values.

7. Which of the custom JSP tags in Oracle9i Reports:

A. rw:reports
B. rw:objects
C. rw:dataArea
D. rw:graph
E. rw:id
F. All of the above

8. In a Report Wizard if we choose Report Type Create Web Layout Only and complete the steps of the wizard. Which view will
appear?

a. Paper Layout
b. Paper Design
c. Data Model
d. Web Source
e. Paper Parameter Form

9. You want to create a template to be used a standard for all company reports, which are many different styles. How many different templates must you have if you plan to use multiple report style?

A. Two
B. One

C. One per report style.
D. One per report style + one more.

10. You want to create a template to be used as a standard for all company reports.
What is the easiest way to do this.
A. Open an existing template file, rename it and modify the template objects.
B. Open the report wizard and create a new template.
C. Open the layout model and copy the paste items from the default templates provided in the report builder.
D. Templates cannot be modified in release 2.

11. How many report templates would you need to create for the Tabular, Matrix, Group Left and Group above Styles?

A. 1
B. 2
C. 3
D. 4

12. You used the STS template when creating the Sales report. In the Live Previewer, you changed the background color of the report margin. If you reapply the template in the
Report Wizard, what will happen to the changes you made to the report?
A. They will remain unchanged
B. They will automatically be overridden by the template.
C. They will be overridden if you select the Revert option.
D. They will be overridden if you select the Reinherit option

13. Which two report Builder components would you use to modify the body of a report template? (Choose Two).

A. Report Wizard
B. Live Previewer
C. Template Editor
D. Property Inspector
E. Object Navigator

14. Which Report Builder component would you use to import an image into the margin of the SAL1 Template?

A. Layout Model
B. Live Previewer
C. Property Platte
D. Object Navigator
E. Template Editor

15. In the Report Wizard, which template option would you use to select a user-defined template? not registered in you cagprefs.ora?

A. Default
B. No Template
C. Template file
D. Predefined Template

Chapter 8,9,10:

1. Which of the following objects consists of the data model?

A. Query
B. Parameter
C. Group
D. Link
E. Column
F. Repeating Frame
G. Field

2. How would you change a group name?
A. Double click the group node in the Layout Model
B. Change the Name property on the group Property Inspector
C. Change the Name property on the report Property Inspector
D. Highlight the group name in the Data Model and enter the new name

3. You are developing a master –detail report for the Sales department using a join query . You set a group filter on the master group to retrieve the first 20 records from the Inventory table and a group filter on the detail group to retrieve the last 30 records from the Sales table . How many records will the query retrieve?
A. All the records from both tables
B. All the records from the Inventory table and the last 30 records from the Sales table
C. The first 20 records from the Inventory table and all the records from the Sales table
D. The first 20 records from the Inventory table and the last 30 records from the Sales table

4. You are developing the Sales report based on this query :

SELECT s.id, s.name, s.description, s.m_id, p.id, p.name
FROM inventory s, manufacturer p
WHERE s.m_id = p.id
The report should break on the Manufacturer values. In the Data Model, how would you create a break group?
A. Place the Inventory column first in the default group
B. Set a break order on the default group Property Inspector
C. Set a break order on the Inventory column Property Inspector
D. Click and drag the Inventory column out of and below the default group to create a child group
E. Click and drag the Inventory column out of and above the default group to create a parent group

5. You are developing a master a master-detail report and need to restrict the number of rows retrieved for the detail group. How could you restrict the number of records retrieved to ten?
A. Add a group filter to the query
B. Add a group filter to both groups
C. Add a packaged filter to the detailed group
D. Alter the Maximum Rows field on the query Property Inspector
E. You cannot restrict the number of records retrieved for a group

6. When would you have to update the layout to reflect the change you made to the query that retrieves data for the Inventory report?

A. Only when you add a column
B. Only when you remove a column
C. Only when you change a column label
D. When any change is made to the query

7. How would you create a data link between two groups?
A. Use the Link tool in the Data Model , click the child group , and drag a link to the parent group
B. Use the Link tool in the Data Model , click the parent group , and drag a link to the child group
C. Use the Link tool in the Data Model , click the primary key of the child group , and drag a link to the foreign key of the parent group
D. Use the Anchor tool in the Layout Model , click the primary key of the child group , and drag a link to the foreign key of the parent group
E. Use the Link tool in the Data Model , click the primary key or foreign key of the parent group , and drag a link to the primary key or foreign key of the child group

8. How would you create a break a group for the master-detail report based on a single query?
A. Create a second query and link the groups
B. Click and drag the break column(s) out of and above the default group in the Data Model
C. Click and drag the break column(s) out of and below the default group in the Data Model
D. Click and drag the break column(s) out of and above the default group in the Layout Model
E. Click and drag the break column(s) out of and below the default group in the Layout Model

9. Using the report wizard you create a tabular report to display all the columns in the EMP table. The records are ordered by the dept_name and job columns. You need to create a hierarchical report that breaks on the dept_name and job values. Using the data model how would you create this break structure?
A. Specify the break order on the g_emp group Property palette.
B. Specify the break order on the dept_name and job columns Property palettes.
C. Click and drag the dept_name and jobs column out and above of the g_emp group to create a new parent group.
D. Change the position of dept_name and the job columns within the g_emp group.

10. You create a salary report to display employee salaries grouped by the dept column. You need to change the break order from ascending to descending using the model. How would you reverse the display order of department?
A. Double click the dept column in the group to alter the property inspector and change the break out order value.
B. Double click the dept column in the group to open the property inspecto and change the set break out order value.
C. Double click the g_dept group object to change the break order.
D. Click the dept column in the group to change the break order.

11. You Created a tabular report for the sales department to display each customer and the sales person assign to the customer. The data is sorted by customer using the order by clause in this query.
This is department manager asks you to alter the report so that data is sorted by sales person rather than by customer. What is the best way to make the needed change?
A. Recreate the query and default the layout.
B. Alter the query, default the layout and redo the boilerplates.
C. Query and manually change the layout to save the boilerplate.
D. Alter the query and make no further change.

12. In the data Model you created this query : SELECT Id_no, description, price, quantity, manufacturer_id FROM inventory. Next you click and drag the manufacturer_id column out of and above the default group. You need to sort the child group by id_number. How could you accomplish this task?

A. Add an order by clause to the query.
B. In the Data model double click the ID_number column and alter the break order.
C. In the layout model double click the ID_Number filed and later the print direction.

D. Default the layout , Choose a master/detail report style and select ID_number as the break order.

13. The register’s office requested a report that lists each students, their advisors name and phone number. Each class has currently enrolled in and a GPA for each semester. To do this you need to pull data from the student, advisor, class and grade tables. From a performance point of view which data model option is preferable for database access?

A. Create one query and three additional groups.
B. Create two queries and two additional groups and then relate the groups.
C. Create three queries and one additional group and then relate the groups
D. Create four queries and relate the groups.

14. In the data model you created two queries that produced two groups named employee and sales. The sales group is a child in the employee group. You establish a relationship between the two queries by creating a link. Which modifications would you make to the data link property sheet for this relationship?
A. No modifications are needed because the default values represent the relationship.
B. Modify the SQL clause to having and conditioned to link.
C. Modify the SQL clause to where and conditioned to link.
D. Modify the SQL clause to where and conditioned to = .

15. You created the Inventory report based on this query :

SELECT id, name, description , quantity, m_id
FROM inventory
ORDER BY id
You clicked and dragged the m_id column out of and above the default group to create a break group. How would you display a count value for the id values reset by the m_id values ?
A. Alter the query
B. Use a placeholder column with the COUNT function
C. Use a summary column and reset it by default group
D. Use a summary column and reset it by the break group
E. Use a formula column and reset it by break group
F. Use a formula column and reset it by default group

16. Which type of column would you use to store the names of the regions with the largest and smallest total salary values?

A. file
B. link
C. summary
D. placeholder

17. You creating a report to display all employee names and salaries. Which type of column would you use to calculate a report level total of all employee salaries?

A. file
B. formula
C. summary
D. placeholder

18. Which summary column property sheet setting would you alter to specify the group for which a % of Total is calculated?

A. Source
B. Function
C. Reset At
D. Compute At

19. The Inventory table has a column that contains the name of a .bmp file stored on a network drive. These .bmp files are images of inventory items. Which type of column would you use to display these images in the Inventory report?

a. file
b. formula
c. summary
d. placeholder

20. Which type of column would you create to display the values created by a PL/SQL function ?

a. file
b. formula
c. summary
d. placeholder

21. Which summary column property sheet setting would you alter to select the name of the column whose values are to be summarized?

a. Function
b. Reset At
c. Compute At
d. Source

22. You created the Sales report based on this query:
SELECT c.id, c.name, o.c_id, o.total, c.exempt_ststus
FROM customer c, order o
WHERE c.id = o.c_id
You need to add a column to the report to display a tax calculation based on total *0.06 where the EXEMPT_STATUS value is equal to ‘Y’. How would you add this column to the report?

A. Use a summary column
B. Use a formula column
C. Use a placeholder column
D. Add the calculation to the query
E. Add a link column to the query


Chapter 11, 12
1. You need to add a page number to the bottom margin of your report pages. How would you navigate to the margin area?
A. Use the menu options Tools > Margin
B. Click on the margin button
C. In the layout models press +
D. This task can only be accomplished programmatically

2. Which setting change would you allow to make a child object to moved out of a parent object?

A. Flex mode on
B. Flex mode off
C. Confined mode on
D. Confined mode off

3. You creating a sales data template and need to add a picture to the margin . What is the best way to add this margin?
A. Choose the margin code in the object navigator and select File > Import > Image
B. Choose the margin code in the object navigator and use the tool bar button
C. Click the margin button in the layout model and select File > Import > Image
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. You creating a report containing two headers and three tailor pages. You set the logical page size to 2 into 1. The body if the report is four logical pages. How many physical pages is the entire report?

A. 36
B. 4
C. 9
D. 6

7. Which setting would you use to ensure that a parent object will not resize even if the child object expands?

A. Flex mode on
B. Flex mode off
C. Confined mode on
D. Confined mode off

8. Which setting would you use to ensure that if a child object expands, the parent object will be resized to accommodate the child object?

A. Flex mode on
B. Flex mode off
C. Confined mode on
D. Confined mode off

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

A. Fixed
B. Expand
C. Contract
D. Variable

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

A. Page Protect
B. Page Break After
C. Page Break Before
D. Keep With Anchoring Object

11. When you defaulted the layout of the master/detail report, what is the default

A. Horizontal Field Size?
B. Fixed
C. Expand
D. Contract
E. Variable

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

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

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

A. Fixed
B. Expand
C. Contract
D. Variable

15. How would you assign a Pagination property value of Page to two field in the layout Editor?
A. Double-Click on each field and modify the Pagination property
B. Choose Tools> Options for each field and modify the Pagination property.
C. Choose Tools>Properties from the menu for each field and modify the Pagination property.
D. Use Key, Select both fields, and choose Tools>Common Properties to modify the Pagination property.
E. Use theKey, Select both fields and choose Tools>Options from the menu to modify the Pagination property.

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

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

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 Sizing value for a graphical object will format faster?

A. Fixed
B. Expand
C. Contract
D. Variable

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

Chapter 13, 14, 15
1. You need to add a page number to the bottom margin of your report pages. How would you navigate to the margin area?
A. Use the menu options Tools > Margin
B. Click on the margin button
C. In the layout models press +
D. This task can only be accomplished programmatically
E.
2. Which setting change would you allow to make a child object to move out of a parent object?

A. Flex mode on
B. Flex mode off
C. Confined mode on
D. Confined mode off

3. You creating a sales data template and need to add a picture to the margin . What is the best way to add this margin?
a. Choose the margin code in the object navigator and select File > Import > Image
b. Choose the margin code in the object navigator and use the tool bar button
c. Click the margin button in the layout model and select File > Import > Image
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?

a. Fixed
b. Expand
c. Contract
d. 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?

A. Page Protect
B. Page Break After
C. Page Break Before
D. 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?

A. Sizing
B. Pagination
C. 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.Ans: B

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 How would you assign a Pagination property value of Page to two fields in the layout Editor?
A. Double-Click on each field and modify the Pagination property
B. Choose Tools> Options for each field and modify the Pagination property.
C. Choose Tools>Properties from the menu for each field and modify the Pagination property.
D. Use Key, Select both fields, and choose Tools>Common Properties to modify the Pagination property.
E. Use theKey, Select both fields and choose Tools>Options from the menu to modify the Pagination property.

14. How would you resize an anchor?

A. Click and drag the anchor
B. You cannot resize an anchor

C. Alter the % property of the anchor
D. Alter the Object property of the anchor

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 anybody 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 Sizing value for a graphical object will format faster?

A. Fixed
B. Expand

C. Contract
D. Variable