You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below: SGA_TARGET= 10GB SGA_MAX_SIZE = 14GB STREAMS_POOL_SIZE = 1GB SHARED_POOL_SIZE = 3GB Which two statements are correct in this scenario? () A maximum of 3 GB can be allocated to shared pool。 The value for SGA_TARGET can be increased up to a maximum of 15 GB。 A total of 14 GB memory will be allocated to the automatically tuned memory components.。 Increasing the value for SGA_TARGET will automatically increase the memory allocated for STREAMS_POOL_SIZE。 Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters。 Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB。
You work as a database administrator for Certkiller .com. In your development environmentenvironment, the developers are responsible for modifying the table structure according to the application requirements. However, you want to keep track of the ALTER TABLE commands being executed by developers, so you enable auditing to achieve this objective. Which two views would you refer to find out the audit information?() DBA_AUDIT_TRAIL。 DBA_AUDIT_SESSION。 DBA_FGA_AUDIT_TRAIL。 DBA_COMMON_AUDIT_TRAIL。
Given: What is the result?() TestA。 TestB。 Compilation fails.。 An exception is thrown at runtime.。
The following parameter are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You want to manage the SQL plan evolution task manually. Examine the following steps: 1. Set the evolve task parameters. 2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function. 3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function. 4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function. 5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function. Identify the correct sequence of steps:() 2,4,5。 2,1,4,3,5。 1,2,3,4,5。 1,2,4,5。
同样生产过程中调节器积分调节作用有以下规律积分时间加长调节作用() 增强。 减弱。 不变。
下面对受体的认识,哪些是正确的()