1) CDB1 is a container database running in ARCHIVELOG mode.
2) Multiple uncommitted transactions are running in CDB1.
3) Redo log groups 1 and 2 are INACTIVE.
4) Redo log group 3 is the CURRENT group.
All members of redo log group 3 are lost before it is archived.
Examine these possible steps:
1) SHUTDOWN ABORT
2) STARTUP NOMOUNT
3) STARTUP MOUNT
4) ALTER DATABASE MOUNT
5) RESTORE DATABSE
6) RECOVER DATABASE NOREDO
7) RECOVER DATABASE UNTIL AVAILABLE
8) RESTORE ARCHIVELOG ALL
9) ALTER DATABSE OPEN
10)ALTER DATABASE OPEB RESETLOGS
Choose the minimum required steps in the correct order to recover the
Database.
1, 3, 5, 8, 6, 10
1, 3, 5, 6, 10
1, 3, 5, 7, 10
1, 2, 5, 7, 4, 10
1) CDB1 and CDB2 are two container databases.
2) PDB1 is a pluggable database in CDB1.
3) PDB1_C1_SRV is a service for PDB1.
4) CDB1_LINK is a database link in CDB2 referring to PDB1.
5) CDB2 is also an entry in tnsnames.ora pointing to the CDB2 database
Default service.
You execute these commands successfully:
$ sqlplus sys/oracle_4U@cdb2 as sysdba
SQL> CREATE PLUGGABLE DATABASE PDB1
FROM PDB1@CDB1_LINK -
SERVICE_NAME_CONVERT=('PDB1_C1_SRV','PDB1_C2_SRV');
Which two are true? (Choose two.)
1The ORCL database data files are in Automatic Storage Management
(Oracle ASM) disk group +DATA.
2ORCL uses disk group +FRA for the Fast Recovery Area.
3LISTENER is the listener for ORCL.
4The database, listener, ASM instance, and ASM disk groups are managed
By Oracle Restart.
5All components are currently shut down.
You execute this command:
What is the outcome?
The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk
Groups, and the
LISTENER are started.
Only the ORCL database instance is started.
Only the ORCL database and the ASM instances are started.
Only the ORCL database instance, the Oracle ASM instance, and the +DATA
And +FRA disk groups
Are started.
Examine this configuration:
1CDB1 and CDB2 are two container databases.
2 PDB1 is a pluggable database in CDB1.
3 PDB1_C1_SRV is a service for PDB1.
4CDB1_LINK is a database link in CDB2 referring to PDB1.
5 CDB2 is also an entry in tnsnames.ora pointing to the CDB2 database
Default service.
You execute these commands successfully:
$ sqlplus sys/oracle_4U@cdb2 as sysdba
SQL> CREATE PLUGGABLE DATABASE PDB1
FROM PDB1@CDB1_LINK
SERVICE_NAME_CONVERT=('PDB1_C1_SRV', 'PDB1_C2_SRV') ;
Which two are true?
1 CDB1 is a container database.
2 APP1_ROOT is an application container contained in CDB1.
3 APP1_ROOT$SEED is the application seed contained in APP1_ROOT and
Synchronized with APP1_ROOT.
4 APP1_PDB1 and APP1_PDB2 are application PDBs contained in
APP1_ROOT.
5 APP1_USER_APP is an application installed in APP1_ROOT at version 1.0.
6 USER1 is a common user in APP1_ROOT and all its application PDBs,
Created when version 1.0 of APP1_USER_APP was installed.
You execute these commands:
$ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba
SQL> ALTER SESSION SET CONTAINER=app1_root;
Session altered.
SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app BEGIN
UPGRADE '1.0' TO '2.0';
Pluggable database altered.
SQL> GRANT CREATE SESSION TO USER1;
Grant succeeded.
SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app END
UPGRADE TO '2.0'; Pluggable database altered
SQL> ALTER SESSION SET CONTAINER=app1_pdb1;
Session altered.
SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app SYNC;
Pluggable database altered.
Which two are true?
USER1 is defined in APP1_PDB2.
USER1 can connect only to APP1_PDB1
USER1 can connect only to APP1_ROOT.
Your container database, CDB1, is in local undo mode.
You successfully execute this command while connected to CDB1:
CREATE PLUGGABLE DATABASE pdb1
ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES= (CONNECT)
CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1' ;
Which three are true about PDB1?
You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT.
Which two are always true? (Choose two.)
CDB1 and CDB2 must be in shared undo mode.
A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.
All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.
Cloning HR_ROOT automatically clones HR_PDB1.
The HR_PDB1clone created in CDB2 will be in mount state when cloning ends.
A container database, CDB1, contains a pluggable database PDB1.
Another container database is called CDB2.
You want to relocate PDB1 from CDB1 to CDB2 with near-zero down time.
Which three are required?
CDB1 must be in archivelog mode.
CDB2 must be in shared UNDO mode only.
CDB1 and CDB2 must be in shared UNDO mode.
CDB2 must be in archivelog mode.
CDB1 and CDB2 must both be in local UNDO mode.
Profiling performed by the SQL Tuning Advisor?
It is a set of recommendations by the optimizer to change the access methods
Used.
It is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error.
It is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal execution plans.
It is auxiliary information collected by the optimizer for a SQL statement to
Help use better joins orders.
Table:
BEGIN .DBMS_REDACT.ADD_POLICY(
Object_schema
=> 'SCOTT',
Object_name
=> 'EMP',
Column_name
=> 'SAL',
Policy_name
=> 'SCOTT_EMP',
Function_type
=> DBMS_REDACT.FULL,
Expression
=>
'SYS_CONTEXT(''SYS_SESSION_ROLES'',''MGR'')
= ''FALSE'''); END;
All users have their default set of system privileges.
For which three situations will data not be redacted?
我来回答:
