Oracle 1z0-160 Exam Practice Questions (P. 2)
- 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 #6
How would you enable a port persistently to keep communication open through that port always?
- ATo enable a port persistently, you must contact your DBaaS support team to update the port specifications for use.
- BYou can use server certificates to map a server’s identity to enable persistent connection through a port to DBaaS instances.
- CAll ports that are available in DBaaS servers must use an SSH tunnel and cannot be enabled persistently.
- DTo enable a port persistently, you would require access to the Compute Cloud Service Console to open the ports to a set of IP addresses.
Correct Answer:
A
A
send
light_mode
delete
Question #7
is a command-line interface for managing a database instance on cloud. dbaascli
Which two functions can you manage with dbaascli?
Which two functions can you manage with dbaascli?
- Arunning health checks on your database
- Bcreating users in the database instance
- Crestoring from the most recent backup
- Dcreating a database instance
- Eapplying a patch
Correct Answer:
CE
The dbaascli utility is provided on Oracle Database Cloud Service deployments to perform a variety of life-cycle and administration operations.
Using the dbaascli utility, you can perform operations like:
* Database recovery
The orec latest subcommand restores the most recent backup and performs complete recovery.
* Patching the database deployment
The dbpatchm apply subcommand applies the patch.
*Changing the password of the SYS user
* Checking the status of the Oracle Data Guard configuration
* Switchover and failover in an Oracle Data Guard configuration
* Rotating the master encryption key
References:
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/dbaascli.html
CE
The dbaascli utility is provided on Oracle Database Cloud Service deployments to perform a variety of life-cycle and administration operations.
Using the dbaascli utility, you can perform operations like:
* Database recovery
The orec latest subcommand restores the most recent backup and performs complete recovery.
* Patching the database deployment
The dbpatchm apply subcommand applies the patch.
*Changing the password of the SYS user
* Checking the status of the Oracle Data Guard configuration
* Switchover and failover in an Oracle Data Guard configuration
* Rotating the master encryption key
References:
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/dbaascli.html
send
light_mode
delete
Question #8
Which statement is true about the Database as a Service (DBaaS) instances and Database instances in Oracle Public Cloud?
- AAn Oracle database instance can support only one DBaaS instance.
- BA DBaaS instance can support only one Oracle database instance.
- CAn Oracle database instance can support multiple DBaaS instances.
- DA DBaaS instance runs in a pluggable database (PDB), which is contained in a multi-tenant container database (CDB).
- EA DBaaS instance can support multiple Oracle database instances.
Correct Answer:
E
References:
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/sscs/ProvisionDB/SOACS_prereq%20_DBCS.html
E
References:
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/sscs/ProvisionDB/SOACS_prereq%20_DBCS.html
send
light_mode
delete
Question #9
Which two statements are true about the information that you see on the Database Cloud Service page?
- AIt shows the date the instance was last accessed.
- BIt shows the number of active sessions for each instance in your domain.
- CIt shows the total memory for all instances in your domain.
- DIt lists the memory for each instance in your domain.
- EIt shows the name of each database instance.
Correct Answer:
CE
The Oracle Database Cloud Service Services page displays all deployments on Oracle Database Cloud Service.
Use the Oracle Database Cloud Service Services page to perform the following tasks:
✑ Viewing All Database Deployments
✑ Creating a Database Deployment
✑ Viewing Detailed Information for a Database Deployment
Deleting a Database Deployment -
The Activity page displays activities for all Oracle Database Cloud Service deployments in your identity domain.
Example:

References:
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/sscs/ProvisionDB/SOACS_prereq%20_DBCS.html https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/service-console-services-page.html
CE
The Oracle Database Cloud Service Services page displays all deployments on Oracle Database Cloud Service.
Use the Oracle Database Cloud Service Services page to perform the following tasks:
✑ Viewing All Database Deployments
✑ Creating a Database Deployment
✑ Viewing Detailed Information for a Database Deployment
Deleting a Database Deployment -
The Activity page displays activities for all Oracle Database Cloud Service deployments in your identity domain.
Example:

References:
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/sscs/ProvisionDB/SOACS_prereq%20_DBCS.html https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/service-console-services-page.html
send
light_mode
delete
Question #10
Which statement is true about the Oracle software releases that are currently supported in a Database as a Service (DBaaS) instance in Oracle Public Cloud?
- AAll versions and releases of Oracle Database 12c are supported.
- BAll versions and releases of Oracle Database 11g are supported.
- COracle Database 11g Release 2 is supported.
- DOracle Database 12c is supported but only for single container databases.
Correct Answer:
C
11g Release 2 and 12c Release 1 (and 2) are supported.

References:
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/dbaas/obe_dbaas_creating_an_instance/obe_dbaas_creating_an_instance.html
C
11g Release 2 and 12c Release 1 (and 2) are supported.

References:
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/dbaas/obe_dbaas_creating_an_instance/obe_dbaas_creating_an_instance.html
send
light_mode
delete
All Pages