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.
by using the connect statement as a local user having only the set container privilege
by using easy connect
by using external authentication
as a common user with the set container privilege
by executing the alter session set container command as a local user
Question No: 42
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)?
tracking the most recent read time for a table segment in a user tablespace
tracking the most recent write time for a table segment in a user tablespace
tracking insert time by row for table rows
tracking the most recent write time for each block in a table segment
tracking the most recent read time for a table segment in the sysauxtablespace
tracking the most recent write time for a table segment in the sysauxtablespace
Question No: 43
Users report this error message when inserting rows into the orders table:
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?
drop and re-create the index
coalesce the orders鈥瀒nd index
coalesce the indexes tablespace
perform an on line table rebuild using dbns_redefir.ition.
rebuild the index online moving it to anothertablespace that has enough free space for the index
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:
Create directory structures similar to the production database on all new machines.
Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.
Create a database clone template for the database.
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
Question No: 45
After implementing full Oracle Data Redaction, you change the default value for the number data type as follows:
SQLgt; SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE
SQLgt; EXEC DBMS_REDACT.UPDATE_FULL_REDACTI0N_VALUES(-1)
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?
Re-enable redaction policies that use FULL data redaction.
Re-create redaction policies that use FULL data redaction.
Re-connect the sessions that access objects with redaction policies defined on them.
Flush the shared pool.
Restart the database instance.
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?
Oracle Data Pump
Oracle Recovery Manager (RMAN)
Oracle Label Security
Oracle Database Vault
Oracle Real Application Security
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?
Enable temporary undo for the database.
Enable undo retention guarantee.
Increase the size of the redo log buffer.
Enable Automatic Memory Management (AMM).
Increase the size of the temporary tablespace.
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?
image copy backup by using RMAN
multisection image copy backup by using RMAN
multisection parallel backup by using RMAN
cold backup after taking the tablespace offline
cold backup after placing the tablespace in backup mode
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:
RKANgt; CONNECT CATALOG rci2c/passI2c@catdbi2c
RKANgt; IMPORT CATALOG rcii/pwdcatUQcatdfoil DBI2=142324i; What is the outcome of the import?
It fails because the target database and recovery catalog database are of different versions.
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.
It succeeds but the database is not automatically registered in the rc:2c catalog.
It fails because RMAN is not connected to the target database with r3:T=:42324:.
Question No: 50
Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?
Tables or table partitions can be recovered by using an auxiliary instance only.
Tables or table partitions with a foreign key cannot be recovered.
Tables or table partitions can be recovered only when the database is in mount state.
Tables or table partitions from the system and sysauxtablespaces cannot be recovered.
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% Ensurepass Free Download!
–Download Free Demo:1z0-063 Demo PDF
100% Ensurepass Free Guaranteed!
–Download 2018 EnsurePass 1z0-063 Full Exam PDF and VCE
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|