[Free] 2018(Jan) EnsurePass Testking Oracle 1z0-062 Dumps with VCE and PDF 131-140

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

In which two scenarios do you use SQL* Loader to load data?

  1. Transform the data while it is being loaded into the database.

  2. Use transparent parallel processing without having to split the external data first.

  3. Load data into multiple tables during the same load statement.

  4. Generate unique sequential key values in specified columns.

Answer: A,D Explanation:

You can use SQL*Loader to do the following:

/ (A) Manipulate the data before loading it, using SQL functions.

/ (D) Generate unique sequential key values in specified columns. etc:

/ Load data into multiple tables during the same load session.

/ Load data across a network. Thismeans that you can run the SQL*Loader client on a different system from the one that is running the SQL*Loader server.

/ Load data from multiple datafiles during the same load session.

/Specify the character set of the data.

/ Selectively load data (youcan load records based on the records#39; values).

/Use the operating system#39;s file system to access the datafiles.

/ Load data from disk, tape, or named pipe.

/ Generate sophisticated error reports, which greatly aid troubleshooting.

/ Load arbitrarilycomplex object-relational data.

/ Use secondary datafiles for loading LOBs and collections.

/ Use either conventional or direct path loading. While conventional path loading is very flexible, direct path loading provides superior loading performance.

Note:

  • SQL*Loader loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that puts little limitation on the format of the data in the datafile.

    Question No: 132

    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 gt; ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE;

    Which is true about the result of this command?

    1. TheSTATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.

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

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

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

    Answer: C Explanation:

    Note:

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

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

Question No: 133

You install “Oracle Grid Infrastructure for a standalone server” on a host on which the ORCL1 and ORCL2 databases both have their instances running.

Which two statements are true?

  1. All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.

  2. The srvctl add database command must be used to add ORCL1 and ORCL2 to the ORACLE Restart configuration.

  3. Both ORCL1 and ORCL2 are automatically added to the Oracle Restart configuration.

  4. All database listeners running from the database home are automatically added to the Oracle Restart configuration.

  5. The crsctl start has command must be used to start software services for Oracle Automatic Storage Management (ASM) after the “Oracle Grid Infrastructure for a standalone server” installation is complete.

Answer: B,D

Question No: 134

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 thatcontains 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: B Explanation:

Once DDL logging is turned on, every DDL command will be logged in the alert log file and also the log.xml file.

Note:

  • By default Oracle database does not log any DDL operations performed by any user. The default settings for auditing only logs DML operations.

  • Oracle 12c DDL Logging – ENABLE_DDL_LOGGING

    The first method is by using the enabling a DDL logging feature built into the database. By default it is turned off and you can turn it on by setting the value of ENABLE_DDL_LOGGING initialization parameter to true.

  • We can turn it on using the following command. The parameter is dynamic and you can turn it on/off on the go.

    SQLgt; alter system set ENABLE_DDL_LOGGING=true; System altered.

    Elapsed: 00:00:00.05 SQLgt;

    Once it isturned on, every DDL command will be logged in the alert log file and also the log.xml file.

    Question No: 135

    Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column?

    1. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.

    2. The procedure may be used for some components to relocate component data fromthe SYSAUX tablespace to another tablespace.

    3. All the components may be moved into SYSAUX tablespace.

    4. All the components may be moved from the SYSAUX tablespace.

    Answer: A,B

    Question No: 136

    Aredaction policy was added to the SAL column of the SCOTT.EMP table:

    Ensurepass 2018 PDF and VCE

    All users have their default set of system privileges. For which three situations will data not be redacted?

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

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

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

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

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

    6. SYSTEMsession, 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#39;s current default roles and returns TRUE if the role is granted.

Example:

SYS_CONTEXT(#39;SYS_SESSION_ROLES#39;, #39;SUPERVISOR#39;)

conn scott/tiger@pdborcl

SELECT sys_context(#39;SYS_SESSION_ROLES#39;, #39;RESOURCE#39;)

FROM dual;

SYS_CONTEXT(#39;SYS_SESSION_ROLES#39;,#39;SUPERVISOR#39;)

———————– FALSE

conn sys@pdborcl as sysdba GRANT resource TO scott; conn scott/tiger@pdborcl

SELECT sys_context(#39;SYS_SESSION_ROLES#39;, #39;RESOURCE#39;)

FROM dual;

SYS_CONTEXT(#39;SYS_SESSION_ROLES#39;,#39;SUPERVISOR#39;)

———————– TRUE

Question No: 137

Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENERby issuing the following command:

1snrctl gt;STOP

What happens to the sessions that are presently connected to the database Instance?

  1. They are able to perform only queries.

  2. They are not affected and continue to function normally.

  3. They are terminated and the active transactions are rolledback.

  4. They are not allowed to perform any operations until the listener LISTENER is started.

Answer: B Explanation:

The listener is used when the connection is established. The immediate impact of stopping the listener will be that no new session canbe established from a remote host. Existing sessions are not compromised.

Question No: 138

Which two statements are true about variable extent size support for large ASM files?

  1. The metadata used totrack extents in SGA is reduced.

  2. Rebalance operations are completed faster than with a fixed extent size

  3. An ASM Instance automatically allocates an appropriate extent size.

  4. Resync operations are completed faster when a disk comes online after being taken offline.

  5. Performance improves in a stretch cluster configuration by reading from a local copy of an extent.

Answer: A,C Explanation:

A: Variable size extents enable support for larger ASM datafiles, reduce SGA memory requirements for verylarge databases (A), and improve performance for file create and open operations.

C: You don#39;t have to worry about the sizes; the ASM instance automatically allocates the appropriate extent size.

Note:

  • The contents of ASM files are stored in a disk group as a set, or collection, of data extents that are stored on individual disks within disk groups. Each extent resides on an individual disk. Extents consist of one or more allocation units (AU). To accommodate increasingly larger files, ASM uses variable size extents.

  • The size of the extent map that defines a file can be smaller by a factor of 8 and 64 depending on the file size. The initial extent size is equal to the allocation unit size and it increases by a factor of 8 and 64 at predefined thresholds. This feature is automatic for newly created and resized datafiles when the disk group compatibility attributes are set to Oracle Release 11 or higher.

    Question No: 139

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

    Your production database PROD uses file system storage. You want to migrate storage including the Fast Recovery Area for the PROD database to Oracle Automatic Storage Management (ASM) by using RMAN. You back up the entiredatabase.

    What should the next step be in this migration process?

    1. enabling row movement for the database

    2. disabling Oracle Flashback Database if enabled

    3. opening the database in exclusive mode

    4. placing all tablespaces in read-only mode

    Answer: B Explanation: References:

    https://docs.oracle.com/cd/E11882_01/server.112/e18951/asm_rman.htm#OSTMG89995

    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.