Exam (elaborations)
D192 Lesson 1 Exercise With Complete Solutions 2024
- Course
- Institution
D192 Lesson 1 Exercise With Complete Solutions 2024
[Show more]
Seller
Follow
Content preview
10/11/24, 8:32 AMD192 Lesson 1 Exercise
Jeremiah
Terms in this set (21)
Which of the following ODI Studio Operator
navigators manages and monitors data
integration processes in production?
Which of the following tools enables you SQL*Plus
to create, manage, and monitor CDBs and
PDBs?
LGWR
Which background process guarantees that
committed data is saved even when the The log writer (LGWR) process writes the redo log buffer information to the online
changes have not been recorded in data redo log files.
files? - A commit operation is completed only after the redo buffer is written to online
redo log files.
Which of the following primary structures is Elements
known as the abstract mapping structure?
Which statement is true? B: A database must have at least one control file.
A: A database can have only one control The control file is the most key file in an Oracle database. Due to its importance, it is
file. a good practice to have two more copies of the file. A database must have at least
B: A database must have at least one one control file to start the database.
control file.
C: A database may have zero or more
control files.
D: A database must have at least two
control files.
Choose two SGA structures that are A: Buffer cache
required in every Oracle instance. B: Shared pool
A: Buffer cache Database buffer cache, shared pool, and log buffer are required; they are
B: Shared pool configured automatically in every instance.
D192 Lesson 1 Exercise
1/5
, 10/11/24, 8:32 AM
A: ARCn
B: MMAN
MMON (Manageability Monitor) captures the AWR database and performs ADDM
From the following list, choose two analysis.
processes that are optional in an Oracle
Database 12c database. MMNL (Manageability Monitor Lite) performs tasks related to active session-history
sampling and metrics computation.
A: ARCn
B: MMAN The ARCn (Archiver) process is responsible for writing redo log copies to the archive
C: MMON log location. This process is enabled only when the database is running in
D: MMNL ARCHIVELOG mode.
MMAN (Memory Manager) is responsible for resizing the memory components when
required. This process is active only when Automatic Memory operations are
configured.
Which of the following provides an C: Version Management
interface to manage, safeguard, and
replicate revisions of units of work?
A: Load Balancing
B: Changed Data Capture
C: Version Management
D: Knowledge Modules
User John has updated several rows in a C: Does nothing.
table and issued a commit. What does the
DBWn (database writer) process do at this When a user issues a commit, the LGWR process makes sure the redo log buffer is
time in response to the commit event? written to the online redo log files. Database writer takes no action against the
commit event.
A: Writes the changed blocks to redo log
files.
B: Writes the changed blocks to data files.
C: Does nothing.
D: Triggers checkpoint and thus LGWR
writes the changes to redo log files.
Which of the following is the proper order A: Operating-system block, database block, extent, segment
of Oracle's storage hierarchy, from smallest
to largest? Multiple operating-system blocks make up database blocks, contiguous chunks of
which make up extents. A segment consists of one or more extents.
A: Operating-system block, database
block, extent, segment
B: Segment, extent, database block,
operating-system block
C: Segment, database block, extent,
operating-system block
D: Operating-system block, database
block, segment, extent
2/5
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 $10.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