Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-067

Oracle 1z0-067 Exam Practice Questions (P. 4)

  • Full Access (264 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #16
In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to 20.
Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement?
  1. A
    The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used
  2. B
    Setting the target tablespace to read-only after the segments are moved
  3. C
    The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds T3S percent used
  4. D
    Taking the target tablespace offline after the segments are moved
  5. E
    The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs

Correct Answer:
AB

Question #17
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. A
    RMAN recovery catalog
  2. B
    RMAN Media Management Library
  3. C
    Enterprise Manager Cloud Control
  4. D
    Enterprise Manager Database Express
  5. E
    Oracle Secure Backup

Correct Answer:
AC

Question #18
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. A
    MAXSETSIZE TO 2;
  2. B
    DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  3. C
    CHANNEL DEVICE TYPE DISK FORMAT '/disk1/%U' , '/disk2/%U';
  4. D
    DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

Correct Answer:
D
References:

Question #19
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. A
    The valid time columns employee_time_start and employee_time_end are automatically created.
  2. B
    The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
  3. C
    The valid time columns are not populated by the Oracle Server automatically.
  4. D
    The valid time columns are visible by default when the table is described.
  5. E
    Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data

Correct Answer:
ABE
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 tables 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.

Question #20
Which two statements are true when row-archival management is enabled?
  1. A
    Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.
  2. B
    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. C
    The row archival visibility session parameter defaults to all rows.
  4. D
    The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.
  5. E
    The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer

Correct Answer:
AD

Previous Questions Next Questions

All Pages