Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP
Question No: 51
You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization.
Which two backup solutions can be used?
RMAN recovery catalog
RMAN Media Management Library
Enterprise Manager Cloud Control
Enterprise Manager Database Express
Oracle Secure Backup
Question No: 52
Examine the following set of RMAN commands:
RKANgt; CONFIGURE CHANNEL del DEVICE TYPE DISK FORMAT #39; /u02/backup/%U#39; ; RKANgt; RUN
ALLOCATE CHANNEL chl DEVICE TYPE DISK;
EXECUTE SCRIPT arc_backup;
Which statement is true about the RMAN run block execution?
The script is executed and both DC1 and chi channels are used for script execution.
The execution of the script fails because multiple channels cannot exist simultaneously.
The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN run block.
The new channel, chi, is ignored because a channel has been configured already.
Question No: 53
Which two statements are true about service creation for pluggable databases (PDBs)?
When a PDB is created, a service is automatically started in the instance with the same name as the PDB.
The defaultservice that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.
A database managed by Oracle Restart can have additional services created or existing services modified by usingthe srvctl utility for each PDB.
Only a common user can create additional services for a PDB.
When a PDB is created, a service with the same name as the PDB is created in the PDB.
Question No: 54
You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your UNIX-based Oracle 12c database:
ALTER SYSTEMSETTHREADED EXECUTION= TRUESCOPE=SPFILE; SHUTDOWNIMMEDIATE
You then restart the instance and get an error: STARTUP
Why does the startup command return the error shown?
because the threaded architecture requires exiting from sql*pIus and reconnectingwith sql*PIus / as sysdba before issuing a startup command
because the threaded architecture requires issuing a new connect / as sysdba from within sql*pIus before issuing a startup command
because the threaded architecture requires authentication using a password file before issuing a startup command
because the threaded architecture requires connecting to the instance via a listener before issuing a startup command
because the threaded architecture requires restarting the listener before issuing astartup command
Question No: 55
Examine the commands executed in CDBS ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB):
SQLgt; CREATE ROLE c ##role1 CONTAINER-ALL;
SQLgt; GRANT CREATE SESSION, CREATE TABLE TO c##role1 CONTAINER#39;ALL; SQLgt;CREATE USER c##adnin IDENTIFIED BY orcl123;
SQLgt;GRANT c##role1 TO c##admin CONTAINER=ALL;
SQLgt; GRANT SELECT ON DBA_USERS to c##rola1 CONTAINER*ALL;
Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1role?
The command fails and gives an error because object privileges cannot be granted to a common user.
The command fails because container is not set to current.
The command succeeds and the common user cmadnxn can create a session and query the D3A_users view incdbssoo? and all the PDBs.
The command succeeds and the common user ct (admin can create a session in cdbSroot and all the PDBs, but can only query the dba_users view in ct3S?cdt.
The command succeeds and the common user c#(admin can create a session and query the D3A users view only in cdbsrooi.
Question No: 56
Your database is running in archivelog mode. Examine the initialization parameters you plan to set for yourdatabase instance.
LOG_ARCHIVE_DEST_1 = #39;LOCATION=/disk1/arch#39; LOG_ARCHIVE_DEST_2 = #39;L0CATI0N=/disk2/3rch#39;
LOG_ARCHIVE_DEST_3 = #39;LOCATION=/disk3/arch#39; L0G_ARCHIVE_DEST_4 = #39;L0CATI0N=/disk4/3rch MANDATORY#39;
Identify the statement that correctly describes these settings.
An online redo log file is not allowed to be overwritten if the archived log file cannot be created in any of the log_archive_dest_.n destinations.
Optional destinations cannot use the fast recovery area.
An online redo log file isnot allowed to be overwritten if the archived log file cannot be created in the location specified for log_archive_dest_4.
These settings work only if log archive_min_succeed_dest is set to a value of 4.
Question No: 57
Because of logical corruption of data in a table, you want to recover the tablefrom an RMAN backup to a specified point in time.
Examine the steps to recover this table from an RMAN backup: 1.Determine which backup contains the table that needs to be recovered.
Issue the recover table RMAN command with an auxiliary destination defined and the point in time specified.
Import the Data Pump export dump file into the auxiliary instance.
Create a Data Pump export dump file that contains the recovered table on a target database.
Identify the required steps in the correct order.
A. 1, 4, 3
B. 1, 2
C. 1, 4, 3, 2
D. 1, 2, 4
Question No: 58
Which two statements are true abouta multitenant architecture?
Each pluggable database (PDB) has its own initialization parameter file.
A PDB can have a private undo tablespace.
Log switches occur only at the container database level.
A PDB can have a private temporary tablespace.
Each PDB has a private control file.
Question No: 59
Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?
A DBA can check specific tables with the DMU
The database to be migrated must be opened read-only.
The release of the database to be converted can be any release since 126.96.36.199.
The DMU can report columns that are too long in the converted characterset
The DMU can report columns that are not represented in the converted characterset
Explanation: A: In certain situations, you may want to exclude selected columns or tables from scanning or conversion steps ofthe migration process.
D: Exceed column limit
The cell data will not fit into a column after conversion.
E: Need conversion
The cell data needs to be converted, because its binary representation in the target character set is different than the representation in the current character set, but neither length limit issues nor invalid representation issues have been found.
Question No: 60
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
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|