新OCP83_在线真题试卷与模拟练习_新OCP83

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

How do you configure a CDB for local undo mode?

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 Which view displays all waits waited on by a session at least once?

、Examine this configuration

⑴CDB1 is a container database running in ARCHIVELOG mode.

⑵Multiple uncommitted transactions are running in CDB1

⑶Redo log groups 1 and 2 are INACTIVE

⑷Redo log group 3 is the CURRENT group

All members of redo log group 3 are lost before it is archived

Examine these possible steps

⑴SHUTDOWN ABORT

⑵STARTUP NOMOUNT

⑶STARUP MOUNT

⑷ALTER DATABASE MOUNT

⑸RESTORE DATABASE

⑹RECOVER DATABASE NOREDO

⑺RECOVER DATABASE UNTIL AVAILABLE

⑻RESTORE ARCHIVELOG ALL

⑼ALTER DATABASE OPEN

⑽ALTER DATABASE OPEN RESETLOGS

Choose the minimum required steps in the correct order to recover the database

A schema owner truncated a table in error and must recover the data Which Oracle Flashback feature could be used to recover the data?

Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?

Examine this configuration SQL> ALTER PLUGGABLE DATABASE app_root CLOSE; Pluggable database altered. SQL> FLASHBACK PLUGGABLE DATABASE app_root TO SCN 2074756; Flashback complete. Which table or set of tables will exist after the Flashback operation has completed?

Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?

Examine this configuration: Which is true?

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 0 backup Today is the

26th of August

Which backups will be obsolete?

Examine this configuration

What is the outcome?

Examine this output of an export from the current release of an Oracle multitenant database What is the outcome?

Application PDBS, SALES_App1 and SALES_App2, must be created and they must access common tables of the SALES_App application Examine these steps:

Which are the minimum required steps in the correct sequence?

Examine this configuration ⑴cdb1 is a container database ⑵There are several pluggable databases (PDBs) in CDB1 ⑸Each PDB has several tables with referential integrity constraints ⑹FLASHBACK DAABASE is ON ⑺UNDO RETENTION GUARANTEE is enabled Multiple undesired multitable changes were made in all the PDBs Which method can be used to undo the changes using a single command

Examine this configuration: In which order will the upgrade occur?

Which operating system group is NOT needed to perform an Oracle Database installation?

.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?

Examine this configuration: ⑴CDB1 is a container database. ⑵DEFAULT SHARING is METADATA. ⑶APP_ROOT is an application root contained in CDB1. ⑷APP_PDB1 is an application PDB contained in APP_ROOT ⑸COMPANYAPP is an application contained in APP_ROOT. ⑹EMP is a common table created in APP_ROOT and all its application PDBs, created when version 1.0 of COMPANYAPP was installed. 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. SOL>DESC emp; What will be the outcome and why?

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

Examine this configuration: ⑴CDB1 is an Oracle Database 12c Release 2 container database (CDB). ⑵PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1. 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_NAMEOPEN MODE RESTRICTED --------------------------------------------------------------- ⑵ PDB$$SEED MIGRATE YES ⑶ PDB1 MOUNTED YES ⑷ 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?

1 2 3 4 5 6