1Z0-083試験無料問題集「Oracle Database Administration II 認定」

ページ: 1 / 21
トータル 283 問

サインアップ、ログインされた後に、試験全体を無料で表示できるようになります。

出題：1

Examine the RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which prerequisite must be met before accomplishing the backup?

A. All the tablespaces in the database must be encrypted

B. Oracle wallet for the encryption must be set up.

C. Oracle Database Vault must be enabled.

D. The password for the encryption must be set up.

正解：B 解答を投票する

出題：2

Which three are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle 19c and later releases? (Choose three.)

A. A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.

B. A PDB snapshot can be a sparse copy of a source PDB.

C. A PDB snapshot depends on an existing storage snapshot of the source PDB.

D. A snapshot copy PDB can be a full copy of a source PDB.

E. A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.

F. A PDB snapshot can be a full copy of a source PDB.

G. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.

正解：B,F,G 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

The persistent configuration settings for RMAN have default for all parameters. Identify four RMAN commands that produce a multi-section backup.

A. BACKUP ARCHIVELOG ALL SECTION SIZE 25M;

B. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;

C. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;

D. BACKUP SPFILE SECTION SIZE 1M;

E. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;

F. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE
100M;

G. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

正解：A,B,C,G 解答を投票する

出題：4

Examine this configuration:
1. CDB1 is a container database.
2. APP1_ROOT is an application container contained in CDB1.
3. APP1_ROOT$SEED is the application seed contained in APP1_ROOT and synchronized with APP1_ROOT.
4. APP1_PDB1 and APP1_PDB2 are application PDBs contained in APP1_ROOT.
5. APP1_USER_APP is an application installed in APP1_ROOT at version 1.0.
6. USER1 is a common user in APP1_ROOT and all its application PDBs, created when version
1.0 of APP1_USER_APP was installed.
You execute these commands:
$ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba
SQL> ALTER SESSION SET CONTAINER=app1_root;
Session altered.
SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app
BEGIN UPGRADE '1.0' TO '2.0'; pluggable database altered.
SQL> GRANT CREATE SESSION TO USER1; Grant succeeded.
SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app
END UPGRADE TO '2.0'; Pluggable database altered
SQL> ALTER SESSION SET CONTAINER=app1_pdb1;
Session altered.
SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app SYNC;
Pluggable database altered.
Which two are true?

A. USER1 can connect only to APP1_ROOT.

B. USER1 is defined in APP1_PDB2. E) USER1 can connect only to APP1_PDB1.

C. USER1 can connect to CDB1.

D. USER1 can connect to APP1_ROOT, APP1_ROOT$SEED, and APP1_PDB1.

E. USER1 can connect to APP1_ROOT and APP1_PDB1.

正解：B,E 解答を投票する

出題：5

Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database
12c when it is enabled?

A. Reduced logical I/O

B. Reduced virtual memory utilization

C. Reduced CPU utilization

D. Reduced physical I/O

E. Improved Serial Execution performance

正解：B,C 解答を投票する

出題：6

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?

A. eight

B. seven

C. five

D. three

E. six

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

Examine this configuration:

While CDB1is open,
'/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl' is
accidentally deleted.
To recover from this critical failure, you execute these commands:

What will be the outcome?

A. It will create `$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl'

B. It will create `/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl'.

C. It will fail because there is no autobackup of the controlfiles.

D. It will create `/u01/app/oracle/product/12.2.0.1/db_1/dbs/ snapcf_cdb1control02.ctl'.

E. It will re-create `/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'

正解：E 解答を投票する

出題：8

You execute the following piece of code with appropriate privileges:
User SCOTT has been granted the CREATE SESSION privilege and the MGR role.
Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?

A. Data is never redacted for the EMP_V.SAL column.

B. Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.

C. Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.

D. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.

E. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.

正解：A,B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：9

Which three are true about managing memory components in an Oracle database instance?
(Choose three.)

A. Automatic Memory Management must be used together with locking the System Global Area into physical memory.

B. With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.

C. With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.

D. With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.

E. Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.

F. On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

正解：B,D,F 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：10

Which two are true about the Program Global Area (PGA) and its management in an Oracle database instance? (Choose two.)

A. The entire PGA is located in the System Global Area (SGA) when using shared servers.

B. The private SQL area (UGA) is located in the System Global Area (SGA) when using shared servers.

C. The private SQL area (UGA) is located in the System Global Area (SGA) when using dedicated servers.

D. Sorts and Hash Joins use PGA memory.

E. PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.

正解：B,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：11

After implementing full Oracle Data Redaction, you change the default value for the number data type as follows:
SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL;
NUMBER_VALUE
-------------------------
SQL> EXEC DBMS_REDACT.UPDATE_FULL_REDACTI0N_VALUES(-1)
PL/SQL procedure successfully completed.
SQL> select number_value from redaction_values_for_type_full;
NUMBER VALUE
------------------------
After changing the value, you notice that FULL redaction continues to redact numeric data with a zero.
What must you do to activate the new default value for numeric full redaction?

A. Re-create redaction policies that use FULL data redaction.

B. Re-connect the sessions that access objects with redaction policies defined on them.

C. Re-enable redaction policies that use FULL data redaction.

D. Flush the shared pool.

E. Restart the database instance.

正解：E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：12

Which three are true about RMAN duplexed backup sets or image copies?

A. An image copy on disk can be copied to sbt.

B. An image copy on sbt can be copied to disk.

C. An image copy on disk can be copied to disk.

D. A backup set may be duplexed with both copies written to sbt.

E. A backup set may be duplexed so that one copy is written to sbt and the other to disk.

F. A backup set may be duplexed with both copies written to disk.

正解：C,D,F 解答を投票する

出題：13

Which two statements are true about RMAN duplexed backups?

A. It is only supported for backups to tape via the media management interface.

B. Duplex backups can contain only data files and control files.

C. It is not supported for image copies.

D. For performing duplexed backups, the parallelism for the device must be set equal to the number of copies.

E. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.

正解：C,E 解答を投票する

出題：14

Examine this configuration:
1. The ORCLdatabase data files are in Automatic Storage Management (Oracle ASM) disk group
+DATA.
2. ORCLuses disk group +FRAfor the Fast Recovery Area.
3. LISTENER is the listener for ORCL.
4. The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart.
5. All components are currently shut down.
You execute this command:

What is the outcome?

A. Only the ORCL database instance is started.

B. Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.

C. The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENER are started.

D. Only the ORCL database and the ASM instances are started.

E. Only the ORCL database instance and the +DATA and +FRA disk groups are started.

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

ページ: 1 / 21
トータル 283 問

1Z0-083 の機能をすべて解除する

キャプチャ不要
365日無料更新サービス
希望する合格率を設定できる
時間の割り当てられる（時間：分）
1Z0-083 に2つの練習用モード
サポートサービス対応

完全版を入手する

弊社のサイトにはあなたの試験合格を助けるために研究された効果的な知能問題集を提供しています。材料はすべてのユーザーによって称賛されています。弊社のサイトは、最短時間で多くの証明書を取得するのに役立つ学習プラットフォームになります。

掲示板

試験OmniStudio-Consultant-JPN トピック1 問題118 スレッド
試験Salesforce-AI-Specialist-JPN トピック1 問題5 スレッド
試験OmniStudio-Consultant-JPN トピック4 問題17 スレッド
試験OmniStudio-Consultant-JPN トピック1 問題54 スレッド
試験OmniStudio-Consultant-JPN トピック1 問題51 スレッド
試験IIA-CIA-Part3 トピック3 問題134 スレッド
試験MS-102J トピック1 問題136 スレッド

弊社を連絡する

我々の働いている時間：( UTC+9 ) 9:00-24:00

月曜日から土曜日まで

サポート：現在連絡

我々は１２時間以内ですべてのお問い合わせを答えます。