[2021-New] Oracle 1Z0-062 Dumps With Update Exam Questions (41-50)

1Z0-062 Dumps

1Z0-062 Exam Questions - Online Test

1Z0-062 Premium VCE File

Learn More 100% Pass Guarantee - Dumps Verified - Instant Download
150 Lectures, 20 Hours

Q1. Which three statements are true about Oracle Data Pump export and import operations?

A. You can detach from a data pump export job and reattach later.

B. Data pump uses parallel execution server processes to implement parallel import.

C. Data pump import requires the import file to be in a directory owned by the oracle owner.

D. The master table is the last object to be exported by the data pump.

E. You can detach from a data pump import job and reattach later.

Answer: A,B,D

Explanation: B: Data Pump can employ multiple worker processes, running in parallel, to increase job performance.

D: For export jobs, the master table records the location of database objects within a dump file set. / Export builds and maintains the master table for the duration of the job. At the end of an export job, the content of the master table is written to a file in the dump file set. / For import jobs, the master table is loaded from the dump file set and is used to control the sequence of operations for locating objects that need to be imported into the target database.

Q2. You notice that the elapsed time for an important database scheduler Job is unacceptably long.

The job belongs to a scheduler job class and window.

Which two actions would reduce the job's elapsed time?

A. Increasing the priority of the job class to which the job belongs

B. Increasing the job's relative priority within the Job class to which it belongs

C. Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window

D. Moving the job to an existing higher priority scheduler window with the same schedule and duration

E. Increasing the value of the JOB_QUEUE_PROCESSES parameter

F. Increasing the priority of the scheduler window to which the job belongs

Answer: B,C

Explanation: B: Job priorities are used only to prioritize among jobs in the same class.

Note: Group jobs for prioritization Within the same job class, you can assign priority values of 1-5 to individual jobs so that if two jobs in the class are scheduled to start at the same time, the one with the higher priority takes precedence. This ensures that you do not have a less important job preventing the timely completion of a more important one.

C: Set resource allocation for member jobs Job classes provide the link between the Database Resource Manager and the Scheduler, because each job class can specify a resource consumer group as an attribute. Member jobs then belong to the specified consumer group and are assigned resources according to settings in the current resource plan.

Q3. In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.

How would you accomplish this?

A. Setting a metric threshold

B. Implementing Database Resource Manager

C. Enabling resumable timeout for user sessions

D. Decreasing the value of the IDLE_TIME resource limit in the default profile

Answer: D

Explanation: An Oracle session is sniped when you set the idle_time parameter to disconnect inactive sessions. (It's only like sniping on ebay in that a time is set for an action to occur.)

Oracle has several ways to disconnect inactive or idle sessions, both from within SQL*Plus via resources profiles (connect_time, idle_time), and with the SQL*net expire time parameter. Here are two ways to disconnect an idle session:

Set the idle_time parameter in the user profile Set the sqlnet.ora parameter expire_time

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

Resource Manager?

A. Maximum Undo per consumer group

B. Maximum Idle time

C. Parallel server limit

D. CPU

E. Exadata I/O

F. Local file system I/O

Answer: A,C,D

Q5. You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name.

Which statement is true?

A. The ORACLE_BASE base parameter is not set.

B. The installation is being performed by the root user.

C. The operating system group that is specified should have the root user as its member.

D. The operating system group that is specified must have permission to write to the inventory directory.

Answer: D

Explanation:

Note:

Providing a UNIX Group Name

If you are installing a product on a UNIX system, the Installer will also prompt you to provide the name of the group which should own the base directory.

You must choose a UNIX group name which will have permissions to update, install, and deinstall Oracle software. Members of this group must have write permissions to the base directory chosen.

Only users who belong to this group are able to install or deinstall software on this machine.

Q6. You execute the following piece of code with appropriate privileges:

User SCOTT has been granted the CREATE SESSION privilege and the MGR role.

Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?

A. Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.

B. Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.

C. Data is never redacted for the EMP_V.SAL column.

D. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.

E. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.

Answer: A,C

Explanation:

Note:

* DBMS_REDACT.FULL completely redacts the column data.

* DBMS_REDACT.NONE applies no redaction on the column data. Use this function for development testing purposes. LOB columns are not supported.

* The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables you to mask (redact) data that is returned from queries issued by low-privileged users or an application.

* If you create a view chain (that is, a view based on another view), then the Data Redaction policy also applies throughout this view chain. The policies remain in effect all of the way up through this view chain, but if another policy is created for one of these views, then for the columns affected in the subsequent views, this new policy takes precedence.

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

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

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

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

D. 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. This means 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 (you can load records based on the records' values).

/Use the operating system's file system to access the datafiles.

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

/ Generate sophisticated error reports, which greatly aid troubleshooting.

/ Load arbitrarily complex 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.

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

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

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

C. You can connect by using easy connect.

D. You can connect by using OS authentication.

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

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

Answer: C,D,E,F

Explanation:

* The choice 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.

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

CONNECT / ) when this initialization parameter is set to TRUE receive an ORA-01031"insufficient privileges" 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 the desired PDB. This can be done using:

ALTER SESSION SET CONTAINER=<PDB Name>

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

Q9. Identify two situations in which the alert log file is updated.

A. Running a query on a table returns ORA-600: Internal Error.

B. Inserting a value into a table returns ORA-01722: invalid number.

C. Creating a table returns ORA-00955: name us already in used by an existing objects.

D. Inserting a value into a table returns ORA-00001: unique constraint (SYS.OK_TECHP) violated.

E. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50) error.

Answer: A,E

Explanation: The alert log is a chronological log of messages and errors, and includes the following items:

*All internal errors (ORA-600), block corruption errors (ORA-1578), and deadlock errors (ORA-60) that occur

* Administrative operations, such as CREATE, ALTER, and DROP statements and STARTUP, SHUTDOWN, and ARCHIVELOG statements

* Messages and errors relating to the functions of shared server and dispatcher processes

* Errors occurring during the automatic refresh of a materialized view

* The values of all initialization parameters that had nondefault values at the time the database and instance start

Note:

* The alert log file (also referred to as the ALERT.LOG) is a chronological log of messages and errors written out by an Oracle Database. Typical messages found in this file is: database startup, shutdown, log switches, space errors, etc. This file should constantly be monitored to detect unexpected messages and corruptions.

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

memory_max_target—6G memory_target=5G pga_aggregate_target=500M sga_max_size=0 sga_target=0

Which statement is true?

A. Only SGA components are sized automatically-

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

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

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

Answer: C