You created a tabular report for human resources department.

第1题：

第2题：

第3题：

第4题：

The human resources department requested an employee report to high light those employees who are due for 30 days 6 months and 1 year evaluation. The higher_data field should display blue text for 30 days employee, a red text for 6 months employees and a green text for one year employees. You created a format trigger on the higher_data field to handle this task. What will happen if the format trigger returns a false value? （）

• A、The report execution will be halted. 
• B、The higher_data file will not be displayed. 
• C、The record will not be displayed. 
• D、Nothing will happen.

第5题：

You have forgotten the name of binary PL/SQL library saved to the operating system. This file contains the PL/SQL constricts you created for the inventory report. For which file extension should you reach?（）

• A、 .SQL 
• B、 .PLL 
• C、 .PLD
• D、 .PRT

第6题：

第7题：

The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR; （）

• A、You obtain the results retrieved from the public synonym HR created by the database administrator.
• B、You obtain the results retrieved from the HR table that belongs to your schema.
• C、You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
• D、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
• E、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.

第8题：

第9题：

The transportation department requested a shipping cost report to list the resources used by each department. A separate page should be product for each department. Which property would you modify to achieve these results?（）

• A、Minimum widow records. 
• B、Column mode. 
• C、Spacing 
• D、Print direction. 
• E、Source F maximum records per page. 
• F、Maximum records per page.

第10题：

You are planning the migration of an existing application to Windows Azure and SQL Azure.  The application produces report files at the request of remote systems.   Requests for report files will be placed into a single Windows Azure Queue.   You must minimize the compute resources and storage transactions required to process the requests.   You need to recommend an approach for processing the requests. What should you recommend？（）

• A、 Create a worker role for each report file that constantly polls the queue for requests.
• B、 Create a workerrole for each report file that checks the queue at scheduled intervals for requests.
• C、 Create a single worker role that constantly polls the queue for requests and executes the requests on multiple threads.
• D、 Create a single worker role that checks the queue at scheduled intervals for requests and executes the requests on multiple threads.