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. 4)

  • 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 #16
View the Exhibit to observe the error.

You receive this error regularly and have to shutdown the database instance to overcome the error. AutomaticShared Memory Management is configured for the instance.
What can you do to reduce the chance of this error in the future?
  1. A
    Increase the value of SGA_MAX_SIZE
  2. B
    Enable automatic memory management
  3. C
    Set the PRE_PAGE_SGA parameter to true
  4. D
    Lock the System Global Area (SGA) in memory

Correct Answer:
B
ORA-04031: unable to allocate string bytes of shared memory ("string","string","string","string")
Cause: More shared memory is needed than was allocated in the shared pool or Streams pool.
Action: If the shared pool is out of memory, either use the DBMS_SHARED_POOL package to pin largepackages, reduce your use of shared memory, or increase the amount of available shared memory byincreasing the value of the initialization parametersSHARED_POOL_RESERVED_SIZE andSHARED_POOL_SIZE. If the large pool is out of memory, increase the initialization parameterLARGE_POOL_SIZE. If the error is issued from an Oracle Streams or XStream process, increase theinitialization parameter STREAMS_POOL_SIZE or increase the capture or apply parameter MAX_SGA_SIZE.

Question #17
Which are the two prerequisites before setting up Flashback Data Archive? (Choose two.)
  1. A
    Flash recovery area must be defined
  2. B
    Undo retention guarantee must be enabled.
  3. C
    Database must be running in archivelog mode.
  4. D
    Automatic undo management must be enabled.
  5. E
    The tablespace in which the Flashback Data Archive is created must have automatic segment spaceManagement (ASSM).

Correct Answer:
DE

Question #18
Given below are RMAN commands to enable backup optimization and set the retention policy:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;
RMAN> CONFIGURE BACKUP OPTIMIZATION ON;
RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
The USERS tablespace has never been backed up. You take the USERS tablespace offline on Monday. Viewthe Exhibit to examine the operations performed by using RMAN.
Which two statements are true about the backup of the USERS tablespace? (Choose two.)

  1. A
    It will be backed up as a part of database backup on Friday.
  2. B
    It will be backed up as a part of database backup on Tuesday.
  3. C
    It will not be backed up as a part of database backup on Wednesday.
  4. D
    The command on Sunday deletes the backup of the USERS tablespace taken on Tuesday.

Correct Answer:
BD
Refer to here.
Backup Optimization for SBT Backups with Redundancy Retention Policy

Question #19
View the Exhibit.


You must unload data from the ORDERS, ORDER_ITEMS, and products database tables to four files using the External Table Population method.
You execute the command shown on the exhibit, but only two files have been created.
Which parameter must be changed so that four files are created?
  1. A
    TYPE
  2. B
    LOCATION
  3. C
    PARALLEL
  4. D
    DEFAULT DIRECTORY
  5. E
    ORGANIZATION EXTERNAL

Correct Answer:
C

Question #20
Which option must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?
  1. A
    New channels for restore and recovery tasks
  2. B
    New name for the data files of the tablespace
  3. C
    Auxiliary name for the data files of the tablespace
  4. D
    Auxiliary destinations for an auxiliary set of data files

Correct Answer:
D

Previous Questions Next Questions

All Pages