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

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

Question No.181

Which three statements are true about Oracle Data Pump? (Choose three.)

  1. IMPDP can be used to change target data file names, schemas, and tablespaces during import.

  2. The DBMS_DATAPUMP PL/SQL package can be used independently of Data Pump clients to perform export and import operations.

  3. EXPDP and IMPDP are the client components of Oracle Data Pump.

  4. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

  5. IMPDP always use the conventional path insert method to import data.

Correct Answer: ABC

Explanation:

https://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_overview.htm#SUTIL2880

Question No.182

In your Oracle 12c database, you plan to execute the command:

SQLgt; CREATE TABLESPACE tbs1 DATAFILE `/u02/oracle/data/tbs01.dbf#39; SIZE 50M; The u02 file system has 1 GB of free space available.

What is the outcome?

  1. It creates a locally managed tablespace with manual segment space management enabled.

  2. It raises an error because extent management is not specified.

  3. It creates a locally managed tablespace with automatic segment space management enabled.

  4. It creates a dictionary-managed tablespace with manual segment space management enabled.

Correct Answer: C

Explanation:

https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces002.htm#ADMIN11359

Question No.183

You executed the following command to create a password file in the database server:

$ orapwd file = orapworcl entries = 5 ignorecase=N

Which statement describes the purpose of the above password file?

  1. It records usernames and passwords of users when granted the DBA role

  2. It contains usernames and passwords of users for whom auditing is enabled

  3. It is used by Oracle to authenticate users for remote database administrator

  4. It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating groups

Correct Answer: C

Question No.184

Examine the parameters for a database instance:

image

Your database has three undo tablespaces and the default undo tablespace is not autoextensible. Resumable space allocation is not enabled for any sessions in the database instance.

What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transactions?

  1. Transactions write their undo in the SYSTEM undo segment.

  2. Transactions fail.

  3. Transactions wait until space becomes available in UNDOTBS1.

  4. Transactions write their undo in a temporary tablespace.

Correct Answer: B

Explanation:

https://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm (undo retention)

Question No.185

Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database.

You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted.

What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?

  1. Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PDB.

  2. Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command.

  3. Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command.

  4. Take the USERDATA tablespace offline in ACCOUNTS_PDB.

Correct Answer: D

Explanation:

You can take an online tablespace offline so that it is temporarily unavailable for general use. The rest of the database remains open and available for users to access data. Conversely, you can bring an offline tablespace online to make the schema objects within the tablespace available to database users. The database must be open to alter the availability of a tablespace.

Question No.186

You perform RMAN backups for your database and use a recovery catalog for managing the backups. To free space, you execute this command:

RMANgt; DELETE OBSOLETE;

Which three statements are true is this scenario? (Choose three.)

  1. The backup sets marked as expired are deleted.

  2. The information related to the backups is removed from the recovery catalog and the control file.

  3. The physical files related to the backup need to be manually deleted.

  4. The physical files related to the backup are deleted automatically.

  5. The backups deleted are based on the backup retention policy.

Correct Answer: BDE

Question No.187

Your database is configured in ARCHIVELOG mode.

Examine the RMAN configuration parameters:

image

Examine the command:

RMANgt; BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

What is the outcome?

  1. It fails because the DELETE INPUT option can be used only with the BACKUP AS BACKUPSET command.

  2. It executes successfully and creates a backup set of the database along with archived log files and then deletes the original archived log files.

  3. It executes successfully and creates an image copy of the database along with archive log files and then deletes the original archived log files.

  4. It fails because the DELETE INPUT option can be used only with the BACKUP AS COPY command.

Correct Answer: B

Explanation:

https://docs.oracle.com/cd/B13789_01/server.101/b10734/rcmbackp.htm

Question No.188

You want to prevent a group of users in your database from performing long-running transactions that consume huge amounts of space in the undo tablespace. If the quota for these users is exceeded during execution of a data manipulation language (DML) statement, the operation should abort and return an error. However, queries should still be allowed, even if users have exceeded the undo space limitation. How would you achieve this?

  1. Specify the maximum amount of quota a user can be allocated in the undo tablespace.

  2. Decrease the number of Interested Transaction List (ITL) slots for the segments on which these users perform transactions.

  3. Implement a profile for these users.

  4. Implement a Database Resource Manager plan.

Correct Answer: D

Question No.189

You have successfully taken a database backup by using the command: RMANgt; BACKUP AS BACKUPSET DATABASE;

Now you execute this command:

RMANgt; BACKUP INCREMENTAL LEVEL 1 DATABASE;

What is the outcome?

  1. It fails because an incremental level 1 backup always searches for an image copy as level 0 backup.

  2. It fails because an incremental level 0 backup does not exist.

  3. It takes a backup of blocks that have been formatted since the last full database backup.

  4. It takes an incremental level 0 backup of the database.

  5. It first takes an incremental level 0 backup and then an incremental level 1 backup.

Correct Answer: E

Explanation:

https://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup004.htm (4.4.1.2)

Question No.190

The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user SCOTT opens a session and executes commands as follows:

SQLgt; INSERT INTO cust VALUES(101, #39;JACK#39;);

1 row created.

SQLgt; INSERT INTO cust VALUES(102, #39;SMITH#39;);

1 row created.

As a DBA, you execute the following command from another session: ALTER TABLESPACE sales READ ONLY;

Which statement is true regarding the effect of this command on the transaction in Scott#39;s session?

  1. The command fails as a transaction is still pending.

  2. The transaction in Scott#39;s session is rolled back and the tablespace becomes readonly.

  3. The command waits and the user SCOTT can execute data manipulation language (DML) statements only as part of the current transaction.

  4. The command hangs until all transactions on the objects in the tablespace commit or rollback, and then the tablespace is placed in readonly mode.

Correct Answer: B

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