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

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

Question No.221

Your database is running in ARCHIVELOG mode. You want to take a consistent whole database backup. Which two statements are true in this scenario? (Choose two.)

  1. The user-managed backup consists of only formatted data blocks.

  2. The database must be shut down to take a user-managed backup.

  3. The RMAN backup contains only data files.

  4. The RMAN backup can be performed while the database is open.

  5. The database must be in MOUNT state to take RMAN backup.

Correct Answer: AB

Question No.222

You want to create a file watcher and an event-based job for detecting the arrival of files on the local server from various locations. To achieve this, you enable the raising of file arrival events from remote systems. Which two conditions must be satisfied to receive file arrival events from a remote system? (Choose two.)

  1. The remote system must have a running Oracle Database instance and a scheduler agent installed.

  2. The initialization parameter REMOTE_OS_AUTHENT must be set to TRUE on your database.

  3. The local database must be set up to run remote external jobs.

  4. The remote system#39;s scheduler agent must be registered with your database.

  5. Database links to remote databases must be created.

Correct Answer: CD

Explanation:

https://docs.oracle.com/cd/E18283_01/server.112/e17120/scheduse005.htm

Question No.223

You are using RMAN to back up your database. All the data files are in read/write mode. Examine the RMAN configuration parameters:

image

Which two statements are true about a whole consistent backup of a database running in ARCHIVELOG mode? (Choose two.)

  1. The backup can be used as an incremental level 0 backup.

  2. The database instance must be shut down to take the backup.

  3. The database must be in MOUNT state to take the backup.

  4. The backup consists of blocks that have been formatted.

  5. The system Change Number (SCN) is the same for all the data files in the backup.

Correct Answer: BE

Question No.224

Examine the details of the uncompressed, non-partitioned heap table CITIES.

image

Examine the command:

SQLgt; ALTER TABLE cities SHRINK SPACE COMPACT;

What must you do before executing it?

  1. Ensure free space that is approximately equal to the space used by the table should be available.

  2. Ensure there are no pending transactions on the table.

  3. Enable row movement is enabled.

  4. Disable all indexes on the table.

Correct Answer: C

Question No.225

Which two tools can be used to configure static service information in the listener.ora file? (Choose two.)

  1. Oracle Net Manager

  2. Oracle Enterprise Manager Cloud Control

  3. Oracle Net Configuration Assistant

  4. Listener Control Utility (LSNRCTL)

  5. Oracle Enterprise Manager Database Express

Correct Answer: AB

Question No.226

Which three statements are true about the Pre-Upgrade Information Tool? (Choose three.)

  1. It clears all user recycle bins in a database and releases their storage space.

  2. It writes a list of invalid SYS and SYSTEM object to the registry$sys_inv_objs table.

  3. It evaluates the dependencies of network utility packages.

  4. It identifies any deprecated and unsupported parameters.

  5. It generates fix-up scripts and automatically runs them to resolve issues that are flagged in the source database.

Correct Answer: BCD

Question No.227

The schema SALES exists in two databases, ORCL1 and ORCL2, and has the same password, SALES123.

User SALES has CREATE DATABASE LINK and CREATE SESSION privileges on both databases.

Examine these commands: Conn SALES/SALES123

CREATE DATABASE LINK orcl2 USING #39;orcl2#39;;

What is the outcome of executing these commands in the ORCL1 database?

  1. ORCL2 is created as a public database link to connect a single session to the SALES schema in the ORCL2 database.

  2. ORCL2 is created as a shared database link to connect multiple sessions to the SALES schema in the ORCL2 database.

  3. ORCL2 is created as a private database link to connect to only the SALES schema in the ORCL2 database.

  4. ORCL2 database link creation fails.

Correct Answer: C

Question No.228

Your database is configured in ARCHIVELOG mode, and a daily full database backup is taken by using RMAN. Control file autobackup is configured. Loss of which three database files can lead to an incomplete recovery? (Choose three.)

  1. inactive online redo log file group

  2. a data file belonging to the default temporary tablespace

  3. a data file belonging to the SYSAUX tablespace

  4. server parameter le (SPFILE)

  5. active online redo log le group

  6. all the control flies

Correct Answer: AEF

Question No.229

In your Oracle 12c database, you invoke SQL *Loader Express Mode command to load data:

$gt; sqlldr hr/hr table=employees

Which two statements are true about this command? (Choose two.)

  1. It succeeds and creates the EMPLOYEES table in the HR schema if the table does not exist.

  2. It fails because the SQL *Loader control file location is not specified.

  3. It fails because the SQL *Loader data file location is not specified.

  4. It succeeds with default settings if the EMPLOYEES table belonging to the HR schema is already defined in the database.

  5. It succeeds even if the HR user does not have the CREATE DIRECTORY privilege.

Correct Answer: DE

Question No.230

Which task is performed by a background process in a database instance?

  1. Connecting between a client process and a dispatcher

  2. Executing PL/SQL code

  3. Creating dedicated server connections

  4. Copying online redo log files to offline storage

Correct Answer: D

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