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

Free Oracle 1Z0-062 Exam Braindumps (page: 2)

Page 2 of 87
PDF with 419 Questions

After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:

After changing the value, you notice that FULL redaction continues to redact numeric data with zero.
What must you do to activate the new default value for numeric full redaction?

  1. Re-enable redaction policies that use FULL data redaction.
  2. Re-create redaction policies that use FULL data redaction.
  3. Re-connect the sessions that access objects with redaction policies defined on them.
  4. Flush the shared pool.
  5. Restart the database instance.

Answer(s): E

Explanation:

About Altering the Default Full Data Redaction Value You can alter the default displayed values for full Data Redaction polices. By default, 0 is the redacted value when Oracle Database performs full redaction (DBMS_REDACT.FULL) on a column of the NUMBER data type. If you want to change it to another value (for example, 7), then you can run the
DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure to modify this value.
The modification applies to all of the Data Redaction policies in the current database instance. After you modify a value, you must restart the database for it to take effect.
Note:
* The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables you to mask (redact) data that is returned from queries issued by low-privileged users or an application.
* UPDATE_FULL_REDACTION_VALUES Procedure
This procedure modifies the default displayed values for a Data Redaction policy for full redaction.
* After you create the Data Redaction policy, it is automatically enabled and ready to redact data.
* Oracle Data Redaction enables you to mask (redact) data that is returned from queries issued by low-privileged users or applications. You can redact column data by using one of the following methods:
/ Full redaction.
/ Partial redaction.
/ Regular expressions.
/ Random redaction.
/ No redaction.



You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.
You plan to create the database using SQL statements.
Which three techniques can you use to achieve this? (Choose three.)

  1. Use Oracle Managed Files (OMF).
  2. Specify the SEED FILE_NAME_CONVERT clause.
  3. Specify the PDB_FILE_NAME_CONVERT initialization parameter.
  4. Specify the DB_FILE_NAMECONVERT initialization parameter.
  5. Specify all files in the CREATE DATABASE statement without using Oracle managed
    Files (OMF).

Answer(s): A,B,C

Explanation:

You must specify the names and locations of the seed's files in one of the following ways:
* (A) Oracle Managed Files
* (B) The SEED FILE_NAME_CONVERT Clause
* (C) The PDB_FILE_NAME_CONVERT Initialization Parameter



Examine the following parameters for a database instance:
MEMORY_MAX_TARGET=0
MEMORY_TARGET=0
SGA_TARGET=0
PGA_AGGREGATE_TARGET=500m
Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)? (Choose three.)

  1. LOG_BUFFER
  2. SORT_AREA_SIZE
  3. JAVA_POOL_SIZE
  4. STREAMS_POOL_SIZE
  5. DB_16K_CACHE_SZIE
  6. DB_KEEP_CACHE_SIZE

Answer(s): A,E,F

Explanation:

Manually Sized SGA Components that Use SGA_TARGET Space SGA Component, Initialization Parameter
/ The log buffer
LOG_BUFFER
/ The keep and recycle buffer caches
DB_KEEP_CACHE_SIZE
DB_RECYCLE_CACHE_SIZE
/ Nonstandard block size buffer caches
DB_nK_CACHE_SIZE
Note:
* In addition to setting SGA_TARGET to a nonzero value, you must set to zero all initialization parameters listed in the table below to enable full automatic tuning of the automatically sized SGA components.
* Table, Automatically Sized SGA Components and Corresponding Parameters



Which two statements are true concerning the Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? (Choose two.)

  1. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.
  2. In a PDB plan, subplans may be used with up to eight consumer groups.
  3. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.
  4. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
  5. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

Answer(s): A,E

Explanation:

A: Setting a PDB resource plan is optional. If not specified, all sessions within the PDB are treated equally.
*In a non-CDB database, workloads within a database are managed with resource plans. In a PDB, workloads are also managed with resource plans, also called PDB resource plans.
The functionality is similar except for the following differences:
/ Non-CDB Database
Multi-level resource plans
Up to 32 consumer groups
Subplans
/ PDB Database
Single-level resource plans only
Up to 8 consumer groups
(not B) No subplans






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

1Z0-062 Exam Discussions & Posts