1z1-067問題集、Oracle実際の試験問題

質問 1

You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup operation?

A. The tablespace must be taken offline.

B. The backup must be performed in mount state.

C. The database must be backed up as an image copy.

D. All files must be backed up as backup sets.

正解: B

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

質問 2

Examine the RMAN command:
RMAN> SET ENCRYPTION IDENTIFIED BY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which type of encryption is used for the backup performed by using this command?

A. dual-mode encryption

B. transparent encryption

C. password-mode encryption

D. default encryption

正解: A

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

質問 3

You administer a database that was created using Oracle Database 10g.
The default tablespace type property was not changed. You execute this statement to create a tablespace, mytbs:
CREATE TABLESPACE mytbs DATAFILE '/u1/data/mytbs.dbf' SIZE 100M;
Which two statements are correct regarding the mytbs tablespace? (Choose two.)

A. It is a smallfile tablespace

B. It is a locally managed tablespace with autoallocate

C. It is a bigfile tablespace

D. It is a locally managed tablespace with uniform size of 8m

E. It is a dictionary-managed tablespace

正解: A,B

質問 4

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 specifies a job class that will be activated when that window opens.

C. A window and the Resource Manager plan that is active when a job runs determine the job class for the job.

D. A window and the job class associated with a job controls resource allocation for that job.

E. A window specifies a Resource Manager plan that is automatically activated when the windows opens.

正解: D,E

質問 5

Your database is running in archivelog mode. Examine the parameters for your database instance:
LOG_ARCHIVE_DEST_l ='LOCATION=/disk1/arch MANDATORY'
LOG_ARCHIVE_DEST_2 ='LOCATION=/disk2/arch'
LOG_ARCHIVE_DEST_3 ='LOCATIO=/disk3/arch'
LOG_ARCHIVE_DEST _4 ='LOCATIONs/disk4/arch'
LOG_ARCHIVE _MIN_SUCCEED_DEST = 2
While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have been used.
What happens at the next log switch?

A. The archived redo log files are written to the fast recovery area until the mandatory destination is made available.

B. The database instance is shutdown immediately.

C. The database instance hangs and the redo log files are not overwritten.

D. The destination set by the log_archive_dest parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.

正解: C

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

質問 6

Your multitenant container database (CDB) cdb1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:
SQL>STARTUP
Which two statements are true about the successful execution of the command?

A. All the PDBs are in closed state.

B. The root, the seed, and all the PDBs are opened in read-write mode.

C. All redo log files are opened.

D. All the PDBs are opened in read-write mode.

E. Only the root database is opened in read-write mode.

正解: C,E

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

質問 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 in association with a job class controls a resource allocation.

C. A window in association with a resource plan controls a job class allocation.

D. A window specifies a job class that will be activated when that window becomes active.

E. A window specifies a resource plan that will be activated when that window becomes active.

正解: B,E

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

質問 8

RMAN is connected to the target database PROD1 and an auxiliary instance in NOMOUNT state. Examine the command to create a duplicate database:
RMAN> DUPLICATE TARGET DATABASE TO dup1
FROM ACTIVE DATABASE
NOFILENAMECHECK
PASSWORD FILE
SPFILE;
Which two statements are true about the execution of the DUPLICATE command?

A. The duplicate database is created without using RMAN backups and PROD1 is allowed to remain open during duplication.

B. The duplicate database has the same directory structure as the source database.

C. The password file and SPFILE for the duplicate database DUP1 are created in their respective default locations.

D. The duplicate database is created by using the backups created during the execution of the DUPLICATE command.

E. All archive redo log files are automatically copied to the duplicate database.

正解: A,E

質問 9

Which three statements are true about persistent lightweight jobs?

A. They generate large amounts of metadata.

B. A user cannot set privileges on them.

C. They may be created as fully self-contained jobs.

D. They must reference an existing Scheduler Program.

E. The are useful when users need to create a large number of jobs quickly.

正解: B,D,E

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

質問 10

You are required to migrate your 11.2.0.3 database to an Oracle 12c database.
Examine the list of steps that might be used to accomplish this task:
1.Place all user-defined tablespaces in read-only mode on the source database.
2.Use the RMAN convert command to convert data files to the target platform's endian format, if required.
3.Perform a full transportable export on the source database with the parameters VERSI0N=I2, TRANSPORTABLE=ALWAYS, and FULL=Y.
4. Transport the data files for all the user-defined tablespaces.
5. Transport the export dump file to the target database.
6. Perform an import on the target database by using the full, network_link, and transportable_datafiles parameters.
7. Perform an import on the target database by using the full and transportable_datafiles parameters.
Identify the required steps in the correct order.

A. 1, 2,4, and 7

B. 1, 2, 4, 6, 5, 3, and 7

C. 2, 4, 5, 6, and 7

D. 1, 3, 5, 4, 2, and 7

正解: D

質問 11

You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to pluggable databases (PDBs).
You have already created a test system to support the consolidation of databases in a multitenant container database (CDB) that has multiple PDBs.
What is the easiest way to perform capacity planning for consolidation?

A. capturing the workload on the production system and replaying the workload for one PDB at a time on the test system

B. capturing the workload on the production system and using Consolidated Database Replay to replay the workload of all production systems simultaneously for all PDBs

C. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Performance Analyzer on the test system

D. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Tuning Advisor on the test system

正解: B

質問 12

Which three statements are true about the keystore storage framework for transparent data encryption?

A. It enables a keystore to be stored only in a file on a file system.

B. It transparently decrypts data for the database users and applications that access this data.

C. It facilitates and helps to enforce keystore backup requirements.

D. It handles encrypted data without modifying applications.

E. It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.

F. It enables separation of duties between the database administrator and the security administrator.

正解: C,E,F

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

Oracle Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP - 1z1-067 模擬練習