Cert12c_067_121afin_passLeader

Question 1 of 40

1

QUESTION 121
You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter resumable_timeout to 3600.
Which two statements are true?

Select one or more of the following:

A. A resumable statement can be suspended and resumed only once during execution.
B. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
C. A suspended statement will report an error if no corrective action has taken place during a timeout period.
D. Before a statement executes in resumable mode, the alter session enable resumable statement must be issued in its session.
E. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.

Explanation

Question 2 of 40

1

QUESTION 122
Your database is running in archivelog mode and Automatic Undo Management is enabled.
Which two tasks should you perform before enabling Flashback Database?

Select one or more of the following:

A. Enable minimal supplemental logging.
B. Ensure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to which the database can be flashed back.
C. Enable the recyclebin.
D. Enable undo retention guarantee.
E. Enable Fast Recovery Area.

Explanation

Question 3 of 40

1

QUESTION 123
Consider the following scenario for your database:
- Backup optimization is enabled in RMAN.
- The recovery window is set to seven days in RMAN.
- The most recent backup to disk for the tools tablespace was taken on March 1, 2013.
- The tools tablespace is read-only since March 2, 2013.
On March 15, 2013, you issue the RMAN command to back up the database to disk.
Which statement is true about the backup of the tools tablespace?

Select one or more of the following:

A. The RMAN backup fails because the tools tablespace is read-only.
B. RMAN skips the backup of the tools tablespace because backup optimization is enabled.
C. RMAN creates a backup of the tools tablespace because backup optimization is applicable only for the backups written to media.
D. RMAN creates a backup of the tools tablespace because no backup of the tablespace exists within the seven-day recovery window.

Explanation

Question 4 of 40

1

QUESTION 124
You set the following parameters in the parameter file and restart the database instance:
NEMORY_MAX_TARGET=0
MEMORY__TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Which two statements are true?

Select one or more of the following:

A. The memory_max_target parameter is automatically set to 500 MB.
B. The pga_aggregate_targetand sga_target parameters are automatically set to zero.
C. The value of the memory_max_targetparameter remains zero for the database instance.
D. The lower limits of the pga_aggregate_target and sga_targetparameters are set to 90 MB and 270 MB respectively.
E. The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values.

Explanation

Question 5 of 40

1

QUESTION 125
Your database supports an OLTP workload. Examine the output of the query:
SQL> SSLECT target_mttr, estimated_mttr
FROM v$instance_recovery
Target_mttrestimated_mttr
---------------------- ---------------------------
To ensure faster instance recovery, you set the fast_start_mttrjtargh:t initialization parameter to 30.
What is the effect of this setting on the database?

Select one or more of the following:

A. Automatic checkpoint tuning is disabled.
B. The frequency of log switches is increased.
C. The overhead on database performance is increased because of frequent writes to disk.
D. The MTTR advisor is disabled.

Explanation

Question 6 of 40

1

QUESTION 126
Which three statements are true about persistent lightweight jobs?

Select one or more of the following:

A. A user cannot set privileges on them.
B. They generate large amounts of metadata.
C. They may be created as fully self-contained jobs.
D. They must reference an existing Scheduler Program.
E. The are useful when users need to create a large number of jobs quickly.

Explanation

Question 7 of 40

1

QUESTION 127
You restore and recover your database to a new host by using an existing RMAN open database backup.
Which step must you perform next?

Select one or more of the following:

A. Execute catproc.sqi to recompile invalid PL/SQL modules.
B. Open the database with the resetlogs option.
C. Set a new database identifier (DBID) for the newly restored database.
D. Use the RMAN set newname and switch commands to switch to new files.

Explanation

Question 8 of 40

1

QUESTION 128
Which two statements are true about unified auditing?

Select one or more of the following:

A. A unified audit trail captures audit information from unified audit policies and audit settings.
B. Unified auditing is enabled by executing make-fins_rdbms.mk uniaud_onioracle ORACLE_HOME=SORACLE_HOME.
C. Audit records are created for all users except sys.
D. Audit records are created only for the DML and DDL operations performed on database objects.
E. Unified auditing is enabled by setting the audit_trail parameter to db, extended.
F. A unified audit trail resides in a read-only table in the audsys schema in the system tablespace.

Explanation

Question 9 of 40

1

QUESTION 129
Your database is running in archivelog mode.
You are taking a backup of your database by using RMAN with a recovery catalog.
Because of a media failure, one of the data files and all the control files are lost.
Examine the steps to recover the database:
1.Restore the control files by using the RMAN restore controlfile command.
2.Mount the database.
3.Restore the data files by using the RMAN restore database command.
4.Open the database with the resetlogs option.
5.Recover the data files by using the RMAN recover using backup controlfile command.
6. Start the database instance in nomount state.
7. Connect to the target database by using a recovery catalog.
8.Open the database.
9.Restore the data file.
10.Recover the data file.
Identify the required steps in the correct order.

Select one or more of the following:

A. 7, 6, 1, 2, 3, 5, 4
B. 7, 2, 1, 3, 5, 8
C. 7, 6, 1, 2, 9, 10, 8
D. 7, 6, 1, 2, 9, 10, 4

Explanation

Question 10 of 40

1

QUESTION 130
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?

Select one or more of the following:

A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.
B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
D. Database files stored in ZFS and accessed using conventional NFS mounts.
E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature
F. Database files stored in any file system and accessed using the Oracle Direct NFS feature
G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

Explanation

Question 11 of 40

1

QUESTION 131
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?

Select one or more of the following:

A. Compare Period ADDM report
B. AWR Compare Period report
C. Active Session History (ASH) report
D. taking a new snapshot and comparing it with a preserved snapshot

Explanation

Question 12 of 40

1

QUESTION 132
Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database (COB) plan using Oracle Database Resource Manager?

Select one or more of the following:

A. maximum undo per consumer group
B. maximum idle time for a session in a PDB
C. parallel server limit
D. CPU
E. maximum number of sessions for a PDB

Explanation

Question 13 of 40

1

QUESTION 133
Which three types of failures are detected by the Data Recovery Advisor (DRA)?

Select one or more of the following:

A. loss of a non-critical data file
B. loss of a control file
C. physical data block corruption
D. logical data block corruption
E. loss of an archived redo log file

Explanation

Question 14 of 40

1

QUESTION 134
You want to capture column group usage and gather extended statistics for better cardinality estimates for the customers table in the SH schema.
Examine the following steps:
1. Issue the SELECTDBMS_STATS. CREATE_EXTENDED_STATS(`SH', 'CUSTOMERS')from dual statement.
2. Execute the dbms_stats.seed_col_usage (null,`SH',500) procedure.
3. Execute the required queries on the customers table.
4. Issue the select dbms_stats.reportwcol_usage(`SH', 'customers') from dual statement.
Identify the correct sequence of steps.

Select one or more of the following:

A. 3, 2, 1, 4
B. 2, 3, 4, 1
C. 4, 1, 3, 2
D. 3, 2, 4, 1

Explanation

Question 15 of 40

1

QUESTION 135
Examine the initialization parameter that is set in the PFILE:
DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/'
You execute the following command to create the CDB1. container database (CDB):
SQL>CREATEDATABASECDB1
DEFAULTTABLESPACE users
DEFAULTTEMPORARY TABLESPACEtemp
UNDO TABLESPACEundotbsl
ENABLEPLUGGA3LEDATABASE
SEED
SYSTEMDATAFILESSIZE125M AUTOEXTEND ON NEXT10M MAXSIZEUNLIMITED
SYSAUXDATAFILESSIZE100M;
Which three statements are true?

Select one or more of the following:

A. It creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively.
B. The files created for both the root and seed databases use Oracle Managed Files (OMF).
C. It creates a multitenant container database with the root and seed databases opened and one PDB mounted.
D. It sets the users tablespace as the default for both the root and seed databases.
E. undotbs1is used as the undo tablespace for both the root and seed databases.
F. It creates a multitenant container database with the root database opened and the seed database mounted.

Explanation

Question 16 of 40

1

QUESTION 136
Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN:
1.Create media families for data files and archived redo log files.
2.Configure database backup storage selectors or RMAN media management parameters.
3.Create an OSB user preauthorized for RMAN operations.
4.Configure RMAN Access to the OSB SBT.
5.Disable Non-Uniform Memory Access (NUMA) awareness by setting the ob_ignore_numa parameter to 0.
Identify the steps in the correct order.

Select one or more of the following:

A. 1, 4, 3, 2, 5
B. 1, 3, 4, 5, 2
C. 4, 3, 1, 2, 5
D. 4, 3, 5, 1, 2

Explanation

Question 17 of 40

1

QUESTION 137
Examine the RMAN command:
RMAN> SET ENCRYPTION IDENTIFIED BY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which type of encryption is used for the backup performed by using this command?

Select one or more of the following:

A. password-mode encryption
B. dual-mode encryption
C. transparent encryption
D. default encryption

Explanation

Question 18 of 40

1

QUESTION 138
The following parameters are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE
OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
You want to manage the SQL plan evolution task manually. Examine the following steps:
1.Set the evolve task parameters.
2.Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_TASK function.
3.Implement the recommendations in the task by using the
DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4.Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
5.Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.

Select one or more of the following:

A. 2, 4, 5
B. 2, 1, 4, 3, 5
C. 1, 2, 3, 4, 5
D. 1, 2, 4, 5

Explanation

Question 19 of 40

1

QUESTION 139
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?

Select one or more of the following:

A. USERS
B. SYSTEM
C. SYSAUX
D. EXAMPLE

Explanation

Question 20 of 40

1

QUESTION 140
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?

Select one or more of the following:

A. The database instance hangs and the redo log files are not overwritten.
B. The archived redo log files are written to the fast recovery area until the mandatory destination is made available.
C. The database instance is shutdown immediately.
D. The destination set by the log_archive_dest parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.

Explanation

Question 21 of 40

1

QUESTION 141
Identify three scenarios in which RMAN will use backup sets to perform active database duplication.

Select one or more of the following:

A. when the duplicate ... from active database command contains the section size clause
B. when you perform active database duplication on a database with flashback disabled
C. when you specify set encryption before the duplicate ... from active database command
D. when the number of auxiliary channels allocated is equal to or greater than the number of target channels
E. when you perform active database duplication on a database that has read-onlytablespaces

Explanation

Question 22 of 40

1

QUESTION 142
Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?

Select one or more of the following:

A. A DBA can check specific tables with the DMU
B. The database to be migrated must be opened read-only.
C. The release of the database to be converted can be any release since 9.2.0.8.
D. The DMUcan report columns that are too long in the converted characterset
E. The DMUcan report columns that are not represented in the converted characterset

Explanation

Question 23 of 40

1

QUESTION 143
Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)

Select one or more of the following:

A. It can be used to allow the access privilege settings for users but not roles.
B. It can be used to allow the access privilege settings for users as well as roles
C. It can be used to control the time interval for which the access privilege is available to a user.
D. It can be used to selectively restrict the access for each user in a database to different host computers.
E. It can be used to selectively restrict a user's access to different applications in a specific host computer.

Explanation

Question 24 of 40

1

QUESTION 144
You perform an RMAN block media recovery on the tools 01.dbf data file in the SALES database.
Which two statements are true?

Select one or more of the following:

A. You must ensure that the SALES database is mounted or open.
B. You must restore a backup control file to perform a block media recovery
C. You must take the tools01.dbf data file offline before you start a block media recovery.
D. You must put the database in NOARCHIVELOG mode to perform a block media recovery.
E. You can perform only a complete media recovery of individual blocks, point-in-time recovery of individualdata blocks is not supported.

Explanation

Question 25 of 40

1

QUESTION 145
Which statement is true regarding the creation of nested plans using the Oracle Resource Manager?

Select one or more of the following:

A. Only one nested subplan is allowed per parent plan
B. The plans can be nested up to four levels.
C. Nested plans only control resources used by recursive SQL
D. Nested plans control only the degree of parallelism and I/O requests
E. Each nested plan gets a proportion of the CPU resources assigned to its parent group.

Explanation

Question 26 of 40

1

QUESTION 146
You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?

Select one or more of the following:

A. The backup as copy can only be taken to disk
B. The backup as copy can only be taken to tape
C. Backup can be performed only when the instance is shutdown
D. Backup will constitute all used and unused blocks in the database

Explanation

Question 27 of 40

1

QUESTION 147
You issue the command:
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Which statement is true about the command?

Select one or more of the following:

A. It creates a copy of the control file and stores it in the location specifiedin the diagnostic_dest initialization parameter.
B. It creates a file that contains the SQL statement, which is required to re-create the control file.
C. It updates the alert log file with the location and contents of the control file.
D. It creates a binary backup of the control file.

Explanation

Question 28 of 40

1

QUESTION 148
You create a default Flashback Data Archive FLA1and 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?

Select one or more of the following:

A. It gives an error because DDL statements cannot be executed on a table that is enabled for Flashback Data Archive.
B. It executes successfully and all metadata related to the EMPLOYEEStable before altering the table definition is purged from Flashback Data Archive.
C. It executes successfully and continues to store metadata related to the EMPLOYEEStable
D. It executes successfully but Flashback Data Archive is disabled for the EMPLOYEEStable

Explanation

Question 29 of 40

1

QUESTION 149
Examine the commands executed in CDBS ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB):
SQL> CREATE ROLE c ##role1 CONTAINER-ALL;
SQL> GRANT CREATE SESSION, CREATE TABLE TO c##role1 CONTAINER'ALL;
SQL> CREATE USER c##adnin IDENTIFIED BY orcl123;
SQL> GRANT c##role1 TO c##admin CONTAINER=ALL;
SQL> GRANT SELECT ON DBA_USERS to c##rola1 CONTAINER*ALL;
Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1role?

Select one or more of the following:

A. The command fails and gives an error because object privileges cannot be granted to a common user.
B. The command fails because container is not set to current.
C. The command succeeds and the common user cmadnxn can create a session and query the D3A_users view in cdbssoo? and all the PDBs.
D. The command succeeds and the common user ct (admin can create a session in cdbSroot and all the PDBs, but can only query the dba_users view in ct3S?cdt.
E. The command succeeds and the common user c#(admin can create a session and query the D3A users view only in cdbsrooi.

Explanation

Question 30 of 40

1

QUESTION 150
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 with the data captured for a specified privilege capture.
3. Start analyzing the data captured by the policy.
4. Revoke the unused privileges.
5. Compare the used and unused privileges' lists.
6. Stop analyzing the data.
Identify the correct sequence of steps

Select one or more of the following:

A. 1, 3, 5, 6, 2, 4
B. 1, 3, 6, 2, 5, 4
C. 1, 3, 2, 5, 6, 4
D. 1, 3, 5, 2, 6, 4

Explanation

Question 31 of 40

1

QUESTION 151
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> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which statement is true about the execution of this command to back up the database?

Select one or more of the following:

A. All data files belonging to pdb2_1 are backed up and all archive log files are deleted
B. All data files belonging to pdb2_1 are backed up along with the archive log files.
C. Only the data files belonging to pdb2_ are backed up.
D. This command gives an error because archive log files can be backed up only when RMAN is connected to the root database.

Explanation

Question 32 of 40

1

QUESTION 152
You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs.
You do not want to restart the database instance.
How can you detect the cause of the degraded performance?

Select one or more of the following:

A. Enable Memory Access Mode, which reads performance data from SGA.
B. Use emergency monitoring to fetch data directly from SGA for analysis.
C. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
D. Use Active Session History (ASH) data and hang analysis in regular performance monitoring,
E. Run ADDM in diagnostic mode.

Explanation

Question 33 of 40

1

QUESTION 153
You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your UNIX- based Oracle 12c database:
CONNECT/AS SYSDBA
ALTER SYSTEMSETTHREADED__EXECUTION= TRUESCOPE=SPFILE;
SHUTDOWNIMMEDIATE
You then restart the instance and get an error:
STARTUP
ORA-01031:insufficientprivileges
Why does the startup command return the error shown?

Select one or more of the following:

A. because the threaded architecture requires exiting from sql*pIus and reconnecting with sql*PIus / as sysdba before issuing a startup command
B. because the threaded architecture requires issuing a new connect / as sysdba from within sql*pIus before issuing a startup command
C. because the threaded architecture requires authentication using a password file before issuing a startup command
D. because the threaded architecture requires connecting to the instance via a listener before issuing a startup command
E. because the threaded architecture requires restarting the listener before issuing a startup command

Explanation

Question 34 of 40

1

QUESTION 154
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?

Select one or more of the following:

A. All redo log files are opened.
B. The root, the seed, and all the PDBs are opened in read-write mode.
C. All the PDBs are opened in read-write mode.
D. All the PDBs are in closed state.
E. Only the root database is opened in read-write mode.

Explanation

Question 35 of 40

1

QUESTION 155
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?

Select one or more of the following:

A. An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
B. An attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.
C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.
D. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.
E. A user belonging to the DSS__QUERIES resource consumer group can create a new session but the session will be queued.

Explanation

Question 36 of 40

1

QUESTION 156
Examine the commands executed to monitor database operations:
$> conn sys/oracle@prod as sysdba
SQL> VAR eid NUMBER
SQL>EXEC :eid :=
DBMS_SQL_MONITOR.BEGlN_OPERATION('batch_job',FORCED_TRACKING=>'Y');
Which two statements are true?

Select one or more of the following:

A. Database operations will be monitored only when they consume a significant amount of resource.
B. Database operations for all sessions will be monitored.
C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
D. Only DML and DDL statements will be monitored for the session.
E. All subsequent statements in the session will be treated as one database operation and will be monitored.

Explanation

Question 37 of 40

1

QUESTION 157
Examine the command:
$expdp SYSTEM FULL=YES DUMPFILE=dpump_dir1:fulll%U.dmp, dpump_dir2:full2% U.dmp, dpump_dir3:full3%U.djnp FILESIZE=400M PARALLEL=3 JOB_NAME=expfull
Which statement is true about the execution of the command?

Select one or more of the following:

A. It fails because the log file parameter is not specified.
B. It fails because no absolute path is specified for the log file and dump file.
C. It succeeds and exports the full database, simultaneously creating three copies of dump files at three different locations.
D. It succeeds and exports the full database, simultaneously creating three dump files at three different locations, but the total number of dump files can exceed three.

Explanation

Question 38 of 40

1

QUESTION 158
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?

Select one or more of the following:

A. by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis
B. by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots
C. by using Active Session History (ASH) data and performing hang analysis
D. by running ADDM in diagnostic mode

Explanation

Question 39 of 40

1

QUESTION 159
Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined.
You execute this command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true?

Select one or more of the following:

A. The minimum size for the standard buffer cache is 100 MB.
B. The maximum size for the standard buffer cache is 100 MB.
C. The minimum space guaranteed in the buffer cache for any server process is 100 MB.
D. The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB.
E. The minimum size for all buffer caches is 100 MB.

Explanation

Question 40 of 40

1

QUESTION 160
You created a tablespace with this statement:
CREATE BIGFILE TABLESPACE adtbs
DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G;
The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table.
Which two alter statements will achieve this?

Select one or more of the following:

A. ALTER TA3LESPACE adtbs RESI2E 20G;
B. ALTER TA3LESPACE adtbs ADD DATAFILE;
C. ALTER TABLESPACE adtbs AUTOEXTEND ON;
D. ALTER TA3LESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG;
E. ALTER TA3LESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON;

	Created by A A over 6 years ago

Quiz on Cert12c_067_121afin_passLeader, created by A A on 19/11/2017.

Cert12c_067_121afin_passLeader

Question 1 of 40

QUESTION 121 You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures. You set the value of the initialization parameter resumable_timeout to 3600. Which two statements are true?

Select one or more of the following:

Explanation

Question 2 of 40

QUESTION 122 Your database is running in archivelog mode and Automatic Undo Management is enabled. Which two tasks should you perform before enabling Flashback Database?

Select one or more of the following:

Explanation

Question 3 of 40

Select one or more of the following:

Explanation

Question 4 of 40

QUESTION 124 You set the following parameters in the parameter file and restart the database instance: NEMORY_MAX_TARGET=0 MEMORY__TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M Which two statements are true?

Select one or more of the following:

Explanation

Question 5 of 40

Select one or more of the following:

Explanation

Question 6 of 40

QUESTION 126 Which three statements are true about persistent lightweight jobs?

Select one or more of the following:

Explanation

Question 7 of 40

QUESTION 127 You restore and recover your database to a new host by using an existing RMAN open database backup. Which step must you perform next?

Select one or more of the following:

Explanation

Question 8 of 40

QUESTION 128 Which two statements are true about unified auditing?

Select one or more of the following:

Explanation

Question 9 of 40

Select one or more of the following:

Explanation

Question 10 of 40

QUESTION 130 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?

Select one or more of the following:

Explanation

Question 11 of 40

QUESTION 131 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?

Select one or more of the following:

Explanation

Question 12 of 40

QUESTION 132 Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database (COB) plan using Oracle Database Resource Manager?

Select one or more of the following:

Explanation

Question 13 of 40

QUESTION 133 Which three types of failures are detected by the Data Recovery Advisor (DRA)?

Select one or more of the following:

Explanation

Question 14 of 40

Select one or more of the following:

Explanation

Question 15 of 40

Select one or more of the following:

Explanation

Question 16 of 40

Select one or more of the following:

Explanation

Question 17 of 40

QUESTION 137 Examine the RMAN command: RMAN> SET ENCRYPTION IDENTIFIED BY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which type of encryption is used for the backup performed by using this command?

Select one or more of the following:

Explanation

Question 18 of 40

Select one or more of the following:

Explanation

Question 19 of 40

QUESTION 139 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?

Select one or more of the following:

Explanation

Question 20 of 40

Select one or more of the following:

Explanation

Question 21 of 40

QUESTION 141 Identify three scenarios in which RMAN will use backup sets to perform active database duplication.

Select one or more of the following:

Explanation

Question 22 of 40

QUESTION 142 Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?

QUESTION 121
You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter resumable_timeout to 3600.
Which two statements are true?

QUESTION 122
Your database is running in archivelog mode and Automatic Undo Management is enabled.
Which two tasks should you perform before enabling Flashback Database?

QUESTION 124
You set the following parameters in the parameter file and restart the database instance:
NEMORY_MAX_TARGET=0
MEMORY__TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Which two statements are true?

QUESTION 126
Which three statements are true about persistent lightweight jobs?

QUESTION 127
You restore and recover your database to a new host by using an existing RMAN open database backup.
Which step must you perform next?

QUESTION 128
Which two statements are true about unified auditing?

QUESTION 130
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?

QUESTION 131
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?

QUESTION 132
Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database (COB) plan using Oracle Database Resource Manager?

QUESTION 133
Which three types of failures are detected by the Data Recovery Advisor (DRA)?

QUESTION 137
Examine the RMAN command:
RMAN> SET ENCRYPTION IDENTIFIED BY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which type of encryption is used for the backup performed by using this command?

QUESTION 139
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?

QUESTION 141
Identify three scenarios in which RMAN will use backup sets to perform active database duplication.

QUESTION 142
Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?

QUESTION 143
Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)

QUESTION 144
You perform an RMAN block media recovery on the tools 01.dbf data file in the SALES database.
Which two statements are true?

QUESTION 145
Which statement is true regarding the creation of nested plans using the Oracle Resource Manager?

QUESTION 146
You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?

QUESTION 147
You issue the command:
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Which statement is true about the command?

QUESTION 152
You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs.
You do not want to restart the database instance.
How can you detect the cause of the degraded performance?

QUESTION 154
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?

QUESTION 155
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?

QUESTION 156
Examine the commands executed to monitor database operations:
$> conn sys/oracle@prod as sysdba
SQL> VAR eid NUMBER
SQL>EXEC :eid :=
DBMS_SQL_MONITOR.BEGlN_OPERATION('batch_job',FORCED_TRACKING=>'Y');
Which two statements are true?

QUESTION 157
Examine the command:
$expdp SYSTEM FULL=YES DUMPFILE=dpump_dir1:fulll%U.dmp, dpump_dir2:full2% U.dmp, dpump_dir3:full3%U.djnp FILESIZE=400M PARALLEL=3 JOB_NAME=expfull
Which statement is true about the execution of the command?