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

Oracle 1z0-053 Exam Practice Questions (P. 3)

  • Full Access (706 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 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 parameter is 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 #22
Users are connected to a database instance that is using Automatic Storage Management (ASM). The DBA executes the command as follows to shut down the
ASM instance:
SQL> SHUTDOWN IMMEDIATE;
What happens to the database instance?
  1. A
    It shuts down long with the ASM instance.
  2. B
    It is aborted and the ASM instance shuts down normally.
  3. C
    It stays open and SHUTDOWN command for the ASM instance fails.
  4. D
    It shuts down only after all pending transactions are completed and the ASM instance waits for this before shutting down.

Correct Answer:
C
IMMEDIATE or TRANSACTIONAL Clause (link)
Oracle ASM waits for any in-progress SQL to complete before performing an orderly dismount of all of the disk groups and shutting down the Oracle ASM instance. Oracle ASM does not wait for users currently connected to the instance to disconnect. If any database instances are connected to the Oracle ASM instance, then the SHUTDOWN command returns an error and leaves the Oracle ASM instance running. Because the Oracle ASM instance does not contain any transactions, the TRANSACTIONAL mode behaves the same as IMMEDIATE mode.

Question #23
Examine the following ALTER command;
SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;
What is the purpose of the command?
  1. A
    It cancels all pending disk drops within the disk group.
  2. B
    It adds previously dropped disks back into the disk group.
  3. C
    It restores disks that are being dropped as the result of a DROP DISKGROUP operation.
  4. D
    It mounts disks in the disk group for which the drop-disk operation has already been completed.
  5. E
    It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed.

Correct Answer:
A
The key point is PENDING.

Question #24
A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows:
SQL> CREATE DISKGROUP dgroup1 NORMAL REDUNDANCY
FAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2'
FAILGROUP controller2 DISK '/devices/diskb1', '/devices/diskb2';
What happens when the whole CONTROLLER1 Failure group is damaged?
  1. A
    The transactions that use the disk group will halt.
  2. B
    The mirroring of allocation units occurs within the CONTROLLER2 failure group.
  3. C
    The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered.
  4. D
    The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.

Correct Answer:
C

Question #25
Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.
Which tool or utility would you use to start the listener?
  1. A
    Oracle Net Manager
  2. B
    Listener Control utility
  3. C
    Database Configuration Assistant
  4. D
    Oracle Net Configuration Assistant

Correct Answer:
B

Question #26
What are three benefits of using ASM? (Choose three.)
  1. A
    Ease of disk administration and maintenance
  2. B
    Load balancing across physical disks
  3. C
    Software RAID-1 data redundancy with double or triple mirrors
  4. D
    Automatic recovery of failed disks

Correct Answer:
ABC

Question #27
What components are present in an ASM instance? (Choose three.)
  1. A
    SGA
  2. B
    Database processes
  3. C
    Database datafiles
  4. D
    Control files
  5. E
    Database parameter file or SPFILE

Correct Answer:
ABE

Question #28
Which of the following is a benefit of ASM fast disk resync?
  1. A
    Failed disks are taken offline immediately but are not dropped.
  2. B
    Disk data is never lost.
  3. C
    By default, the failed disk is not dropped from the disk group ever, protecting you from loss of that disk.
  4. D
    The failed disk is automatically reformatted and then resynchronized to speed up the recovery process.
  5. E
    Hot spare disks are automatically configured and added to the disk group.

Correct Answer:
A
ASM Fast Mirror Resync

Question #29
What is the result of increasing the value of the parameter ASM_POWER_LIMIT during a rebalance operation?
  1. A
    The ASM rebalance operation will likely consume fewer resources and complete in a shorter amount of time.
  2. B
    The ASM rebalance operation will consume fewer resources and complete in a longer amount of time.
  3. C
    The ASM rebalance operation will be parallelized and should complete in a shorter amount of time.
  4. D
    There is no ASM_POWER_LIMIT setting used in ASM.
  5. E
    None of the above

Correct Answer:
C

Question #30
What is the default AU size of an ASM disk group? What is the maximum AU size in an ASM disk group?
  1. A
    100KB default, 10TB maximum
  2. B
    256KB default, 1024MB maximum
  3. C
    10MB default, 126PB maximum
  4. D
    64KB default, 1EB maximum
  5. E
    1MB default, 64MB maximum

Correct Answer:
E
The AU size is determined at creation time with the allocation unit size (AU_SIZE) disk group attribute. The values can be 1, 2, 4, 8, 16, 32, and 64 MB.

Previous Questions Next Questions

All Pages