[Free] 2019(Nov) EnsurePass Oracle 1z0-062 Dumps with VCE and PDF 41-50

Get Full Version of the Exam
http://www.EnsurePass.com/1z0-062.html

Question No.41

Examine the current value for the following parameters in your database instance: SGA_MAX_SIZE = 1024M

SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M

LOG_BUFFER = 200M

You issue the following command to increase the value of DB_8K_CACHE_SIZE: SQLgt; ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;

Which statement is true?

  1. It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.

  2. It succeeds only if memory is available from the autotuned components if SGA.

  3. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.

  4. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.

Correct Answer: D

Explanation:

The SGA_TARGET parameter can be dynamically increased up to the value specified for the SGA_MAX_SIZE parameter, and it can also be reduced.

Example:

For example, suppose you have an environment with the following configuration: SGA_MAX_SIZE = 1024M

SGA_TARGET = 512M DB_8K_CACHE_SIZE = 128M

In this example, the value of SGA_TARGET can be resized up to 1024M and can also be reduced until one or more of the automatically sized components reaches its minimum size. The exact value depends on environmental factors such as the number of CPUs on the system.

However, the value of DB_8K_CACHE_SIZE remains fixed at all times at 128M DB_8K_CACHE_SIZE

Size of cache for 8K buffers

For example, consider this configuration: SGA_TARGET = 512M DB_8K_CACHE_SIZE = 128M

In this example, increasing DB_8K_CACHE_SIZE by 16 M to 144M means that the 16M is taken away from the automatically sized components. Likewise, reducing DB_8K_CACHE_SIZE by 16M to 112M means that the 16M is given to the automatically sized components.

Question No.42

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#39;s password is TIGER. The service mane quot;HQquot; is used to connect to the remote HQ database. Which command would you execute to create the database link?

  1. CREATE DATABASE LINK HQ USING #39;HQ#39;;

  2. CREATE DATABASE LINK HQ CONNECT TO CURRENT_USER USING `HQ#39;;

  3. CREATE PUBLIC DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING #39;HQ#39;;

  4. CREATE DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING #39;HQ#39;;

Correct Answer: C

Question No.43

Which statement is true regarding the startup of a database instance?

  1. The instance does not start up normally and requires manual media recovery after a shutdown using the ABORT option.

  2. Uncommitted transactions are rolled back during the startup of the database instance after a shutdown using the immediate option.

  3. There is no difference in the underlying mechanics of the startup whether the database is shut down by using the IMMEDIATE option or the ABORT option.

  4. Media recovery is required when the database is shut down by using either the IMMEDIATE option or the ABORT option.

  5. Instance recovery is not required if the database instance was shut down by using SHUTDOWN IMMEDIATE.

Correct Answer: E

Explanation:

http://docs.oracle.com/cd/A87860_01/doc/server.817/a76956/start.htm

Question No.44

Which two statements are true concerning dropping a pluggable database (PDB)? (Choose two.)

  1. The PDB must be open in read-only mode.

  2. The PDB must be in mount state.

  3. The PDB must be unplugged.

  4. The PDB data files are always removed from disk.

  5. A dropped PDB can never be plugged back into a multitenant container database (CDB).

Correct Answer: BC

Explanation:

http://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13658

Question No.45

Which two are true concerning a multitenant container database with three pluggable database? (Choose two.)

  1. All administration tasks must be done to a specific pluggable database.

  2. The pluggable databases increase patching time.

  3. The pluggable databases reduce administration effort.

  4. The pluggable databases are patched together.

  5. Pluggable databases are only used for database consolidation.

Correct Answer: CD

Question No.46

Which three statements are true concerning unplugging a pluggable database (PDB)? (Choose three.)

  1. The PDB must be open in read only mode.

  2. The PDB must be dosed.

  3. The unplugged PDB becomes a non-CDB.

  4. The unplugged PDB can be plugged into the same multitenant container database (CDB)

  5. The unplugged PDB can be plugged into another CDB.

  6. The PDB data files are automatically removed from disk.

Correct Answer: BDE

Explanation:

B, not A: The PDB must be closed before unplugging it.

D: An unplugged PDB contains data dictionary tables, and some of the columns in these encode information in an endianness-sensitive way. There is no supported way to handle the conversion of such columns automatically. This means, quite simply, that an unplugged PDB cannot be moved across an endianness difference.

E (not F): To exploit the new unplug/plug paradigm for patching the Oracle version most effectively, the source and destination CDBs should share a filesystem so that the PDB#39;s datafiles can remain in place.

Question No.47

What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?

  1. Effectively implements role separation

  2. Enables you to take advantage of Oracle Managed Files.

  3. Automatically registers the database with Oracle Restart.

  4. Helps you to easily upgrade the database from a prior release.

  5. Enables the Installation of Grid Infrastructure files on block or raw devices.

Correct Answer: AC

Explanation:

C: To use Oracle ASM or Oracle Restart, you must first install Oracle Grid Infrastructure for a standalone server before you install and create the database. Otherwise, you must manually register the database with Oracle Restart.

Desupport of Block and Raw Devices

With the release of Oracle Database 11g release 2 (11.2) and Oracle RAC 11g release 2 (11.2), using Database Configuration Assistant or the installer to store Oracle Clusterware or Oracle Database files directly on block or raw devices is not supported. If you intend to upgrade an existing Oracle RAC database, or an Oracle RAC database with Oracle ASM instances, then you can use an existing raw or block device partition, and perform a rolling upgrade of your existing installation. Performing a new installation using block or raw devices is not allowed.

Question No.48

In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure:

CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2, v_SALARY NUMBER, v_dept_id NUMBER)

BEGIN

INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id); END;

/

GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king;

How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?

  1. Create the CREATE_TEST procedure with definer#39;s rights.

  2. Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.

  3. Create the CREATE_TEST procedure with invoker#39;s rights.

  4. Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.

Correct Answer: C

Explanation:

If a program unit does not need to be executed with the escalated privileges of the definer, you should specify that the program unit executes with the privileges of the caller, also known as the invoker. Invoker#39;s rights can mitigate the risk of SQL injection.

Incorrect:

Not A: By default, stored procedures and SQL methods execute with the privileges of their owner, not their current user. Such definer-rights subprograms are bound to the schema in which they reside.

Not B: Using the GRANT option, a user can grant an Object privilege to another user or to PUBLIC.

Question No.49

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)? (Choose three.)

  1. Tracking the most recent read time for a table segment in a user tablespace

  2. Tracking the most recent write time for a table segment in a user tablespace

  3. Tracking insert time by row for table rows

  4. Tracking the most recent write time for a table block

  5. Tracking the most recent read time for a table segment in the SYSAUX tablespace

  6. Tracking the most recent write time for a table segment in the SYSAUX tablespace

Correct Answer: ABD Explanation: Incorrect:

Not E, Not F When Heat Map is enabled, all accesses are tracked by the in-memory activity tracking module. Objects in the SYSTEM and SYSAUX tablespaces are not tracked.

To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and modification.

Heat Map provides data access tracking at the segment-level and data modification tracking at the segment and row level.

To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and modification. You can also use Automatic Data Optimization (ADO) to automate the compression and movement of data between different tiers of storage within the database.

Question No.50

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

image

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.

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

Get Full Version of the Exam
1z0-062 Dumps
1z0-062 VCE and PDF

Leave a Reply

Your email address will not be published. Required fields are marked *

Proudly powered by WordPress