Which statement is true about the execution of the last command?

You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:$ . oraenvORACLE_SID = [oracle] ? cdb1The oracle base for 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: 2013Coppyright (c) 1982, 2013, oracle and/or its affiliates. All rights reserved.Connected to target database:CDB1 … Read more

Which method or feature should you use?

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.Which method or feature should you use?Comparing Current System Performance to a Baseline Period You may have noticed a performance change on a production system and would like to know why, or you may have … Read more

Which statement is true about the execution of the command?

Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the command to create a common user:SQL> CREATE USER c##a_adminIDENTIFIED BY passwordDEFAULT TABLESPACE usersQUOTA I00M ON usersTEMPORARY TABLESPACE temp;Which statement is true about the execution of the command?When creating a common user, any tablespace, tablespace group or profile specified in the CREATE command … Read more

Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:

Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:1. Create a policy to capture the privileges used by a user for privilege analysis.2. Generate a report with the data captured for a specified privilege capture.3. Start analyzing the data captured by the policy.4. Revoke the unused privileges.5. … Read more

Which two statements are true regarding SecureFile lobs?

Which two statements are true regarding SecureFile lobs?References: http://docs.oracle.com/cd/E11882_01/appdev.112/e18294/adlob_smart.htm#ADLOB46 Question: Which two statements are true regarding SecureFile lobs? Options: The amount of undo retained is user controlled. They can be used only for nonpartitioned tables. Fragmentation is minimized by using variable-sized chunks. They support random reads and writes of encrypted LOB data. Correct Answer The … Read more

Which is the default permanent tablespace for all users except DBSNMP and OUTLN?

You created a database with DBCA by using one of the Oracle supplied templates.Which is the default permanent tablespace for all users except DBSNMP and OUTLN?This table space is used to store permanent user objects and data. Like the TEMP table space, every database should have a table space for permanent user data that is … Read more

Which statement is true about the command?

Examine the RMAN command:RMAN> RUN {ALLOCATE CHANNEL c1 DEVICE TYPE sbt;ALLOCATE CHANNEL c2 DEVICE TYPE sbt;ALLOCATE CHANNEL c3 DEVICE TYPE sbt;BACKUPINCREMENTAL LEVEL = 0(DATAFILE 1, 4, 5 CHANNEL c1)(DATAFILE 2, 3, 9 CHANNEL c2)(DATAFILE 6, 7, 8 CHANNEL c3)SQL ‘ALTER SYSTEM ARCHIVE LOG CURRENT’; }Which statement is true about the command? Choose the best answer. … Read more

Which situation can you use Flashback Database?

In which situation can you use Flashback Database?TO BEFORE RESETLOGS Returns the database to its state including all changes up to the SCN of the most recent OPEN RESETLOGS. Note:FLASHBACK DATABASE can only return the database to a point before the most recent OPEN RESETLOGS operation if your database has been upgraded to Oracle Database … Read more

Which statement is true about the execution of this command to back up the database?

Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2, both of which are open. RMAN is connected to the target database pdb2_1. RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;Which statement is true about the execution of this command to back up the database?Reference: http://docs.oracle.com/database/121/BRADV/rcmcnctg.htm#BRADV005 … Read more