Oracle 1z0-160 Exam Practice Questions (P. 5)
- Full Access (70 questions)
- Six months of Premium Access
- Access to one million comments
- Seamless ChatGPT Integration
- Ability to download PDF files
- Anki Flashcard files for revision
- No Captcha & No AdSense
- Advanced Exam Configuration
Question #21
A key pair is required to create a DBaaS instance.
What can the key pair be used for?
What can the key pair be used for?
- AThey key pair is used to start up, shut down, and manage EM Express availability.
- BThe 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.
- CThe keys replace password use. DBaaS instance use only key pairs; password authentication is not enable for SSH default connections.
- DCommunication between instances in a DBaaS account is controlled by network access rules and network groups.
Correct Answer:
C
Before you create a Database Cloud Service instance you can choose to 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 2017), 1-7 https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf
C
Before you create a Database Cloud Service instance you can choose to 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 2017), 1-7 https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf
send
light_mode
delete
Question #22
Which statement is true about Database Schema Service and Database as a Service in Oracle Public Cloud?
- ADatabase Schema Service requires no database administrators to administer the database.
- BDatabase as a Service (DBaaS) requires no database administrators to administer the database.
- CDatabase as a Service (DBaaS) provides complete database instances with shared control between the subscriber DBA and Oracle Support.
- DDatabase Schema Service provides database schemas with shared control between the subscriber DBA and Oracle Support.
Correct Answer:
C
C
send
light_mode
delete
Question #23
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?
DBaaS Monitor.
How would you enable the Oracle DBaaS Monitor?
- AUse the enable_dbaas_monitor command.
- BCreate an SSH tunnel to port 443.
- CDisable the ora_p2_httpssl security rule in Oracle Compute Cloud Service Console.
- DUse the Oracle GlassFish Server Administration Console.
- EAdd ODBM access to each DBA’s user profile.
Correct Answer:
B
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) has been unblocked. When a Database Cloud Service deployment is first created, the HTTPS port is blocked to ensure network security
Incorrect Answers:
C: You should enable the ora_p2_httpssl security rule, not disable it.
When a database deployment is created, the following Oracle Compute Cloud Service security rules are created, but set to a disabled status:
* ora_p2_httpssl, which controls access to port 443, the port used for HTTPS connections, including Oracle REST Data Services, Oracle Application Express, and
Oracle DBaaS Monitor.
..etc.
To enable access to a compute node port, you enable the appropriate security rule.
References:
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/access-dbaas-monitor.html
B
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) has been unblocked. When a Database Cloud Service deployment is first created, the HTTPS port is blocked to ensure network security
Incorrect Answers:
C: You should enable the ora_p2_httpssl security rule, not disable it.
When a database deployment is created, the following Oracle Compute Cloud Service security rules are created, but set to a disabled status:
* ora_p2_httpssl, which controls access to port 443, the port used for HTTPS connections, including Oracle REST Data Services, Oracle Application Express, and
Oracle DBaaS Monitor.
..etc.
To enable access to a compute node port, you enable the appropriate security rule.
References:
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/access-dbaas-monitor.html
send
light_mode
delete
Question #24
You are monitoring resource usage on your Database Cloud Service.
What two resource usage metrics can you find on the Instance Overview page?
What two resource usage metrics can you find on the Instance Overview page?
- Anumber of days left on your subscription
- Bnumber of processes allocated
- CI/O from reads and writes
- Dmemory
- Estorage
- Fnumber of current users
Correct Answer:
DE
The Overview page includes graphs that plot the data values for the top metrics for the past 7 days. The type of data collected and shown depends on the type of service. For example, for Oracle Database Cloud Service, the graphs show Storage Used and Maximum Storage Used.
DE
The Overview page includes graphs that plot the data values for the top metrics for the past 7 days. The type of data collected and shown depends on the type of service. For example, for Oracle Database Cloud Service, the graphs show Storage Used and Maximum Storage Used.
send
light_mode
delete
Question #25
You are preparing the storage volume for use in an instance.
Which two tasks must you perform?
Which two tasks must you perform?
- APoint to a mount point that has existing files and directories.
- BConnect to the DBaaS instance to which you attached the storage volume by using ssh or PuTTY as the opc user.
- CCreate a mount point on your instance.
- DConnect to the DBaaS instance to which you attached the storage volume by using ssh or PuTTY as the oracle user.
Correct Answer:
AC
To add temporary storage to a database deployment:
1. Use the Create Storage Volume wizard in the Compute Cloud Service console to create a storage volume.
2. Attach the storage volume to the Compute Cloud Service instance on which the compute node is running. When you attach the storage volume, it is assigned a disk number. Note down this disk number for later use.
3. Connect as the opc user to the compute node.
4. Start a root-user command shell
$ sudo -s #
5. Confirm the addition of the storage volume by using the ls command:
# ls /dev/xvd*
6. Create a single, primary partition that occupies the entire storage volume by using the fdisk command.
7. Create a file system on the partition by using the mkfs command.
8. Create a directory to use as the mount point for the partition by using the mkdir command.
9. Mount the partition on the directory you just created by using the mount command.
10. Set the ownership and permissions of the mount-point directory appropriately by using the chown and chmod commands.
11. Exit the root-user command shell.
References: Using Oracle Database Cloud Service (February 2017), 4-4 https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf
AC
To add temporary storage to a database deployment:
1. Use the Create Storage Volume wizard in the Compute Cloud Service console to create a storage volume.
2. Attach the storage volume to the Compute Cloud Service instance on which the compute node is running. When you attach the storage volume, it is assigned a disk number. Note down this disk number for later use.
3. Connect as the opc user to the compute node.
4. Start a root-user command shell
$ sudo -s #
5. Confirm the addition of the storage volume by using the ls command:
# ls /dev/xvd*
6. Create a single, primary partition that occupies the entire storage volume by using the fdisk command.
7. Create a file system on the partition by using the mkfs command.
8. Create a directory to use as the mount point for the partition by using the mkdir command.
9. Mount the partition on the directory you just created by using the mount command.
10. Set the ownership and permissions of the mount-point directory appropriately by using the chown and chmod commands.
11. Exit the root-user command shell.
References: Using Oracle Database Cloud Service (February 2017), 4-4 https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf
send
light_mode
delete
All Pages