[Free] 2019(Nov) EnsurePass Oracle 1z0-062 Dumps with VCE and PDF 11-20

Get Full Version of the Exam
http://www.EnsurePass.com/1z0-062.html

Question No.11

The HR user receives the following error while inserting data into the sales table:

image

On investigation, you find that the users tablespace uses Automatic Segment Space Management (ASSM). It is the default tablespace for the HR user with an unlimited quota on it.

Which two methods would you use to resolve this error? (Choose two.)

  1. Altering the data file associated with the USERS tablespace to extend automatically

  2. Adding a data file to the USERS tablespace

  3. Changing segment space management for the USERS tablespace to manual

  4. Creating a new tablespace with autoextend enabled and changing the default tablespace of the HR user to the new tablespace

  5. Enabling resumable space allocation by setting the RESUMABLE_TIMEOUT parameter to a nonzero value

Correct Answer: AB

Question No.12

Which two statements are true concerning the Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? (Choose two.)

  1. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.

  2. In a PDB plan, subplans may be used with up to eight consumer groups.

  3. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.

  4. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.

  5. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

Correct Answer: AE

Explanation:

A: Setting a PDB resource plan is optional. If not specified, all sessions within the PDB are treated equally.

In a non-CDB database, workloads within a database are managed with resource plans. In a PDB, workloads are also managed with resource plans, also called PDB resource plans.

The functionality is similar except for the following differences: Non-CDB Database

Multi-level resource plans Up to 32 consumer groups Subplans

PDB Database

Single-level resource plans only Up to 8 consumer groups

(not B) No subplans

Question No.13

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? (Choose four.)

  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.

Correct Answer: ACDE

Question No.14

Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.

image

Which two statements are true? (Choose two.)

  1. An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.

  2. An attempt to start a new session by a user belonging to OTHER_GROUPS fails with an error.

  3. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.

  4. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.

  5. A user belonging to the DSS QUERIES resource consumer group can create a new session but the session will be queued.

Correct Answer: CE

Question No.15

In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer. Which statement is true?

  1. The CDB must be open.

  2. The CDB must be in the mount stage.

  3. The CDB must be in the nomount stage.

  4. Alt existing PDBs must be closed.

    Correct Answer: A Explanation: Creating a PDB

    Rather than constructing the data dictionary tables that define an empty PDB from scratch, and then populating its Obj$ and Dependency$ tables, the empty PDB is created when the CDB is created. (Here, we use empty to mean containing no customer-created artifacts.) It is referred to as the seed PDB and has the name PDB$Seed. Every CDB non-negotiably contains a seed PDB;

    it is non-negotiably always open in read-only mode. This has no conceptual significance; rather, it is just an optimization device. The create PDB operation is implemented as a special case of the clone PDB operation. The size of the seed PDB is only about 1 gigabyte and it takes only a few seconds on a typical machine to copy it.

    Question No.16

    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.

Correct Answer: A

Explanation:

You can design your applications to automatically grant a role to the user who is trying to log in, provided the user meets criteria that you specify. To do so, you create a secure application role, which is a role that is associated with a PL/SQL procedure (or PL/SQL package that contains multiple procedures). The procedure validates the user: if the user fails the validation, then the user cannot log in. If the user passes the validation, then the procedure grants the user a role so that he or she can use the application. The user has this role only as long as he or she is logged in to the application. When the user logs out, the role is revoked.

Incorrect:

Not B: REMOTE_OS_AUTHENT specifies whether remote clients will be authenticated with the value of the OS_AUTHENT_PREFIX parameter.

Not C, not E: 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. After the specified number of failure attempts, the connection will be automatically dropped by the server process. Not D: REMOTE_LOGIN_PASSWORDFILE specifies whether Oracle checks for a password file. Values:

shared

One or more databases can use the password file. The password file can contain SYS as well as non-SYS users.

exclusive

The password file can be used by only one database. The password file can contain SYS as well as non-SYS users.

none

Oracle ignores any password file. Therefore, privileged users must be authenticated by the operating system.

Note:

The REMOTE_OS_AUTHENT parameter is deprecated. It is retained for backward compatibility only.

Question No.17

Which two statements are true about the logical storage structure of an Oracle database? (Choose two.)

  1. An extent contains data blocks that are always physically contiguous on disk.

  2. An extent can span multiple segments.

  3. Each data block always corresponds to one operating system block.

  4. It is possible to have tablespaces of different block sizes.

  5. A data block is the smallest unit of I/O in data files.

Correct Answer: DE

Question No.18

Examine the memory-related parameters set in the SPFILE of an Oracle database:

image

Which statement is true?

  1. Only SGA components are sized automatically.

  2. Memory is dynamically re-allocated between the SGA and PGA as needed.

  3. The size of the PGA cannot grow automatically beyond 500 MB.

  4. The value of the MEMORY_TARGET parameter cannot be changed dynamically.

Correct Answer: B

Question No.19

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?

  1. Compare Period ADDM report

  2. AWR Compare Period report

  3. Active Session History (ASH) report

  4. Taking a new snapshot and comparing it with a preserved snapshot

Correct Answer: A

Question No.20

You executed this command to create a password file:

$ orapwd file = orapworcl entries = 10 ignorecase = N

Which two statements are true about the password file? (Choose two.)

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

  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 of mixed case passwords for the database users who have been granted the SYSDBA role.

Correct Answer: AD

Explanation:

You can create a password file using the password file creation utility, ORAPWD. Adding Users to a Password File

When you grant SYSDBA or SYSOPER 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}] IGNORECASE

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.

Get Full Version of the Exam
1z0-062 Dumps
1z0-062 VCE and PDF

Leave a Reply

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