You need to generate a list of all customer last names with their credit limits from the CUSTOMERS table. Those customers who do not have a credit limit should appear last in the list. Which two queries would achieve the required result?（）

You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could you use？（）

单选题查看答案

For which database operation would you need the database to be in the MOUNT state（）

单选题查看答案

You are configuring a JMS server with a need for load balancing the messages. To achieve the  load balance you should （）.

多选题查看答案

Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（） 

多选题查看答案

You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）

单选题查看答案

You need to recover five data files that are spread across multiple disks. Which initialization parameter should you set to speed up redo application？（）

单选题查看答案

You need to create a data block for DML operations in the NEW_EMPLOYEE form module. Which data source can you use for this block?（）

单选题查看答案

You include the calendar class in your Hotel Booking application. Which additional form level objects will you need to create to implement this reusable component fully?（）

单选题查看答案

You need to display a very large single-record data block. Since it will be so large, a convenient means of navigation is needed between items. Which type of canvas would you use to display the data block? （）

单选题查看答案

You create a master-detail form. The users need to be able to exit the form quickly, adhering to default transaction processing, regardless of the cursor location. You believe you can achieve this using a Key-Exit trigger. What do you need to do to implement this request? （）

单选题查看答案