Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
sale

Want to Unlock All Questions for this Exam?

Full Exam Access, Discussions, No Robots Checks

27
Students signed up in the last 24H

Oracle 1z0-078 Exam Actual Questions

The questions for 1z0-078 were last updated on May 13, 2024.
  • Viewing page 1 out of 20 pages.
  • Viewing questions 1-4 out of 77 questions
 

Topic 1 - Exam A

Question #1 Topic 1

Examine this sequence of commands:

The cluster consists of nodes HOST01, HOST02, HOST03 and HOST04, and the clusterware is running on all four nodes.
Which three statements are true about the result of the root user running these commands on HOST01? (Choose three.)

  • A. The Oracle Clusterware stack is stopped on all nodes.
  • B. The Oracle Clusterware stack is prevented from being automatically started on HOST01.
  • C. The Oracle Clusterware stack is prevented from being automatically started on all nodes.
  • D. The Oracle Clusterware stack is stopped on all nodes except HOST01.
  • E. The Oracle Clusterware stack is started on all nodes except HOST01.
  • F. The Oracle Clusterware stack is started on all nodes.
Reveal Solution Hide Solution   Discussion   5

Correct Answer: ABF 🗳️

Question #2 Topic 1

Secure Cluster Communication protects the cluster interconnect from common security threats when used together with Single Network Support. Secure Cluster Communication includes message digest mechanisms, protection against fuzzing, and uses Transport Layer Security (TLS) to provide privacy and data integrity between the cluster members.
Which statement is true about securing cluster interconnect communication?

  • A. Security for the cluster interconnect is invoked automatically as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c and Database administrators or cluster administrators do not need to make any configuration changes for this feature.
  • B. Security for the cluster interconnect is invoked automatically as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c using an auto-generated encryption key that is stored locally on each node of the cluster in an Oracle Wallet and Database administrators or cluster administrators must provide a valid path for the Wallet file.
  • C. Security for the cluster interconnect is invoked by auto-generated server certificates that will be assigned to each cluster node as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c.
  • D. Database administrators or cluster administrators must provide an encryption key during new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c to secure the interconnect communication.
  • E. Database administrators or cluster administrators must provide a valid server certificate and an Oracle Wallet for each node during new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c to secure the interconnect communication.
Reveal Solution Hide Solution   Discussion   1

Correct Answer: A 🗳️

Question #3 Topic 1

Which three resources are managed using global concurrency control in an Oracle 19c RAC multi-instance database? (Choose three.)

  • A. Database block buffers
  • B. Mutexes
  • C. Redo log buffers
  • D. Latches
  • E. Enqueues
  • F. Cursors
Reveal Solution Hide Solution   Discussion   7

Correct Answer: BDE 🗳️

Question #4 Topic 1

Examine this command:
SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1;
Which three conditions must be true for successful execution of this command on a RAC database? (Choose three.)

  • A. The source PDB must be closed on the CDB instance from where the command is executed.
  • B. The source PDB must be in READ ONLY mode on all CDB instances if the CDB is in No Archive mode.
  • C. The source PDB must use a global temporary tablespace.
  • D. It can be executed only by a common user with the CREATE PLUGGABLE DATABASE system privilege connected to the root container.
  • E. Oracle Managed Files must be enabled or PDB_FILE_NAME_CONVERT must be set.
  • F. All running CDB instances must be open in restricted mode.
Reveal Solution Hide Solution   Discussion   2

Correct Answer: ADE 🗳️

Next Questions

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel