4/5 - (1 vote)

[Mar-2024] 1z1-078 Exam Dumps – Free Demo & 365 Day Updates

Free Sales Ending Soon – Use Real 1z1-078 PDF Questions

Oracle 1z1-078 Exam Syllabus Topics:

Topic Details
Topic 1
  • Explain the types of patches and upgrades available
  • Explain the hivh availability components of Oracle Clusterware
Topic 2
  • Configure the RAC database to use ARCHIVELOG mode and the fast recovery area
  • Convert a single instance Oracle database to RAC
Topic 3
  • Explain how global resources are managed
  • Determine RAC-specific wait-events, global enqueues and system statistics
Topic 4
  • Perform ongoing maintenance tasks on ASM disk groups
  • Explain how ASM files, directories and aliases are created and managed
Topic 5
  • Configure server-side connect-time load balancing
  • Use DBCA to convert a single-instance database to a RAC One Node database
Topic 6
  • Optional Install for the Grid Infrastructure Management Repository
  • Install a patchset with the Oracle Universal Installer (OUI) utility
Topic 7
  • Describe the architecture and components of Flex ASM
  • Monitor ASM instances using the V$ASM dynamic performance views
Topic 8
  • Install the Oracle database software
  • Modify initialization parameters in a RAC environment
Topic 9
  • Configure client-side connect-time load balancing and failover
  • Convert an Oracle RAC One Node database to a RAC database
Topic 10
  • Describe the multitenant architecture in RAC and non-RAC environments
  • Use Automatic Database Diagnostic Monitor (ADDM) in RAC
Topic 11
  • Explain use of Affinity to reduce Global Resource Contention
  • Define undo tablespaces in a RAC environment

 

QUESTION 46
Examine the output of the asmcmd and srvctl 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? (Choose three.)

 
 
 
 
 
 

QUESTION 47
Which three events occur when a node fails in an Oracle Clusterware 19c Cluster? (Choose three.)

 
 
 
 
 

QUESTION 48
Which method should be used to convert a single-instance Oracle 19c Database to a RAC Database?

 
 
 
 

QUESTION 49
You want to create a tablespace, SALES, with these requirements:
1. Its data file has an alias name sales.dbf.
2. Its data file is stored in the directory CURRENT_YR in the disk group DATA.
Examine this command:
SQL> CREATE TABLESPACE sales;
Which two tasks must you perform to meet these requirements? (Choose two.)

 
 
 
 
 

QUESTION 50
Which three statements are true about the administration and use of policy sets in Oracle 19c Clusterware? (Choose three.)

 
 
 
 
 

QUESTION 51
Which three statements are true about the services created when the DBCA is used to create a RAC database? (Choose three.)

 
 
 
 
 

QUESTION 52
You must deploy several Oracle 19c databases on an Oracle Grid Infrastructure Managed Cluster, and are required to have the ability to perform these actions without down time:
1. Apply a Grid Infrastructure interim patch.
2. Apply a Grid Infrastructure Patch Set Update (PSU).
3. Apply a database on-line patch.
4. Apply a Grid Infrastructure patchset.
5. Apply a database patchset.
6. Upgrade Grid Infrastructure from one release to another.
7. Upgrade databases from one release to another.
Your plan is to perform these tasks:
1. Install and configure Oracle Grid Infrastructure on a local file system.
2. Install Oracle Database software on an ACFS file system.
3. Create several RAC One Node databases.
Which of the seven requirements are met by your plan?

 
 
 
 
 
 

QUESTION 53
Examine this command executed on the first node of a four-node cluster:
$ < DATABASE_ORACLE_HOME >/OPatch/opatch apply 33575673
What does this command do?

 
 
 
 
 

QUESTION 54
Which three statements are true about ASM Cloud File System (ACFS) replication? (Choose three.)

 
 
 
 
 

QUESTION 55
Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 19c when using Full Featured Grid Naming Service (GNS). (Choose three.)

 
 
 
 
 
 

QUESTION 56
Which three statements are true about accessing ASM files? (Choose three.)

 
 
 
 
 

QUESTION 57
Which two statements are true concerning diagnostic components and requirements of Oracle 19c Clusterware? (Choose two.)

 
 
 
 
 

QUESTION 58
A cluster running 19c Grid Infrastructure supports both Oracle 11g to 19c RAC databases using ASM.
The COMPATIBLE.ASM, COMPATIBLE.RDBMS, and COMPATIBLE.ADVM parameters are currently set to 11.2 for all diskgroups..
You must support these capabilities in all diskgroups:
1. ACFS Replication
2. ACFS Encryption
To what minimum values must the compatible attributes be set?

 
 
 
 
 

QUESTION 59
Which two components must always be defined or specified by an administrator to make an application highly available using Oracle 92c Clusterware? (Choose two.)

 
 
 
 
 

QUESTION 60
Which two benefits are obtained by using Affinity to reduce global resource contention? (Choose two.)

 
 
 
 
 

QUESTION 61
Examine this command and output:

Examine this command:

Which statement must be true for the successful execution of the second command?

 
 
 
 

QUESTION 62
Which statement is true about Oracle Database 19c SGA Management?

 
 
 
 

QUESTION 63
You administer a six-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1,PDB_2, and PDB_3.
Server pool prod_pool has a cardinality of three and all six hosts of the cluster are up.
Examine these commands executed on HOST01:

Which two statements are true regarding the AR service? (Choose two.)

 
 
 
 
 

QUESTION 64
Which statement is true concerning the installation of an Oracle Grid Infrastructure 19c patchset and its status during the installation?

 
 
 
 

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

 
 
 
 
 
 

QUESTION 66
Which two methods exist for enabling the collection of additional resource debugging information for specific resources controlled by Oracle 19c Clusterware? (Choose two.)

 
 
 
 

QUESTION 67
Which two commands will stop the Oracle High Availability Services (OHAS) and prevent it from starting automatically at system boot on the local node? (Choose two.)

 
 
 
 

QUESTION 68
Which two statements are true about High Availability NFS (HANFS)? (Choose two.)

 
 
 
 
 

QUESTION 69
Which two statements are true about Transparent Application Continuity in Oracle RAC 19c? (Choose two.)

 
 
 
 
 

QUESTION 70
Which three statements are true about undo management in a RAC environment? (Choose three.)

 
 
 
 
 

1z1-078 Dumps – Pass Your Certification Exam: https://www.2pass4sure.com/Oracle-Database/1z1-078-actual-exam-braindumps.html

         

Related Links: myportal.utt.edu.tt www.stes.tyc.edu.tw www.stes.tyc.edu.tw myportal.utt.edu.tt myportal.utt.edu.tt myportal.utt.edu.tt