[Free] 2018(Jan) EnsurePass Testinsides Oracle 1z0-062 Dumps with VCE and PDF 11-20

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-062
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-062.html

Oracle Database 12c: Installation and Administration

Question No: 11

Ensurepass 2018 PDF and VCE

In your database, USERS is the default permanent tablespace. Examine the commands and their outcome:

You plan to execute the commands:

Ensurepass 2018 PDF and VCE

Which two statements are true?

  1. The MYTAB table is created in the SYSTEM tablespace but no rows can be inserted into the table by USER02.

  2. The MYTAB table is created in the SYSTEM tablespace and rows can be inserted into the table by USER02.

  3. TheMYTAB table is created in the USERS tablespace but no rows can be inserted into the table by USER02.

  4. The CREATE TABLE statement generates an error because the SYSDBA privilege does not provide any space quota on the SYSTEM tablespace by default.

  5. TheMYTAB table is owned by the SYS user.

Answer: B,E

Question No: 12

What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving enabled?

  1. It fails with the ORA-665610 Invalid DDL statement on history-tracked message

  2. The rows in the table are truncated without being archived.

  3. The rows in the table are archived, and then truncated.

  4. The rows in both the table and the archive are truncated.

Answer: B

Explanation:

You cannot roll back a TRUNCATE TABLE statement, nor can you use a FLASHBACK TABLE statement to retrieve the contents of a table that has been truncated.

Question No: 13

Which two statements are true about the (PMON) background process in Oracle Database 12c?

  1. It records checkpoint information in the control file.

  2. It frees unused temporary segments.

  3. It kills sessions that exceed idle time.

  4. It registers database services with all local and remote listeners known to the database instance.

  5. It frees resources held by abnormally terminated processes.

    Answer: D,E Explanation:

    References: https://docs.oracle.com/database/122/CNCPT/process- architecture.htm#CNCPT9840

    Question No: 14

    Which set of statements is true about data dictionary views?

    1. They are stored in the SYSTEM tablespace.

    2. They arebased on virtual tables.

    3. They are owned by the SYS user.

    4. They can be queried by a normal user only if the 07_DICTIONARY_ACCESSIBILITY parameter is set to TRUE.

    5. The V$FIXED_TABLE view can be queried to list the names of these views.

    6. They are owned by the SYSTEM user.

      1. 2, 5, and 6

      2. 1, 2, and 3

      3. 1 and 3

D. 2, 3, 4, and 5

Answer: C Explanation: References:

https://docs.oracle.com/cd/E11882_01/server.112/e40540/datadict.htm#CNCPT002

Question No: 15

Which statement is true regarding thestartup 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 ashutdown 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.

Answer: E Explanation: References:

Question No: 16

Which four operations performed after the Oracle Restart installation are automatically added to the Oracle Restart configuration?

  1. listener configured by using NETCA

  2. database service created by using SRVCTL

  3. database created by using a SQL statement

  4. database created by using DBCA

  5. ASM instance created by using ASMCA

  6. database service created by using DBMS_SERVICE.CREATE_SERVICE

  7. database service created by modifying the SERVICE_NAMES initializationparameter

Answer: A,B,C,D

Question No: 17

A senior DBA asked you to execute the following command to improve performance: SQLgt;ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);

You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.

What could be a reason for this recommendation?

  1. The keep pool is not configured.

  2. Automatic Workarea Management is not configured.

  3. Automatic Shared Memory Management is not enabled.

  4. The data blocks in the SUBSCRIBE_LOG table are rarely accessed.

  5. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view.

Answer: D Explanation:

The most of the rows in SUBSCRIBE_LOG table are accessed once a week.

Question No: 18

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.

Answer: A,C 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 RACdatabase 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.

References:

Question No: 19

You use a recovery catalog for maintaining your database backups. You execute the following command:

$rman TARGET / CATALOG rman / cat@catdb

RMAN gt; BACKUP VALIDATE DATABASE ARCHIVELOG ALL;

Which two statements are true?

  1. Corrupted blocks, if any, are repaired.

  2. Checks are performed for physical corruptions.

  3. Checks are performed for logical corruptions.

  4. Checks are performed to confirm whether all database files exist in correct locations

  5. Backup sets containing both data files and archive logs are created.

Answer: B,D Explanation:

B (not C): You can validate that all database files and archived redo logs can be backed up by running a command as follows:

RMANgt; BACKUP VALIDATE DATABASE ARCHIVELOG ALL;

This form of the command would check for physical corruption. To check for logical corruption,

RMANgt;BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL;

D: You can use the VALIDATE keyword of the BACKUP command to do the following: Check datafiles for physical and logical corruption

Confirm that all database files exist and are in the correct locations.

Note:

You can use the VALIDATE option of the BACKUP command to verify that database files exist and are in the correct locations (D), and have no physical or logical corruptions that would prevent RMAN from creating backups of them. When performinga BACKUP…VALIDATE, RMAN reads the files to be backed up in their entirety, as it would during a real backup. It does not, however, actually produce any backup sets or image copies (Not A, not E).

Question No: 20

You are about to plug a multi-terabytenon-CDB into an existing multitenant container database (CDB).

The characteristics of the non-CDB are as follows:

  • Version: Oracle Database 11gRelease 2 (11.2.0.2.0) 64-bit

  • Character set: AL32UTF8

  • National character set: AL16UTF16

  • O/S: Oracle Linux6 64-bit

    The characteristics of the CDB are as follows:

  • Version: Oracle Database 12c Release 1 64-bit

  • Character Set: AL32UTF8

  • National character set: AL16UTF16

  • O/S: Oracle Linux 6 64-bit

Which technique should you use to minimize down time whileplugging this non-CDB into the CDB?

  1. Transportable database

  2. Transportable tablespace

  3. Data Pump full export/import

  4. The DBMS_PDB package

  5. RMAN

Answer: B Explanation:

  • Overview, example:

    • Log into ncdb12c as sys

    • Get the database in aconsistent state by shutting it down cleanly.

    • Open the database in read only mode

    • Run DBMS_PDB.DESCRIBE to create an XML file describing the database.

    • Shut down ncdb12c

    • Connect to target CDB (CDB2)

    • Check whether non-cdb (NCDB12c) can be plugged into CDB(CDB2)

    • Plug-in Non-CDB (NCDB12c) as PDB(NCDB12c) into target CDB(CDB2).

    • Access the PDB and run the noncdb_to_pdb.sql script.

    • Open the new PDB in read/write mode.

  • You can easily plug an Oracle Database 12c non-CDB into a CDB. Just create a PDB manifest file for the non-CDB, and then use the manifest file to create a cloned PDB in the CDB.

  • Note that to plug in a non-CDB database into a CDB, the non-CDB database needs to be of version 12c as well. So existing 11g databases will need to be upgraded to 12c before they can be part of a 12c CDB.

  • 100% Ensurepass Free Download!
    Download Free Demo:1z0-062 Demo PDF
    100% Ensurepass Free Guaranteed!
    1z0-062 Dumps

    EnsurePass 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

    Leave a Reply

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

    This site uses Akismet to reduce spam. Learn how your comment data is processed.