1z0 062 dumps (61 to 70)

It is more faster and easier to pass the Oracle 1z0 062 pdf exam by using Best Quality Oracle Oracle Database 12c: Installation and Administration questuins and answers. Immediate access to the Replace 1z0 062 pdf Exam and find the same core area oracle database 12c installation and administration 1z0 062 pdf questions with professionally verified answers, then PASS your exam with a high score now.


♥♥ 2021 NEW RECOMMEND ♥♥

Free VCE & PDF File for Oracle 1Z0-062 Real Exam (Full Version!)

★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW 1Z0-062 Exam Dumps (PDF & VCE):
Available on: http://www.surepassexam.com/1Z0-062-exam-dumps.html

Q61. Which three statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)? 

A. System privileges apply only to the PDB in which they are used. 

B. Local users cannot use local system privileges on the schema of a common user. 

C. The granter of system privileges must possess the set container privilege. 

D. Common users connected to a PDB can exercise privileges across other PDBs. 

E. System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users. 

Answer: A,C,E 

Explanation: A, Not D: In a CDB, PUBLIC is a common role. In a PDB, privileges granted locally to PUBLIC enable all local and common users to exercise these privileges in this 

PDB only. 

C: A user can only perform common operations on a common role, for example, granting privileges commonly to the role, when the following criteria are met: 

The user is a common user whose current container is root. 

The user has the SET CONTAINER privilege granted commonly, which means that the 

privilege applies in all containers. 

The user has privilege controlling the ability to perform the specified operation, and this 

privilege has been granted commonly 

Incorrect: 

Note: 

* Every privilege and role granted to Oracle-supplied users and roles is granted commonly except for system privileges granted to PUBLIC, which are granted locally. 


Q62. You are connected to a pluggable database (PDB) as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following: SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE; Which is true about the result of this command? 

A. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened. 

B. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened. 

C. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted. 

D. Nothing happens; because there is no SPFILE for each PDB, the statement is ignored. 

Answer:

Explanation: 

Note: 

* In a container architecture, the parameters for PDB will inherit from the root database. That means if statistics_level=all in the root that will cascade to the PDB databases. 

You can over ride this by using Alter system set, if that parameter is pdb modifiable, there is a new column in v$system_parameter for the same. 


Q63. 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? 

A. Re-enable redaction policies that use FULL data redaction. 

B. Re-create redaction policies that use FULL data redaction. 

C. Re-connect the sessions that access objects with redaction policies defined on them. 

D. Flush the shared pool. 

E. Restart the database instance. 

Answer:

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. 

Reference: Oracle Database Advanced Security Guide 12c, About Altering the Default Full Data Redaction Value 


Q64. Examine the following query output: 

You issue the following command to import tables into the hr schema: 

$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y 

Which statement is true? 

A. All database operations performed by the impdp command are logged. 

B. Only CREATE INDEX and CREATE TABLE statements generated by the import are logged. 

C. Only CREATE TABLE and ALTER TABLE statements generated by the import are logged. 

D. None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged. 

Answer:

Explanation: Oracle Data Pump disable redo logging when loading data into tables and when creating indexes. The new TRANSFORM option introduced in data pumps import provides the flexibility to turn off the redo generation for the objects during the course of import. The Master Table is used to track the detailed progress information of a Data Pump job. The Master Table is created in the schema of the current user running the Pump Dump export or import, and it keeps tracks of lots of detailed information. 


Q65. You execute the following PL/SQL: 

Which two statements are true? 

A. Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed. 

B. FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed. 

C. FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column. 

D. FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial. 

Answer: A,B 

Explanation: DBMS_FGA.add_policy 

* The DBMS_FGA package provides fine-grained security functions. 

* ADD_POLICY Procedure 

This procedure creates an audit policy using the supplied predicate as the audit condition. 

Incorrect: 

Not C: object_schema 

The schema of the object to be audited. (If NULL, the current log-on user schema is assumed.) 


Q66. You performed an incremental level 0 backup of a database: 

RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE; 

To enable block change tracking after the incremental level 0 backup, you issued this 

command: 

SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE 

‘ /mydir/rman_change_track.f’; 

To perform an incremental level 1 cumulative backup, you issued this command: 

RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; 

Which three statements are true? 

A. Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups. 

B. The change tracking file must always be backed up when you perform a full database backup. 

C. Block change tracking will always reduce I/O performed during cumulative incremental backups. 

D. More than one database block may be read by an incremental backup for a change made to a single block. 

E. The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks. 

Answer: A,D,E 

Explanation: A: In a cumulative level 1 backup, RMAN backs up all the blocks used since the most recent level 0 incremental backup. 

E:.Oracle Block Change Tracking Once enabled; this new 10g feature records the modified since last backup and stores the log of it in a block change tracking file using the CTW (Change Tracking Writer) process. During backups RMAN uses the log file to identify the specific blocks that must be backed up. This improves RMAN's performance as it does not have to scan whole datafiles to detect changed blocks. Logging of changed blocks is performed by the CTRW process which is also responsible for writing data to the block change tracking file. 

Note: 

* An incremental level 0 backup backs up all blocks that have ever been in use in this database. 


Q67. A redaction policy was added to the SAL column of the SCOTT.EMP table:

 

All users have their default set of system privileges. 

For which three situations will data not be redacted? 

A. SYS sessions, regardless of the roles that are set in the session 

B. SYSTEM sessions, regardless of the roles that are set in the session 

C. SCOTT sessions, only if the MGR role is set in the session 

D. SCOTT sessions, only if the MGR role is granted to SCOTT 

E. SCOTT sessions, because he is the owner of the table 

F. SYSTEM session, only if the MGR role is set in the session 

Answer: A,D,F 

Explanation: 

* SYS_CONTEXT This is a twist on the SYS_CONTEXT function as it does not use USERENV. With this usage SYS_CONTEXT queries the list of the user's current default roles and returns TRUE if the role is granted. 

Example: 

SYS_CONTEXT('SYS_SESSION_ROLES', 'SUPERVISOR') 

conn scott/tiger@pdborcl 

SELECT sys_context('SYS_SESSION_ROLES', 'RESOURCE') 

FROM dual; 

SYS_CONTEXT('SYS_SESSION_ROLES','SUPERVISOR') 

FALSE 

conn sys@pdborcl as sysdba 

GRANT resource TO scott; 

conn scott/tiger@pdborcl SELECT sys_context('SYS_SESSION_ROLES', 'RESOURCE') FROM dual; SYS_CONTEXT('SYS_SESSION_ROLES','SUPERVISOR') TRUE 


Q68. You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute the following script: 

SQL > @utlrp.sql 

Which two actions does the script perform? 

A. Parallel compilation of only the stored PL/SQL code 

B. Sequential recompilation of only the stored PL/SQL code 

C. Parallel recompilation of any stored PL/SQL code 

D. Sequential recompilation of any stored PL/SQL code 

E. Parallel recompilation of Java code 

F. Sequential recompilation of Java code 

Answer: C,E 

Explanation: utlrp.sql and utlprp.sql 

The utlrp.sql and utlprp.sql scripts are provided by Oracle to recompile all invalid objects in the database. They are typically run after major database changes such as upgrades or patches. They are located in the $ORACLE_HOME/rdbms/admin directory and provide a wrapper on the UTL_RECOMP package. The utlrp.sql script simply calls the utlprp.sql script with a command line parameter of "0". The utlprp.sql accepts a single integer parameter that indicates the level of parallelism as follows. 

0 - The level of parallelism is derived based on the CPU_COUNT parameter. 

1 - The recompilation is run serially, one object at a time. 

N - The recompilation is run in parallel with "N" number of threads. 

Both scripts must be run as the SYS user, or another user with SYSDBA, to work correctly. 

Reference: Recompiling Invalid Schema Objects 


Q69. 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? 

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 

B. Setting the target tablespace to read-only 

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 TBS PERCENT USED 

D. Setting the target tablespace offline 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 PERCENT USED 

Answer: B,C 

Explanation: 

The value for TBS_PERCENT_USED specifies the percentage of the tablespace quota when a tablespace is considered full. The value for TBS_PERCENT_FREE specifies the targeted free percentage for the tablespace. When the percentage of the tablespace quota reaches the value of TBS_PERCENT_USED, ADO begins to move data so that percent free of the tablespace quota approaches the value of TBS_PERCENT_FREE. This action by ADO is a best effort and not a guarantee. 


Q70. As a user of the ORCL database, you establish a database link to the remote HQ database such that all users in the ORCL database may access tables only from the SCOTT schema in the HQ database. SCOTT’s password is TIGER. The service mane “HQ” is used to connect to the remote HQ database. 

Which command would you execute to create the database link? 

A. CREATE DATABASE LINK HQ USING 'HQ' 

B. CREATE DATABASE LINK HQ CONNECT TO CXJRRENT_USER USING HQ' S 

C. CREATE PUBLIC DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ' 

D. CREATE DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ' 

Answer: