Download Oracle.1z0-067.Pass4Sure.2018-12-17.131q.vcex

Download Exam

File Info

Exam Upgrade Oracle9i/10g/11g OCA OR OCP to Oracle Database 12c OCP
Number 1z0-067
File Name Oracle.1z0-067.Pass4Sure.2018-12-17.131q.vcex
Size 682 KB
Posted Dec 17, 2018
Download Oracle.1z0-067.Pass4Sure.2018-12-17.131q.vcex

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Purchase

Coupon: MASTEREXAM
With discount: 20%






Demo Questions

Question 1

Examine the RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; 
RMAN> BACKUP DATABASE PLUS ARCHIVELOG; 
Which prerequisite must be met before accomplishing the backup?


  1. The password for the encryption must be set up.
  2. Oracle wallet for the encryption must be set up.
  3. All the tablespaces in the database must be encrypted.
  4. Oracle Database Vault must be enabled.
Correct answer: B
Explanation:
Configuration encryption will used by Transparent encryption. For transparent encryption, you will need to create a wallet, and it must be open. Transparent encryption will then occur automatically after you have issued the CONFIGURE ENCRYPTION FOR DATABASE ON or CONFIGURE ENCRYPTION FOR TABLESPACE ON command.  http://docs.oracle.com/cd/E25054_01/backup.1111/e10642/rcmbckad.htm#CEGEJABHCONFIGURE ENCRYPTION : You can use this command to persistently configure transparent encryption. You cannot persistently configure dual mode or password mode encryption. SET ENCRYPTION : You can use this command to configure dual mode or password mode encryption at the RMAN session level.
Configuration encryption will used by Transparent encryption. For transparent encryption, you will need to create a wallet, and it must be open. Transparent encryption will then occur automatically after you have issued the CONFIGURE ENCRYPTION FOR DATABASE ON or CONFIGURE ENCRYPTION FOR TABLESPACE ON command.  
http://docs.oracle.com/cd/E25054_01/backup.1111/e10642/rcmbckad.htm#CEGEJABH
CONFIGURE ENCRYPTION : You can use this command to persistently configure transparent encryption. You cannot persistently configure dual mode or password mode encryption. SET ENCRYPTION : You can use this command to configure dual mode or password mode encryption at the RMAN session level.



Question 2

A database is running in archive log mode. The database contains locally managed tablespaces. Examine the RMAN command:
RMAN> BACKUP 
AS COMPRESSED BACKUPSET 
SECTION SIZE 1024M 
DATABASE; 
Which statement is true about the execution of the command? 


  1. The backup succeeds only if all the tablespaces are locally managed.
  2. The backup succeeds only if the RMAN default device for backup is set to disk.
  3. The backup fails because you cannot specify section size for a compressed backup.
  4. The backup succeeds and only the used blocks are backed up with a maximum backup piece size of 1024 MB.
Correct answer: D
Explanation:
COMPRESSED enables binary compression. RMAN compresses the data written into the backup set to reduce the overall size of the backup set. All backups that create backup sets can create compressed backup sets. Restoring compressed backup sets is no different from restoring uncompressed backup sets. RMAN applies a binary compression algorithm as it writes data to backup sets. This compression is similar to the compression provided by many media manager vendors. When backing up to a locally attached tape device, compression provided by the media management vendor is usually preferable to the binary compression provided by BACKUP AS COMPRESSED BACKUPSET. Therefore, use uncompressed backup sets and turn on the compression provided by the media management vendor when backing up to locally attached tape devices. You should not use RMAN binary compression andmedia manager compression together. Some CPU overhead is associated with compressing backup sets. If the target database is running at or near its maximum load, then you may find the overhead unacceptable. In most other circumstances, compressing backup sets saves enough disk space to be worth the CPU overhead. SECTION SIZE sizeSpec  Specifies the size of each backup section produced during a data file backup. By setting this parameter, RMAN can create a multisection backup. In a multisection backup, RMAN creates a backup piece that contains one file section, which is a contiguous range of blocks in a file. All sections of a multisection backup are the same size. You can create a multisection backup for a data file, but not a data file copy. File sections enable RMAN to create multiple steps for the backup of a single large data file. RMAN channels can process each step independently and in parallel, with each channel producing one section of a multisection backup set. If you specify a section size that is larger than the size of the file, then RMAN does not use multisection backup for the file. If you specify a small section size that would produce more than 256 sections, then RMAN increases the section size to a value that results in exactly 256 sections. Depending on where you specify this parameter in the RMAN syntax, you can specify different section sizes for different files in the same backup job. Note: You cannot use SECTION SIZE with MAXPIECESIZE or with INCREMENTAL LEVEL 1.
COMPRESSED enables binary compression. 
RMAN compresses the data written into the backup set to reduce the overall size of the backup set. All backups that create backup sets can create compressed backup sets. Restoring compressed backup sets is no different from restoring uncompressed backup sets. 
RMAN applies a binary compression algorithm as it writes data to backup sets. This compression is similar to the compression provided by many media manager vendors. When backing up to a locally attached tape device, compression provided by the media management vendor is usually preferable to the binary compression provided by BACKUP AS COMPRESSED BACKUPSET. 
Therefore, use uncompressed backup sets and turn on the compression provided by the media management vendor when backing up to locally attached tape devices. You should not use RMAN binary compression andmedia manager compression together. 
Some CPU overhead is associated with compressing backup sets. If the target database is running at or near its maximum load, then you may find the overhead unacceptable. In most other circumstances, compressing backup sets saves enough disk space to be worth the CPU overhead. 
SECTION SIZE sizeSpec  Specifies the size of each backup section produced during a data file backup. 
By setting this parameter, RMAN can create a multisection backup. In a multisection backup, RMAN creates a backup piece that contains one file section, which is a contiguous range of blocks in a file. All sections of a multisection backup are the same size. You can create a multisection backup for a data file, but not a data file copy. 
File sections enable RMAN to create multiple steps for the backup of a single large data file. 
RMAN channels can process each step independently and in parallel, with each channel producing one section of a multisection backup set. 
If you specify a section size that is larger than the size of the file, then RMAN does not use multisection backup for the file. If you specify a small section size that would produce more than 256 sections, then RMAN increases the section size to a value that results in exactly 256 sections. 
Depending on where you specify this parameter in the RMAN syntax, you can specify different section sizes for different files in the same backup job. 
Note: You cannot use SECTION SIZE with MAXPIECESIZE or with INCREMENTAL LEVEL 1.



Question 3

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?


  1. RMAN recovery catalog
  2. RMAN Media Management Library
  3. Enterprise Manager Cloud Control
  4. Enterprise Manager Database Express
  5. Oracle Secure Backup
Correct answer: AC
Explanation:
Enterprise Manager allows a centralized control of database backups. It is possible to set up and schedule RMAN backups for all the databases in a large company, use a consistent backup strategy, and refer to all past RMAN output logs at any time, since they are stored in the Enterprise Manager Cloud Control repository. There is no need to use a central RMAN catalog, because information about the backups is centrally available from Enterprise Manager. And with the group backup feature new to Enterprise Manager Cloud Control 12c, it can be even faster to set up RMAN backups for all the databases-even if there are thousands-that are part of an Enterprise Manager group. http://www.oracle.com/technetwork/articles/oem/havewala-rman-em12c-2104270.html
Enterprise Manager allows a centralized control of database backups. It is possible to set up and schedule RMAN backups for all the databases in a large company, use a consistent backup strategy, and refer to all past RMAN output logs at any time, since they are stored in the Enterprise Manager Cloud Control repository. 
There is no need to use a central RMAN catalog, because information about the backups is centrally available from Enterprise Manager. And with the group backup feature new to Enterprise Manager Cloud Control 12c, it can be even faster to set up RMAN backups for all the databases-even if there are thousands-that are part of an Enterprise Manager group. 
http://www.oracle.com/technetwork/articles/oem/havewala-rman-em12c-2104270.html



Question 4

You want RMAN to make duplicate copies of data files when using the backup command. 
What must you set using the RMAN configure command to achieve this?


  1. MAXSETSIZE TO 2;
  2. DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  3. CHANNEL DEVICE TYPE DISK FORMAT '/disk1/%U' , '/disk2/%U';
  4. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
Correct answer: D
Explanation:
Configuring Backup Duplexing You can use the CONFIGURE ... BACKUP COPIES command to specify how many copies of each backup piece should be created on the specified device type for the specified type of file. This type of backup is known as a duplexed backup set. The CONFIGURE settings for duplexing only affect backups of datafiles, control files, and archived logs into backup sets, and do not affect image copies. NOT A The CONFIGURE MAXSETSIZE command limits the size of backup sets created on a channel. This CONFIGURE setting applies to any channel, whether manually allocated or configured, when the BACKUP command is used to create backup sets. The default value is given in bytes and is rounded down to the lowest kilobyte value. Reference: http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmconfa.htm#BRADV137
Configuring Backup Duplexing You can use the CONFIGURE ... BACKUP COPIES command to specify how many copies of each backup piece should be created on the specified device type for the specified type of file. This type of backup is known as a duplexed backup set. The CONFIGURE settings for duplexing only affect backups of datafiles, control files, and archived logs into backup sets, and do not affect image copies. NOT A The CONFIGURE MAXSETSIZE command limits the size of backup sets created on a channel. This CONFIGURE setting applies to any channel, whether manually allocated or configured, when the BACKUP command is used to create backup sets. The default value is given in bytes and is rounded down to the lowest kilobyte value. Reference: http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmconfa.htm#BRADV137



Question 5

Which two statements are true when row-archival management is enabled?


  1. Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.
  2. The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.
  3. The row archival visibility session parameter defaults to all rows.
  4. The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.
  5. The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.
Correct answer: BD



Question 6

Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database (COB) plan using Oracle Database Resource Manager?


  1. maximum undo per consumer group
  2. maximum idle time for a session in a PDB
  3. parallel server limit
  4. CPU
  5. maximum number of sessions for a PDB
Correct answer: CD
Explanation:



Question 7

Which three types of failures are detected by the Data Recovery Advisor (DRA)?


  1. loss of a non-critical data file
  2. loss of a control file
  3. physical data block corruption
  4. logical data block corruption
  5. loss of an archived redo log file
Correct answer: BDE
Explanation:
Data Recovery Advisor can diagnose failures such as the following: Components such as datafiles and control files that are not accessible because they do not exist, do not have the correct access permissions, have been taken offline, and so on Physical corruptions such as block checksum failures and invalid block header field values
Data Recovery Advisor can diagnose failures such as the following: Components such as datafiles and control files that are not accessible because they do not exist, do not have the correct access permissions, have been taken offline, and so on Physical corruptions such as block checksum failures and invalid block header field values



Question 8

Examine the initialization parameter that is set in the PFILE:
DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/' 
You execute the following command to create theCDB1. container database (CDB):
SQL>CREATE DATABASE CDB1 
DEFAULT TABLESPACE users 
DEFAULT TEMPORARY TABLESPACE temp 
UNDO TABLESPACE undotbsl 
ENABLE PLUGGABLE DATABASE 
SEED 
SYSTEM DATAFILES SIZE125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED 
SYS AUX DATAFILES SIZE 100M; 
Which three statements are true? 


  1. It creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively.
  2. The files created for both the root and seed databases use Oracle Managed Files (OMF).
  3. It creates a multitenant container database with the root and seed databases opened and one PDB mounted.
  4. It sets the users tablespace as the default for both the root and seed databases.
  5. undotbs1 is used as the undo tablespace for both the root and seed databases.
  6. It creates a multitenant container database with the root database opened and the seed database mounted.
Correct answer: ABE
Explanation:
The seed actually doesn’t use anything since it’s read-only, but any PDB created from the seed will use the undotbs1 undo tablespace. Each PDB can have its own default tablespace, but cannot change the undo tablespace.
The seed actually doesn’t use anything since it’s read-only, but any PDB created from the seed will use the undotbs1 undo tablespace. Each PDB can have its own default tablespace, but cannot change the undo tablespace.



Question 9

Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN:
  1. Create media families for data files and archived redo log files. 
  2. Configure database backup storage selectors or RMAN media management parameters. 
  3. Create an OSB user preauthorized for RMAN operations. 
  4. Configure RMAN Access to the OSB SBT. 
  5. Disable Non-Uniform Memory Access (NUMA) awareness by setting the ob_ignore_numa parameter to 0. 
Identify the steps in the correct order.


  1. 1, 4, 3, 2, 5
  2. 1, 3, 4, 5, 2
  3. 4, 3, 1, 2, 5
  4. 4, 3, 5, 1, 2
Correct answer: C
Explanation:
Reference:http://docs.oracle.com/cd/B19306_01/backup.102/b14234/obadm_odb.htm#BDCBGJBF
Reference:
http://docs.oracle.com/cd/B19306_01/backup.102/b14234/obadm_odb.htm#BDCBGJBF



Question 10

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?


  1. password-mode encryption
  2. dual-mode encryption
  3. transparent encryption
  4. default encryption
Correct answer: B
Explanation:
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmbckad.htm#CEGEJABH To make dual-mode encrypted backups: Start RMAN and connect to a target database and recovery catalog (if used). Execute the SET ENCRYPTION BY PASSWORD command, making sure to omit the ONLY keyword. The following example sets the encryption password for all tablespaces (where password is a placeholder for the actual password that you enter) in the backup and omits ONLY to indicate dual-mode encryption: SET ENCRYPTION IDENTIFIED BY password ON FOR ALL TABLESPACES;
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmbckad.htm#CEGEJABH To make dual-mode encrypted backups: Start RMAN and connect to a target database and recovery catalog (if used). Execute the SET ENCRYPTION BY PASSWORD command, making sure to omit the ONLY keyword. The following example sets the encryption password for all tablespaces (where password is a placeholder for the actual password that you enter) in the backup and omits ONLY to indicate dual-mode encryption: SET ENCRYPTION IDENTIFIED BY password ON FOR ALL TABLESPACES;









CONNECT US

Facebook

Twitter

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!



HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files