多项选择题

A. Change in the Oracle Database versionB. Change in yo……

Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）

A. Change in the Oracle Database version
B. Change in your network infrastructure
C. Change in the hardware configuration of the database server
D. Migration of database storage from non-ASM to ASM storage
E. Database and operating system upgrade

<上一题目录下一题>

热门试题

单项选择题Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN. You want to issue the following RMAN command: RMAN > BACKUP TABLESPACE hr_pdb:userdata; Which task should you perform before issuing the command?（）

A. Place the root container in ARHCHIVELOG mode.
B. Take the user data tablespace offline.
C. Place the root container in the nomount stage.
D. Ensure that HR_PDB is open.

多项选择题Which four actions are possible during an Online Data file Move operation?（）

A. Creating and dropping tables in the data file being moved
B. Performing file shrink of the data file being moved
C. Querying tables in the data file being moved
D. Performing Block Media Recovery for a data block in the data file being moved
E. Flashing back the database
F. Executing DML statements on objects stored in the data file being moved

多项选择题Which two statements are true about Oracle Managed Files (OMF)?（）

A. OMF cannot be used in a database that already has data files created with user-specified directions.
B. The file system directions that are specified by OMF parameters are created automatically.
C. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.
D. OMF automatically creates unique file names for table spaces and control files.
E. OMF may affect the location of the redo log files and archived log files.

多项选择题You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?（）

A. User session data
B. Stack space
C. Private SQL area
D. Location of the runtime area for DML and DDL Statements
E. Location of a part of the runtime area for SELECT statements

多项选择题Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）

A. ALTER TABLE SPLIT PARTITION
B. ALTER TABLE MERGE PARTITION
C. ALTER TABLE TRUNCATE PARTITION
D. ALTER TABLE ADD PARTITION
E. ALTER TABLE DROP PARTITION
F. ALTER TABLE MOVE PARTITION