In the layout model increase the size of the employee record fields.
In the report wizard increase the display width values of the employee record fields.
In the property palette increase the size of the repeating frame surrounding the employee records.
In the life previewer, high light a field, click on the parent frame icon and make the frame bigger verticall.
第1题:
You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem?()
第2题:
Users in your PROD database complain about the slow response of the transactions. While investigating the reason, you find that the transactions are waiting for the undo segments to be available, and undo retention has been set to zero. What would you do to overcome this problem?()
第3题:
The IT department requested a report to list each server name and the name of each department that utilizes resources from each server. You create a tabular layout that breaks on the server name. You ran the report and noticed that the department field is too large for most of the department names. Which field size setting would you use to allow the field to be smaller but not larger than the field layout size?()
第4题:
You work as a database administrator for Certkiller .com. Users in the Certkiller .com PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available, and undo retention has been set to zero. What would you do to overcome this problem?()
第5题:
You create a financial report to be represented to board of directors. The accounting manager has asked you to change the number format to show a thousand separator. What is the best method to make this change to the report quickly?()
第6题:
You are working as a DBA at NetFx Corporation. A user, Scott, is maintaining the records of all the employees in the EMPLOYEEtable. Initially, the salary of the employee, ’E0025’, was $1800. On 1 May 2004, the salary of the employee, ’E0025’, was increased by $200. The user, Scott, issued the following statement to modify the record of the employee, ’E0025’: SQL>UPDATE EMPLOYEE SET SALARY = 2000 WHERE EMPNO = ’E0025’; SQL>COMMIT; On December 1, 2004, the salary of the employee, ’E0025’, was increased by $400. The user, Scott, issued the following statement to modify the record of the employee, ’E0025’: SQL>UPDATE EMPLOYEE SET SALARY = 2400 WHERE EMPNO = ’E0025’; SQL>COMMIT; On July 1, 2005, the salary of the employee, ’E0025’, was increased by $500. The user, Scott, issued the following statement to modify the record of the employee, ’E0025’ SQL>UPDATE EMPLOYEE SET SALARY = 2900 WHERE EMPNO = ’E0025’; SQL>COMMIT; On July 5, 2005, the HR manager asked you to generate the increment report of the employee, ’E0025’, for the period between 1 May 2004 and 1 July 2005. Which flashback feature will you use to generate the increment report?()
第7题:
You want to create a template to be used as a standard for all company reports. What is the easiest way to do this?()
第8题:
You are creating a tabular report for the sales department with a department break group. You need to ensure that if al least six sales records will not fit at the button of a page, the group will start on the next page. Which printing frame property would you alter to achieve these results?()
第9题:
Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance?()
第10题:
You create a tabular employee report and are concerned about readability because the employee records are very close together. What is the best way to increase the amount of white space between the records?()