IT-6203A - Advanced Database Management Systems oed answer key
Showing 1 to 20 of 139 total answers.
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
At which level does ASM perform mirroring?
Answer
At the database object level
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Which is the best method for recovering a tempfile?
Answer
Add another tempfile to the TEMP tablespace and drop the corrupted or missing tempfile while the database is running.
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Which of the following are not RMAN standalone commands?
Answer
ALLOCATE CHANNEL
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Identify the true statement about Flashback Data Archives.
Answer
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.
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Recorded client request contains the information: SQL text
Answer
True
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
The RMAN SWITCH command is equivalent to what SQL command?
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
a database ______ is the smallest unit of storage in Oracle.
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Identify the correct statement regarding TSPITR terminology.
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
What method does RMAN use to enable fast incremental backup?
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Recorded client request contains the information: Bind values
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
What is the difference between the V$LOG and V$LOGFILE views?
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Which of the following initialization parameters is not valid?
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
The _______is the next level of logical grouping in the database
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
is a block of executable code designed to perform a specific task
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
holds the most recent changes to the data blocks in the datafiles.
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
The group of datafiles containing the tablespace(s) to be recovered
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
The point in time or SCN to which the tablespace will be recovered.
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Which of the following parameters are required for an ASM instance?
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems