[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-063 Dumps with VCE and PDF 41-50

2018 Jan Oracle Official New Released 1z0-063
100% Free Download! 100% Pass Guaranteed!

Oracle Database 12c: Advanced Administration

Question No: 41

You are administering a multitenant container database (CDB).

Identify two ways to access a pluggable database (PDB) that is open in read-only mode.

  1. by using the connect statement as a local user having only the set container privilege

  2. by using easy connect

  3. by using external authentication

  4. as a common user with the set container privilege

  5. by executing the alter session set container command as a local user

Answer: A,D

Question No: 42

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)?

  1. tracking the most recent read time for a table segment in a user tablespace

  2. tracking the most recent write time for a table segment in a user tablespace

  3. tracking insert time by row for table rows

  4. tracking the most recent write time for each block in a table segment

  5. tracking the most recent read time for a table segment in the sysauxtablespace

  6. tracking the most recent write time for a table segment in the sysauxtablespace

Answer: A,B,D

Question No: 43

Users report this error message when inserting rows into the orders table:

ERROR atline1:

ORA-01654f:unable to extend index USERS.ORDERS_IND by 8in tablespace INDEXES

You determine that the indexes tablespace is out of space and there is no free space on the filesystem used by the Oracle database.

Which two must you do to fix this problem without affecting currently executing queries?

  1. drop and re-create the index

  2. coalesce the orders鈥瀒nd index

  3. coalesce the indexes tablespace

  4. perform an on line table rebuild using dbns_redefir.ition.

  5. rebuild the index online moving it to anothertablespace that has enough free space for the index

Answer: A,C

Question No: 44

You have a production Oracle 12c database running on a host.

You want toinstall and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database.

The steps in random order:

  1. Create directory structures similar to the production database on all new machines.

  2. Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.

  3. Create a database clone template for the database.

  4. Run the Database Configuration Assistant (DBCA) to create the database. 5.Run OUI in graphical mode on each machine.

6.Run OUI in silent mode using the OUI response file.

Identify the required steps in the correct sequence to achieve the requirementwith minimal human intervention.

A. 2, 1, 6, and 4

B. 2, 3, and 6 C. 3, 1, 5, and 6 D. 2, 3, 1, and 6

E. 1, 5, and 4

Answer: D

Question No: 45

After implementing full Oracle Data Redaction, you change the default value for the number data type as follows:


————- 0


PL/SQL procedure successfully completed.

SQLgt; select number_value from redaction_values_for_type_full; NUMBER VALUE



After changing the value, you notice that FULL redaction continues to redact numeric data with a zero.

What must you do to activate the new default value for numeric full redaction?

  1. Re-enable redaction policies that use FULL data redaction.

  2. Re-create redaction policies that use FULL data redaction.

  3. Re-connect the sessions that access objects with redaction policies defined on them.

  4. Flush the shared pool.

  5. Restart the database instance.

Answer: E

Explanation: About Altering the Default Full Data Redaction Value

You can alter the default displayed values for full Data Redaction polices. By default, 0 is the redacted value when Oracle Database performs full redaction (DBMS_REDACT.FULL) on a column of the NUMBER data type. If you want to change it to another value (for example, 7), then you can run the DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure to modify this value. The modification applies to all of the Data Redaction policies in the current database instance. After you modify a value, you must restart the database for it to take effect.

Question No: 46

Which Oracle Database component is audited by default if the Unified Auditing option is enabled?

  1. Oracle Data Pump

  2. Oracle Recovery Manager (RMAN)

  3. Oracle Label Security

  4. Oracle Database Vault

  5. Oracle Real Application Security

Answer: B

Question No: 47

Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it.

This consumes a lot of undo tablespace and is affecting undo retention. Which two actions would you take to solve this problem?

  1. Enable temporary undo for the database.

  2. Enable undo retention guarantee.

  3. Increase the size of the redo log buffer.

  4. Enable Automatic Memory Management (AMM).

  5. Increase the size of the temporary tablespace.

Answer: D,E

Question No: 48

A database is running in archivelog mode. You want to back up a 10 TB data file belonging to the users tablespace. The backup of the data file is too slow.

What type of backup do you recommend to improve the performance of the backup?

  1. image copy backup by using RMAN

  2. multisection image copy backup by using RMAN

  3. multisection parallel backup by using RMAN

  4. cold backup after taking the tablespace offline

  5. cold backup after placing the tablespace in backup mode

Answer: A

Question No: 49

The CATDB12C database contains an Oracle Database 12c catalog schema owned by the rci2c user.

The CATD3H database contains an Oracle Database Ug catalog schema owned by the rch user.

A database with dbid=H2324I is registered in the catdbII catalog. Both the recovery catalog databases are open.

In the CATD3i2c database, you execute the commands:

: r-ar.

RKANgt; CONNECT CATALOG rci2c/passI2c@catdbi2c

RKANgt; IMPORT CATALOG rcii/pwdcatUQcatdfoil DBI2=142324i; What is the outcome of the import?

  1. It fails because the target database and recovery catalog database are of different versions.

  2. It succeeds and all global scripts in the rci: catalog that have the same name as existing global scripts in the RCI2C catalog are automatically renamed.

  3. It succeeds but the database is not automatically registered in the rc:2c catalog.

  4. It fails because RMAN is not connected to the target database with r3:T=:42324:.

Answer: B

Question No: 50

Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?

  1. Tables or table partitions can be recovered by using an auxiliary instance only.

  2. Tables or table partitions with a foreign key cannot be recovered.

  3. Tables or table partitions can be recovered only when the database is in mount state.

  4. Tables or table partitions from the system and sysauxtablespaces cannot be recovered.

  5. Tables with not null constraints cannot be recovered.

Answer: A,D Reference:http://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV695(Limitat ions of Recovering Tablesand Table Partitions from RMAN Backups)

100% Free Download!
Download Free Demo:1z0-063 Demo PDF
100% Pass Guaranteed!
Download 2018 EnsurePass 1z0-063 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 EnsurePass IT Certification PDF and VCE

Leave a Comment


Your email address will not be published. Required fields are marked *