Your database is running in ARCHIVELOG mode. You backup your database regularly. If certain files are lost, an incomplete recovery is required.
In which two cases is this true?
Which three statements correctly describe the relationship amongst jobs, programs, and schedules within the Oracle Job Scheduler?
Which two statements are true about encrypted backups performed by using RMAN?
Choose two.
Your database is running in archivelog mode. Examine the parameters for your database instance:
LOG_ARCHIVE_DEST_l ='LOCATION=/disk1/arch MANDATORY'
LOG_ARCHIVE_DEST_2 ='LOCATION=/disk2/arch'
LOG_ARCHIVE_DEST_3 ='LOCATIO=/disk3/arch'
LOG_ARCHIVE_DEST _4 ='LOCATIONs/disk4/arch'
LOG_ARCHIVE _MIN_SUCCEED_DEST = 2
While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have been used.
What happens at the next log switch?
Examine the following set of RMAN commands:
RMAN> CONFIGURE CHANNEL dc1 DEVICE TYPE DISK FORMAT ' /u02/backup/%U' ; RMAN> RUN
{
ALLOCATE CHANNEL ch1 DEVICE TYPE DISK;
EXECUTE SCRIPT arc_backup;
}
Which statement is true about the RMAN RUN block execution?
Examine the command to create a pluggable database (PDB):
SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1
FILE_NAME-_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/’) PATH_PREFIX = '/disk2/oracle/pdb2';
Which two statements are true?
Which three conditions must be met before you create a Virtual Private Catalog (VPC)?
Which three methods can be used to create a pluggable database (PDB) in an existing multitenant container database (CDB)? (Choose three.)
You issue the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN> 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?
View the SPFILE parameter settings in the Exhibit.
You issue this command and get errors:
SQL> startup
ORA-00824:cannotsetSGAJTARGET or MEMORY_TARGET dueto existing internalsettings,seealertlog for moreinformation
Why did the instance fail to start?
You execute the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk
RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2;
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT “/disk/%U’;
RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT “/disk/%U’;
RMAN> BACKUP DATABASE;
Which statement is true about the backup set created by the BACKUP command?
You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.
Which three storage options support the use of HCC?
RMAN is connected to the target database PROD1 and an auxiliary instance in NOMOUNT state. Examine the command to create a duplicate database:
RMAN> DUPLICATE TARGET DATABASE TO dup1
FROM ACTIVE DATABASE
NOFILENAMECHECK
PASSWORD FILE
SPFILE;
Which two statements are true about the execution of the DUPLICATE command?
A user issues a query on the sales table and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file '/u0l/app/oracle/oradata/ORCL/temp01.dbf'
ORA-27037: unable to obtain file status
Which two actions would you take to recover the temporary tablespace?
Which three types of backups can be performed for a database running in NOARCHIVELOG mode? (Choose three.)
Your database is running on the host OUSERVER. You back up your database regularly using RMAN and the backups are cataloged in a recovery catalog. For testing purposes, you want to replicate your database to another host, OUSERVER1, with the same directory structure. So, you copy the backups to the new host. What must you do to make the database operational in OUSERVER1?
Which three statements are true about compression of backup sets?
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 create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.
How would you achieve this?
You need to perform a block media recovery on the tools01.dbf data file in your database by using Recovery Manager (RMAN).
Which two are prerequisites for performing this operation?
Choose two.
Which two statements are true about unified auditing?
You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years.
You execute the following command to change the requirement:
SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR;
What is the outcome?
Your multitenant container database (CDB) CDB1 has two pluggable databases, PDB1 and PDB2. The local net service name CDB1 connects to the root database, and the service names PDB1 and PDB2 connect to the pluggable databases (PDBs), PDB1 and PDB2, respectively.
Examine the commands to change the value of the PDB modifiable initialization parameter:
$> sqlplus sys/oracle_4U@pdb1 AS SYSDBA
SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines=FALSE SCOPE=BOTH;
SQL> CONN sys/oracle_4U@pdb2 AS SYSDBA
SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines=TRUE SCOPE=BOTH;
SQL> CONN sys/oracle_4U@pdb1 AS SYSDBA
SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines=TRUE SCOPE=BOTH;
Which statement is true about the OPTIMIZER_USER_SQL_PLAN_BASELINES parameter? (Choose the best answer.)
Identify two scenarios in which the RMAN crosscheck command can be used.
Which three statements are true about transportable databases? (Choose three.)
You issue the RMAN command:
RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;
Which statement is true about the execution of the command?
Choose the best answer.
The CATDB12c database contains an Oracle Database version 12c catalog schema owned by the RC12C user.
The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open.
You execute the RMAN commands:
RMAN> CONNECT CATALOG rc12c/pass12c@catdb12c
RMAN> IMPORT CATALOG rc11/pwdcat11@ract11
Which two tasks are performed as part of the import? (Choose two.)
Examine these Data Pump commands to export and import objects from and to the same database.
The dba has not yet created users hr1 and oe1.
$expdp system/manager
schemas = hr.oe
directory = EXP_DIR
dumpfile = export.dat
include = table
$ impdpsysten/manager
schemas = hr1,oe1
directory = EXP_DIR
dumpfile = export.dat
remap_schena=hr:hrl, oe:oe1
What will happen when running these commands?
Your database supports an OLTP workload. Examine the output of the query:
SQL> SELECT target_mttr, estimated_mttr
FROM v$instance_recovery
Target_mttr estimated_mttr
---------------------- ---------------------------
0 76
To ensure faster instance recovery, you set the fast_start_mttr_target initialization parameter to 30.
What is the effect of this setting on the database?
You are installing Oracle Database 12c with the Oracle Universal Installer (OUI). You select the option to create a database by using file system storage but you do not explicitly set ORACLE_BASE. What is the effect on the installation?
Which two statements are true about Enterprise Manager (EM) Express in Oracle Database 12c? (Choose two.)
Users report this error message when inserting rows into the orders table:
ERROR atline1:
ORA-01654f:unable to extend index USERS.ORDERS_IND by 8in tablespace INDEXES
You determine that the indexes tablespace is out of space and there is no free space on the filesystem used by the Oracle database.
Which two must you do to fix this problem without affecting currently executing queries?
Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):
$> impdp
transport_datafiles=
‘/u01/app/oracle/oradata/hrdb/sales01.dbf’,
‘/u01/app/oracle/oradata/hrdb/cust01.dbf’,
‘/u01/app/oracle/oradata/hrdb/emp01.dbf’,
version=12 logfile=import.log
Which three are prerequisites for successful execution of the command?
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 TO##Madmin CONTAINER=ALL;
SQL>CONNsys/oracle@HR_PDB as sysdba
SQL> GRANTc##role1TO b_admin CONTAINER=CURRENT;
Which two statements are true?
You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). RMAN is connected to CDB$ROOT.
Examine the command:
RMAN> LIST FAILURE;
Which statement is true about this command?
Which four tablespace types can be renamed?
Choose four.
You plan to migrate a production database to Real Application Clusters (RAC).
You created a test RAC database by cloning the production database and plan to replay a workload, captured from the production database.
Examine these steps:
1) Preprocess the captured workload.
2) Restart the database instance in RESTRICTED mode.
3) Set up Replay Clients.
4) Restore the test database to the point when the capture started on the production database.
5) Remap connections.
Which is the correct sequence of required steps?
The SYS user creates this job:
Which two statements are true about this job? (Choose two.)
Which two statements are true regarding SecureFile lobs?