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-052

Oracle 1z0-052 Exam Practice Questions (P. 1)

  • Full Access (284 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 #1
You notice that the performance of the database has degraded because of frequent checkpoints.
Which two actions resolve the issue? (Choose two.)
  1. A
    Disable automatic checkpoint tuning
  2. B
    Check the size of the redo log file size and increase the size if it is small
  3. C
    Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor
  4. D
    Decrease the number of redo log members if there are more than one redo log members available in each redo log group

Correct Answer:
BC

Question #2
Identify the memory component from which memory may be allocated for:
Session memory for the shared serverBuffers for I/O slavesOracle Database Recovery Manager (RMAN) backup and restore operations
  1. A
    Large Pool
  2. B
    Redo Log Buffer
  3. C
    Database Buffer Cache
  4. D
    Program Global Area (PGA)

Correct Answer:
A

Question #3
You executed the following command to create a tablespace called SALES_DATA:

Which two statements are true about the SALES_DATA tablespace? (Choose two)
  1. A
    The database automatically determines the extent-sizing policy for the tablespace.
  2. B
    The segments are automatically shrunk when the contents are removed from them.
  3. C
    The allocation of extents within the tablespace is managed through the dictionary tables.
  4. D
    The space utilization description of the data blocks in segments is recorded in bitmap blocks.
  5. E
    The space utilization description of the data blocks in segments is managed through free lists.

Correct Answer:
AD

Question #4
In which of the scenario will the DBA perform recovery? (Choose all that apply.)
  1. A
    The alert log file is corrupted.
  2. B
    A tablespace is accidentally dropped.
  3. C
    One of the redo log members is corrupted.
  4. D
    A database user terminates the session abnormally.
  5. E
    The hard disk on which the data files is stored is corrupted.

Correct Answer:
BE

Question #5
You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG mode.
Given below are the steps to accomplish the task in random order:
1. Shut down the instance.
2. Execute the ALTER DATABASE ARCHIVELOG command.
3. Start up the instance and mount the database.
4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1.
5. Open the database.
Which is the correct sequence of steps for accomplishing the task?
  1. A
    4, 1, 3, 2, 5
  2. B
    1, 3, 4, 5, 2
  3. C
    1, 3, 2, 5; 4 not required
  4. D
    4, 1, 5, 2; 3 not required
  5. E
    1, 3, 4, 5; 2 not required

Correct Answer:
C

Next Questions

All Pages