Oracle 19c OC 1Z0-083-CHN_在线真题试卷与模拟练习_Oracle 19c OC 1Z0-083-CHN

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(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 1.CDB1 is a container database running in ARCHIVELOG mode 2.Multiple uncommitted transactions are running in CDB1 3.Redo log groups 1 and 2 are INACTIVE 4.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 1.SHUTDOWN ABORT 2.STARTUP NOMOUNT 3.STARUP MOUNT 4.ALTER DATABASE MOUNT 5.RESTORE DATABASE 6.RECOVER DATABASE NOREDO 7.RECOVER DATABASE UNTIL AVAILABLE 8.RESTORE ARCHIVELOG ALL 9.ALTER DATABASE OPEN 10.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 featur ecould be use to recover the data?

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

39 、You want to transport the UNIVERSIRY tablespace from one database to another. The universiry tablespace is currently open read/ writeThe source and destination platforms have the same endian format. Examine this list of steps: 1.Make the UNIVERSIRY tablespace read-only on the source system 2.Export the UNIVERSIRY tablespace metadata using EXPDP 3.Create a cross-platform backup set from the UNIVERSITY tablespace on the sourcesystem, using an RMAN command that includes the DAMAPUMP clause 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 RMANcommand that includes the pamapump clause 7.Import the UNIVERSIRY tablespace metadata using IMPDP 8.Make the UNIVERSIRY tablespace read/ write on the destination system Which are the minimum number of steps required, in the correct order,totransport the UNIVERSIRY tablespace?

45、Examine this configuration 1.CDB1 is a container database. 2.APP_ROOT Is an application root in CDB1. 3.APP_PDB1 is an application PDB in APP_ROOT. 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. SQL>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?

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

69 、Examine this configuration: 2.COMHON USER PREFIx ls set to an empty string 3.PDBI is a pluogable database in CDB1. 4.APP1 ROOT Is an application container in CDB1 5.APP1 PDB1 is an application PDBIn APP1 ROOT. You execute these commands: $ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> CREATE ROLE role1 CONTAINER-CURRENT: Which is true?

77、On the 10th of August, you implement an incremental database backup strategy andconfigure 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?

83 、Examine this configuration 1.cDB1 is an Oracle Database 12c Release 2 container database(CDB)2.PDB1 and PDB2 are two pluggable databases(PDBs)in CDB1 After successfully all the preupgrade tasks,you execute these commands Oracle Database18c environment: $$ export ORACLE SID=cdb1 $$ sqlplus / as sysdba SQL> STARTUP UPGRADE: SQL>SHOW pdbs CON_ID CON_NAME OPEN_MODE RESTRICTED 2 PDB$$SEED MIGRNTE YES 3 PDB1 MOUNTED YES 4 PDB2 MOUNTED YES SQL> ALTER PLUGGABLE DATABASE PDB1 OPEN UPGRADE; Pluggable database altered. SQL>exit $$SORACLE_HOME/perl/bin/perl catctl.pl -C 'PDB2' What is the outcome?

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

92、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.

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

6.Sync the SALES_APP1 and SALES _APP2 application PDBs with the application root.

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?

95、Examine this configuration 1.cdb1 is a container database 2. There are several pluggable databases(PDBS)in CDB1 5. Each PDB has several tables with referential integrity constraints 6.FLASHBACK DAABASE IS ON 7.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

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

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

104、Your CDB has two regular PDBs as well as one application container with two applcation PDBs and an applicaton seed No changes have been made to the standard PDBSSEED How many default temporary tablespaces can be assigned in the CDB?

Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases?

Which two are true about server-generated alerts?

Which three are true about upgrading Oracle Grid Infrastructure?

1 2 3 4 5 6