1Z0-160 Exam Questions

Dbaascli is a command-line interface for managing a database instance on cloud. Which two functions can you manage with dbaascli?

Your Database as a Service (DBaaS) instance hosts a multitenant container database (CDB) with four pluggable database (PDB) tenants. Users of an application in one PDB and users of...

Which two can be increased to scale up the compute shape of a Database as a Service (DBaaS) instance in Oracle Cloud?

You are configuring network connections to your database instance. What does each network group represent?

Which two statements are true about the Database as a Service (DBaaS) instances and Oracle database instances that are provided by Oracle Public Cloud?

You are creating a new Database as a Service (DBaaS) instance. Which statement is true about connections that are created by default?

You get complaints from users of several different applications that performance has degraded over time. These applications run in this configuration: 1. There is one database and...

What are two things can you do on the My Services Dashboard page?

The first step to connecting to Oracle Cloud is generating an SSH key pair. To generate a key pair on a Unix or Linux machine, you would run the ssh-keygen utility. What should be...

Which three will be supported after migrating an on-premises database to a Database as a Service (DBaaS) instance on Oracle Cloud?

Which three statements are true about SSH tunnels in a Database as a Service (DBaaS) Cloud configuration?

Which three statements are true about the service levels provided by Database as a Service (DBaaS)?

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

You want to migrate an Oracle Database 11.2.0.2 on-premises database to the Oracle Database 11g database of the Database as a Service (DBaaS) instance on Oracle Cloud. A subset of...

How would you stop Oracle REST Data Services (ORDS)?

Which two statements are true about the SSH tunnels within a Database as a Service (DBaaS) Cloud environment?

You may need to create an on-demand backup of a database instance, or restore a backup. Which two steps are true about performing an on-demand backup?

You are using access rules to control network traffic among your DBaaS instances. Which statement is true about access rules?

Identify the access that is initially available to connect to your Database as a Service (DBaaS) environment.

Which two problems indicate that you should consider scaling up your Database as a Service (DBaaS) instance that hosts an Oracle Database 12c multitenant container database (CDB) w...

You wish to perform database recovery and restore the most recent backup. Which two steps will you perform?

You want to access your database over SQL*Net with a client application that is running locally on your machine. How would you enable access to port 1521 of the Compute Node (VM)?

There are two ways to enable a port to a Database as a Service (DBaaS) instance. The first requires access to the Compute Cloud Service Console to open the ports to a set of IP add...

You have an Oracle Database 11g on-premises database with encrypted tablespaces. You want to migrate this database to the pre-created database of the Database as a Service (DBaaS)...

You did not configure Backup and Recovery during instance creation. You therefore need to schedule your backup strategy with RMAN. Which two tasks would you need to perform to cust...

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?

You want to use traditional GUI tools on a Database as a Service (DBaaS) instance. You have configured PuTTY and SSH sessions. What two things would you need to configure?

Which two statements are true about the Database as a Service (DBaaS) instances and Oracle database instances that are provided by Oracle Public Cloud?

You want to make sure that Oracle Application Express (APEX) is enabled and accessible. Which two steps must you perform?

When you are using Oracle Compute Service Console and reviewing the network configuration of your database instance, what do the arrows that are shown within the Access Rules defin...

Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. The...

Which two statements are true regarding the count function?

Which two statements are true regarding single row functions?

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

With Oracle Database Cloud Service as the subscription type, you must configure a database for Backup and Recovery. Which two options do you have to back up your database instance?

Users must be granted roles to manage Cloud services. Which three statements are true about roles and role assignment in Database as a Service (DBaaS)?

Which users are created and can be used for database and host management of your DBaaS database servers?

Which two situations require that your Database as a Service (DBaaS) instance be scaled up?

How would you enable a port persistently to keep communication open through that port always?

You are on the Database Cloud Service Instance View page. Which three consoles can you open?

What are two ways to enable a port on your DBaaS VM server for access to your DBaaS instance?

A key pair is required to create a DBaaS instance. What can the key pair be used for?

Which statement is true about Database Schema Service and Database as a Service in Oracle Public Cloud?

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 e...

You are monitoring resource usage on your Database Cloud Service. What two resource usage metrics can you find on the Instance Overview page?

You are preparing the storage volume for use in an instance. Which two tasks must you perform?

You want to perform an on-demand backup. Which two statements are true?

You get complaints from users of several different applications that performance has degraded over time. These applications run in this configuration: 1. There are three different...

Which are two of the tasks that must be performed to enable SQL*NET access for your DBaaS database instance over SSL?

Which two statements are true regarding constraints?