Get Certified for Mnc Companies
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...
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...
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...
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...
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...
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...
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...
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...
Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.You want to...
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>...
