1z0-063 無料問題集「Oracle Database 12c: Advanced Administration」
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
The following are the possible steps to accomplish this task:
1. Place all the user-defined tablespace in read-only mode on the source database.
2. Upgrade the source database to a 12c version.
3. Create a new PDB in the target container database.
4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.
5. Copy the associated data files and export the dump file to the desired location in the target database.
6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.
Identify the correct order of the required steps.
The following are the possible steps to accomplish this task:
1. Place all the user-defined tablespace in read-only mode on the source database.
2. Upgrade the source database to a 12c version.
3. Create a new PDB in the target container database.
4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.
5. Copy the associated data files and export the dump file to the desired location in the target database.
6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.
Identify the correct order of the required steps.
正解：D
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
Examine the probable steps involved in the basic backup process of RMAN and Oracle Secure Backup (OSB):
1. RMAN initiates backup and passes the database backup storage selector to OSB.
2. RMAN creates the backup job.
3. OSB creates the backup job with an OSB user.
4. RMAN updates its repository.
5. RMAN executes the job and transfers data from a client to media.
6. OSB executes the job and transfers data from a client to media.
7. OSB updates its repository.
Identify the required steps in the correct order.
1. RMAN initiates backup and passes the database backup storage selector to OSB.
2. RMAN creates the backup job.
3. OSB creates the backup job with an OSB user.
4. RMAN updates its repository.
5. RMAN executes the job and transfers data from a client to media.
6. OSB executes the job and transfers data from a client to media.
7. OSB updates its repository.
Identify the required steps in the correct order.
正解：C
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
One of your multitenant container databases (CDB) contains two pluggable databases (PDBs) called PDB1 and PDB2.
You connect to PDB2 as a common user with DBA privileges.
The STATISTICS_LEVEL parameter is PDB modifiable.
As the user SYS, you execute this command successfully on PDB2:
SQL> ALTER SET STATISTICS_LEVEL=ALL SID='*' SCOPE=BOTH;
Which two statements are true about the result of this command?
You connect to PDB2 as a common user with DBA privileges.
The STATISTICS_LEVEL parameter is PDB modifiable.
As the user SYS, you execute this command successfully on PDB2:
SQL> ALTER SET STATISTICS_LEVEL=ALL SID='*' SCOPE=BOTH;
Which two statements are true about the result of this command?
正解：A
解答を投票する
Examine the parameters for your database instance:
NAME TYPE VALUE
------------------------------------------------
optimizer_adaptive_reporting_only boolean FALSE
optimizer_capture_sql_plan_baselines boolean FALSE
optimizer_dynamic_sampling integer 2
optimizer_features_enable string 12.1.0.1
Which three statements are true about the process of automatic optimization by using statistics feedback?
(Choose three.)
NAME TYPE VALUE
------------------------------------------------
optimizer_adaptive_reporting_only boolean FALSE
optimizer_capture_sql_plan_baselines boolean FALSE
optimizer_dynamic_sampling integer 2
optimizer_features_enable string 12.1.0.1
Which three statements are true about the process of automatic optimization by using statistics feedback?
(Choose three.)
正解：B、C、E
解答を投票する
You are administering a multitenant container database (CDB) CDB1 with two pluggable databases (PDBs), PDB1 and PDB2. You execute the following commands on CBD$ROOT as the SYS user:
SQL> CREATE USER c##scott IDENTIFIED BY scottorcl1;
SQL> GRANT CREATE SESSION TO c##scott;
Which statement is true about the C##SCOTT user?
SQL> CREATE USER c##scott IDENTIFIED BY scottorcl1;
SQL> GRANT CREATE SESSION TO c##scott;
Which statement is true about the C##SCOTT user?
正解：C
解答を投票する
Examine the commands:
SQL> ALTER SESSION SET RECYCLEBIN = ON;
Session altered.
SQL> DROP TABLE emp; --(First EMP table)
Table dropped.
SQL> CREATE TABLE emp(id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2 (15), salary NUMBER(7,2)); Table created.
You then execute multiple INSERT statements to insert rows into the EMP table and drop the table again:
SQL> DROP TABLE emp; -- (Second EMP table)
Table dropped.
SQL> FLASHBACK TABLE emp TO BEFORE DROP;
Which statement is true about the FLASHBACK command?
SQL> ALTER SESSION SET RECYCLEBIN = ON;
Session altered.
SQL> DROP TABLE emp; --(First EMP table)
Table dropped.
SQL> CREATE TABLE emp(id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2 (15), salary NUMBER(7,2)); Table created.
You then execute multiple INSERT statements to insert rows into the EMP table and drop the table again:
SQL> DROP TABLE emp; -- (Second EMP table)
Table dropped.
SQL> FLASHBACK TABLE emp TO BEFORE DROP;
Which statement is true about the FLASHBACK command?
正解：C
解答を投票する