083+上传墨天轮+288+共404+v20220518_在线真题试卷与模拟练习_083+上传墨天轮+288+共404+v20220518_考试宝

更新时间：试题数量：购买人数：提供作者：

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

随机练习 自定义设置练习量

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

学习资料 考试学习相关信息

搜索

题库预览

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?

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

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的哪个选项？

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? 完成该需求的最少必要步骤的正确执行顺序是什么

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? 完成该需求的最少必要步骤的正确执行顺序是什么？

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）将为哪些数据库生成

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

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?

1. CDB1 is an Oracle Database 12c Release 2 container database (CDB). 2. PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1. 1. CDB1 为 Oracle 数据库 12c 第2版的容器数据库（CDB）。 2. PDB1 和 PDB2 是 CDB1 中的两个可插拔数据库（PDB）。在成功执行所有升级前准备操作后，你在 Oracle 数据库 18c 环境中执行了以下命令 After successfully performing all the preupgrade tasks, you execute these commands from the Oracle Database 18c environment: $$ export ORACLE_SID=cdb1 $$ sqlplus / as sysdba SQL> STARTUP UPGRADE; SQL> SHOW pdbs CON_ID CON_NAME OPEN MODE RESTRICTED 2 PDB$$SEED 3 PDB1 4 PDB2 SQL> ALTER PLUGGABLE DATABASE pdb1 OPEN UPGRADE; Pluggable database altered. SQL> exit $$$ORACLE_HOME/perl/bin/perl catctl.pl -C 'PDB2' What is the outcome?

Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. COMMON_USER_PREFIX is set to an empty string. 3. PDB1 is a pluggable database in CDB1. 4. APP1_ROOT is an application container in CDB1. 5. APP1_PDB1 is an application PDB in APP1_ROOT. 选择最佳答案。查看以下配置信息： 1. CDB1 是一个容器数据库。 2. 通用用户前缀（COMMON_USER_PREFIX）被设置为空字符串。 3. PDB1 是 CDB1 中的一个可插拔数据库。 4. APP1_ROOT 是 CDB1 中的一个应用容器。 5. APP1_PDB1 是 APP1_ROOT 中的一个应用可插拔数据库。 You execute these commands: $ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> CREATE ROLE role1 CONTAINER=CURRENT; Which is true?

Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. DEFAULT_SHARING is METADATA. 3. APP_ROOT is an application root contained in CDB1. 4. APP_PDB1 is an application PDB contained in APP_ROOT. 5. COMPANYAPP is an application contained in APP_ROOT. 6. EMP is a common table created in APP_ROOT and all its application PDBs, created when version 1.0 of COMPANYAPP was installed. 选择最佳答案。查看以下配置信息： 1. CDB1 为一个容器数据库。 2. 初始化参数 DEFAULT_SHARING 的值为 METADATA（元数据共享）。 3. APP_ROOT 是包含在 CDB1 中的一个应用容器。 4. APP_PDB1 是包含在 APP_ROOT 中的一个应用可插拔数据库。 5. COMPANYAPP 是部署在 APP_ROOT 中的一个应用程序。 6. EMP 是一张公用表，在安装 COMPANYAPP 1.0 版本时创建于 APP_ROOT 及其所有应用可插拔数据库中 You execute these commands: $ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> ALTER SYSTEM SET DEFAULT_SHARING=DATA; System altered. 系统已更改。 SQL> ALTER SESSION SET CONTAINER=app_root; Session altered. 会话已更改。 SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp BEGIN UPGRADE '1.0' TO '2.0'; pluggable database altered. 可插拔数据库已更改。 SQL> ALTER TABLE emp ADD (sal NUMBER NOT NULL); Table altered.表已更改。 SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp END UPGRADE TO '2.0'; Pluggable database altered. 可插拔数据库已更改 SQL> ALTER SESSION SET CONTAINER=app_pdb1; Session altered.会话已更改 SQL> DESC emp; Name Null? Type ENO NUMBER ENAME VARCHAR2 (20) SQL> SELECT * FROM emp; ENO ENAME 100 Alan 200 Ben SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp SYNC; What will be the outcome and why? 执行上述同步操作后的结果是什么？原因是什么？

Choose the best answer. Examine this configuration: 1. CDB1 is an Oracle container database from an older release. 2. PDB1, PDB2, PDB3, and PDB4 are pluggable databases in CDB1. 1. CDB1 是早期版本的 Oracle 容器数据库。 2. PDB1、PDB2、PDB3 和 PDB4 是 CDB1 中的可插拔数据库。 A priority list UpgrdList has these entries: 1, pdb2 2, pdb1, pdb3 You execute this command: $ /u01/app/oracle/product/18.1.0/ db_1/rdbms/admin/dbupgrade -L UpgrdList In which order will the upgrade occur?数据库将按何种顺序执行升级？

Choose the best answer. Your CDB has two regular PDBs as well as one application container with two application PDBs and an application seed. No changes have been made to the standard PDB$SEED. How many default temporary tablespaces can be assigned in the CDB? 你的容器数据库中包含两个常规可插拔数据库，同时还有一个应用容器，该应用容器下配有两个应用可插拔数据库和一个应用种子容器。未对标准的 PDB$SEED 种子容器做任何修改该容器数据库中最多可分配多少个默认临时表空间？

查看当前版本 Oracle 多租户数据库的导出操作前置输出结果 SQL> col name for a10 SQL> select name, open_mode from v$$pdbs; NAME OPEN_MODE ------------------ ---------- PDB$$SEED READ ONLY PDB1 READ WRITE PDB2 MOUNTED SQL> exit Next you execute: $ expdp system/oracle full=y What is the outcome?

Choose the best answer. Examine this output of an export from the current release of an Oracle multitenant database: $ sqlplus system/oracle . 查看当前版本 Oracle 多租户数据库的导出操作前置输出结果 SQL> col name for a10 SQL> select name, open_mode from v$$pdbs; NAME OPEN_MODE -------------------- PDB$$SEED READ ONLY PDB1 READ WRITE PDB2 MOUNTED SQL> exit Next you execute: $ expdp system/oracle full=y What is the outcome?

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

You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges. The statistics_level parameter is PDB modifiable. As the user sys, execute the following command on pdb2: 你正在管理一个包含两个可插拔数据库（PDB）pdb1 和 pdb2 的多租户容器数据库（CDB）。你以拥有 DBA 权限的通用用户身份连接至 pdb2。statistics_level 参数为 PDB 可修改类型。以 sys 用户身份在 pdb2 上执行以下命令： SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE; Which statement is true about the result of this command?

Examine this extract from the show parameters command:查看show parameters命令的以下输出片段 How are SGA and PGA memory managed by instance using these parameter settings? 实例会如何通过这些参数设置管理SGA和PGA内存？（含图）

Examine this extract from the show parameters command: [show parameters命令输出表格] How are SGA and PGA memory managed by instance using these parameter settings? 实例会如何通过这些参数设置管理 SGA 和 PGA 内存？ (缺图)

You execute this command successfully: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What is the outcome?

更多题库