Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1Z0-067

Free Oracle 1Z0-067 Exam Questions (page: 6)

Page 6 of 45
PDF with 264 Questions

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

Answer(s): A,B

Explanation:

RMAN recovery catalog is used to store backup and recovery metadata, such as information about RMAN backups, copies, and archived redo logs. This allows for centralized management of backup and recovery scripts for multiple databases. RMAN Media Management Library (MML) is used to store backup files, such as image copies and backup sets, and can also be used to manage backups across multiple databases.

Enterprise Manager Cloud Control and Enterprise Manager Database Express are not backup solutions, they are used for monitoring and managing databases.
Oracle Secure Backup is a third-party product that can be used for backup management and can be integrated with RMAN.



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;

Answer(s): A


Reference:

http://docs.oracle.com/cd/B14117_01/server.101/b10734/rcmconfg.htm



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?

  1. The valid time columns employee_time_start and employee_time_end are automatically created.
  2. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
  3. The valid time columns are not populated by the Oracle Server automatically.
  4. The valid time columns are visible by default when the table is described.
  5. Setting the session valid time using
    DBMS_FLASHBACK_ARCHIVENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

Answer(s): A,B,E

Explanation:

A: To implement Temporal Validity(TV), 12c offers the option to have two date columns in that table which is having TV enabled using the new clause Period For in the Create Table for the newly created tables or in the Alter Table for the existing ones. The columns that are used can be defined while creating the table itself and will be used in the Period For clause or you can skip having them in the table's definition in the case of which, the Period For clause would be creating them internally.
E: ENABLE_AT_VALID_TIME Procedure
This procedure enables session level valid time flashback.



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

  1. Visibility of theORA_ARCHIVE_STATEcolumn is controlled by the row archival visibility session parameter.
  2. TheORA_ARCHIVE_STATEcolumn 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. TheORA_ARCHIVE_STATEcolumn is visible if it is referenced in the select list of a query.
  5. TheORA_ARCHIVE_STATEcolumn is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.

Answer(s): A,D



Viewing page 6 of 45



Post your Comments and Discuss Oracle 1Z0-067 exam prep with other Community members:

1Z0-067 Exam Discussions & Posts