Paper 18

45. What are the triggers available in the reports?

Before report, Before form, After form , Between page, After report.

46. Does a Before form trigger fire when the parameter form is suppressed.

Yes.

47. At what point of report execution is the before Report trigger fired?

After the query is executed but before the report is executed and the
records are displayed.

48. Is the After report trigger fired if the report execution fails?

Yes.

49. Give the sequence of execution of the various report triggers?

Before form , After form , Before report, Between page, After report.

50. Is it possible to modify an external query in a report which contains
it?

No.

51. What are the ways to monitor the performance of the report?

Use reports profile executable statement.
Use SQL trace facility.

52. Why is it preferable to create a fewer no. of queries in the data
model.

Because for each query, report has to open a separate cursor and has to
rebind, execute and fetch data.

53. What are the various methods of performing a calculation in a report ?

1. Perform the calculation in the SQL statements itself.
2. Use a calculated / summary column in the data model.

54. Which of the above methods is the faster method?

performing the calculation in the query is faster.

55. Why is a Where clause faster than a group filter or a format trigger?

Because, in a where clause the condition is applied during data retrieval
than after retrieving the data.

56. What is the main diff. bet. Reports 2.0 & Reports 2.5?

Report 2.5 is object oriented.

57. What is the diff. bet. setting up of parameters in reports 2.0 reports
2.5?

LOVs can be attached to parameters in the reports 2.5 parameter form.

58. How is link tool operation different bet. reports 2 & 2.5?

In Reports 2.0 the link tool has to be selected and then two fields to be
linked are selected and the link is automatically created. In 2.5 the first
field is selected and the link tool is then used to link the first field to
the second field.

REPORT 2.5 SPECIFIC ISSUES.

59.What are the two types views available in the object navigator(specific
to report 2.5)?

View by structure and view by type .

60. Which of the two views should objects according to possession?

view by structure.

61.How is possible to restrict the user to a list of values while entering
values for parameters?

By setting the Restrict To List property to true in the parameter property
sheet.

62. How is it possible to select generate a select ste. for the query in
the query property sheet?

By using the tables/columns button and then specifying the table and the
column names.

63. If a parameter is used in a query without being previously defined,
what diff. exist betw. report 2.0 and 2.5 when the query is applied?

While both reports 2.0 and 2.5 create the parameter, report 2.5 gives a
message that a bind parameter has been created.

64. Do user parameters appear in the data modal editor in 2.5?

No.

65.What is the diff. when confine mode is on and when it is off?

When confine mode is on, an object cannot be moved outside its parent in
the layout.

66. What is the diff. when Flex mode is mode on and when it is off?

When flex mode is on, reports automatically resizes the parent when the
child is resized.

67. How can a button be used in a report to give a drill down facility?

By setting the action asscoiated with button to Execute pl/sql option and
using the SRW.Run_report function.

68. What are the two ways by which data can be generated for a parameter's
list of values?

1. Using static values.
2. Writing select statement.

69. What are the two panes that Appear in the design time pl/sql
interpreter?

1.Source pane. 2. Interpreter pane

70. What are three panes that appear in the run time pl/sql interpreter?

1.Source pane. 2. interpreter pane. 3. Navigator pane.


CROSS PRODUCTS AND MATRIX REPORTS

71. How can a cross product be created?

By selecting the cross products tool and drawing a new group surrounding
the base group of the cross products.

72. How can a group in a cross products be visually distinguished from a
group that does not form a cross product?

A group that forms part of a cross product will have a thicker border.

73. Atleast how many set of data must a data model have before a data model
can be base on it?

Four.

74. Is it possible to have a link from a group that is inside a cross
product to a group outside ? (Y/N)

No.

75. Is it possible to link two groups inside a cross products after the
cross products group has been created?

No.

76. What is an user exit used for?

A way in which to pass control (and possibly arguments ) form Oracle report
to another Oracle products of 3 GL and then return control ( and ) back
to Oracle reprots.

77. What are the three types of user exits available ?

Oracle Precompiler exits, Oracle call interface,NonOracle user exits.

78. How can values be passed bet. precompiler exits & Oracle call
interface?

By using the statement EXECIAFGET & EXECIAFPUT.

79. How can I message to passed to the user from reports?

By using SRW.MESSAGE function.

Oracle DBA

1. SNAPSHOT is used for
[DBA] a] Synonym, b] Table space, c] System server, d] Dynamic data
replication
Ans : D

2. We can create SNAPSHOTLOG for
[DBA] a] Simple snapshots, b] Complex snapshots, c] Both A & B, d]
Neither A nor B
Ans : A

3. Transactions per rollback segment is derived from
[DBA] a] Db_Block_Buffers, b] Processes, c] Shared_Pool_Size, d] None
of the above
Ans : B

4. ENQUEUE resources parameter information is derived from
[DBA] a] Processes or DDL_LOCKS and DML_LOCKS, b] LOG_BUFFER,
c] DB__BLOCK_SIZE..
Ans : A

5. LGWR process writes information into
a] Database files, b] Control files, c] Redolog files, d] All the
above.
Ans : C

6. SET TRANSACTION USE ROLLBACK SEGMENT is used to create user
objects
in a particular Tablespace
a] True, b] False
Ans : False

7. Databases overall structure is maintained in a file called
a] Redolog file, b] Data file, c] Control file, d] All of the
above.
Ans : C

8. These following parameters are optional in init.ora parameter file
DB_BLOCK_SIZE,
PROCESSES
a] True, b] False
Ans : False

9. Constraints cannot be exported through EXPORT command
a] True, b] False
Ans : False

10. It is very difficult to grant and manage common privileges needed by
different groups of
database users using the roles
a] True, b] False
Ans : False