Examine the memory-related parameters of an Oracle database instance:
Which statement is true?
D
Explanation:
Reference:
https://docs.oracle.com/database/121/ADMIN/memory.htm#ADMIN11200
In your database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20.
Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data
movement?
C D
You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED
container data files in separate directories.
You plan to create the database using SQL statements.
Which three techniques can you use to achieve this? (Choose three.)
A B C
Explanation:
You must specify the names and locations of the seed's files in one of the following ways:
* (A) Oracle Managed Files
* (B) The SEED FILE_NAME_CONVERT Clause
* (C) The PDB_FILE_NAME_CONVERT Initialization Parameter
In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following
commands in the root container:
Which two statements are true?
A C
Explanation:
* You can include the CONTAINER clause in several SQL statements, such as the CREATE USER, ALTER USER,
CREATE ROLE, GRANT, REVOKE, and ALTER SYSTEM statements.
* * CREATE ROLE with CONTAINER (optional) clause/ CONTAINER = ALL
Creates a common role.
/ CONTAINER = CURRENT
Creates a local role in the current PDB.
Which two statements are true about variable extent size support for large ASM files?
A C
Explanation:
A: Variable size extents enable support for larger ASM datafiles, reduce SGA memory requirements for very large databases
(A), and improve performance for file create and open operations.
C: You don't have to worry about the sizes; the ASM instance automatically allocates the appropriate extent size.
Note:
* The contents of ASM files are stored in a disk group as a set, or collection, of data extents that are stored on individual
disks within disk groups. Each extent resides on an individual disk. Extents consist of one or more allocation units (AU).
Toaccommodate increasingly larger files, ASM uses variable size extents.
* The size of the extent map that defines a file can be smaller by a factor of 8 and 64 depending on the file size. The initial
extent size is equal to the allocation unit size and it increases by a factor of 8 and 64 at predefined thresholds. This feature
isautomatic for newly created and resized datafiles when the disk group compatibility attributes are set to Oracle Release 11
or higher.
Your database is running an ARCHIVELOG mode.
The following parameters are set in your database instance:
Which statement is true about the archived redo log files?
A
Explanation:
You can choose to archive redo logs to a single destination or to multiple destinations.
Destinations can be localwithin the local file system or an Oracle Automatic Storage Management (Oracle ASM) disk
groupor remote (on a standby database). When you archive to multiple destinations, a copy of each filled redo log file is
written to each destination. These redundant copies help ensure that archived logs are always available in the event of a
failure at one of the destinations.
To archive to only a single destination, specify that destination using the LOG_ARCHIVE_DEST and
LOG_ARCHIVE_DUPLEX_DEST initialization parameters.
ARCHIVE_DEST initialization parameter. To archive to multiple destinations, you can choose to archive to two or more
locations using the LOG_ARCHIVE_DEST_n initialization parameters, or to archive only to a primary and secondary
destination using the LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST initialization parameters.
You created a new database using the "create database" statement without specifying the "ENABLE PLUGGABLE
DATABASE" clause.
What are two effects of not using the "ENABLE PLUGGABLE database" clause?
A D
Explanation:
A (not B, not E): The CREATE DATABASE ... ENABLE PLUGGABLE DATABASE SQL statement creates a new CDB. If you
do not specify the ENABLE PLUGGABLE DATABASE clause, then the newly created database is a non-CDB and can never
contain PDBs.
D: You can create a PDB by plugging in a Non-CDB as a PDB. The following graphic depicts the options for creating a PDB:
Incorrect Answers:
E: For the duration of its existence, a database is either a CDB or a non-CDB. You cannot transform a non-CDB into a CDB
or vice versa. You must define a database as a CDB at creation, and then create PDBs within this CDB.
Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is
damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs. Which
three steps should you perform to recover the control file and make the database fully operational? (Choose three.)
C D F
Explanation:
Step 1: Start the database instance in the nomount stage and restore the control file from control file auto backup Step 2:
Open all the pluggable databases.
Step 3: If all copies of the current control file are lost or damaged, then you must restore and mount a backup control file.
You must then run the RECOVER command, even if no data files have been restored, and open the database with the
RESETLOGS option.
Note:
* RMAN and Oracle Enterprise Manager Cloud Control (Cloud Control) provide full support for backup and recovery in a
multitenant environment. You can back up and recover a whole multitenant container database (CDB), root only, or one or
more pluggable databases (PDBs).
You are administering a database stored in Automatic Storage Management (ASM). One of the ASM
disks is dropped because of hardware failure. You replace the failed disk and want the resulting
rebalance operations to occur with minimal impact on database performance.
Which two settings will help to maintain consistent database performance during the rebalance?
A. Decrease the value of the disk_repair_time attribute for the disk group.
B. Increase the number of slave DBWR processes by setting a higher value for dbwrioslaves.
C. Increase the number of DBWR processes by setting a higher value for db_writer_processes.
D. Increase the number of ARB processes by setting a higher value for asm_power_limit.
118/119
Questions & Answers PDF
P-
E. Define the power option while adding or removing the disks.
F. Increase the number of RBAL processes.
BD
119/119
In which two scenarios is an RMAN recovery catalog automatically resynchronized?
CD