083中英文重置版

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

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 练习进度 0 / 0

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

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Q8.How do you configure a CDB for local undo mode?

如何将CDB配置为本地撤消模式?

Q10.A user complains about poor database performance
用户抱怨数据库性能差
You want to verify if the user's session has waited for certain types of I/O activity
您希望验证用户会话是否已等待特定类型的I/0活动
Which view displays all waits waited on by a session at least once?
哪个视图至少显示一次会话等待的所有等待?

Q12.Examine this configuration检查此配置
1) CDB1 is a container database running in ARCHIVELOG mode.
CDB1 是以ARCHIVELOG模式运行的容器数据库。
2) Multiple uncommitted transactions are running in CDB1
CDB1中正在运行多个未提交的事务
3) Redo log groups 1 and 2 are INACTIVE
重做日志组1和2处于非活动状态
4) Redo log group 3 is the CURRENT group All members of redo log group 3 are lost before it is archived
重做日志组3是当前组重做日志组3的所有成员在存档之前都已丢失
Examine these possible steps
检查这些可能的步骤
1) SHUTDOWN ABORT
2) STARTUP NOMOUNT
3) STARUP MOUNT
4) ALTER DATABASE MOUNT
5) RESTORE DATABASE
6) RECOVER DATABASE NOREDO
7) RECOVER DATABASE UNTILAVAILABLE
8) RESTORE ARCHIVELOG ALL
9) ALTER DATABASE OPEN
10) ALTER DATABASE OPEN RESET LOGS
Choose the minimum required steps in the correct order to recover the database
按正确顺序选择恢复数据库所需的最少步骤

Q13.A schema owner truncated a table in error and must recover the data
架构所有者错误地截断了表,必须恢复数据
Which Oracle Flashback feature could be used to recover the data?
哪种Oracle 闪回功能可用于恢复数据?

Q37.Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?
在对Oracle数据库执行性能优化练习时,应首先优化哪一个环境

Q39.You want to transport the UNIVERSIRY tablespace from one database to another.The university tablespace is currently open read/write The source and destination platforms have the same endian format.
您希望将UNIVERSIRY 表空间从一个数据库传输到另一个数据库。universiry 表空间当前处于打开读/写状态源平台和目标平台具有相同的endian格式。Examine this list of steps:
检查以下步骤列表:
1). Make the UNIVERSIRY tablespace read-only on the source system
使源系统上的UNIVERSIRY表空间为只读
2). Export the UNIVERSIRY tablespace metadata using EXPDP
使用EXPDP 导出 UNIVERSIRY表空间元数据
3). Create a cross-platform backup set from the UNIVERSITY tablespace on the source system,using an RMAN command that includes the DAMAPUMP clause
从源系统上的UNIVERSITY表空间创建跨平台备份集,使用包含DAMAPUMP 子句的RMAN命令
4). Copy the cross-platform backup sets to the destination system
将跨平台备份集复制到目标系统
5). Copy the Data Pump dump set from the source to the destination system
将数据泵转储集从源系统复制到目标系统
6). Restore the cross-platform backup set on the destination system using an RMAN command that includes the pamapump clause
使用RMAN命令还原目标系统上的跨平台备份集,该命令包括pamapump子句
7). Import the UNIVERSIRY tablespace metadata using IMPDP
使用IMPDP 导入 UNIVERSIRY表空间元数据
8). Make the UNIVERSIRY tablespace read/write on the destination system
Which are the minimum number of steps required, in the correct order, to transport the UNIVERSIRY tablespace?
在目标系统上读/写UNIVERSIRY 表空间按照正确的顺序,运输车辆所需的最小步骤数是多少通用表空间?

Q45.Examine this configuration
检查这个配置
1). CDB1 is a container database.
CDB1是一个容器数据库。
2). APP_RoOT is an application root in cDB1.
APP_RoOT是cDB1中的一个应用程序根目录。
3). APP_PDB1 is an application PDB in APP_ROOT.
APP_PDB1是APP ROOT中的一个应用程序PDB。
4). FLASHBACK DATABASE is ON.
闪回数据库打开。
You execute these commands:
您可以执行以下命令:
$$ sqlplus sys/oracle_4U@localhost:1521/cdb1
SQL> SELECT current_scn FROM v$$database;
CURRENT_SCN----------------------2074756
SQL> CREATE TABLE cdb1_tab (c1 NUMBER);
Table created.
SQL> ALTER SESSION SET CONTAINER=app_root;
Session altered.
SQL> CREATE TABLE app_root_tab (c1 NUMBER);
Table created.
SOL> ALTER SESSION SET CONTAINER=app_pdb1;
Session altered.
SQL> CREATE TABLE app_pdb1_tab (c1 NUMBER);
Table created.
SQL> conn / as sysdba
Connected.
Which table or set of tables will exist after the Flashback operation has completed?
在闪回操作完成后，哪个表或一组表将存在?

Q50.Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?
哪条语句正确描述了SQL调优顾问执行的SQL评测?

Q69.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.
You execute these commands:
$ sqlplus sys/oracle@localhost:1521/cdbl as sysdba
SQL> CREATE ROLE role1 CONTAINER=CURRENT;
Which is true?
哪个是真的?

Q77.On the 10th of August, you implement an incremental database backup strategy and configure a recovery window of five days
Level 0 backups are taken on the 10th, 17th, and 24th of August Differential level 1 incremental backups are taken daily between the level O backup Today is the 26th of August
8月10日,您将实施增量数据库备份策略并配置五天的恢复窗口0级备份在8月10日、17日和24日进行每天在0级备份之间执行差异1级增量备份
今天是八月二十六日
Which backups will be obsolete?
哪些备份将过时?

Q83.Examine this configuration
检查以下配置
1). CDB1 is an Oracle Database 12c Release 2 container database (CDB).
CDB1是一个Oracle数据库12c Release 2容器数据库(CDB)。
2). PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1.$$ export ORACLE_SID=cdb1
$$ sqlplus / as sysdba
SQL> STARTUP UPGRADE;
SQL> SHOW pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
----------- ----------------- ----------------- -------------------
2 PDBSSEED MIGRATE YES
3 PDB1 MOUNTED YES
4 PDB2 MOUNTED YES
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?
结果如何?

Q89.Examine this output of an export from the current release of an Oracle multitenant database
检查Oracle多租户数据库当前版本的导出的输出
What is the outcome?
结果如何?

Q92.Application PDBS, SALES_Appl and SALES_App2, must be created and they must access common tables of the SALES_App application
必须创建应用程序PDBS、SALES_Appl和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.
在应用程序根目录中安装SALES_APP应用程序，在CDB根目录和应用程序根目录中安装公共表。
3). Create an application seed.
创建一个应用程序种子。
4). Install the SALES APP application in the application seed.
在应用程序种子中安装SALES应用程序。
5). Create the SALES_APP1 and SALES_APP2 application PDBs.
创建SALES_APP1和SALES_APP2应用程序pdb。
6). Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.
将SALES_APP1和l SALES_APP2应用程序pdb与应用程序根目录同步。
7). Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.
将SALES_APP1和l SALES_APP2应用程序pdb与应用程序种子同步。
8). Sync the application seed with the application root.
将应用程序种子与应用程序根目录同步。
Which are the minimum required steps in the correct sequence?
在正确的顺序中，需要的最小步骤是什么?

Q95.Examine this configuration
检查以下配置
1). cdb1 is a container database
Cdb1是一种容器数据库
2). There are several pluggable databases(PDBS)
In CDB1在CDB1中有几个可插拔数据库(PDBS)
3). Each PDB has several tables with referential integrity constraints
每个PDB都有几个具有引用完整性约束的表
4). FLASHBACK DAABASE is ON
FLASHBACK database开启
5). UNDO RETENTION GUARANTEE is enabled
开启UNDO RETENTION GUARANTEE功能
Multiple undesired multitable changes were made in all the PDBS
在所有的PDBS中进行了多个不希望的多表更改
Which method can be used to undo the changes using a single command?
使用单个命令可以使用哪种方法撤消更改

Q97.Examine this configuration:In which order will the upgrade occur?
检查这个配置:升级的顺序是什么?

Q102.Which operating system group is NOT needed to perform an Oracle Database installation?
DB RECOVERY FILE DEST Which操作系统组不需要执行Oracle数据库安装?

Q104.Your CDB has two regular PDBs as well as one application container with two application PDBs and an application seed.
您的CDB有两个常规pdb，以及一个应用程序容器，其中包含两个应用程序pdb和一个应用程序种子。
No changes have been made to the standard PDBSSEED.
标准PDBSSEED没有做任何更改。
How many default temporary tablespaces can be assigned in the CDB?
在CDB中可以分配多少默认的临时表空间?

Q1.Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and

Later releases?

关于回收Oracle数据库19c和19c中闪回日志使用的空间,哪两个是正确的以后的版本?

Q2.Which two are true about server-generated alerts?

关于服务器生成的警报,哪两个是正确的?

Q3.Which three are true about upgrading Oracle Grid Infrastructure?

关于升级Oracle网格基础架构,哪三个是正确的?