Oracle 1Z0-067 Online Practice Questions and Exam Preparation

Oracle 1Z0-067 Online Questions & Answers

• Question 31:

  RMAN is configured to create backupset backups for your database. You issue the command to back up the database: RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

  Which two statements are true about the backup performed by the command? (Choose two.)

  A. It backs up all the data files and deletes obsolete backups after the backup is complete
  B. It backs up all the archived log files and deletes the ones that were just backed up
  C. Only the used blocks in the data files are backed up
  D. It backs up all archived redo log files and online log files and deletes the archived log files after the backup is complete
  E. It backs up only those archived log files that are not backed up at least once
  B. It backs up all the archived log files and deletes the ones that were just backed up
  C. Only the used blocks in the data files are backed up

• Question 32:

  Which three RMAN persistent settings can be set for a database?

  A. backup retention policy
  B. default backup device type
  C. default section size for backups
  D. default destinations for backups
  E. multiple backup device types for a single backup
  A. backup retention policy
  B. default backup device type
  D. default destinations for backups

  ---

  Explanation: To simplify ongoing use of RMAN, you can set several persistent configuration settings for each target database. These settings control many aspects of RMAN behavior. For example, you can configure the backup retention policy, default destinations for backups, default backup device type, and so on. You can use the SHOW and CONFIGURE commands to view and change RMAN configurations.

  Reference: http://docs.oracle.com/cd/B19306_01/backup.102/b14192/setup004.htm#i1019739

• Question 33:

  Examine the list of possible steps to transport a tablespace across platforms that have the same compatibility level, character sets, and endian format:

  1.

  Make the tablespace read-only at the source database.

  2.

  Export metadata from the source database.

  3.

  Import metadata into the target database.

  4.

  Transfer the dump file and data files to the target machine.

  5.

  Convert data files by using Recovery Manager (RMAN).

  6.

  Make the tablespace read-write at the target database.

  Identify the required steps in the correct order. (Choose the best answer.)

  A. 1, 2, 4, 3, and 6
  B. 2, 4, 3, and 5
  C. 2, 4, and 3
  D. 1, 5, 2, 4, 3, and 6
  A. 1, 2, 4, 3, and 6

• Question 34:

  Examine the commands:

  SQL> ALTER SESSION SET RECYCLBIN = ON;

  Session altered.

  SQL> DROP TABLE emp; --(First EMP table)

  Total 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 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?

  A. It recovers the structure, data, and indexes of the first emp table.
  B. It recovers only the structure of the second emp table.
  C. It returns an error because two tables with the same name exist in the recycle bin.
  D. It recovers the structure, data, and indexes of the second emp table.
  D. It recovers the structure, data, and indexes of the second emp table.

• Question 35:

  You issue the RMAN command:

  RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;

  Which statement is true about the execution of the command? (Choose the best answer.)

  A. The backup succeeds only if the USERS tablespace is locally managed.
  B. RMAN uses multiplexing to perform the backup.
  C. The resulting backupset has backup pieces that cannot exceed 300 MB.
  D. RMAN always performs this type of backup in parallel.
  E. The backup set size is limited to 300 MB.
  C. The resulting backupset has backup pieces that cannot exceed 300 MB.

  ---

  Reference: https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmbckad.htm#BRADV89541

• Question 36:

  Which three statements are true about the SQL*Loader utility?

  A. It can be used to load data from multiple external files into multiple tables.
  B. It can be used to extract and reorganize data from external files, and then load it into a table.
  C. It can be used to load data from external files using direct path only.
  D. It can be used to create tables using data that is stored in external files.
  E. It can be used to generate unique sequential values in specified columns while loading data.
  A. It can be used to load data from multiple external files into multiple tables.
  B. It can be used to extract and reorganize data from external files, and then load it into a table.
  E. It can be used to generate unique sequential values in specified columns while loading data.

• Question 37:

  Which three types of backups can be performed for a database running in NOARCHIVELOG mode? (Choose three.)

  A. backup of only the used blocks in a critical tablespace (SYSTEM or SYSAUX) while the database is open
  B. backup of noncritical tablespaces without shutting down the instance
  C. backup of only those blocks that have changed since the last backup while the database is mounted
  D. backup of the database without shutting down the instance
  E. consistent whole database backup
  B. backup of noncritical tablespaces without shutting down the instance
  C. backup of only those blocks that have changed since the last backup while the database is mounted
  E. consistent whole database backup

• Question 38:

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

  A. It facilitates and helps to enforce keystore backup requirements.
  B. It handles encrypted data without modifying applications.
  C. It enables a keystore to be stored only in a file on a file system.
  D. It enables separation of duties between the database administrator and the security administrator.
  E. It transparently decrypts data for the database users and applications that access this data.
  F. It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.
  A. It facilitates and helps to enforce keystore backup requirements.
  D. It enables separation of duties between the database administrator and the security administrator.
  F. It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.

  ---

  References: http://oradb-srv.wlv.ac.uk/E16655_01/network.121/e17729/asotrans.htm#CHDEABCA (benefits of the keystore storage framework)

• Question 39:

  Examine the RMAN command:

  RMAN> SET ENCRYPTION IDENTIFIED BY ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

  Which type of encryption is used for the backup performed by using this command?

  A. password-mode encryption
  B. dual-mode encryption
  C. transparent encryption
  D. default encryption
  B. dual-mode encryption

  ---

  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; References:http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmbckad.htm#CEGEJABH

• Question 40:

  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?

  A. MAXSETSIZE TO 2;
  B. DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  C. CHANNEL DEVICE TYPE DISK FORMAT '/disk1/%U' , '/disk2/%U';
  D. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
  D. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

  ---

  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