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. 5)

  • 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 #21
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. A
    maximum undo per consumer group
  2. B
    maximum idle time for a session in a PDB
  3. C
    parallel server limit
  4. D
    CPU
  5. E
    maximum number of sessions for a PDB

Correct Answer:
CD

Question #22
Which three types of failures are detected by the Data Recovery Advisor (DRA)?
  1. A
    loss of a non-critical data file
  2. B
    loss of a control file
  3. C
    physical data block corruption
  4. D
    logical data block corruption
  5. E
    loss of an archived redo log file

Correct Answer:
BDE
References:

Question #23
You want to capture column group usage and gather extended statistics for better cardinality estimates for the customers table in the SH schema.
Examine the following steps:
1. Issue the SELECTDBMS_STATS. CREATE_EXTENDED_STATS(SH, 'CUSTOMERS')from dual statement.
2.Execute the dbms_stats.seed_col_usage (null,SH,500) procedure.
3.Execute the required queries on the customers table.
4.Issue the select dbms_stats.reportwcol_usage(SH, 'customers') from dual statement.
Identify the correct sequence of steps.
  1. A
    3, 2, 1, 4
  2. B
    2, 3, 4, 1
  3. C
    4, 1, 3, 2
  4. D
    3, 2, 4, 1

Correct Answer:
B
Step 1 (2). Seed column usage -
Oracle must observe a representative workload, in order to determine the appropriate column groups. Using the new procedure
DBMS_STATS.SEED_COL_USAGE, you tell Oracle how long it should observe the workload.
Step 2: (3) You don't need to execute all of the queries in your work during this window. You can simply run explain plan for some of your longer running queries to ensure column group information is recorded for these queries.
Step 3. (1) Create the column groups
At this point you can get Oracle to automatically create the column groups for each of the tables based on the usage information captured during the monitoring window. You simply have to call the DBMS_STATS.CREATE_EXTENDED_STATS function for each table.This function requires just two arguments, the schema name and the table name. From then on, statistics will be maintained for each column group whenever statistics are gathered on the table.
Note:
* DBMS_STATS.REPORT_COL_USAGE reports column usage information and records all the SQL operations the database has processed for a given object.
* The Oracle SQL optimizer has always been ignorant of the implied relationships between data columns within the same table. While the optimizer has traditionally analyzed the distribution of values within a column, he does not collect value-based relationships between columns.
* Creating extended statistics
Here are the steps to create extended statistics for related table columns withdbms_stats.created_extended_stats:
1 - The first step is to create column histograms for the related columns.
2 Next, we run dbms_stats.create_extended_stats to relate the columns together.
Unlike a traditional procedure that is invoked via an execute ("exec") statement, Oracle extended statistics are created via a select statement.

Question #24
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>CREATEDATABASECDB1 -

DEFAULTTABLESPACE users -

DEFAULTTEMPORARY TABLESPACEtemp -

UNDO TABLESPACEundotbsl -

ENABLEPLUGGA3LEDATABASE -

SEED -
SYSTEMDATAFILESSIZE125M AUTOEXTEND ON NEXT10M MAXSIZEUNLIMITED
SYSAUXDATAFILESSIZE100M;
Which three statements are true?
  1. A
    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. B
    The files created for both the root and seed databases use Oracle Managed Files (OMF).
  3. C
    It creates a multitenant container database with the root and seed databases opened and one PDB mounted.
  4. D
    It sets the users tablespace as the default for both the root and seed databases.
  5. E
    undotbs1 is used as the undo tablespace for both the root and seed databases.
  6. F
    It creates a multitenant container database with the root database opened and the seed database mounted.

Correct Answer:
ABE

Question #25
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. A
    1, 4, 3, 2, 5
  2. B
    1, 3, 4, 5, 2
  3. C
    4, 3, 1, 2, 5
  4. D
    4, 3, 5, 1, 2

Correct Answer:
C

Previous Questions Next Questions

All Pages