a database ______ is the smallest unit of storage in Oracle.
blockCorrect
A default installation of the Oracle database using the Oracle Universal Installer with a seed database, or using the Database Creation Assistant, will automatically create a password file.
TrueCorrect
A distinct advantage to using ARCHIVELOG mode is that you can perform online backups (also known as hot backups), while the database is available to users.
TrueCorrect
Access Paths Analyze the impact of creating new indexes, materialized views, and partitioning.
TrueCorrect
After the capture operation is complete, the captured information must be preprocessed by transforming the captured data into replay files that can be easily replayed on the target system
TrueCorrect
At which level does ASM perform mirroring?
At the database object levelCorrect
Backing up the control file for a database running in ARCHIVELOG mode produces the same end result as the method you use in NOARCHIVELOG mode.
TrueCorrect
backout options: CASCADE Back out all transactions and their dependent transactions.
TrueCorrect
backout options: NOCASCADE Back out only the specified transaction, if possible.
TrueCorrect
backout options: NOCASCADE_FORCE Back out the specified transactions, ignoring dependent transactions.
TrueCorrect
backout options: NONCONFLICT_ONLY Back out changes to nonconflicting rows of the specified transaction only
TrueCorrect
backup is the default type of incremental backup that backs up all changed blocks since the last level 0 or level 1 incremental backup
differentialCorrect
backup of a database involves reading a set of database rows and writing them to a file
logicalCorrect
backups back up all changed blocks since the last level 0 incremental backup
cumulative incrementalCorrect
backups involve copying the files that constitute the database. These backups are also referred to as file system backups because they involve using operating system file backup commands.
physicalCorrect
Before running the first replay, you must perform some prerequisite checks: Ensure that the target system has access to the replay directory
TrueCorrect
Before running the first replay, you must perform some prerequisite checks:Remap connection strings to the replay system from the production system.
TrueCorrect
Before running the first replay, you must perform some prerequisite checks:Remap references to other production systems via database links, external .tables, directory objects, URLs, and E-mail notifications.
TrueCorrect
Choose the four best commands from the following list that you would use to enable ARCHIVELOG mode, and put them in the correct order: 1. STARUP MOUNT 2. SHUTDOWN ABORT 3. ALTER DATABASE ARCHIVELOG; 4. STARTUP FORCE 5. ALTER DATABASE ENABLE ARCHIVELOG; 6. ALTER SYSTEM SWITCH LOGFILE; 7. SHUTDOWN NORMAL 8. ALTER DATABASE OPEN; 9. SHUTDOWN IMMEDIATE
9, 1, 3, 8Correct
contains two major subcaches: the library cache and the data dictionary cache.
shared poolCorrect
DUPLICATE command: NOFILENAMECHECK Don’t check for duplicate filenames between the source and destination databases.
TrueCorrect
DUPLICATE command: OPEN RESTRICTED When the destination database is ready, open it immediately with the RESTRICTED SESSION option.
TrueCorrect
DUPLICATE command: SKIP READONLY Exclude read-only tablespaces from the copy operation.
TrueCorrect
DUPLICATE command: SKIP TABLESPACE Exclude specific tablespaces, except for SYSTEM and UNDO.
TrueCorrect
holds the most recent changes to the data blocks in the datafiles.
redo log bufferCorrect
Identify the correct statement regarding duplicate databases created with RMAN.
RMAN copies the database from the target to the duplicate database and both can have the same name.Correct
Identify the correct statement regarding TSPITR terminology.
The recovery set is the group of datafiles containing the tablespace(s) to be recovered.Correct
Identify the data dictionary view you can use to check for object dependencies between tablespaces.
TS_PITR_CHECKCorrect
Identify the true statement about Automatic Memory Management (AMM).
MEMORY_MAX_TARGET enables AMM, and it is a dynamic parameter.Correct
Identify the true statement about Flashback Data Archives.
If you do not specify a RETENTION clause for a Flashback Data Archive, you must specify it when assigning a table to the Flashback Data Archive.Correct
Identify the true statement regarding incremental and differential backups.
A differential backup is the default type of incremental backup and backs up all changed blocks since the last level 0 or level 1 incremental backup.Correct
If a user connection is dropped or a user process otherwise fails, ______ does the cleanup work
PMONCorrect
If you are interested in recovering only a small set of logically isolated tables to a previous point in time, you may be able to perform recovery using Oracle’s Flashback Table features.
TrueCorrect
If you are recovering one or more tablespaces or the entire database from backups that have different passwords, you can conveniently specify all the passwords at once with _______
set decryptionCorrect
If you do not use a recovery catalog, what data dictionary or dynamic performance views must you query to retrieve RMAN backup information?
The V$ views on each target such as V$BACKUP_SET and V$DATAFILE_COPYCorrect
If you lose all of the tempfiles from your temporary tablespace, what is the most likely result noticed by your users?
The users can’t use ORDER BY or GROUP BY in their queries.Correct
If you specify the initialization parameter DB_RECOVERY_FILE_DEST, what other initialization parameter must be set?
DB_RECOVERY_FILE_DEST_SIZECorrect
If you want to use two-way mirroring (normal redundancy) for a new disk group, how many failure groups do you need?
Two failure groups.Correct
In the case of a system crash or instance failure, due to a power outage or CPU failure, the ______, performs crash recovery by applying the entries in the online redo log files to the datafiles.
system monitorCorrect
is a block of executable code designed to perform a specific task
background processCorrect
is a group of extents that form a database object that Oracle treats as a unit, such as a table or index.
segmentCorrect
is an optional area of the SGA. It is used for transactions that interact with more than one database, message buffers for processes performing parallel queries, and RMAN parallel backup and restore operations.
large poolCorrect
Is in charge of redo log buffer management. It is one of the most active processes in an instance with heavy DML activity.
LGWRCorrect
is used by the Oracle JVM (Java Virtual Machine) for all Java code and data within a user session.
java poolCorrect
It refers to one of the log file status in V$LOG described as the log group has not been used yet.
unusedCorrect
It refers to one of the log file status in V$LOG described as the log group is not needed for instance recovery, may be in use for media recovery, and may or may not be archived
InactiveCorrect
It refers to one of the log file status in V$LOG described as The log is being cleared by ALTER DATABASE CLEAR LOGFILE. After being cleared, the status changes to UNUSED.
clearingCorrect
key tuning parameters for the BACKUP command: _________ The maximum number of input files that a channel can have open at a given time.
MaxopenfilesCorrect
key tuning parameters for the BACKUP command: ____________ The maximum number of files per backupset.
filespersetCorrect
key tuning parameters for the BACKUP command: ______________ The maximum size of a backup piece per channel.
MAXPIECESIZECorrect
Other datafiles required to recover the tablespace(s), such as the datafiles for the SYSTEM, UNDO, and TEMP tablespaces
auxiliary setCorrect
Performance tuning is the final step in a four-step process: planning, implementing, and monitoring must precede it.
TrueCorrect
Place the following commands in the correct order for restoring a control file from an RMAN autobackup: 1. RECOVER DATABASE 2. ALTER DATABASE OPEN RESETLOGS 3. STARTUP NOMOUNT 4. ALTER DATABASE MOUNT 5. RESTORE CONTROLFILE FROM AUTOBACKUP
3, 5, 4, 1, 2Correct
Question text The SGA is a group of memory structures for an Oracle instance that are shared by the users of the database instance
TrueCorrect
Recorded client request contains the information: Bind values
TrueCorrect
Recorded client request contains the information: SQL text
TrueCorrect
Recorded client request contains the information: Transaction information
TrueCorrect
Recovery falls into one of two general categories: complete and incomplete.
TrueCorrect
RMAN makes it easy to make a full copy or a subset of a target database.
TrueCorrect
SCN-based incomplete recovery works well if your applications save the SCN at critical points in a process flow, or the alert or trace logs indicate a serious error as of a particular SCN.
TrueCorrect
SQL Profiling Collect auxiliary statistics on a SQL statement along with partial execution statistics and store them in a SQL Profile.
TrueCorrect
Statistics Analysis Check for stale or missing statistics, and recommend refreshing or creating them
TrueCorrect
Structure Analysis Restructure the SQL statements to see if better execution plans are generated
TrueCorrect
The _____ is an area of memory allocating dynamic sections of itself, privately for one set of connection processes.
PGACorrect
The _______is the next level of logical grouping in the database
extentCorrect
The database buffer cache holds blocks of data from disk that have been recently read to satisfy a SELECT statement or that contain modified blocks that have been changed or added from a Data Manipulation Language (DML) statement.
TrueCorrect
The four steps to create a set of recommendations are as follows: 1. Create a task 2. Define the workload 3. Generate the recommendations 4. Review and implement the recommendations
TrueCorrect
The group of datafiles containing the tablespace(s) to be recovered
recovery setCorrect
The net service name of your target database is DW and the net service name of your recovery catalog database is RCAT. The environment variable ORACLE_SID has a value of RCAT. Which of the following sets of commands will successfully create a recovery catalog?
The phrase “closed databaserecovery” is somewhat of a misnomer if you consider that the database instance may still be available when one or more datafiles become unavailable.
TrueCorrect
The point in time or SCN to which the tablespace will be recovered.
target timeCorrect
The RMAN SWITCH command is equivalent to what SQL command?
ALTER SYSTEM RENAME FILECorrect
The SQL Tuning Advisor analyzes one or more SQL statements sequentially, examining statistics, and potentially recommends creating a SQL profile, new indexes, materialized views, or a revised SQL statement.
TrueCorrect
The SQL Tuning Advisor performs all but which of the following analyses?
Changes to materialized viewsCorrect
The three possible states of a log file group are INACTIVE, ACTIVE, and CURRENT.