QUESTION 91 Which three statements are true about unplugging a pluggable database (PDB)?
A. The PDB must be open in read only mode.
B. The PDB must be dosed.
C. The unplugged PDB becomes a non-CDB.
D. The unplugged PDB can be plugged into the same multitenant container database (CDB)
E. The unplugged PDB can be plugged into another CDB.
F. The PDB data files are automatically removed from disk.
QUESTION 92 You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as the sys user. You execute the commands: SQL> CREATE USER C##ADMIN IDENTIFIED BY orcll23; SQL> CREATE ROLE C##CONNECT; SQL> GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT; SQL> GRANT C##CONNECT to C##ADMIN CONTAINER=ALL; Which statement is true about the c##connect role?
A. It is created only in cdb$root and cannot be granted to the c##admin user with the container=all clause.
B. It is granted to the c##admin user only in the CDB.
C. It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB.
D. It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a PDB.
Examine the RMAN command: RMAN> BACKUP VALIDATE DATABASE; Which statement is true about the execution of the command?
A. Block change tracking must be enabled before executing this command.
B. The database must be running in archivelog mode for the successful execution of this command.
C. A complete database backup must exist before executing this command.
D. The command checks for blocks containing all zeros, an invalid checksum, or a corrupt block header.
E. The command checks for blocks that contain a valid checksum and matching headers and footers, but that has logically inconsistent contents.
QUESTION 94 Which three conditions must be met before you create a Virtual Private Catalog (VPC)?
A. A base recovery catalog should exist.
B. The owner of VPC cannot own recovery catalog.
C. At least one target database should be registered in the recovery catalog.
D. The register database privilege should be granted to the virtual catalog owner.
E. The recovery_catalog_owner role should be granted to the virtual catalog owner.
QUESTION 95 In your database, there are tablespaces that were read-only when the last backup was taken. These tablespaces have not been made read/write since then. You want to perform an incomplete recovery on the database by using a backup control file. What precaution must you take for the read-only tablespaces before performing an incomplete recovery?
A. All the read-only tablespaces should be taken offline.
B. All the read-only tablespaces should be restored separately.
C. All the read-only tablespaces should be renamed to have the MISSINGnnnn format.
D. All the read-only tablespaces should be made online with logging disabled.
QUESTION 96 Examine the RMAN commands executed in your database: RMAN>CONFIGUREDEFAULT DEVICE TYPE TO disk; RMAN>CONFIGURE DEVICETYPE DISK BACKUP TYPE TO BACKUPSET; RKAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; You issue the command: RMAN> BACKUP DATABASE; Which two statements are true about the command?
A. It performs a log switch.
B. It creates compressed backup sets by using binary compression by default.
C. It backs up only the used blocks in data files.
D. It backs up data files, the control file, and the server parameter file.
E. It creates a backup of only the control file whenever the database undergoes a structural change.
QUESTION 97 Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?
A. The PDB is closed and the temp file is re-created automatically when the PDB is opened.
B. The PDB is closed and requires media recovery at the PDB level.
C. The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.
D. The PDB does not close and starts by using the default temporary tablespace defined for the CD
QUESTION 98 You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases: $ . oraenv ORACLE-_SID = [oracle] ? cdb1 The oraclebasefor ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 is /u01/app/oracle $ rman target / Recovery Manager : Release 12.1.0.0.2 - production on Fri Ju1 19 05:18:33: 2013 Coppyright (c) 1982, 2013, oracle and/or its affiliates. All rights reserved. Connected to target database:CDB1 (DBID=782249327) RMAN>SELECT name FROMv$tablespace; Which statement is true about the execution of the last command?
A. It succeeds and displays all the tablespaces that belong to the root database.
B. It fails and returns an error because a connection is not made by using the sysdba privilege.
C. It succeeds and displays all the tablespaces that belong to the root and pluggable databases.
D. It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.
QUESTION 99 Which Oracle Database component is audited by default if the Unified Auditing option is enabled?
A. Oracle Data Pump
B. Oracle Recovery Manager (RMAN)
C. Oracle Label Security
D. Oracle Database Vault
E. Oracle Real Application Security
QUESTION 100 Which two statements are true about tablespaces in multitenant container databases (CDBs)?
A. Default permanent tablespaces can be shared across pluggable databases (PDBs).
B. The current container must be set to root to create or modify the default temporary tablespace or tablespace group for a CDB.
C. Each PDB can have its own default temporary tablespace
D. The default permanent tablespace for a PDB can be changed only by a local user with the required permissions.
E. The amount of space that each PDB can use in a shared temporary tablespace must be set at the CDB level.
QUESTION 101 When is the UNDO_RETENTION parameter value ignored by a transaction?
A. when the data file of the undo tablespace is autoextensible
B. when there are multiple undotablespaces available in a database
C. when the undo tablespace is of a fixed size and retention guarantee is not enabled
D. when Flashback Database is enabled
QUESTION 102 Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)?
A. Database Resident Connection Pooling
B. Oracle Suggested Backup Strategy
C. Database Vault in ORACLE_HOME
D. Nondefaultblocksizetablespaces
E. Configure Label Security
QUESTION 103 You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default format of which two data types would be affected by this setting?
A. DATE
B. TIMESTAMP
C. INTERVAL YEAR TO MONTH
D. INTERVAL DAY TO SECOND
E. TIMESTAMP WITH LOCAL TIME ZONE
QUESTION 104 Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?
A. By default, EM express is available for a database after database creation.
B. You can use EM express to manage multiple databases running on the same server.
C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
D. You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.
E. You can create and configure pluggable databases by using EM express.
QUESTION 105 You issue the RMAN commands: RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk; RKAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY; RMAN>CONFIGURE CONTROLFILE AUTOBACKUP ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT; Which three tasks are performed by the BACKUP DATABASE command?
A. switching the online redo log file
B. backing up all data files as image copies and archive log files, and deleting those archive log files
C. backing up only the used blocks in the data files
D. backing up all used and unused blocks in the data files
E. backing up all archived log files and marking them as obsolete
QUESTION 106 As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database. Which step should you perform next to start the upgrade of the database?
A. Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files during the upgrade.
B. Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time
C. Start up the database instance by using the STARTUP UPGRADEcommand and gather fixed object statistics to minimize the time needed for recompilation.
D. Start up the database instance by using the STARTUPUPGRADEcommand, which opens the existing database, and then performs additional upgrade operations.
QUESTION 107 Examine the command to duplicate a database: RMAN> DUPLICATE TARGET DATABASE TO cdb PLUGGABLE DATABASE pdb1, pdb5; Which two statements are true about the DUPLICATE command?
A. The SPFILE is copied along with the data files of the pluggable databases (PDBs). The root and the seed database in the container database (CDB) are also duplicated.
B. A backup of pdbi and pd35 must exist before executing the command
C. The duplicate command first creates a backup, and then duplicates the PDBs by using the
D. backup.
E. An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.
QUESTION 108 Which two statements are true about scheduling operations in a pluggable database (PDB)?
A. Scheduler jobs for a PDB can be defined only at the container database (CDB) level.
B. A job defined in a PDB runs only if that PDB is open. C
C. Scheduler attribute setting is performed only at the CDB level.
D. Scheduler objects created by users can be exported or imported using Data Pump.
E. Scheduler jobs for a PDB can be created only by common users.
QUESTION 109 A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance?
A. Set the backup_tape_io_slaves parameter to true.
B. Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.
C. Configure large pool if not already done.
D. Remove the rate parameter, if specified, in the allocate channel command
E. Always use RMAN compression for tape backups rather than the compression provided by media manager
F. Always use synchronous I/O for the database
QUESTION 110 For which three pieces of information can you use the RMAN list command?
A. stored scripts in the recovery catalog
B. available archived redo log files
C. backup sets and image copies that are obsolete
D. backups of tablespaces
E. backups that are marked obsolete according to the current retention policy
QUESTION 111 You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference. Which method or feature should you use?
A. Database Replay
B. Automatic Database Diagnostic Monitor (ADDM) Compare Period report
C. Active Session History (ASH) report
D. SQL Performance Analyzer
QUESTION 112 Which three statements are true about a job chain?
A. It can contain a nested chain of jobs.
B. It can be used to implement dependency-based scheduling.
C. It cannot invoke the same program or nested chain in multiple steps in the chain.
D. It cannot have more than one dependency.
E. It can be executed using event-based or time-based schedules.
QUESTION 113 Because of logical corruption of data in a table, you want to recover the table from 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. 2.Issue the recover table RMAN command with an auxiliary destination defined and the point in time specified. 3.Import the Data Pump export dump file into the auxiliary instance. 4.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 114 Examine the command: SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL; In which two scenarios is this command required?
A. The current online redo log file is missing.
B. A data file belonging to a noncritical tablespace is missing.
C. All the control files are missing
D. The database backup is older than the control file backup.
E. All the data files are missing.
QUESTION 115 Which two are prerequisites for setting up Flashback Data Archive?
A. Fast Recovery Area should be defined.
B. Undo retention guarantee should be enabled.
C. Supplemental logging should be enabled
D. Automatic Undo Management should be enabled
E. All users using Flashback Data Archive should have unlimited quota on the Flashback Data Archive tablespace.
F. The tablespace in which the Flashback Data Archive is created should have Automatic Segment Space Management (ASSM) enabled
QUESTION 116 The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set to /u01/app/oracle/product/12.1.0/db 1. You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Examine the initialization parameters set in your database. NAMETYPEVALUE -------------------------------------------- ------------------- ------ audit_file_deststring/u01/app/oracle/admin/eml2rep/adump background_dump_deststring core_dump_deststring db_create_file_deststring db_recovery_file_deststring/u01/app/oracle/fast_recovery_area diagnostic_deststring What is the location of the ADR base?
A. It is set to/u01/app/oracle/product:/12.1.0/db_1/log.
B. It is set to /u01/app/oracle/admin/enl2r&p/adump.
C. It is set to /u01/app/oracle
D. It is setto /u01/app/oracle/flash_recovery_area.
QUESTION 117 You want to export the pluggable database (PDB) hr pdb1 from the multitenant container database (CDB)CDB1 and import it into the cdb2 CDB as the emp_pdb1 PDB. Examine the list of possible steps required to perform the task: 1.Create a PDB named emp_pdb1. 2.Export the hr_pdb1 PDB by using the full clause. 3.Open the emp_pdb1 PDB. 4.Mount the emp_pdb1 PDB. 5.Synchronize the emp_pdb1 PDB in restricted mode. 6.Copy the dump file to the Data Pump directory. 7.Create a Data Pump directory in the emp_pdb1 PDB 8.Import data into emp_pdb1 with the full and remap clauses. 9.Create the same tablespaces in emp_pdb1 as in hr_pdb1 for new local user objects. Identify the required steps in the correct order.
A. 2, 1, 3, 7, 6, and 8
B. 2, 1, 4, 5, 3, 7, 6, 9, and 8
C. 2, 1, 3, 7, 6, 9, and 8
D. 2, 1, 3, 5, 7, 6, and 8
QUESTION 118 You wish to create jobs to satisfy these requirements: 1. Automatically bulk load data from a flat file. 2. Rebuild indexes on the SALES table after completion of the bulk load. How would you create these jobs?
A. Create both jobs by using Scheduler raised events
B. Create both jobs using application raised events.
C. Create one job to rebuild indexes using application raised events and another job to perform bulk load using Scheduler raised events
D. Create one job to rebuild indexes using Scheduler raised events and another job to perform bulk load by using events raised by the application.
QUESTION 119 Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). In the PDB hr_pdb, the common user c##admin and the local user b_admin have only the connect privilege. You create a common role c##role1 with the create table and select any table privileges. You then execute the commands: SQL> GRANTc##role1 TOcMadmin CONTAINER=ALL; SQL> CONNsys/oracle@HR_PDB assysdba SQL> GRANTc##role1TO b_admin CONTAINER=CURRENT; Which two statements are true?
A. C##admin can create and select any table, and grant the c##role1 role to users only in the root container.
B. B_admin can create and select any table in both the root container and kr_pdb.
C. c##admin can create and select any table in the root container and all the PDBs
D. B_admin can create and select any table only in hr_pdb.
E. The grant c=>role1 to b_admin command returns an error because container should be set to ALL.
QUESTION 120 Examine the commands executed in the root container of your multitenant container database (CDB) that has multiple pluggable databases (PDBs): SQL> CREATE USER c##a_admin IDENTIFIED BY orcl123; SQL> CREATE ROLE c##role1 CONTAINER=ALL; SQL> GRANT CREATE VIEW TO C##roleI CONTAINER=ALL; SQL> GRANT c##role1 TO c##a_admin CONTAINER=ALL; SQL> REVOKE c##role1 FROM c##a_admin; What is the result of the revoke command?
A. It executes successfully and the c##role1 role is revoked from the c##a_admin user only in the root container.
B. It fails and reports an error because the container=all clause is not used.
C. It executes successfully and the c##rocl1role is revoked from the c##a_adminuser in the root database and all the PDBs.
D. It fails and reports an error because the comtainer=currentclause is not used.
