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

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

Question No.191

You plan to implement the distributed database system in your company. You invoke Database Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts you to specify the Global Database Name. What must this name be made up of?

  1. It must be made up of a database name and a domain name.

  2. It must be made up of the value in ORACLE_SID and HOSTNAME.

  3. It must be made up of the value that you plan to assign for INSTANCE_NAME and HOSTNAME.

  4. It must be made up of the value that you plan to assign for ORACLE_SID and SERVICE_NAMES.

Correct Answer: A

Explanation:

Using the DBCA to Create a Database (continued)

  1. Database Identification: Enter the Global Database Name in The form database_name.domain_name, and the system identifier (SID). The SID defaults lo the database name and uniquely identifies the instance associated with the database.

  2. Management Options: Use this page to set up your database so that it can be managed with Oracle Enterprise Manager. Select the default: quot;Configure the Database with Enterprise Manager.quot; Optionally, this page allows you to configure alert notifications and daily disk backup area settings.

Note:

Yon must configure the listener before you can configure Enterprise Manager (as shown earlier).

Question No.192

Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

  1. The ADDM requires at least four AWR snapshots for analysis

  2. The ADDM runs after each AWR snapshot is collected automatically by MMON

  3. The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)

  4. The ADDM analysis provides only diagnostics information but does not provide recommendations

  5. The ADDM calls other advisors if required, but does not provide recommendations about the advisors

Correct Answer: BC

Question No.193

Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?

  1. execution of SQL statements by users connected with the SYSDBA privilege

  2. creation of a fine-grained audit policy

  3. configuration of unified auditing mode

  4. usage of the AUDIT statement

Correct Answer: A

Explanation:

https://docs.oracle.com/cd/B28359_01/network.111/b28531/auditing.htm#DBSEG0622

Question No.194

Your database instance is started by using a server parameter file (SPFILE). You execute the following command to change the value of the LOG_BUFFER initialization parameter:

ALTER SYSTEM SET LOG_BUFFER=32 M;

What is the outcome of this command?

  1. The parameter value is changed and it comes into effect as soon as space becomes available in the SGA.

  2. It returns an error because the value of this parameter cannot be changed dynamically.

  3. The parameter value is changed and it comes into effect at the next instance startup.

  4. It returns an error because SCOPE should be set to MEMORY.

Correct Answer: B

Question No.195

Which three statements are true about space usage alerts? (Choose three.)

  1. Alerts are issued only when the critical threshold for space available in a tablespace is breached.

  2. The sum of active extents and allocated user quotas is considered to compute space usage for an undo tablespace.

  3. Database alerts can provide warnings about low space availability at both tablespace and segment levels.

  4. Alerts are not issued for locally managed tablespaces that are offline or in read-only mode.

  5. A newly created locally managed tablespace is automatically assigned the default threshold values defined for a database.

Correct Answer: ADE

Explanation:

https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema001.htm#ADMIN10120

Question No.196

You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the following sequence statements:

image

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

Correct Answer: C

Question No.197

Which two statements are true when row archival management is enabled? (Choose two.)

  1. The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.

  2. The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.

  3. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.

  4. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.

  5. The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.

Correct Answer: CD

Question No.198

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

image

You plan to execute the commands:

image

Which two statements are true? (Choose two.)

  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. The MYTAB 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. The MYTAB table is owned by the SYS user.

Correct Answer: BE

Question No.199

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

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

Correct Answer: ACD

Question No.200

Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle Database Resource Manager? (Choose three.)

  1. Maximum Undo per consumer group

  2. Maximum Idle time

  3. Parallel server limit

  4. CPU

  5. Exadata I/O

  6. Local file system I/O

Correct Answer: CDE

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