You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1. Which statements are true regarding extent management and allocation units in the ASM disk group？（） The au_size disk group attribute determines the size of allocation units in the disk group. 。 The allocation unit size may vary but the extent size is fixed.。 The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.。 Extent management is completely automated.。
馈线到天线端的小区连接和机柜端的小区连接需（） 正确。 不需要对应。
Examine the data from the EMP table: EMP_ID DEPT_ID COMMISSION 1 10 500 2 20 1000 3 10 4 10 600 5 30 800 6 30 200 7 10 8 20 300 The COMMISSION column shows the monthly commission earned by the employee. Which three tasks would require subqueries or joins in order to perform in a single step? （） Deleting the records of employees who do not earn commission.。 Increasing the commission of employee 3 by the average commission earned in department 20.。 Finding the number of employees who do NOT earn commission and are working for department 20.。 Inserting into the table a new employee 10 who works for department 20 and earns a commission that is equal to the commission earned by employee 3.。 Creating a table called COMMISSION that has the same structure and data as the columns EMP_ID and COMMISSIONS of the EMP table.。 Decreasing the commission by 150 for the employees who are working in department 30 and earning a commission of more then 800.。
盆栽及造型类：
You configured the large pool for Oracle backup and restore operations. As a result， which component would require less memory？（） streams pool。 shared pool。 log buffer。 keep buffer cache。 recycle buffer cache。
Your application demands frequent connection and disconnection from the database. You have three listener processes that are listening for the database PROD. While setting up the connect string using Oracle Enterprise Manager 10g Database Control， which two options would you select to balance the connection load across all the listener processes？（）
