Latesttests
2018 Jan Oracle Official New Released 1z0-062
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-062.html

Oracle Database 12c: Installation and Administration

Question No: 91

You enabled an audit policy by issuing the following statements:

SQLgt;AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;

SQLgt; AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;

For which database users and for which executions is the audit policy now active? Select two.

  1. SYS, SYSTEM

  2. SCOTT

  3. Only for successful executions

  4. Only for failed executions

  5. Both successful and failed executions

Answer: A,E Explanation:

  • The ORA_DATABASE_PARAMETER policy audits commonly used Oracle Database parameter settings. By default, this policy is not enabled.

    Question No: 92

    Which two statements are true about Oracle Data Pump export and import operations?

    1. You can detach from a data pump export job and reattach later.

    2. Data pump uses parallel execution server processes to implement parallel import.

    3. Data pump import requires the import file to be in a directory owned by the oracle owner.

    4. The master table is the last object to be exported by the data pump.

    5. You can detach from a data pump import job and reattach later.

    Answer: A,B,D Explanation:

    B: Data Pump can employ multiple worker processes, running in parallel, to increasejob performance.

    D: For export jobs, the master table records the location of database objects within a dump file set. / Export builds and maintains the master table for the duration of the job. At the end of an export job, the content of the master table is written to a file in the dump file set.

    / For import jobs, the master table is loaded from the dump file set and is used to control the sequence of operations for locating objects that need to be imported into the target database.

    Question No: 93

    Examine the parameters for a database instance:

    Latesttests 2018 PDF and VCE

    Which two statements are true?

    1. Undo records for temporary tables are stored in a temporary tablespace.

    2. Undo records for temporary tables are stored in the undo tablespace andlogged in the redo.

    3. Undo records for temporary tables are stored in the undo tablespace and logged in the redo only for those sessions where temporary undo is enabled.

    4. No redo is generated for the undo records belonging to temporary tables.

    5. Noredo and undo records are generated for temporary tables.

    Answer: C,E

    Question No: 94

    You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?

    1. It may advise the use of online table redefinition for tables in dictionary managed tablespace.

    2. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.

    3. It may advise the use of online table redefinition for tables in locally managed tablespaces

    4. It will detect and advise about chained rows.

    5. It may advise the use of segment shrink for free list managedtables.

    Answer: A,D,E Explanation:

    The Segment Advisor generates the following types of advice:

  • If the Segment Advisor determines that an object has a significant amount of free space, it recommends online segment shrink. If the object is a table thatis not eligible for shrinking, as in the case of a table in a tablespace without automatic segment space management, the Segment Advisor recommends online table redefinition (C).

  • (D) If the Segment Advisor encounters a table with row chaining above a certain threshold, it records that fact that the table has an excess of chained rows.

    Question No: 95

    You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.

    Which two are possible if table updates are performed which affect the invisible index columns?

    1. The index remains invisible.

    2. The index is not updated by the DML statements on the indexed table.

    3. The index automatically becomes visible in order to have it updated by DML on the table.

    4. The index becomes unusable but the table is updated by the DML.

    5. The index is updated by the DML on the table.

    Answer: A,E Explanation:

    Unlike unusable indexes, an invisible index is maintained during DML statements. Note:

  • Oracle 11g allows indexes to be marked as invisible. Invisible indexes are maintained like any other index, but they are ignored by the optimizer unless the OPTIMIZER_USE_INVISIBLE_INDEXES parameter is set to TRUE at the instance or sessionlevel. Indexes can be created as invisible by using the INVISIBLE keyword, and their visibility can be toggled using the ALTER INDEX command.

  • Question No: 96

    Which two statements are true about SQL *Loader Express Mode in an Oracle 12c database?

    1. The DEGREE_OF_PARALLELISMparameter is set to AUTO.

    2. You cannot have multiple SQL *Loader data files.

    3. If no data file is specified, it assumes the data file to be lt;table-namegt;.dat in the current directory and uses it.

    4. You can have multiple bad files created when loading inparallel.

    5. You can selectively load rows into a table based on a filer.

    Answer: A,D Explanation:

    References: https://docs.oracle.com/database/121/SUTIL/GUID-0F35B551-861B-450D- 8BF3-2312893A67D7.htm#SUTIL3951

    Question No: 97

    Which two statements describe the relationship between a scheduler window, a resource manager plan, and a job class?

    1. A scheduler window together with a job class, controls resource allocationfor a job using that job class in that scheduler window.

    2. A job class specifies a scheduler window that will be open when that job class becomes active.

    3. A scheduler window specifies a resource manager plan that will be activated when that scheduler window becomes active.

    4. A scheduler window specifies a job class that will be activated when that scheduler window becomes active.

    5. A scheduler window can control resource allocation by itself.

    Answer: D,E

    Question No: 98

    You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy.

    One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed.

    When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow.

    Which two recommendations should you make to speed upthe rebalance operation if this type of failure happens again?

    1. Increase the value of the ASM_POWER_LIMIT parameter.

    2. Set the DISK_REPAIR_TIME disk attribute to a lower value.

    3. Specify the statement that adds the disk back to the disk group.

    4. Increase the number of ASMB processes.

    5. Increase the number of DBWR_IO_SLAVES in the ASM instance.

    Answer: A,D Explanation:

    A: ASM_POWER_LIMIT specifies the maximum power on an Automatic Storage Management instance for disk rebalancing. The higher thelimit, the faster rebalancing will complete. Lower values will take longer, but consume fewer processing and I/O resources.

    D:

    • Normally a separate process is fired up to do that rebalance. This will take a certain amount of time. If you want it to happen faster, fire up more processes. You tell ASM it can add more processes by increasing the rebalance power.

    • ASMB

      ASM Background Process

      Communicates with the ASM instance, managing storage and providing statistics

      Incorrect:

      Not B: A higher, not alower, value of DISK_REPAIR_TIME would be helpful here.

      Not E: If you implement database writer I/O slaves by setting the DBWR_IO_SLAVES parameter, you configure a single (master) DBWR process that has slave processes that are subservient to it. In addition, I/O slaves can be used to quot;simulatequot; asynchronous I/O on platforms that do not support asynchronous I/O or implement it inefficiently. Database I/O slaves provide non-blocking, asynchronous requests to simulate asynchronous I/O.

      Question No: 99

      Which three statements are true concerning the multitenant architecture?

      1. Each pluggable database (PDB) has its own set of background processes.

      2. A PDB can have a private temp tablespace.

      3. PDBs can share the sysaux tablespace.

      4. Log switches occur only at the multitenant container database (CDB) level.

      5. Different PDBs can have different default block sizes.

      6. PDBs share a common system tablespace.

      7. Instance recovery is always performed at the CDB level.

      Answer: B,D,G Explanation:

      B:

    • A PDB would have its SYSTEM, SYSAUX, TEMPtablespaces. It can also contains other user created tablespaces in it.

    • There is one default temporary tablespace for the entire CDB. However, you can create additional temporary tablespaces in individual PDBs.

      D:

    • There is a single redo log and a single control file for an entire CDB

    • A log switch is the point at which the database stops writing to one redo log file and begins writing to another. Normally, a log switch occurs when the current redo log file is completely filled and writing must continueto the next redo log file.

    G: instance recovery

    The automatic application of redo log records to uncommitted data blocks when an database instance is restarted after a failure.

    Incorrect: Not A:

    • There is one set of background processes shared by theroot and all PDBs. –

    • High consolidation density. The many pluggable databases in a single container database share its memory and background processes, letting you operate many more pluggable databases on a particular platform than you can single databases that use the old architecture.

      Not C: There is a separate SYSAUX tablespace for the root and for each PDB. Not F: There is a separate SYSTEM tablespace for the root and for each PDB. –

      Question No: 100

      You created a new database using the quot;create databasequot; statement without specifying the quot;ENABLE PLUGGABLEquot; clause.

      What are two effects of not using the quot;ENABLE PLUGGABLE databasequot; clause?

      1. The database is created as a non-CDB and can never contain a PDB.

      2. The database is treated as a PDB and must be plugged into an existing multitenant container database (CDB).

      3. The database is created as a non-CDB and can never be plugged into a CDB.

      4. The database is created as a non-CDB but can be plugged into anexisting CDB.

      5. The database is created as a non-CDB but will become a CDB whenever the first PDB is plugged in.

      Answer: A,D Explanation:

      A (not B,not E): The CREATE DATABASE … ENABLE PLUGGABLE DATABASE SQL

      statement creates a new CDB. If you do not specify the ENABLE PLUGGABLE DATABASE clause, then the newly created database is a non-CDB and can never contain PDBs.

      D: You can create a PDB by plugging in a Non-CDB as a PDB. The following graphic depicts the options for creating a PDB:

      Latesttests 2018 PDF and VCE

      Incorrect:

      NotE: For the duration of its existence, a database is either a CDB or a non-CDB. You cannot transform a non-CDB into a CDB or vice versa. You must define a database as a CDB at creation, and then create PDBs within this CDB.

      100% Free Download!
      Download Free Demo:1z0-062 Demo PDF
      100% Pass Guaranteed!
      Download 2018 Latesttests 1z0-062 Full Exam PDF and VCE

      Latesttests ExamCollection Testking
      Lowest Price Guarantee Yes No No
      Up-to-Dated Yes No No
      Real Questions Yes No No
      Explanation Yes No No
      PDF VCE Yes No No
      Free VCE Simulator Yes No No
      Instant Download Yes No No

      2018 Latesttests IT Certification PDF and VCE