1z0-160 | how many questions of 1z0-160 vce?
Q31. How would you enable a port persistently to keep communication open through that port always?
A. To enable a port persistently, you must contact your DBaaS support team to update the port specifications for use.
B. You can use server certificates to map a server’s identity to enable persistent connection through a port to DBaaS instances.
C. All ports that are available in DBaaS servers must use an SSH tunnel and cannot be enabled persistently.
D. To enable a port persistently, you would require access to the Compute Cloud Service Console to open the ports to a set of IP addresses.
Answer: A
Q32. You created a Database as a Service (DBaaS) instance. This action also created a virtual machine and configured it for the DBaaS instance. It also created two user accounts. One of the users is oracle.
What three functions can the oracle user perform?
A. Grant privileges and roles to database users.
B. Create database users.
C. Back up and recover databases.
D. Create tablespaces.
E. Reboot a VM.
F. Use thesudocommand to perform root user access operations.
Answer: A,B,C
Explanation:
oracle is the Oracle Database administrator account you use to access the system and perform non-root database administration tasks. A home directory, /home/oracle, is created forthis user. This user cannot use the sudo command to perform operations that require root-user access. Additionally, by default you cannot connect as this user to the compute node using SSH. You can add the public key to the user’s $HOME/.ssh/authorized_keys file to grant persistent SSH access, or you can connect as the opc user and then use the sudo -s command to start a root-user command shell, followed by an su - oracle command to switch to the oracle user.
Q33. Which statement is true about the Database as a Service (DBaaS) instances and Database instances in Oracle Public Cloud?
A. An Oracle database instance can support only one DBaaS instance.
B. A DBaaS instance can support only one Oracle database instance.
C. An Oracle database instance can support multiple DBaaS instances.
D. A DBaaS instance runs in a pluggable database (PDB), which is contained in a multi- tenant container database (CDB).
E. A DBaaS instance can support multiple Oracle database instances.
Answer: E
Explanation:
References:http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/sscs/ProvisionDB/SOACS_prereq%20_DBCS.html
Q34. You want to make sure that your database administrators have a convenient way to monitor your DBaaS instance. To do so, you need to enable the Oracle DBaaS Monitor.
How would you enable the Oracle DBaaS Monitor?
A. Use theenable_dbaas_monitorcommand.
B. Create an SSH tunnel to port 443.
C. Disable theora_p2_httpsslsecurity rule in Oracle Compute Cloud Service Console.
D. Use the Oracle GlassFish Server Administration Console.
E. Add ODBM access to each DBA’s user profile.
Answer: B
Explanation:
To access Oracle DBaaS Monitor when the HTTPS port is blocked, you must create an SSH tunnel to port 443 on the compute node hosting the DBaaS Monitor.
Note:How you access Oracle DBaaS Monitor depends on whether the HTTPS port (443) hasbeen unblocked. When a Database Cloud Service deployment is first created, theHTTPS port is blocked to ensure network security
Q35. Which three statements are true about SSH tunnels in a Database as a Service (DBaaS) Cloud configuration?
A. A separate SSH tunnel is required for each port that is required for the environment.
B. The SSH tunnel should include all required portsfor the environment.
C. The available protocols include ssh-2 DSA.
D. The default protocol is ssh-1 RSA.
E. The SSH tunnel is opened automatically by the Cloud Services VPN and remains open.
F. The SSH tunnel must be opened manually and must remain open.
Answer: A,C,F
Explanation:
Incorrect Asnwes:
B: You can only specify the source port, and the destination port. D: The default protocol is ssh-2 RSA-
References:http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/javaservice/JCS/JCS_SSH/create_sshkey.html
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/create-ssh-tunnel.html
Q36. Which statement is true about Database Schema Service and Database as a Service in Oracle Public Cloud?
A. Database Schema Service requires no database administrators to administer the database.
B. Database as a Service (DBaaS) requires no database administrators to administer thedatabase.
C. Database as a Service (DBaaS) provides complete database instances with shared control between the subscriber DBA and Oracle Support.
D. Database Schema Service provides database schemas with shared control between the subscriber DBA andOracle Support.
Answer: C
Q37. Which three statements are true about the Oracle Cloud Service storage volumes that are created as part of a Database as a Service (DBaaS) instance in Oracle Public Cloud?
A. The database data file storage and tempfile storage are placed on the same storage volume.
B. The database backup storage and redo log storage are placed on the same storage volume.
C. The Oracle database product software storage and the database data file storage are placed on the same storage volume.
D. The database backup storage and database product software storage are placed on different storage volumes.
E. The database data file storage and redo log storage areplaced on different storage volumes.
Answer: A,D,E
Explanation:
Compute Cloud Service Storage Volumes
When a Database Cloud Service deployment is created using the Oracle Database Cloud Service service level, the following storage volumes are created.
References:Using Oracle Database Cloud Service (February 2021), page A-3 http://docs.oracle.com/cloud/latest/dbcs_dbaas/CSDBI/CSDBI.pdf
Q38. Which are two of the tasks that must be performed to enable SQL*NET access for your DBaaS database instance over SSL?
A. You must open a port on the virtual machine (VM) that is hosting the instance.
B. You use Net Manager (NETMGR) to configure a database alias and set the connect string.
C. You use Oracle Connection Manager to configure the required network settings.
D. You must configure SSL support on the instance.
Answer: A,B
Explanation:
SQL*Net is Oracle's remote data access protocol that enables client-server and server- server communications across networks.
An Oracle client connects to the server using the port address of the listener, which is normally defined as TCP port 1521 during Oracle installation.
Oracle Net Manager is a utility used for configuring SQL*Net.
References:http://www.orafaq.com/wiki/Net_Manager
Q39. Which two statements are true about the sequence of steps that are performed when creating a Database as a Service (DBaaS) instance in Oracle Public Cloud?
A. A Secure Shell (SSH) key is provided by Oracle for accessing the DBaaS environment as the first step in creating a DBaaSinstance.
B. The billing frequency depends on the Oracle database software edition that is selected for the DBaaS instance.
C. The public SSH key is provided when configuring the database in the DBaaS instance.
D. Storage configuration must be selected forthe DBaaS instance.
E. The database that is configured may be an Oracle 11g database.
Answer: A,E
Explanation:
E: Onwizard Software Release page page to select the Oracle Database software release that you want to run on your instance.
Note: When you create a database instance, you use the Create Database Cloud Service wizard, which steps you through the process of making the choices that produce a service instance tailored to your needs. These choices include:
Q40. 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 three should you check and possibly reconfigure to avoid the need to scale up the DBaaS instance?
A. Check the shares allocated only to the consumer group in the non-CDB that is used by the poorly performing application.
B. Check the shares allocated to all consumer groups in the non-CDB.
C. Check the CDB plan to configure the shares allocated to all PDBs, including the PDB that contains the two poorly performing applications.
D. Check the PDB plan for the PDB that is hosting the two poorly performing applications.
E. Check the CDB plan only to configurethe shares allocated to the PDB that contains the two poorly performing applications.
F. Check the PDB plan for all the PDBs in the CDB, including the PDB that is hosting the two poorly performing applications.
Answer: A,D,E
Explanation:
References:https://docs.oracle.com/database/121/ADMIN/cdb_dbrm_em.htm