1Z0-083無料問題集「Oracle Database Administration II」

質問 1

Your database is in ARCHIVELOG mode and you plan to use Flashback Database.
Which two features or parameters manage space availability in the fast recovery area? (Choose two.)

（A）the archived log deletion policy

（B）the backup optimization policy

（C）the DB_RECOVERY_FILE_DEST parameter setting

（D）the DB_CREATE_ONLINE_LOG_DEST_n parameter setting

（E）the backup retention policy

（F）using guaranteed UNDO retention

正解：A、E 解答を投票する

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

質問 2

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 to APP1_ROOT, APP1_ROOT$SEED, and APP1_PDB1.

（B）USER1 can connect to APP1_ROOT and APP1_PDB1.

（C）USER1 can connect to CDB1.

（D）USER1 is defined in APP1_PDB2. E) USER1 can connect only to APP1_PDB1.

（E）USER1 can connect only to APP1_ROOT.

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

質問 3

Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)

（A）By default, the transported database will use Oracle Managed Files (OMF)

（B）A new DBID is automatically created for the transported database.

（C）Databases can be transported between systems with different endian formats.

（D）Data files can be converted on the source system.

（E）Data files can be converted on the destination system.

（F）The password file is automatically converted by RMAN.

正解：A、D、E 解答を投票する

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

質問 4

Which three true about recovering tables using RMAN? (Choose three.)

（A）RMAN always uses an auxiliary instance.

（B）RMAN can recover tables owned by the SYS user.

（C）RMAN can recover tables in the SYSTEM tablespace.

（D）RMAN can recover tables in a standby database.

（E）RMAN can recover tables in the SYSAUX tablespace.

（F）RMAN can recover a table after a DDL operation has altered the table structure.

（G）RMAN can recover tables owed by the SYSTEM user.

正解：A、F、G 解答を投票する

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

質問 5

Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)

（A）Existing Oracle Database instances must be shut down before starting the upgrade.

（B）An existing Oracle base can be used.

（C）The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.

（D）The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.

（E）A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.

（F）Only the grid user can perform the upgrade.

正解：B、C、F 解答を投票する

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

質問 6

In performance management, which two factors might reduce the ability of an application to scale to a large number of users? (Choose two.)

（A）the number of data files containing extents belonging to tables updated by a transaction

（B）poorly trained users who do not commit transactions

（C）issuing multiple savepoints during a transaction

（D）poorly written SQL

（E）the number of tablespaces containing tables updated by a transaction

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

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

質問 7

Which three are true about upgrading an application in an application container?

（A）An application name and version number must be specified to upgrade the application.

（B）After an application upgrade, the application container's PDBs remain synchronized with the existing application root.

（C）The upgrade can be performed when connected either to CDB$ROOT or to PDB$SEED.

（D）An application root clone gets created automatically.

（E）The upgrade must be performed when connected to CDB$ROOT.

（F）After an application upgrade, the application container's PDBs are automatically synchronized with the application root clone.

正解：A、D、F 解答を投票する

質問 8

Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target connection in Oracle Database 19c and later releases? (Choose three.)

（A）The base catalog must be used by RMAN when performing point-in-time recovery for the PDB registered in the Virtual Private Catalog.

（B）The base catalog owner must give the Virtual Private Catalog access to metadata for one or more PDBs.

（C）The target PDB must be registered in a base catalog.

（D）The target PDB must be registered in a Virtual Private Catalog.

（E）The base catalog must be enabled for Virtual Private Catalog use.

（F）The target PDB must be registered in both the base catalog and the Virtual Private Catalog.

正解：A、B、D 解答を投票する

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

質問 9

You want to duplicate one of your databases when connected to the target database and to the recovery catalog.
Which three are true about this type of database duplication?

（A）The duplication process pushes image copies to the auxiliary instance.

（B）The target database must be in mount state.

（C）The duplication process pushes backup sets to the auxiliary instance.

（D）The target database must be open.

（E）The duplication process can use existing backup sets or image copies.

（F）The duplication process can create backup sets or image copies.

正解：B、C、D 解答を投票する

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

質問 10

Which three are true about Rapid Home Provisioning of Oracle software? (Choose three.)

（A）It can be used to patch existing Oracle software installations.

（B）It can be used to create a single-instance Oracle Database in an already-installed Oracle home.

（C）It can be used to upgrade only single-instance databases running on Oracle Restart.

（D）It can be used to deploy new homes without disrupting active databases.

（E）It can be used to create templates of Oracle homes as gold images of only Oracle databases.

（F）It can be used only on nodes with Oracle Grid Infrastructure installed.

正解：A、B、D 解答を投票する

1Z0-083 無料問題集「Oracle Database Administration II」

弊社を連絡する

関連リンク

トップ試験