Exam (elaborations)
D192 Official Flashcards )With Complete Solutions 2024
- Course
- Institution
D192 Official Flashcards )With Complete Solutions 2024
[Show more]
Seller
Follow
Content preview
10/11/24, 8:31 AMD192 Official Flashcards
Jeremiah
Terms in this set (330)
Which file is read by DBUA to determine /etc/oratab
which databases are available on a server or
as candidates for upgrade? /var/opt/oracle/oratab
What is the lowest release of the database 10.2.0.5
that can be upgraded to Oracle Database
12c using DBUA?
The output of the Pre-Upgrade Information $ORACLE_BASE/cfgtoollogs/db_unique_name/preupgrade
tool is written to what location?
When you run the preupgrd.sql script, to registry$nonsys_inv_objs
which table are the invalid objects written?
Which script compares invalid objects utluiobj.sql
before and after an upgrade and lists only
the invalids after the upgrade?
What version of the time zone file is 18
supplied with Oracle Database 12c
software?
What happens to Enterprise Manager Enterprise Manager Database Control is dropped during the upgrade.
Database Control when the database is
upgraded?
Before a database upgrade, AUD$ table SYS, SYSTEM
should be owned by ____ and reside on ____
tablespace.
True or False: During a DBUA database True
upgrade, you have the option to migrate
data files to another location or to ASM.
True or False: If Flashback Database is not False
enabled on the database, DBUA can
D192 Official Flashcards
True or False: A DBUA upgrade can be True
restarted.
True or False: DBUA can be run in silent True
mode, without accepting any input from
the user.
True or False: Running the Pre-Upgrade True
Information tool is optional before
performing a DBUA upgrade.
True or False: Running the Pre-Upgrade False
Information tool is optional before
performing a manual upgrade.
1/7
, 10/11/24, 8:31 AM
When you run catupgrd.sql to upgrade the catuppst.sql
database, which additional script must be
run to complete the upgrade?
Which script is used to upgrade the catctl.pl
database when run in manual upgrade
mode?
What is the default parallelism used when 4
running the catctl.pl script without the -n
option?
Which script is used for the post-upgrade utlu121s.sql
status information?
True or False: To enable Unified Auditing, False
you must set the UNIFIED_AUDIT_TRAIL
parameter to TRUE.
In which mode should the database be STARTUP UPGRADE
when you change MAX_STRING_SIZE to
EXTENDED?
Which script is used to downgrade the catdwgrd.sql
database to its original release?
After you run catdwgrd.sql to downgrade catrelod.sql
the database, which script should you run
to get the catalog in the correct version?
Which script recompiles all invalid objects utlrp.sql
in the database?
To use Full Transportable Export/Import, 11.2.0.3
the database must be at least ___ version.
True or False: Oracle Database 12c True
supports legacy exp/imp tools to migrate
data.
Which memory area is shared by all server System Global Area (SGA)
and background processes?
Which memory area is associated with Program Global Area (PGA)
server and background processes but not
shared?
What Oracle construct contains the Redo entries or redo logs
D192 Official Flashcards
There should be at least ___ copies of the Two, three
control file; Oracle recommends ___ copies.
Archived log files can be written to as 10
many as ___ locations, either local or
remote.
True or False: An Oracle instance fails when True
one of the multiplexed control files is lost.
Which parameter enables multithreaded THREADED_EXECUTION
Oracle background processes on a Unix
information
platform? necessary to reconstruct
changes made to the database?
2/7
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Denyss. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
83750 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now