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

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

  • Full Access (98 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
You administer a RAC database that currently runs on a four-node cluster but which has three instances.
Which two statements are always true about redo logs for this RAC database? (Choose two.)
  1. A
    A thread of redo must be created before starting a fourth instance if a thread is not already available.
  2. B
    A thread of redo is automatically dropped when an instance is removed from a RAC database by using SRVCTL.
  3. C
    All the instances must have the same number of redo log groups and each group must have the same number of redo log members.
  4. D
    A redo log group added using ALTER DATABASE ADD LOGFILE without the INSTANCE clause is added to each instance.
  5. E
    A thread of redo must contain at least two log groups before it can be enabled.

Correct Answer:
AE

Question #17
Which two steps must always be performed to delete node host04 from an Oracle 19c Clusterware cluster that does not use Grid Naming Service (GNS)? (Choose two.)
  1. A
    Run the crsctl unpin css - host04 command as root on host01, or on either host02 or host03.
  2. B
    Run the crsctl delete node -n host04 command as root on host04.
  3. C
    Run the crsctl delete node -n host04 command as root on host01, or on either host02 or host03.
  4. D
    Run the crsct1 unpin css - host04 command as root on host04.
  5. E
    Run the rootcrs.pl -deconfig -force command as root on host04.
  6. F
    Run the rootcrs.pl -deconfig -force command as root on host01, or on either host02 or host03.

Correct Answer:
CE

Question #18
Which three statements are true about services and load balancing for Oracle 19c clients connecting to Oracle 19c RAC database instances? (Choose three.)
  1. A
    Services support the balancing of client connections across RAC database instances.
  2. B
    In server-side load balancing, node listener redirects the client to another node listener for connection to an instance.
  3. C
    Load balancing can be done by the client or the listener, but not both, for any one connection request.
  4. D
    Client-side connect-time load balancing can balance connection requests across SCAN listeners.
  5. E
    Load balancing can be done by the client, the listener, or both, for any one connection request.

Correct Answer:
ADE

Question #19
Which three statements are true regarding multitenant architecture for RAC databases? (Choose three.)
  1. A
    One UNDO tablespace for each PDB is required.
  2. B
    PDBs can have local temporary tablespaces.
  3. C
    You can open one, several, or all PDBs on one, several, or all CDB instances.
  4. D
    It requires the CDB to use shared UNDO management.
  5. E
    One UNDO tablespace for each instance is required.
  6. F
    PDBs must use shared Temporary tablespace.

Correct Answer:
BCD

Question #20
Which two statements are true about v$asm- views in a clustered environment? (Choose two.)
  1. A
    They exist in both ASM and RDBMS instances, but they can display different outputs depending on the instance type.
  2. B
    Their names can be seen in v$fixed_table when connected to an instance of any type that is started.
  3. C
    Their names can be seen in dict when connected to an ASM instance.
  4. D
    gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.
  5. E
    They exist in both ASM and RDBMS instances, and display the same output.

Correct Answer:
AD

Previous Questions Next Questions

All Pages