Oracle 1z0-160 Free Practice Questions

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

• A. You would require access to the Oracle Compute Cloud Service console to open the ports to a set of IP addresses.
• B. You must contact your Oracle Database Cloud Service support team to update the port specifications for use.
• C. All ports that are available in Oracle Database Cloud Service servers must use an SSH tunnel and cannot be enabled persistently.
• D. You can use server certificates to map a server’s identity to enable persistent connection through a port to a Database Deployment’s compute nodes.

Answer: D

NEW QUESTION 2
Which three consoles can be accessed from the Oracle Database Deployment page?

• A. Database Express Manager Console
• B. OPC Console
• C. Application Express Console
• D. User Console
• E. Storage Container Console
• F. DBaaS Monitor Console

Answer: ACD

NEW QUESTION 3
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?

• A. No backups require
• B. You are responsible for configuring the database backups.
• C. Backup to cloud storage and VM block storag
• D. Ten days worth of backups are kept, with five most recent days worth of backups available directly on VM block storage.
• E. Backup to Oracle Cloud Service storage volumes that is equal to five times the value that was provided in Usable Data Storage when the instance was created.
• F. Backup to cloud storage and VM block storag
• G. Fourteen days worth of backups are kept, with seven most recent days worth of backups available directly on VM block storage.

Answer: AC

Explanation:
When creating a new database deployment on Oracle Database Cloud Service, you choose whether you want automatic backups to be configured for the database. Your choices are:
Both Cloud Storage and Local Storage—30 days' worth of backups are kept, with the 7 most recent days' worth available directly on the compute node’s local storage.
Cloud Storage Only—30 days' worth of backups are kept, with all backups on cloud storage. None—automatic backups are not configured.
References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/db-deployments.html

NEW QUESTION 4
Which two statements are true about the SSH tunnels within an Oracle Database Cloud Service environment?

• A. An individual SSH tunnel is required for each port in the environment.
• B. The client must provide the server with the SSH private key.
• C. The SSH tunnel must be selected by a security rule to enable remote access.
• D. The server must hold the SSH public and private keys in the SSH authorized_keys file.
• E. Oracle Database Cloud Service provides a centralized key server for all SSH connections.

Answer: BC

NEW QUESTION 5
Which two must be true when you migrate an Oracle Database 12.1.0.2 non-CDB to a database that is running in a Database as a Service (DBaaS) instance on Oracle Cloud by using the Remote Cloning method?

• A. The non-CDB may be opened in READ WRITE mode as long as ARCHIVELOG is enabled.
• B. The database link owner must have the CREATE PDB system privilege.
• C. The source platform must have the same endian format.
• D. The non-CDB must be in archivelog mode.
• E. The non-CDB must be opened in READ ONLY mode.
• F. The database link owner must have the CREATE PLUGGABLE DB system privilege.

Answer: EF

Explanation:
To migrate an Oracle Database 12c non-CDB database to a Database Cloud Service database deployment using the remote cloning method, you perform these tasks:
On the on-premises database host, invoke SQL*Plus and set the on-premises database to READ ONLY mode.
On the Database Cloud Service compute node, invoke SQL*Plus and create a database link that enable a connection to the on-premises database.
On the Database Cloud Service compute node, execute the CREATE PLUGGABLE DATABASEcommand to clone the on-premises non-CDB database.
On the Database Cloud Service compute node, execute
the $ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql script.
On the Database Cloud Service compute node, open the new PDB by executing the ALTER PLUGGABLE DATABASE OPEN command.
Optionally, on the on-premises database host invoke SQL*Plus and set the on-premises database back to READ WRITE mode.
You can use this method only if the on-premises platform is little endian, the on-premises database release is 12.1.1.2 or higher, and the on-premises database and Database Cloud Service database have compatible database character sets and national character sets.
References:
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/mig-remote-cloning-non-cdb.html

NEW QUESTION 6
Which two tasks can be performed to customize a backup configuration?

• A. Edit the /home/oracle/bkup/dbcfg.spec file to maintain the list of database configuration files to be backed up.
• B. Use dbms_scheduler to schedule automatic backups.
• C. Edit the /home/oracle/bkup/dbcfg.spec file to maintain the list of system files and folders to be backed up.
• D. Use the bkup_api utility as the oracle user to configure a retention period.

Answer: AD

NEW QUESTION 7
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 security rules define?

• A. whether the connection was completely secured.
• B. the availability of network access to the database instance.
• C. the direction of network access to the database instance.
• D. the status of the database instance.

Answer: B

Explanation:
The arrows indicate if the access rule is enabled or not. Example:

References:
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/service-console-access-rules-page.html

NEW QUESTION 8
Examine these commands:
1. # dbaascli dbpatchm --run -prereq
2. # dbpatchmdg -precheck_async patch_id
3. $ raccli apply patch -db -tag tag-name -prechecks
Which is true?

• A. Only 1 and 2 will execute successfully and check the prerequisites.
• B. All three commands will execute successfully and check the prerequisites.
• C. Only 1 and 3 will execute successfully and check the prerequisites.
• D. Only 2 and 3 will execute successfully and check the prerequisites.

Answer: B

NEW QUESTION 9
You have an Oracle Database 12c on-premise non-CDB database that is running on the AIX platform.
Which two methods can be used to migrate the on-premise database to a database that is running in a Database as a Service (DBaaS) instance on Oracle Cloud?

• A. Remote Cloning
• B. Transporting Tablespaces by using RMAN convert
• C. Data Pump
• D. Transporting Tablespaces by using RMAN “backup from platform”
• E. scp file copy

Answer: AC

Explanation:
You can migrate Oracle Database 12c non-CDB databases from on-premises to Oracle Database 12c databases in Oracle Database Cloud using several different methods including:
* Data Pump Conventional Export/Import
This method can be used regardless of the endian format and database character set of the on-premises database.
* Remote Cloning (non-CDB)
This method can be used only if the on-premises platform is little endian, the on-premises database release is 12.1.1.2 or higher, and the on-premises database and Database Cloud Service database have compatible database character sets and national character sets.
You can use the remote cloning method to copy an Oracle Database 12c non-CDB on-premises database to your Oracle Database 12c database in the cloud.
* RMAN CONVERT Transportable Tablespace with Data Pump
This method can be used only if the database character sets of your on-premises database and Oracle Database Cloud Service database are compatible.
* RMAN Cross-Platform Transportable Tablespace Backup Sets
This method can be used only if the database character sets of your on-premises database and Oracle Database Cloud Service database are compatible.
References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/mig-12c-non-cdb-12c.html

NEW QUESTION 10
Which three statements are true about the service levels provided by Database Cloud Service (DBCS)?

• A. The Virtual Image service level provides a pre-created database.
• B. The Virtual Image service level provides tools for backups and patching.
• C. The automated service provides a pre-installed virtual machine image.
• D. The automated service provides a pre-created database.
• E. The cloud tooling within the automated service level provides a tool for point-in-time database recovery.

Answer: BDE

NEW QUESTION 11
Which statement is true about Oracle Database Schema Service or Oracle Database Cloud Service in Oracle Public Cloud?

• A. Oracle Database Schema Service requires no database administrators to administer the database.
• B. Oracle Database Cloud Service requires no database administrators to administer the database.
• C. Oracle Database Cloud Service provides complete database instances with shared control between thesubscriber DBA and Oracle Support.
• D. Oracle Database Schema Service provides database schemas with shared control between the subscriber DBA and Oracle Support.

Answer: C

NEW QUESTION 12
Which two statements are true about a Database Deployment in Oracle Public Cloud?

• A. A Secure Shell (SSH) key is provided by Oracle for accessing the compute nodes as the first step in creating a Database Deployment.
• B. The billing frequency depends on the Oracle database software edition that is selected for the Database Deployment.
• C. The public SSH key is provided when configuring the database in the Database Deployment.
• D. Storage configuration must be selected for the Database Deployment.
• E. The database that is configured may be an Oracle 11gR2 database.

Answer: AE

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:
Service Level
Billing Frequency
Oracle Database Release Version
Oracle Database Edition
Computing Power
Database Storage
Backup and Recovery Configuration

NEW QUESTION 13
Which two steps are true about performing an on-demand backup?

• A. You need to connect to the compute node as the oracle user.
• B. You need to connect to the compute node as the opc user.
• C. You need to disable the backup configuration (crontab).
• D. You need to enable the backup configuration (crontab).

Answer: D

NEW QUESTION 14
Which statement is true about security rules for Database Deployments?

• A. They are used only for configuring external server access to Database Deployments and do not impact how security lists communicate.
• B. They define a specific communication path, which consists of a source, destination, and protocol-port combination over which communication is allowed.
• C. They are used to map an external user to a database user to allow the user to communicate with and access the database.
• D. They are used to encrypt communication between Database Deployments.

Answer: B

Explanation:
On the Access Rule you can define the following:
SourceHosts from which traffic is allowed. Possible values are DB, PUBLIC-INTERNET, or a custom value in the form of an IP address.
DestinationSecurity list to which traffic is allowed. This will be DB, the ora_db security list for the deployment.
PortsPort or range of ports for the rule.
References:
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/service-console-access-rules-page.html

NEW QUESTION 15
Which user is used to log in to DBaaS Monitor Console to monitor the necessity of scaling a Database
Deployment?

• A. sys
• B. sysman
• C. dbsnmp
• D. dbaas_monitor

Answer: D

NEW QUESTION 16
You are configuring network connections for your database instance. What does each network group represent?

• A. allows unrestricted communication among some of your Oracle Database Cloud service instances by using a set of defined policies and access rules.
• B. defines load balancing and failover configurations between RAC database instances.
• C. defines network connections to the Pluggable Databases (PDBs) within a Container Database.
• D. manages the connections between your external application servers (application servers that you currently use in your business environment) and your Oracle Database Cloud service instances.

Answer: A

Explanation:
Network groups provide a method for VMs to be grouped together for communications and firewall rules. You can define network groups to allow VMs within a group to communicate with each other, while also preventing those VMs from communicating outside the group.
Note:
Access rule. Access rules define the permitted paths of communication for VMs that are within a network group. You can define an access rule to enable a specific path of communication between two network groups, or between a network group and a specified list of IP addresses.
References:
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/dbaas/OU/IntroDBaaS/ConfiguringNetworkS

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

• A. Connect to the instance’s VM as the opc user.
• B. Connect to the instance’s VM as the oracle user.
• C. Disable the backup configuration (crontab).
• D. Enable the backup configuration (crontab).

Answer: AD

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 database deployment hosting a single-instance database or an Oracle Data Guard configuration.
Connect as the opc user to the compute node. In a Data Guard configuration, connect to the compute node hosting the primary database.
Start a root-user command shell:$ sudo -s #
You can choose to have the backup follow the current retention policy, or you can choose to create a long-term backup that persists until you delete it:
• To create a backup that follows the current retention policy, enter the following bkup_api command:# /var/opt/oracle/bkup_api/bkup_api bkup_start
• To create a long-term backup, enter the following bkup_api command:#
/var/opt/oracle/bkup_api/bkup_api bkup_start --keep
Exit the root-user command shell and disconnect from the compute node:# exit$ exit
D: If some activity you want to perform requires you to temporarily disable regularly scheduled backups, 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

NEW QUESTION 18
Oracle provides additional web-based tools for monitoring Database as a Service (DBaaS) instances. One of the tools is DBaaS Monitor Console.
Which user would you have to log in as to use this tool?

• A. dbsnmp
• B. sys
• C. dbaas_monitor
• D. sysman

Answer: C

Explanation:
To access Oracle DBaaS Monitor when the HTTPS port is unblocked:
Open the Oracle Database Cloud Service console.
From the menu for the deployment, select Open DBaaS Monitor Console.A window prompting you for your user name and password is displayed.
Enter dbaas_monitor as the user name and the password specified during the database deployment creation process, and then click OK.
References: Using Oracle Database Cloud Service (February 2021), 10-2 https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf

NEW QUESTION 19
Which users can remotely log in and administer a compute node of a Database Deployment?

• A. root and oracle users
• B. opc and oracle users
• C. sysman and oracle users
• D. root, opc, and oracle users
• E. root, oracle, and sysman users

Answer: B

NEW QUESTION 20
Which two steps would you perform to restore and recover a database from the most recent backup?

• A. Disable the scheduled backup configuration.
• B. Disable the scheduled recovery configuration.
• C. Perform the restore with the dbaascli orec --args –latest command.
• D. Perform the restore with the dbaascli orec –-args –last command.
• E. Perform the restore with the dbaascli orec –-args –stop -last command.
• F. Perform the restore with the dbaascli orec –-args –close –last command.

Answer: AC

Explanation:
A: Note: If some activity you want to perform requires you to temporarily disable regularly scheduled backups, you can do so by removing the scheduling information from the system-wide /etc/crontab file.
C: You can use the dbaascli utility to restore from the most recent backup and perform complete recovery on a database deployment hosting a single-instance database:
Connect as the opc user to the compute node.
Start a root-user command shell:$ sudo -s#
Restore the most recent backup and perform complete recovery using the orec subcommand of the dbaascli utility:# dbaascli orec --args -latestThe restore and recover process performs these steps:
Shuts down the database
Extracts and restores configuration files
Prepares for recovery
Performs the recovery
Restarts the database instance after recovery
Exit the root-user command shell:# exit$
References: Using Oracle Database Cloud Service (February 2021), page 6-23 https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf

NEW QUESTION 21
Which are two of the tasks that must be performed to enable SQL*NET access for your database instance on a Database Deployment over SSL?

• A. You must open a port on the virtual machine (compute node) 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: AB

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

NEW QUESTION 22
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: CDE

Explanation:
References: https://www.oracle.com/database/solutions/private-dbaas.html

NEW QUESTION 23
Which statement is true about the Database Deployment and Database instances in Oracle Public Cloud?

• A. An Oracle database instance can support only one Database Deployment.
• B. A Database Deployment can support only one Oracle database instance.
• C. An Oracle database instance can support multiple Database Deployment.
• D. A Database Deployment runs in a pluggable database (PDB), which is contained in a multi-tenant container database (CDB).
• E. A Database Deployment can support multiple Oracle database instances.

Answer: E

Explanation:
References:
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/db-deployments.html#GUID-61C0A3F6-1760

NEW QUESTION 24
......