Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-034

Oracle 1z0-034 Exam Practice Questions (P. 5)

  • Full Access (148 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #21
Which three statements are true about windows?
  1. A
    Only one window can be open at any given time
  2. B
    Consumer groups are associated with windows
  3. C
    Windows work with job classes to control resource allocation
  4. D
    The database service name must be provided during windows creation
  5. E
    Windows can automatically start job or change resource allocation among jobs for various time periods.

Correct Answer:
ACE

Question #22
Note the following statements that use flashback technology:
1. FLASHBACK TABLE <table> TO SCN <scn>;
2. SELECT * FROM <table> AS OF SCN 123456;
3. FLASHBACK TABLE <table> TO BEFORE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>;
5. SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999;
Which of these statements will be dependent on the availability of relevant undo data in the undo segment?
  1. A
    1, 2, and 5
  2. B
    1, 3, and 4
  3. C
    2, 3, 4, and 5
  4. D
    1, 2, 3, 4, and 5

Correct Answer:
A
The BEFORE DROP clause uses Recycle Bin;
The FLASHBACK DATABASE uses flashback logs at FRA area.

Question #23
View the Exhibit and examine the parameter settings in your server-side parameter file (SPFILE). When you tried to start the database instance, you received the following error:

SQL> startup -
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information
Why did the instance fail to start?
Exhibit:

  1. A
    Because the PGA_AGGREGATE_TARGET parameter is not set
  2. B
    Because the STATISTICS_LEVEL parameter is set to BASIC
  3. C
    Because MEMORY_TARGET and MEMORY_MAX_TARGET cannot be equal
  4. D
    Because both the SGA_TARGET and MEMORY_TARGET parameters are set.

Correct Answer:
B
Setting SGA Target Size -
You enable the automatic shared memory management feature by setting the SGA_TARGET parameter to an on zero value. This parameter sets the total size of the SGA. It replaces the parameters that control the memory allocated for a specific set of individual components, which are now automatically and dynamically resized (tuned) as needed.
Note:
The STATISTICS_LEVEL initialization parameter must be set to TYPICAL (the default) or ALL for automatic shared memory management to function.

Question #24
Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.)
  1. A
    An ASM instance mounts an ASM control file
  2. B
    An ASM instance uses the ASMB process for rebalancing of disks within a disk group
  3. C
    Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameters not set explicitly
  4. D
    An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

Correct Answer:
CD

Question #25
You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is (jetting filled up very fast and it is running out of space. Your database flash recovery area is low on specie and you have no more room on disk.
Proactively, which two options could you use to make more space available in the flash recovery [Choose two]
  1. A
    Change the RMAN archived log deletion policy.
  2. B
    Use the RMAN CROSSCHECK command to reclaim the archived log space.
  3. C
    Change the RMAN retention policy to retain backups for a shorter period of time.
  4. D
    Use OS command to move files from the flash recovery area to some other location

Correct Answer:
BD

Previous Questions Next Questions

All Pages