[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-060 Dumps with VCE and PDF 61-70

2018 Jan Oracle Official New Released 1z0-060
100% Free Download! 100% Pass Guaranteed!

Upgrade to Oracle Database 12c

Question No: 61

Examine this command:



Which three statements are true about the effect of this command?

  1. Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.

  2. Statistics collection is not done for the CUSTOMERS table when database stats are gathered.

  3. Any existing statistics for the CUSTOMERS table are still available to the optimizer at

    parse time.

  4. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.

  5. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.

Answer: C,D,E

Explanation: * SET_TABLE_PREFS Procedure

This procedure is used to set the statistics preferences of the specified table in the specified schema.

  • Example:

    Using Pending Statistics

    Assume many modifications have been made to the employees table since the last time statistics were gathered. To ensure that the cost-based optimizer is still picking the best plan, statistics should be gathered once again; however, the user is concerned that new statistics will cause the optimizer to choose bad plans when the current ones are acceptable. The user can do the following:

    EXEC DBMS_STATS.SET_TABLE_PREFS(#39;hr#39;, #39;employees#39;, #39;PUBLISH#39;, #39;false#39;);

    By setting the employees tables publish preference to FALSE, any statistics gather from now on will not be automatically published. The newly gathered statistics will be marked as pending.

    Question No: 62

    You notice that the elapsed time for an important database scheduler Job is unacceptably long.

    The job belongs to a scheduler job class and window. Which two actions would reduce the job#39;s elapsed time?

    1. Increasing the priority of the job class to which the job belongs

    2. Increasing the job#39;s relative priority within the Job class to which it belongs

    3. Increasing the resource allocation for the consumer group mapped to the scheduler job#39;s job class within the plan mapped to the scheduler window

    4. Moving the job to an existing higher priority scheduler window with the same schedule and duration

    5. Increasing the value of the JOB_QUEUE_PROCESSES parameter

    6. Increasing the priority of the scheduler window to which the job belongs

    Answer: C,F

    Explanation: http://www.dba- oracle.com/job_scheduling/job_classes.htmhttp://docs.oracle.com/database/121/ADMIN/sc hedover.htm#i1106396

    Question No: 63

    You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the following sequence statements:

    Ensurepass 2018 PDF and VCE

    What is the result of the last SET CONTAINER statement and why is it so?

    1. It succeeds because the PDB_ADMIN user has the required privileges.

    2. It fails because common users are unable to use the SET CONTAINER statement.

    3. It fails because local users are unable to use the SET CONTAINER statement.

    4. If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).

    Answer: C

    Question No: 64

    Examine the parameter for your database instance:

    Ensurepass 2018 PDF and VCE

    You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan:

    Ensurepass 2018 PDF and VCE

    Identify the reason why the optimizer chose different execution plans.

    1. The optimizer used a dynamic plan for the query.

    2. The optimizer chose different plans because automatic dynamic sampling was enabled.

    3. The optimizer used re-optimization cardinality feedback for the query.

    4. The optimizer chose different plan because extended statistics were created for the columns used.

    Answer: B

    Explanation: * optimizer_dynamic_sampling

    OPTIMIZER_DYNAMIC_SAMPLING controls both when the database gathers dynamic statistics, and the size of the sample that the optimizer uses to gather the statistics.

    Range of values0 to 11

    Question No: 65

    Examine the current value for the following parameters in your database instance:


    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.

      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:


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


    Size of cache for 8K buffers

  • For example, consider this configuration: SGA_TARGET = 512M


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: 66

You are administering a database and you receive a requirement to apply the following restrictions:

    1. A connection must be terminated after four unsuccessful login attempts by user.

    2. A user should not be able to create more than four simultaneous sessions.

    3. User session must be terminated after 15 minutes of inactivity.

    4. Users must be prompted to change their passwords every 15 days. How would you accomplish these requirements?

      1. by granting a secure application role to the users

      2. by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to FALSE

      3. By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4

      4. By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE.

      5. By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.

Answer: C

Explanation: SEC_MAX_FAILED_LOGIN_ATTEMPTS specifies the number of authentication attempts that can be made by a client on a connection to the server process. These login attempts can be for multiple user accounts in the same connection. After the specified number of failure attempts, the connection will be automatically dropped by the server process. http://docs.oracle.com/database/121/REFRN/refrn10274.htm#REFRN10274

Question No: 67

In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.

How would you accomplish this?

  1. Setting a metric threshold

  2. Implementing Database Resource Manager

  3. Enabling resumable timeout for user sessions

  4. Decreasing the value of the IDLE_TIME resource limit in the default profile

Answer: D

Explanation: An Oracle session is sniped when you set the idle_time parameter to disconnect inactive sessions. (It#39;s only like sniping on ebay in that a time is set for an action to occur.)

Oracle has several ways to disconnect inactive or idle sessions, both from within SQL*Plus via resources profiles (connect_time, idle_time), and with the SQL*net expire time parameter. Here are two ways to disconnect an idle session:

Set the idle_time parameter in the user profile Set the sqlnet.ora parameter expire_time

Question No: 68

Examine the following command;

ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?

  1. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.

  2. All DDL commands are logged in the alert log file.

  3. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.

  4. Only DDL commands that resulted in the creation of new segments are logged.

  5. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.

Answer: C

Explanation: The log files are created only in $ADR_HOME/log

in alert log only alter system is catched.Sun Mar 30 23:30:04 2014ALTER SYSTEM SET enable_ddl_logging=TRUE SCOPE=BOTH;Sun Mar 30 23:32:41 2014ALTER SYSTEM SET enable_ddl_logging=TRUE SCOPE=BOTH;Sun Mar 30 23:39:35 2014ALTER SYSTEM SET enable_ddl_logging=FALSE SCOPE=BOTH;[oracle@ovs trace]$

only in diag/rdbms/…/../log/ two files are capturing this. The xml file is capturing full details and text file having only the commands.

[oracle@ovs log]$ pwd/oraclebase/diag/rdbms/ora12c1/ora12c1/log[oracle@ovs log]$ cat ddl/*

create table testing2(a number) create table testing3( aa number)

[oracle@ovs log]$ cat ddl_ora12c1.logSun Mar 30 23:33:26 2014diag_adl:create table testing2(a number)diag_adl:create table testing3( aa number) http://docs.oracle.com/database/121/REFRN/refrn10302.htm#REFRN10302

Question No: 69

Which three statements are true about Flashback Database?

  1. Flashback logs are written sequentially, and are archived.

  2. Flashback Database uses a restored control file to recover a database.

  3. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.

  4. Flashback Database can recover a database to the state that it was in before a reset logs operation.

  5. Flashback Database can recover a data file that was dropped during the span of time of the flashback.

  6. Flashback logs are used to restore to the blocks#39; before images, and then the redo data may be used to roll forward to the desired flashback time.

Answer: C,D,F Explanation:

http://docs.oracle.com/database/121/BRADV/flashdb.htm#BRADV529http://docs.oracle.co m/database/121/BRADV/glossary.htm#BRADV90169

Question No: 70

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

Ensurepass 2018 PDF and VCE

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


Leave a Comment


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