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

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

Oracle Database 12c: Installation and Administration

Question No: 151

You plan to install the Oracle Database 12c software on a new server. The database will use Automatic Storage Management (ASM) and Oracle Restart. Oracle Grid Infrastructure for a standalone server is already installed on the server.

You want to configure job role separation. You create the following operating system users and groups:

  • The user oracle as the owner of the Oracle database installation

  • The user grid as the owner of Oracle Grid Infrastructure

  • The group oinstall as an Oracle Inventory group

  • The group dba as the OSDBA group for Oracle database

  • The group asmdbaas the OSDBA group for Oracle ASM

  • The group asmadmin as the administration privileges group for Oracle ASM

  • The group asmoper as the group for Oracle ASM

Which two additional tasks should you perform with regard to the OS-level owners and groups?

  1. creating a separate central inventory group for the Oracle Database 12c installation

  2. assigning oinstall as the primary group for the oracle user

  3. assigning asmadmin and asmoper as primary groups for the oracle user

  4. creating OS groups associated with the OSBACKUPDBA, OSDGDBA, and OSKMDBA system privileges

  5. assigning asmdba as the secondary group for the oracle user

Answer: C,D

Question No: 152

Which two statements are true about the Oracle Direct Network File system (DNFS)?

  1. It utilizes the OS file system cache.

  2. A traditional NFS mount is not required when using Direct NFS.

  3. Oracle Disk Manager can manage NFS on its own, without using the operating kernel NFS driver.

  4. Direct NFS is available only in UNIX platforms.

  5. DirectNFS can load-balance I/O traffic across multiple network adapters.

Answer: C,E Explanation:

E: Performance is improved by load balancing across multiple network interfaces (if available).


* To enable Direct NFS Client, you must replace thestandard Oracle Disk Manager (ODM) library with one that supports Direct NFS Client.


Not A: Direct NFS Client is capable of performing concurrent direct I/O, which bypasses any operating system level caches and eliminates any operating systemwrite-ordering locks

Not B:

  • To use Direct NFS Client, the NFS file systems must first be mounted and available over regular NFS mounts.

  • Oracle Direct NFS (dNFS) is an optimized NFS (Network File System) client that provides faster and more scalable access to NFS storage located on NAS storage devices (accessible over TCP/IP).

    Not D: Direct NFS is provided as part of the database kernel, and is thus available on all supported database platforms – even those that don#39;t support NFS natively, like Windows.


  • Oracle Direct NFS (dNFS) is an optimized NFS (Network File System) client that provides faster and more scalable access to NFS storage located on NAS storage devices (accessible over TCP/IP). Direct NFS is built directly into the database kernel- just like ASM which is mainly used when using DAS or SAN storage.

  • Oracle Direct NFS (dNFS) is an internal I/O layer that provides faster access to large NFS files than traditional NFS clients.

    Question No: 153

    In your multitenant container database (CDB) containing same pluggable databases (PDBs), youexecute the following commands in the root container:

    Ensurepass 2018 PDF and VCE

    Which two statements are true?

    1. The C # # ROLE1 role is created in the root database and all the PDBs.

    2. The C # # ROLE1 role is created only in the root database because the container clause isnot used.

    3. Privileges are granted to the C##A_ADMIN user only in the root database.

    4. Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.

    5. The statement for granting a role to a user fails because the CONTAINER clause isnot used.

    Answer: A,C Explanation:

  • You can include the CONTAINER clause in several SQL statements, such as the CREATE USER, ALTER USER, CREATE ROLE, GRANT, REVOKE, and ALTER

    SYSTEM statements.

  • * CREATE ROLE with CONTAINER (optional) clause


    Creates a common role.


    Creates a local role in the current PDB.

    Question No: 154

    Which three are activities performed by SMON?

    1. cleaning up the database buffer cache and freeing resources that a client process was using

    2. applying online redo during instance recovery

    3. cleaning up temporary segments that are no longer needed

    4. performing database services registration with the default listener

    5. restartinga server or a dispatcher process that terminated abnormally

    6. recovering failed transactions that were skipped during instance recovery because of file-read or tablespace offline errors

    Answer: B,C,F

    Question No: 155

    You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications:

    • Applications will connect to the database via a middle tier.

    • The number of concurrent user connections will be high.

    • The database will have mixed workload, with the execution of complex BI queries scheduled at night.

    Which DBCA option must you choose to create the database?

    1. a General Purpose database template with default memory allocation

    2. a Data Warehouse database template, with the dedicated server mode option and AMM enabled

    3. a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled

    4. a default database configuration

    Answer: C



    Question No: 156

    An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges.

    A multitenant container database (CDB) instant has the following parameter set: THREADED_EXECUTION = FALSE

    Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?

    1. You can conned as a common user by using the connect statement.

    2. You can connect as a local user by using the connect statement.

    3. You can connect by using easy connect.

    4. You can connect by using OS authentication.

    5. You can connect by using a Net Service name.

    6. You can connect as a local user by using the SET CONTAINER statement.

    Answer: C,D,E,F Explanation:

  • Thechoice of threading model is dictated by the THREADED_EXECUTION initialization parameter.

THREADED_EXECUTION=FALSE : The default value causes Oracle to run using the multiprocess model.

THREADED_EXECUTION=TRUE : Oracle runs with the multithreaded model.

*OS Authentication is not supported with the multithreaded model.


    When this initialization parameter is set to TRUE, which enables the multithreaded Oracle model, operating system authentication is not supported. Attempts to connect tothe database using operating system authentication (for example, CONNECT / AS SYSDBA or

    CONNECT / ) when this initialization parameter is set to TRUE receive an ORA- 01031quot;insufficient privilegesquot; error.

    F: The new SET CONTAINER statement within a call back function:

    The advantage of SET CONTAINER is that the pool does not have to create a new connection to a PDB, if there is an exisitng connection to a different PDB. The pool can use the existing connection, and through SET CONTAINER, can connect to thedesired PDB. This can be done using:


    This avoids the need to create a new connection from scratch.

    Question No: 157

    As a user of the ORCL database, you establisha 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’s password is TIGER. The service mane “HQ” is used to connect to the remote HQ database.

    Which command would you execute to create the database link?





    Answer: B

    Question No: 158

    You executed this command to create a password file:

    $ orapwd file = orapworcl entries = 10 ignorecase = N Which twostatements are true about the password file?

    1. It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.

    2. It contains username and passwords of database users who are members of the OSOPER operating systemgroup.

    3. It contains usernames and passwords of database users who are members of the OSDBA operating system group.

    4. It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.

    5. It will not permit the use ofmixed case passwords for the database users who have been granted the SYSDBA role.

    Answer: A,D Explanation:

  • You can create a password file using the password file creation utility, ORAPWD.

  • Adding Users to a Password File

    When you grant SYSDBA orSYSOPER privileges to a user, that user#39;s name and privilege information are added to the password file. If the server does not have an EXCLUSIVE password file (that is, if the initialization parameter REMOTE_LOGIN_PASSWORDFILE is NONE or SHARED, or the password file is missing), Oracle Database issues an error if you attempt to grant these privileges.

    A user#39;s name remains in the password file only as long as that user has at least one of these two privileges. If you revoke both of these privileges, Oracle Database removes the user from the password file.

  • The syntax of the ORAPWD command is as follows:

    ORAPWD FILE=filename [ENTRIES=numusers] [FORCE={Y|N}] [IGNORECASE={Y|N}] [NOSYSDBA={Y|N}]


If this argument is set to y, passwords are case-insensitive. That is, case is ignored when comparing the password that the user supplies during login with the password in the password file.

Question No: 159

The ORCL database is configured to support shared server mode. You want to ensure that a user connecting remotely to the database instance has a one-to-one ratio between client and server processes.

Which connection method guarantees that this requirement is met?

  1. connecting by using an external naming method

  2. connecting by using the easy connect method

  3. creating a service in the database by using the dbms_service.create_service procedure and using this service for creating a local naming service

  4. connecting by using the local naming method with the server = dedicated parameter set in the tnsnames.ora file for the net service

  5. connecting by using a directory naming method

Answer: C,E

Question No: 160

Which three statements are true about Oracle Restart?

  1. It can be configured to automatically attempt torestart various components after a hardware or software failure.

  2. While starting any components, it automatically attempts to start all dependencies first and in proper order.

  3. It can be configured to automatically restart a database in case of normalshutdown of the database instance.

  4. It can be used to only start Oracle components.

  5. It runs periodic check operations to monitor the health of Oracle components.

Answer: A,B,E

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