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?（）A、In the layout model increase the size of the employee record fields. B、In the report wizard increase the display width values of the employee record fields. C、In the property palette increase the size of the repeating frame surrounding the employee records. D、In the life previewer, high light a field, click on the parent frame icon and make the frame bigger verticall.
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?（）
- A、In the layout model increase the size of the employee record fields.
- B、In the report wizard increase the display width values of the employee record fields.
- C、In the property palette increase the size of the repeating frame surrounding the employee records.
- D、In the life previewer, high light a field, click on the parent frame icon and make the frame bigger verticall.
相关考题：
Note the following parameters settings in your database:What would happen?() A. It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamicallyB. It will be successful only if the memory is available from the auto tuned componentsC. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGETD. It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE
Examine the data in the EMPLOYEES and DEPARTMENTS tables:Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables:On the EMPLOYEES table, EMPLOYEE_ID is the primary key.MGR_ID is the ID of managers and refers to the EMPLOYEE_ID.DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table.On the DEPARTMENTS table, DEPARTMENT_ID is the primary key.Examine this DELETE statement:What happens when you execute the DELETE statement?（）A. Only the row with department ID 40 is deleted in the DEPARTMENTS table.B. The statement fails because there are child records in the EMPLOYEES table with department ID 40.C. The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 110 and 106 are deleted from the EMPLOYEES table.D. The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 106 and 110 and the employees working under employee 110 are deleted from the EMPLOYEES table.E. The row with department ID 40 is deleted in the DEPARTMENTS table. Also all the rows in the EMPLOYEES table are deleted.F. The statement fails because there are no columns specifies in the DELETE clause of the DELETE statement.
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?（）A、Fixed B、Expand C、Contract D、Variable
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?（）A、Report wizard. B、Layout model. C、Data model. D、Life previewer.
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?（）A、Source B、Print direction C、Maximum records per page D、Minimum Widow records E、Column mode
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？（）A、 Increase the value of the FAST_START_MTTR_TARGET initialization parameter.B、 Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.C、 Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.D、 Increase the value of the SGA_TARGET initialization parameter.
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’： SQLUPDATE EMPLOYEE SET SALARY = 2000 WHERE EMPNO = ’E0025’； SQLCOMMIT； 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’： SQLUPDATE EMPLOYEE SET SALARY = 2400 WHERE EMPNO = ’E0025’； SQLCOMMIT； 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’ SQLUPDATE EMPLOYEE SET SALARY = 2900 WHERE EMPNO = ’E0025’； SQLCOMMIT； 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？（）A、 Flashback DropB、 Flashback TableC、 Flashback DatabaseD、Flashback Version Query
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？（）A、increase the undo retentionB、create more undo segmentsC、create another undo tablespaceD、increase the size of the undo tablespace
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 report builder. D、Templates cannot be modified in release 2.
You are creating the CUST_PREMIUM data block in the AUTO_INSURANCE form. A new state law requires that premiums be lowered for drivers with a good driving history. Because this could potentially affect a large number of records, you want to base the data block on a stored procedure returning a table of records. Which statement supports this approach?（）A、A table of records is efficient in terms of network traffic. B、A table of records improves developer productivity because the database administrator does not have to create a server side view. C、A table of records is efficient because the number of records fetched depends on the Array Fetch property value.D、Your coding effort is simplified since DML operations are handles by setting form module properties.
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?（）A、Open the property palette and set the format mask for all the numeric items in the report. B、Select the data to be free formatted in the life previewer and lick 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.
Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance？（）A、Data blocks have to be written more frequently by DBWR. B、Redo blocks have to be written more frequently by LGWR. C、You need to substantially increase the size of your database buffer cache to hold the additional checkpoint records. D、You need to substantially increase the size of your redo buffer cache to hold the additional checkpoint records.
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？（）A、Increase the undo returnB、Create more undo segmentsC、Create another undotablespaceD、Increase the size of the undotablespace
Using the report wizard you create a tabular report to display all the columns in the EMP table. The records are ordered by the deptname and job columns. You need to create a hierarchical report that breaks on the deptname and job values. Using the data model how would you create this break structure?（）A、Specify the break order on the gemp group Property palette. B、Specify a 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 gemp group to create a new parent group. D、Change the position of the dept_name and the job columns within the gemp group.
You are 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 node 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.
You work as a database administrator for Supportcenter.cn. Users in the Supportcenter.cn 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？（）A、Increase the undo returnB、Create more undo segmentsC、Create another undotablespaceD、Increase the size of the undo tablespace
Your company uses Microsoft Applicat ion Virtualization (App - V). When sequencing applications, you receive an error indicating that the App - V Sequencer is unable to save temporary files. You need to ensure that you can sequence applications. What should you do on the App - V Sequencer computer？（）A、Increase the amount of memory.B、Increase the storage space available to the %TMP% directory.C、Increase the storage space available to the %TEMP% directory.D、Increase the storage space available to the scratch directory.
You have a computer that runs Windows XP Professional. The computer has the following hardware installed: 3 GB page file, 2. 4 GHz processor, 2 GB of physical memory, 20 GB hard disk that has 1 GB of free space You need to enable hibernation support on the computer. What should you do first?（） A、Upgrade the processor.B、Add additional physical memory.C、Increase the size of the page file.D、Create additional free hard disk space.
You work as an application developer at Certkiller .com. You have been given the responsibility of creating a class named CalcSalary that will determine the salaries of Certkiller .com’s staff. The CalcSalary class includes methods to increment and decrement staff salaries. The following code is included in the CalcSalary class： public class CalcSalary { // for promotions public static bool IncrementSalary （Employee Emp， double Amount） { if （Emp.Status == QuarterlyReview.AboveGoals） Emp.Salary += Amount； return true； } else return false； } //for demotions public static bool DecrementSalary （Employee Emp， double Amount） { if （Emp.Status == QuarterlyReview.AboveGoals） Emp.Salary -= Amount； return true； } else return false； } } You would like to invoke the IncrementSalary and DecrementSalary methods dynamically at runtime from the sales manager application， and decide to create a delegate named SalaryDelegate to invoke them. You need to ensure that you use the appropriate code to declare the SalaryDelegate delegate.What is the correct line of code？（）A、 public delegate bool Salary （Employee Emp， double Amount）；B、 public bool Salary （Employee Emp， double Amount）；C、 public event bool Salary （Employee Emp， double Amount）；D、 public delegate void Salary （Employee Emp， double Amount）；
You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution. The solution contains a report named Sales Details that displays sales information of all the employees. You create an SSRS report named Sales Summary that displays the total monthly sales of each employee. Users who view the Sales Summary report occasionally require the monthly sales details for a particular employee. You need to ensure that the users can click a value in the month column of the Sales Summary report to open and render the Sales Details report. What should you do？（）A、 Use a subreport.B、 Use a bookmark link.C、 Use the drilldown functionality.D、 Use a drillthrough report link.
单选题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?（）ARecreate the query and default the layout. BAlter the query, default the layout and redo the boiler plates. CQuery and manually change the layout to save the boiler plate. DAlter the query and make no further change.
单选题You want to create a consumer group， GROUP1， and you execute the following command in the command-line interface： SQL EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP （CONSUMER_GROUP =’group1’， COMMENT = ’New Group’）； This command errors out displaying the following message： ERROR at line 1： ORA-29371： pending area is not active ORA-06512： at "SYS.DBMS_RMIN"， line 115 ORA-06512： at "SYS.DBMS_RESOURCE_MANAGER"， line 108 ORA-06512： at line 1 What action would you take to overcome this error？（）A activate the Pending Area before creating the consumer groupB create the Pending Area before creating the consumer groupC increase the size of the database buffer cache to accommodate the Pending AreaD increase the size of the shared pool to accommodate the Pending AreaE increase the size of the large pool to accommodate the Pending Area
单选题Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance？（）AData blocks have to be written more frequently by DBWR. BRedo blocks have to be written more frequently by LGWR. CYou need to substantially increase the size of your database buffer cache to hold the additional checkpoint records. DYou need to substantially increase the size of your redo buffer cache to hold the additional checkpoint records.
单选题You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution. The solution contains a report named Sales Details that displays sales information of all the employees. You create an SSRS report named Sales Summary that displays the total monthly sales of each employee. Users who view the Sales Summary report occasionally require the monthly sales details for a particular employee. You need to ensure that the users can click a value in the month column of the Sales Summary report to open and render the Sales Details report. What should you do？（）A Use a subreport.B Use a bookmark link.C Use the drilldown functionality.D Use a drillthrough report link.
单选题You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform? （）AMERGEBINSERTCUPDATEDADDEENTERFYou cannot enter the phone numbers for the existing employee records.
单选题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？（）A Increase the value of the FAST_START_MTTR_TARGET initialization parameter.B Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.C Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.D Increase the value of the SGA_TARGET initialization parameter.
单选题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?（）AIn the layout model increase the size of the employee record fields. BIn the report wizard increase the display width values of the employee record fields. CIn the property palette increase the size of the repeating frame surrounding the employee records. DIn the life previewer, high light a field, click on the parent frame icon and make the frame bigger verticall.