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

Oracle 1z0-068 Exam Practice Questions (P. 4)

  • Full Access (149 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
Examine this command:
SQL> CREATE DISKROUP data NORMAL REDANDUNCY:

FAILGROUP fgrpl DISK -
/dev/disk1 NAME disk1,
/dev/disk2 NAME disk2,
/dev/disk3 NAME disk3,

FAILGROUP fgrpl2 DISK -
/dev/disk4 NAME disk4,
/dev/disk5 NAME disk5,
/dev/disk6 NAME disk6,

FAILGROUP fgrpl3 DISK -
/dev/disk7 NAME disk7,
/dev/disk8 NAME disk8,
/dev/disk9 NAME disk9,
ATTRIBUTE au_size=4M,
compatible.asm = 11.2,
compatible.rdbms = 11.2,
compatible.advm = 11.2,
content_type = recovery;
Which two statements a true about this disk group, created using Grid Infrastructure 12.1?
  1. A
    Each disk in each of the three fail groups is a mirror of the corresponding disk of the other two failure groups.
  2. B
    File created in this disk group always has two copies for each allocation unit: one primary and one secondary.
  3. C
    It can contain ASM Dynamic Volume Manager (ADVM) volumes.
  4. D
    Any database instance with the COMPATIBLE parameter set to 11.2 or higher can access it.
  5. E
    The ASM compatible attributes can be changed to 11.1 for this disk group.

Correct Answer:
CD

Question #17
Which two statements are true about the UNDROP clause of the ALTER DISKGROUP statement?
  1. A
    It cancels pending drops of disks dropped using the DROP DISKGROUP command.
  2. B
    A disk cannot be undropped as a result of a drop diskgroup.
  3. C
    It automatically unmounts the disks after successfully undropping them.
  4. D
    It is not possible to cancel pending drops of disks dropped using the force option.

Correct Answer:
BD
The UNDROP DISKS clause of the ALTER DISKGROUP statement cannot be used to restore disks that are being dropped as the result of a DROP DISKGROUP statement, or for disks that are being dropped using the FORCE clause.
Reference:
https://docs.oracle.com/cd/B28359_01/server.111/b31107/asmdiskgrps.htm

Question #18
Examine the output of the asmcmd and srvct1 commands:

Then you execute this command:
$ srvctl relocate asm currentnode host03 targetnode host02
Which three statements are true regarding the execution of this command based on the output shown?
  1. A
    It fails because an ASM instance is not configured to run on HOST02.
  2. B
    It succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03.
  3. C
    It succeeds and 12c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST02.
  4. D
    It fails because the ASM instance has not been shut down first on HOST03.
  5. E
    It succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut down until all connected clients disconnected.
  6. F
    It succeeds and 12c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST01.

Correct Answer:
CEF

Question #19
Which three statements are true about ASM Cloud File System (ACFS) encryption?
  1. A
    A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.
  2. B
    acfsutil encr init is used to establish role separation between encryption managers and encryption auditors.
  3. C
    acfsutil encr off can be run by an encryption manager who may not have system administrator privileges.
  4. D
    acfsutil encr on can be used to specify the encryption key length for a directory or file.
  5. E
    An ACFS snapshot can be ACFS encrypted.

Correct Answer:
ADE
acfsutil encr on k key_length specifies the encryption key length for a directory or file.
Incorrect Answers:
B: The acfsutil encr init command creates storage for encryption keys.
C: Only an administrator can run the acfsutil encr off command on an Oracle ACFS file system.
References:
https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmfs_util009.htm#OSTMG94010

Question #20
Which two statements are true concerning ASM diskgroups using disks with a 4k sector size?
  1. A
    Their COMPATIBLE.ASM attributes must be set to 12.1 or higher.
  2. B
    Their COMPATIBLE.ASM attributes must be set to 11.2 or higher.
  3. C
    Performance of ACFS is improved by using these diskgroups.
  4. D
    Their COMPATIBLE.RDBMS attributes must beset to 11.2 or higher.
  5. E
    Their sector size attributes can be changed using the ALTER DISKGROUP command.

Correct Answer:
BD
The values for SECTOR_SIZE can be set to 512, 4096, or 4K if the disks support those values. The default value is platform dependent. The COMPATIBLE.ASM and COMPATIBLE.RDBMS disk group attributes must be set to 11.2 or higher to set the sector size to a value other than the default value.
Incorrect Answers:
C: Oracle ASM provides support for 4 KB sector disk drives without negatively affecting performance.
Reference:
https://docs.oracle.com/database/121/OSTMG/GUID-8B656725-D347-4166-8775-1070B6C4D580.htm#OSTMG10203

Previous Questions Next Questions

All Pages