首页  /  试题详情

单选题 Choose the best answer. How do you configure a CDB for local undo mode? 如何为容器数据库配置本地回滚模式？

A、 Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace. Execute ALTER DATABASE LOCAL UNDO ON in each PDB, and then restart the CDBinstance.
B、 Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance.
C、 Open the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the CDB instance.
D、 Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, create an UNDO tablespace in each PDB, and then restart the CDB instance.
E、 Open the CDB in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then change the CDB to read/write mode.
查看答案
下载APP答题
由4l***1u提供 分享 举报 纠错
题库推荐
083+上传墨天轮+288+共404+v20220518
2026-02-09
共335道
083+上传墨天轮+288+共404+v20220518
2026-02-09
共335道

相关试题

单选题 What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement? In CREATE DATABASE语句中指定ENABLE PLUGGABLE DATABASE子句，会产生什么效果

A、It will create a multitenant container database (CDB) with only the root opened.
B、It will create a CDB with root opened and seed read only.
C、<选项内容缺失>
D、It will create a CDB with root and seed opened and one PDB mounted.
E、It will create a CDB that must be plugged into an existing CD
F、ItwillcreateaCDBwithrootopenedandseedmounted.

单选题 You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications: Applications will connect to the database via a middle tier. The number of concurrent user connections will be high. The database will have mixed workload, with the execution of complex BI queries scheduled at night. Which DBCA option must you choose to create the database? 你计划使用数据库配置助手（DBCA）创建数据库，具体规格要求如下：应用程序将通过中间层连接至该数据库；并发用户连接数将处于较高水平；数据库为混合负载模式，且复杂的商业智能（BI）查询计划在夜间执行。 创建该数据库时，你必须选择DBCA的哪个选项？

A、a General Purpose database template with default memory allocation
B、a Data Warehouse database template, with the dedicated server mode option and AMM enabled
C、a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled
D、a default database configuration

单选题 Examine this configuration: 1. CDB1 is an Oracle Database 12c Release CDB1 是一个 Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2. 包含可插拔数据库 PDB$SEED、PDB1 和 PDB2 的数据库 2. PDB$$SEED is open READ ONLY PDB$$SEED 处于 只读打开 状态 3. 3. PDB1 is open READ WRITE PDB1 处于 读写打开 状态 4. 4. PDB2 is MOUNTED. PDB2 处于 挂载 状态 5. 5. ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1. ORACLE_HOME 路径为 /u01/app/oracle/product/18.1.0/dbhome_1 You execute these commands before upgrading the database to the current release: $$ . oraenv ORACLE_SID = [cdb1] ? cdb1 The Oracle base remains unchanged with value /u01/app/oracle $$ $ORACLE_HOME/jdk/bin/java -jar preupgrade.jar TERMINAL TEXT For which databases will fixup scripts be created? 修复脚本（fixup scripts）将为哪些数据库生成

A、CDB1, PDB$SEED, PDB1, and PDB2
B、PDB$SEED, PDB1, and PDB2 only
C、CDB1 and PDB$SEED only
D、CDB1, PDB1, and PDB2 only
E、CDB1, PDB$SEED, and PDB1 only

单选题 Aplication PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES_APP application. 需要创建应用可插拔数据库 SALES_APP1 和 SALES_APP2，且这两个库必须能够访问SALES_APP应用的公用表。 Examine these steps: 1. Install the SALES_APP application, including the common tables, in the application root. 在应用根容器中安装 SALES_APP 应用（包含公用表） 2. Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root. 3. Create an application seed in the application root. 4. Install the SALES_APP application in the application seed. 5. Create the SALES_APP1 and SALES_APP2 application PDBs. 创建应用可插拔数据库 SALES_APP1 和 SALES_APP2 6. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root. 将应用可插拔数据库 SALES_APP1 和 SALES_APP2 与应用根容器执行同步 7. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed. 8. Sync the application seed with the application root. Which are the minimum required steps in the correct sequence? 完成该需求的最少必要步骤的正确执行顺序是什么？

A、1,3,5,7
B、2,5,6
C、1,5,6
D、3,4,1,6,8
E、1,3,5,6,7

单选题 You want to create a test database as a replica of your production database with minimum intervention from a DBA. Which method would you use?

A、Use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the database in the new location.
B、Use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure.
C、Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump.
D、Create the database by using the CREATE DATABASE . . . command and manually import data by using Data Pump.

单选题 Choose the best answer. Which operating system group is NOT needed to perform an Oracle Database installation?执行 Oracle 数据库安装时，无需用到以下哪个操作系统用户组？

A、OSASM
B、OSRACDBA
C、OSKMDBA
D、OSDBA
E、OSOPER

单选题 Choose the best answer. Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES_APP application. Examine these steps: 1. Install the SALES_APP application, including the common tables, in the application root. 在应用根容器中安装 SALES_APP 应用（包含公用表） 2. 2. Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root. 3. Create an application seed.; 4. 4. Install the SALES_APP application in the application seed. 5. 5. Create the SALES_APP1 and SALES_APP2 application PDBs. 创建应用可插拔数据库 SALES_APP1 和 SALES_APP2 6. 6. Sync root. 同步根容器 7. 7. Sync seed. 8. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed. SALES_APP1和SALES_APP2 application PDBs with the application seed with the application root. Which are the minimum required steps in the correct sequence?

A、1,3,5,7
B、3,4,1,6,8
C、1,3,5,6,7
D、1,5,6
E、2,5,6

单选题 Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES_APP application. 需要创建应用可插拔数据库 SALES_APP1 和 SALES_APP2，且这两个库必须能够访问 SALES_APP 应用的公用表。 Examine these steps: 1. Install the SALES_APP application, including the common tables, in the application root. 在应用根容器中安装 SALES_APP 应用（包含公用表） 2. Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root. 3. Create an application seed. 4. Install the SALES_APP application in the application seed. 5. Create the SALES_APP1 and SALES_APP2 application PDBs. 创建应用可插拔数据库 SALES_APP1 和 SALES_APP2 6. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root. 将应用可插拔数据库 SALES_APP1 和 SALES_APP2 与应用根容器执行同步 7. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed. 8. Sync the application seed with the application root. Which are the minimum required steps in the correct sequence? 完成该需求的最少必要步骤的正确执行顺序是什么

A、1,3,5,7
B、2,5,6
C、1,5,6
D、3,4,1,6,8
E、1,3,5,6,7