1z0-160 | The Refresh Guide To 1z0-160 examcollection
Q1. You want to perform an on-demand backup. Which two statements are true?
A. Connect to the instance’s VM as theopcuser.
B. Connect to the instance’s VM as theoracleuser.
C. Disable the backup configuration (crontab).
D. Enable the backup configuration (crontab).
Answer: A,D
Explanation:
A:Creating an On-Demand Backup by Using the bkup_api Utility
You can use the bkup_api utility to create an on-demand backup of a databasedeployment hosting a single-instance database or an Oracle Data Guard configuration.
D: If some activity you want to perform requires you to temporarily disable regularly scheduledbackups, you can do so by removing the scheduling information from the system-wide /etc/crontab file.
References: Using Oracle Database Cloud Service (February 2021), 6-4 https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf
Q2. A key pair is required to create a DBaaS instance. What can the key pair be used for?
A. They key pair is used to start up, shut down, and manage EM Expressavailability.
B. The keys are used to control the encryption that is used by DBaaS database instances: the first is for network encryption and the second is for database encryption.
C. The keys replace password use. DBaaS instance use only key pairs;password authentication is not enable for SSH default connections.
D. Communication between instances in a DBaaS account is controlled by network access rules and network groups.
Answer: C
Explanation:
Before you create a Database Cloud Service instance you can chooseto create a Secure Shell (SSH) public/private key pair. The SSH keys are used to facilitate secure access to the compute nodes that support your database deployments.
References: Using Oracle Database Cloud Service (February 2021), 1-7 https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf
Q3. Which users are created and can be used for database and host management of your DBaaS database servers?
A. root,opcandoracleusers
B. root,oracleandcloudusers
C. rootandoracleusers
D. opcandoracleusers
E. cloudandoracleusers
Answer: D
Explanation:
Linux user accounts that are provisioned on an Oracle Database Cloud Service deployment that hosts an Oracle Real Application Clusters (Oracle RAC) database:
* opc
The system administrator account you use to connect to the compute node using SSH. This user can use the sudo command to perform operations that require root-user access.
* oracle
The Oracle Database administrator account you use to access the system and perform non-root database administration tasks.
* grid
The Oracle Grid Infrastructure administrator account you use to perform ASM, ACFS, and clusterware administration tasks.
* root
The root administrator for the system. You do not have direct access to this account. To perform operations that require root-user access, use the sudo command as the opc user.
References:https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/linux-user-accounts-rac.html
Q4. You get complaints from users of several different applications that performance has degraded over time.
These applications run in this configuration:
A check of wait events for the sessions belonging to these applications shows that the sessions are waiting longer and that there are more sessions from other applications in the same database instance.
You wish to avoid scaling up your Database as a Service (DBaaS) instance in Oracle Cloud.
Which four should you check and possibly reconfigure to avoid the need to scale up the DBaaS instance?
A. Modify the users that are using each application so that their sessions are associated with the correct consumer group in the PDB that is hosting their application.
B. Check the CDB plan to configure the shares allocated to all PDBs, including the PDBs that containthe two poorly performing applications.
C. Check the CDB plan only to configure the shares allocated to the PDBs that contain the two poorly performing applications.
D. Create separate consumer groups for the sessions for all applications in the PDB plansfor the PDBs that are hosting the two poorly performing applications.
E. Check the PDB plan for all the PDBs in the CDB, including the PDB that is hosting the two poorly performing applications.
F. Create a PDB plan for each PDB in the CDB that has poorlyperforming applications.
G. Create a separate CDB plan for each PDB that has poorly performing applications.
Answer: A,B,D,F
Q5. You are migrating an Oracle Database 11.2.0.2 on-premise database to an Oracle Database Cloud Service (Database as a Service) that provides a pre-created Oracle Database 11.2.0.4 database.
Which two migration methods are possible?
A. Data Pump Transportable Database (TDB) export/import
B. Remote Cloning
C. Data Pump Transportable Tablespace (TTS) export/import
D. RMAN Transportable Tablespace (TTS)
Answer: C,D
Explanation:
You canmigrate an on-premises source database to the database deployment on Oracle Database Cloud Service using the Data Pump Transportable Tablespace(TTS)method. You canmigrate an on-premises source database to a database deployment on Oracle Database Cloud Service using the RMAN Transportable Tablespace(TTS)with Data Pump method.
Q6. You want all your colleagues to be able to access the compute node associated with an
Oracle Database Cloud – Database as a Service (DBaaS) instance. You want them to do so by using a custom host name rather than an IP address regardless of the client machine (personal or provided by the company) that they use for the access.
How would you enable this access?
A. Configure the Advanced Security Option (ASO).
B. Enable secure access to the DBaaS instance VM and database instance from remote hosts by using SSH.
C. Contact the administrator of your company’s intranet DNS and request a custom DNS record for the compute node’s public IP address.
D. Edit the machine’s/etc/hostsfile.
E. Resolve your domain name to the IP address of the DBaaS compute node by using the third-party domain registration vendor console.
Answer: C
Explanation:
You can associate a custom host name or domain name to the public IP address of a compute node associated with your Oracle Database Cloud Service environment.
To associate a custom host name to the public IP address of a compute node, contact the administrator of your DNS (Domain Name Service) and request a custom DNS record for the compute node’s public IP address. For example, if your domain is example.com and you wanted to use clouddb1 as the custom host name for a compute node, you would request a DNS record that associates clouddb1.example.com to your compute node's public IP address.
References:https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/define-custom-host-or-domain-name.html
Q7. You want to perform database recovery with the most recent backup. Which command would you execute?
A. dbaascli rec –args –latest
B. dbaascli orec –args-latest
C. dbaascli rec –args -last
D. dbaascli orec –args -last
Answer: B
Explanation:
dbaascliorec latest command restores the most recent backup and performs complete recovery.
References:https://docs.oracle.com/en/cloud/paas/database-dbaas- cloud/csdbi/dbaascli.html
Q8. You want to perform an on-demand backup. Which two statements are true?
A. Connect to the instance’s VM as theopcuser.
B. Connect to the instance’s VM as theoracleuser.
C. Disable the backup configuration (crontab).
D. Enable the backup configuration (crontab).
Answer: A,D
Explanation:
A:Creating an On-Demand Backup by Using the bkup_api Utility
You can use the bkup_api utility to create an on-demand backup of a databasedeployment hosting a single-instance database or an Oracle Data Guard configuration.
D: If some activity you want to perform requires you to temporarily disable regularly scheduledbackups, you can do so by removing the scheduling information from the system-wide /etc/crontab file.
References: Using Oracle Database Cloud Service (February 2021), 6-4 https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf
Q9. Which three are ways to scale a Database as a Service (DBaaS) instance that is hosting three Oracle 12c databases?
A. Add additional virtual network interfaces (VNICs) to the DBaaS instance.
B. Increase theMEMORY_TARGETparameter value in each database instance that is running on the DBaaSinstance.
C. Increase theCPU_COUNTparameter value in each database instance that is running on the DBaaS instance.
D. Increase the number of CPUs allocated to the DBaaS instance.
E. Add storage to the DBaaS instance.
F. Use the Oracle Database 12c In-Memory database option in each database instance that is running on the DBaaS instance.
G. Increase the memory allocated to the DBaaS instance.
Answer: D,E,G
Q10. Which three will be supported after migrating an on-premises database to a Database as a Service (DBaaS) instance on Oracle Cloud?
A. increased security of application roles
B. reduction in operational costs
C. ability to increase capacity on demand
D. provisioning of application testing
E. centralization of database management
Answer: C,D,E
Explanation:
References:https://www.oracle.com/database/solutions/private-dbaas.html