Oracle 1z0-067 問題集

質問 1：
You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization.
Which two backup solutions can be used?
A. RMAN Media Management Library
B. Enterprise Manager Cloud Control
C. RMAN recovery catalog
D. Oracle Secure Backup
E. Enterprise Manager Database Express
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which three statements are true about common roles? (Choose three.)
A. Only system privileges can be granted to a common role to a container database (CDB)
B. A common user that is granted a common role can grant the role to other common and local users in a PDB
C. Object privileges can be granted to a common role in a pluggable database (PDB)
D. A common rule cannot be created by a local user
E. A common role can be granted only to a common user
正解：B,C,D

質問 3：
Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined.
You execute this command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true?
A. The minimum space guaranteed in the buffer cache for any server process is 100 MB.
B. The maximum size for the standard buffer cache is 100 MB.
C. The minimum size for the standard buffer cache is 100 MB.
D. The minimum size for all buffer caches is 100 MB.
E. The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:
create table employees
(empno number, salary number,
deptid number, name varchar2(100),
period for employee_time);
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?
A. The valid time columns are not populated by the Oracle Server automatically.
B. The valid time columns are visible by default when the table is described.
C. The valid time columns employee_time_start and employee_time_end are automatically created.
D. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.
E. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
正解：A,C,E

質問 5：
Examine these Data Pump commands to export and import objects from and to the same database.
The dba has not yet created users hr1 and oe1.
$expdp system/manager
schemas = hr.oe
directory = EXP_DIR
dumpfile = export.dat
include = table
$ impdpsysten/manager
schemas = hr1,oe1
directory = EXP_DIR
dumpfile = export.dat
remap_schena=hr:hrl, oe:oe1
What will happen when running these commands?
A. expdp will succeed but impdp will fail because the users do not exist.
B. impdp will create two users called hr1 and oe1 and import only the tables owned by hr and oe schemas to ht1 and oe1 schemas, respectively.
C. expdp will fail because no path has been defined for the dumpfile.
D. inpdp will create two users called hr1 and oe1 and import all objects to the new schemas.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 6：
The CATDB12c database contains an Oracle Database version 12c catalog schema owned by the RC12C user.
The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open.
You execute the RMAN commands:
RMAN> CONNECT CATALOG rc12c/pass12c@catdb12c
RMAN> IMPORT CATALOG rc11/pwdcat11@ract11
Which two tasks are performed as part of the import? (Choose two.)
A. Imported databases are unregistered from the RC11 catalog.
B. All databases registered in the RC11 catalog are registered in the RC12C catalog.
C. Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed.
D. Recovery catalog is resynchronized with the control files of the registered databases.
E. Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.
正解：A,B

質問 7：
Which two statements describe the relationship between a window, a resource plan, and a job class?
A. A job class specifies a window that will be open when that job class becomes active.
B. A window and the job class associated with a job controls resource allocation for that job.
C. A window specifies a Resource Manager plan that is automatically activated when the windows opens.
D. A window and the Resource Manager plan that is active when a job runs determine the job class for the job.
E. A window specifies a job class that will be activated when that window opens.
正解：B,C