Crack4sure Logo
The CATDB12C database contains an Oracle Database 12c catalog schema owned by the RC12C user.
The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RC11 user.
A database with DBID=1423241 is registered in the CATDB11 catalog. Both the recovery catalog databases are open.
In the CATDB12c database, you execute the commands:
What is the outcome of the import?
You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference.
Which method or feature should you use?
You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PROD database uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected to a recovery catalog.
You create an auxiliary instance and want to execute the command:
What is a prerequisite for the successful execution of this command?
You are connected to a recovery catalog and target database. You execute the command:
RMAN> CATALOG START WITH ‘/disk1/backups’;
Which statement is true?
You create a default Flashback Data Archive FLA1 and enable it for the EMPLOYEES table in the HR schema.
After a few days, you want to alter the EMPLOYEES table by executing the command:
SQL> ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12);
Which statement is true about the execution of the command?
A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call.
Which table organization allows for generating the bills with minimum degree of row sorting?
View the Exhibit showing steps to create a database resource manager plan.
SQL>execute dbms_resource_manager.create_pendingarea();
PL/SQL procedure successfully completed.
SQL>exec dbms_resource_manager, create_consumergroup (consumer_group=>’OLTP,,comment=>,onlineuser’)
PL/SQL procedure successfully completed.
SQL>exec bras resource_manager.create plan(plan=>’PRIU3ER3',comment=>'dssprio’);
SQL>exec
Dbms_resource_manager.create_plan_directive(plan=>’PRIU3ER3’,group_or_subplan=>'OLTP’,comment=>'onlinegrp'CPU_Pl=>60);
PL/3QLproceduresuccessfullycompleted.
After executing the steps in the exhibit you execute this procedure, which results in an error:
SQL> EXECUTE dbms_resource_manager. validate_pending_area ();
What is the reason for the error?
Examine this command:
SQL> CREATE DATABASE cdb1
DEFAULT TABLESPACE users
DEFAULT TEMPORARY TABLESPACE temp
UNDO TABLESPACE undotbs1
ENABLE PLUGGABLE DATABASE
SEED
SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
SYSAUX DATAFILES SIZE 100M;
Which two requirements must be met to ensure that CDB1 is created? (Choose two.)
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 pluggable 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?
Examine the commands:
SQL> ALTER SESSION SET RECYCLEBIN = ON;
Session altered.
SQL> DROP TABLE emp; --(First EMP table)
Table dropped.
SQL> CREATE TABLE emp(id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2 (15), salary NUMBER(7,2));
Table created.
You then execute multiple INSERT statements to insert rows into the EMP table and drop the table again:
SQL> DROP TABLE emp; -- (Second EMP table)
Table dropped.
SQL> FLASHBACK TABLE emp TO BEFORE DROP;
Which statement is true about the FLASHBACK command?
You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects. During this operation, you want to ensure the following:
i. Long-running queries are not affected.
ii. No extra space is used.
iii. Data manipulation language (DML) operations on the table succeed at all times throughout the process.
iv. Unused space is reclaimed both above and below the high water mark.
Which alter TABLE option would you recommend?
You use RMAN to take regular backups for your database.
Examine the RMAN commands:
RMAN> CROSSCHECK BACKUP;
RMAN> DELETE EXPITED BACKUP;
Which statement is true?
After implementing full Oracle Data Redaction, you change the default value for the number data type as follows:
SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE
-------------------------
0
SQL> EXEC DBMS_REDACT.UPDATE_FULL_REDACTI0N_VALUES(-1)
PL/SQL procedure successfully completed.
SQL> select number_value from redaction_values_for_type_full;
NUMBER VALUE
------------------------
-1
After changing the value, you notice that FULL redaction continues to redact numeric data with a zero.
What must you do to activate the new default value for numeric full redaction?
You wish to create jobs to satisfy these requirements:
1. Automatically bulk load data from a flat file.
2. Rebuild indexes on the SALES table after completion of the bulk load.
How would you create these jobs?
You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization.
Which two backup solutions can be used? (Choose two.)
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?
Examine this command:
Which two statements are true after successful execution? (Choose two.)
One of your databases is in ARCHIVELOG mode and take nightly RMAN backups.
The USERS and IDX tablespaces are missing due to storage array errors.
Which four actions would recover the tablespaces and their contents while the database remains open? (Choose four.)
You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs.
How can you detect the cause of the degraded performance?
Which statement is true about the ALTER SESSION SET CONTAINER command to switch between containers?
You are administering a multitenant container database (CDB) that has no startup triggers and contains three pluggable databases (PDBs).
You execute the command to start up the CDB:
SQL> STARTUP
Which statement is true?
A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance? (Choose three.)
Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.
SQL> SELECT name, active_sessions, queue_length,
consumed_cpu_time, cpu_waits, cpu_wait_time
FROM v$rsrc_consumer_group;
Which two statements are true? (Choose two.)
Your database is on ARCHIVELOG mode and an incremental backup exists.
A media failure in the loss of a data file and an online redo log.
Examine these commands:
1. STARTUP NOMOUNT
2. STARTUP MOUNT
3. RESTORE DATABASE
4. RECOVER DATABASE
5. RECOVER DATABASE UNTIL CANCEL
6. ALTER DATABASE OPEN
7. ALTER DATABASE OPEN RESETLOGS
Which commands are required to recover your database?
You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:
create table employees
(empno number, salary number,
deptid number, name varchar2(100),
period for employee_time);
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table? (Choose three.)
Your database is running in ARCHIVELOG mode and flashback is enabled.
In which scenario must you use RMAN backups for recovering tables and table partitions?
Your multitenant container database (CDB) CDB1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:
SQL> STARTUP
Which two statements are true about the successful execution of the command? (Choose two.)
You execute the RMAN commands:
RMAN> BACKUP VALIDATE DATABASE;
RMAN> RECOVER CORRUPTION LIST;
Which task is performed by these commands?
Examine the command:
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
In which two scenarios is this command required? (Choose two.)
While performing database backup to tape via the media manager interface, you notice that tape streaming is not happening because RMAN is not sending data blocks fast enough to the tape drive.
Which two actions would you take for tape streaming to happen during the backup? (Choose two.)
You create a new database by using the CREATE DATABASE command in SQL*Plus, with the ENABLE PLUGGABLE DATABASE clause specified.
Which statement is true about the database that is created?
Identify three reasons for using a recovery catalog with Recovery Manager (RMAN). (Choose three.)
TESTED 02 May 2024