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.
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.)
(DBUA)? (Choose three.)
It recompiles all stored PL/SQL code by using utlrp.sql.
It empties the RECYCLE BIN.
It performs prerequisite checks to verify if the Oracle database is ready for
Upgrade.
It sets all user tablespaces to 'read-only' before starting the upgrade.
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
(DBCA) starting from Oracle Database 19c? (Choose three.)
Production database with minimum intervention from a DBA. Which method
Would you use?
Use DBCA to create a template from the existing database to contain the
Database structure with data files and then use the same template to create the
Database in the new location.
Use Database Configuration Assistant (DBCA) to create a template from the
Existing database to contain the database structure.
Use DBCA to create a template from the existing database to contain the
Database structure and then manually copy the data by using Oracle Data Pump.
Create the database by using the CREATE DATABASE . . . command and
Manually import data by using Data Pump.
1-Create a new database for a recovery catalog.
2-Create a tablespace with sufficient space in the catalog database for the recovery catalog.
3-Configure ARCHIVE LOG mode for the catalog database.
4-Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog.
5-Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner.
6-Grant the SYSBACKUP privilege to the recovery catalog schema owner.
Which are the minimum actions that must be performed before executing
The CREATE CATALOG command?
2, 4, 5, 6
1, 2, 3, 4, 5, 6
1, 2, 4, 5
2, 4, 5
Database. You want to know what caused this performance difference.
Which method or feature should you use?
Database Replay
Automatic Database Diagnostic Monitor (ADDM) Compare Period report
Active Session History (ASH) report
SQL Performance Analyzer
Contains two pluggable databases (PDBs), pdb1 and pdb2. You are
Connected to pdb2 as a common user with DBA privileges. The
Statistics_level parameter is PDB modifiable.
As the user sys, execute the following command on pdb2:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;
Which statement is true about the result of this command?
The statistics_level parameter is set to all when any of the PDBs is reopened.
The statistics_level parameter is set to all only for PDB2 when it is reopened.
The statistics_level parameter is set to all when the root database is restarted.
The statement is ignored because there is no SPFILE for a PDB.
我来回答: