IT-6203A - Advanced Database Management Systems oed answer key
Showing 41 to 60 of 139 total answers.
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
What happens to the state of an ASM instance when a connected RDBMS instance fails?
Answer
There is no effect on the ASM instance.
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
You want to switch from AMM to ASMM. What is the correct statement you need to run?
Answer
alter system set memory_max_target = 0;
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
backout options: CASCADE Back out all transactions and their dependent transactions.
Answer
True
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
backup of a database involves reading a set of database rows and writing them to a file
Answer
logical
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
DUPLICATE command: SKIP READONLY Exclude read-only tablespaces from the copy operation.
Answer
True
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
What is the value for INSTANCE_TYPE in the init.ora file or SPFILE for an ASM instance?
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
What is the difference between coarse striping and fine striping for files in a disk group?
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
DUPLICATE command: SKIP TABLESPACE Exclude specific tablespaces, except for SYSTEM and UNDO.
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
What is the difference between a critical and a noncritical datafile in a recovery scenario?
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Which of the following procedures will run a SQL Tuning Advisor job against a SQL Tuning Set?
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Access Paths Analyze the impact of creating new indexes, materialized views, and partitioning.
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
What is the maximum number of database writer processes (DBWn) in an Oracle database instance?
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Which of the following columns is not in the data dictionary view FLASHBACK_TRANSACTION_QUERY?
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Which of the following methods can you use to retrieve the current System Change Number (SCN)?
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
If a user connection is dropped or a user process otherwise fails, ______ does the cleanup work
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
writes new or changed data blocks (known as dirty blocks) in the buffer cache to the datafiles.
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Structure Analysis Restructure the SQL statements to see if better execution plans are generated
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Which tablespaces contain critical datafiles that must be recovered when the database is offline?
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems