單項(xiàng)選擇題

Your database supports an online transaction processing (OLTP) application.
The application is undergoing some major schema changes, such as addition of new indexes and materialized views.
You want to check the impact of these changes on workload performance.
What should you use to achieve this?（）

A. Database replay
B. SQL Tuning Advisor
C. SQL Access Advisor
D. SQL Performance Analyzer
E. Automatic Workload Repository compare reports

你可能感興趣的試題

單項(xiàng)選擇題

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).
The characteristics of the non-CDB are as follows:
-Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit -Character set: AL32UTF8 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit
The characteristics of the CDB are as follows:
-Version: Oracle Database 12c Release 1 64-bit -Character Set: AL32UTF8 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?（）

A. Transportable database
B. Transportable tablespace
C. Data Pump full export/import
D. The DBMS_PDB package
E. RMAN

多項(xiàng)選擇題

You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.
You plan to create the database using SQL statements.
Which three techniques can you use to achieve this?（）

A. Use Oracle Managed Files (OMF).
B. Specify the SEED FILE_NAME_CONVERT clause.
C. Specify the PDB_FILE_NAME_CONVERT initialization parameter.
D. Specify the DB_FILE_NAMECONVERT initialization parameter.
E. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

你可能感興趣的試題

You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories. You plan to create the database using SQL statements. Which three techniques can you use to achieve this?（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.
You plan to create the database using SQL statements.
Which three techniques can you use to achieve this?（）