Regular Free Updates 1z1-078 Dumps Real Exam Questions Test Engine Feb 24, 2024 [Q35-Q59]

NO.35 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?

NO.36 Which two statements are true concerning Oracle 19c Clusterware-managed application VIPs? (Choose two.)

NO.37 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.)

NO.38 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.)

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

NO.40 Your four-node cluster runs Oracle 19c Clusterware and supports a mix of RAC databases from Oracle 10g Release 2 to Oracle 19c.
All databases have one or more services defined.
The Oracle 10g Release 2 database clients connect to the database instances using the public VIP.
The Oracle 11g Release 2, 12c Release 1, and 19c clients connect to the database instances using the Single Client Access Name (SCAN).
You must change the public VIPs.
Which three actions must be performed to change the VIPs on host01, the first node in the cluster? (Choose three.)

NO.41 Which four statements are true concerning the upgrading of Oracle Grid Infrastructure 19c? (Choose four.)

NO.42 Which three statements are true about ASM Cloud File System (ACFS) auditing? (Choose three.)

NO.43 Which two statements are true about load balancing using a database service in a RAC environment? (Choose two.)

NO.44 Examine this command:

Which two statements are required for this command to succeed? (Choose two.)

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

NO.46 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.)

NO.47 You support a RAC database with these characteristics:
1. There are six instances.
2. Server Pool prod has a maximum of four servers.
3. CRM is a policy managed, uniform service using Server Pool prod.
4. ERP is a policy managed, singleton service using Server Pool prod.
5. Grid infrastructure is installed and running in its default configuration.
Which four benefits are provided by this configuration in Oracle 19c? (Choose four.)

NO.48 Which two statements are true about v$asm- views in a clustered environment? (Choose two.)

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

NO.50 Which two statements are true about server categorization in Oracle 19c Clusterware? (Choose two.)

NO.51 Which two statements are true about Oracle Clustered ASM performance? (Choose two.)

NO.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?

NO.53 Which two statements are true about initialization parameters for Clustered ASM instances? (Choose two.)

NO.54 Oracle Clusterware manages an administrator-managed database service defined with the MANUAL management policy.
Which two statements are true? (Choose two.)

NO.55 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?

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

NO.57 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.)

NO.58 Which three statements are true about Quality of Service Management (QoS)? (Choose three.)

NO.59 Which two statements are true regarding the default service that is automatically created upon PDB creation in a RAC database environment? (Choose two.)