RUN_PRODUCT
SET_REPORT_OBJECT_PROPERTY
RUN_REPORT_OBJECT
FIND_REPORT_OBJECT
REPORT_OBJECT_STATUS
COPY_REPORT_OBJECT_OUTPUT
第1题:
The CALC function is used several times within the sales report. To simplify maintenance you want to store the function in one place and call it from within your PL/SQL trigger code. Which node would you use in object navigator to create a report level programme unit to store the function?()
第2题:
You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task?()
第3题:
The sales report needs to display the sales person with the highest order total. Which build report builder component would you use to create a place holder column to display the value?()
第4题:
You are developing a bonus report for the payroll application to calculate and display the bonus issue to each envelope. Employees with a salary of less than 50000$ earn a bonus of 15% and the employees who earn 50000$ or more earn out 10% bonus. Which type of trigger would you use to conditionally assign a bonus percentage?()
第5题:
There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database?()
第6题:
Using the reports server how would you force the orders report in the orders entry application to run every six hours?()
第7题:
36 You are creating a report wizard to create a matrix report. The query build, you select the patient_name column from the patient table; the doctor_name from the doctors table; and the doctor_ID, patient_ID and ID columns from the procedure table. In the report wizard you select patient_name as the row value, doctor_ID as the column values and the count as the cell values. You need to add a total for each doctors column. In the wizard report which tab will allow you to create the summary column?()
第8题:
You want to create a template to be used as 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 styles?()
第9题:
You creating a report that will run in both character mode and bitmapped environments. You include some printer codes in your report. What will happen when you run the report in bitmapped mode? ()
第10题:
You want to move all objects of the APPS user in the test database to the DB_USER schema of the productiondatabase. Which option of IMPDP would you use to accomplish this task()