最も有効な 1z0-067 試験参考書

PDF、デスクトップテストエンジン、オンラインテストエンジン——ShikenPASSではOracle Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP（1z0-067）の学習教材を3つの形式でご用意しています。265問の練習問題を、ご自身の学習スタイルに合わせてお選びいただけます。

Oracle 1z0-067 試験概要:

Oracle 1z0-067 試験シラバストピック:

Oracle Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP（1z0-067）受験者からのよくあるご質問

Oracle Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP 認定 1z0-067 試験問題：

問題 #1

You are installing Oracle Database 12c with the Oracle Universal Installer (OUI). You select the option to create a database by using file system storage but you do not explicitly set ORACLE_BASE. What is the effect on the installation?

A. The software installation proceeds with the default value but database creation fails
B. The installation proceeds with the default value but the database creation is not attempted
C. The installation proceeds with the default value but a message is generated in the alert log file
D. The installation terminates with an error

問題 #2

Examine the RMAN command:
RMAN> BACKUP VALIDATE DATABASE;
Which statement is true about the execution of the command?

A. The database must be running in archivelog mode for the successful execution of this command.
B. A complete database backup must exist before executing this command.
C. The command checks for blocks that contain a valid checksum and matching headers and footers, but that has logically inconsistent contents.
D. Block change tracking must be enabled before executing this command.
E. The command checks for blocks containing all zeros, an invalid checksum, or a corrupt block header.

問題 #3

You are connected to a recovery catalog and target database. You execute the command:
RMAN> CATALOG START WITH '/disk1/backups';
Which statement is true?

A. It lists all the data file copies, backup pieces, and archived logs cataloged in the recovery catalog in the
/disk1/backups directory and its subdirectories.
B. Only valid data file copies, existing in the /disk1/backups directory, are cataloged.
C. Only valid backup pieces and archived logs, existing in the /disk1/backups directory, are cataloged.
D. It lists and catalogs all valid data file copies, backup pieces, and archived logs that exist in all directory paths with the prefix /disk1/backups and their subdirectories.

問題 #4

Which two statements are true about a common user?

A. A common user can have a local schema in a PDB.
B. A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.
C. A common user with the create user privilege can create other common users, as well as local users.
D. A common user can be granted only a common role.
E. A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.

問題 #5

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?
Choose the best answer.

A. It is created in all the PDBs but has CREATE SESSION privilege only in CDB$ROOT.
B. It is created and has the CREATE SESSION privilege only in a PDB that is open.
C. It is created only in CDB$ROOT and has the CREATE SESSION privilege.
D. It is created in all the PDBs with CREATE SESSION privilege.

解説：