单项选择题
A. statistics recommendations
B. SQL Profile recommendations
C. Index-related recommendations
D. restructuring of SQL recommendations
多项选择题 WhataretherecommendationsforOracleDatabase11ginstallationtomakeitOptimalFlexibleArchitecture(OFA)-compliant?()
单项选择题 Note the following parameters settings in your database: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issued the following command to increase the value of DB_8K_CACHE_SIZE: SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M; What would happen?()
单项选择题 You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database. You executed the following RMAN commands: RMAN> CONNECT TARGET sys/sys@APPPROD RMAN> CONNECT AUXILIARY sys/sys@DUPDB RMAN> DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE PASSWORD FILE SPILE NOFILENAMECHECK; What are the implications of this command?()