Download Oracle.1z0-160.PrepAway.2018-09-01.44q.vcex

Download Exam

File Info

Exam Oracle Database Cloud Service
Number 1z0-160
File Name Oracle.1z0-160.PrepAway.2018-09-01.44q.vcex
Size 856 KB
Posted Sep 01, 2018
Download Oracle.1z0-160.PrepAway.2018-09-01.44q.vcex

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase

Coupon: MASTEREXAM
With discount: 20%





Demo Questions

Question 1

Which command would you execute to perform DBaaS recovery with the latest backup? 


  1. dbaascli orec –args -latest
  2. dbaascli rec –args -last
  3. dbaascli orec –args -last
  4. dbaascli rec –args –latest
Correct answer: B
Explanation:
dbaascli orec latest command restores the most recent backup and performs complete recovery. References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/dbaascli.html
dbaascli orec latest command restores the most recent backup and performs complete recovery. 
References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/dbaascli.html



Question 2

You are migrating an Oracle Database 11.2.0.4 on-premise database to an Oracle Database Cloud Service (Database as a Service) that provides a pre-created Oracle Database 12.1.0.2 database. 
What four migration methods can be used?


  1. conventional export/import
  2. Transportable Tablespace (TTS) with RMAN conversion
  3. Transportable Tablespace (TTS) by using Oracle Data Pump
  4. SQL *Loader 
  5. RMAN image restore
  6. Data Pump Transportable Database (TDB) export/import
Correct answer: BCDF
Explanation:
You load data into an Oracle database on Oracle Database Cloud Service using the same tools you would use for an Oracle database on another system. * (D) Using SQL*Loader to Load Data into the Database * Using Oracle Data Pump Import to Load Data into the Database * (BC) Using Transportable Tablespaces to Load Data into the Database There are two ways to transport a tablespace:Manually, involving issuing commands to SQL*Plus, RMAN, and Data Pump. Using the Transport Tablespaces Wizard in Enterprise Manager * Using Pluggable Databases (PDBs) to Load Data into the Database * Using Oracle Public Cloud Data Transfer Services to Move Large Data Sets * (F) Full transportable export/import, is available to make migration to Oracle Database 12c faster, easier, and more efficient than ever before. Full transportable export is available starting with Oracle Database 11g Release 2 (11.2.0.3). References:  https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/load-data-db.htmlhttps://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces013.htm#ADMIN11395http://www.oracle.com/technetwork/database/enterprise-edition/full-transportable-wp-12c-1973971.pdf
You load data into an Oracle database on Oracle Database Cloud Service using the same tools you would use for an Oracle database on another system. 
* (D) Using SQL*Loader to Load Data into the Database 
* Using Oracle Data Pump Import to Load Data into the Database 
* (BC) Using Transportable Tablespaces to Load Data into the Database 
There are two ways to transport a tablespace:
Manually, involving issuing commands to SQL*Plus, RMAN, and Data Pump. 
Using the Transport Tablespaces Wizard in Enterprise Manager 
* Using Pluggable Databases (PDBs) to Load Data into the Database 
* Using Oracle Public Cloud Data Transfer Services to Move Large Data Sets 
* (F) Full transportable export/import, is available to make migration to Oracle Database 12c faster, easier, and more efficient than ever before. Full transportable export is available starting with Oracle Database 11g Release 2 (11.2.0.3). 
References:  https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/load-data-db.html
https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces013.htm#ADMIN11395
http://www.oracle.com/technetwork/database/enterprise-edition/full-transportable-wp-12c-1973971.pdf



Question 3

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 be used by Oracle users in a Database Deployment?


  1. Grant privileges and roles to database users.
  2. Create database users.
  3. Back up and recover databases.
  4. Create tablespaces.
  5. Reboot a VM.
  6. Use the sudo command to perform root user access operations. 
Correct answer: ABC
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 for this 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. Incorrect Answers:F: root is the root administrator for the system. You do not have direct access to this account. To perform operations that require root-user access, use the sudocommand as the opc, not the oracle, user. References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/linux-user-accounts-rac.htmlhttp://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/dbaas/obe_dbaas_administering_your_database_cloud_service/obe_dbaas_administering_your_database_cloud_service.html
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 for this 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. 
Incorrect Answers:
F: root is the root administrator for the system. You do not have direct access to this account. To perform operations that require root-user access, use the sudo
command as the opc, not the oracle, user. 
References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/linux-user-accounts-rac.html
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/dbaas/obe_dbaas_administering_your_database_cloud_service/
obe_dbaas_administering_your_database_cloud_service.html



Question 4

Where is the Oracle Database Cloud software for monitoring and backup installed?


  1. The Oracle Database Cloud software is located in the Database Automatic Diagnostic Repository (ADR).
  2. The installation is done at /var/opt/oracle/dbaascli and /var/opt/oracle/bkup_api.
  3. The location must be set during installation as user-defined locations for the installation to start.
  4. The location is based on Oracle Flex Architecture, which is similar to non-DBaaS systems.
Correct answer: B
Explanation:
When a database deployment is created using the Oracle Database Cloud Service service level, software is installed in the following locations. * bkup_api utility /var/opt/oracle/bkup_api * dbaascli utility /var/opt/oracle/dbaascli * Oracle REST Data Services /u01/app/oracle/product/apex_listener * Oracle Database $ORACLE_HOME:Oracle Database 12c: /u01/app/oracle/product/12.1.0/dbhome_1Oracle Database 11g: /u01/app/oracle/product/11.2.0/dbhome_1Note: Using the dbaascli utility, you can perform operations like: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 Patching the database deployment Database recovery Rotating the master encryption key References: Using Oracle Database Cloud Service (February 2017), A-4https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf
When a database deployment is created using the Oracle Database Cloud Service service level, software is installed in the following locations. 
* bkup_api utility /var/opt/oracle/bkup_api 
* dbaascli utility /var/opt/oracle/dbaascli 
* Oracle REST Data Services /u01/app/oracle/product/apex_listener 
* Oracle Database 
$ORACLE_HOME:
  • Oracle Database 12c: /u01/app/oracle/product/12.1.0/dbhome_1
  • Oracle Database 11g: /u01/app/oracle/product/11.2.0/dbhome_1
Note: Using the dbaascli utility, you can perform operations like:
  • 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 
  • Patching the database deployment 
  • Database recovery 
  • Rotating the master encryption key 
References: Using Oracle Database Cloud Service (February 2017), A-4
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf



Question 5

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? 


  1. sys
  2. dbaas_monitor
  3. sysman
  4. dbsnmp
Correct answer: C
Explanation:
To access Oracle DBaaS Monitor when the HTTPS port is unblocked:1. Open the Oracle Database Cloud Service console. 2. From the menu for the deployment, select Open DBaaS Monitor Console. A window prompting you for your user name and password is displayed. 3. 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 2017), 10-2https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf
To access Oracle DBaaS Monitor when the HTTPS port is unblocked:
1. Open the Oracle Database Cloud Service console. 
2. From the menu for the deployment, select Open DBaaS Monitor Console. 
A window prompting you for your user name and password is displayed. 
3. 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 2017), 10-2
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf



Question 6

How would you connect from your local machine to the database instance on the DBaaS server by using SQL*Net? 


  1. You start an SSH process on your local machine to communicate to a tunnel created on the DBaaS server.
  2. You must use port 1521 and the TCPS communication protocol.
  3. You can use only the SSH connection that is defined on port 22 that is configured by default during DBaaS instance installation.
  4. You must use Transparent Data Encryption (TDE) to secure connections to the DBaaS database instance when using SQL*Net connections from your local machine to DBaaS database instances.
Correct answer: B
Explanation:
To confirm remote access to the database through the SQL*Net security rule, create a connection to the database in Oracle SQL Developer. When creating the connection, fill out the fields as follows:Username: enter SYSTEM.Password: enter Pa55_WoRd.Hostname: enter the Public IP address of the compute node associated with the database deployment. To find out this address, display details of the service asdescribed in Viewing Detailed Information for a Database Deployment Port: enter 1521.SID: enter ORCL.After entering values, click Test to test the connection. Note: TCPS is TCP/IP with SSL.References: Using Oracle Database Cloud Service (February 2017), 4-24https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf
To confirm remote access to the database through the SQL*Net security rule, create a connection to the database in Oracle SQL Developer. When creating the connection, fill out the fields as follows:
  • Username: enter SYSTEM.
  • Password: enter Pa55_WoRd.
  • Hostname: enter the Public IP address of the compute node associated with the database deployment. To find out this address, display details of the service as
    described in Viewing Detailed Information for a Database Deployment 
  • Port: enter 1521.
  • SID: enter ORCL.
After entering values, click Test to test the connection. 
Note: TCPS is TCP/IP with SSL.
References: Using Oracle Database Cloud Service (February 2017), 4-24
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf



Question 7

How do you enable a default connection between Database as a Service (DBaaS) instances?


  1. by creating security lists and adding the instances that you want to communicate to that group
  2. by creating dedicated communication keys and setting them to be used only for your DBaaS instance-to-instance communication
  3. by creating nothing for communication between the DBaaS instances because all instances are interconnected by default
  4. by installing and configuring the NETMGR utility for your DBaaS environment, and then using it to set up the required communication channels
Correct answer: A
Explanation:
Before your DBaaS database was created, you or a coworker generated a private and public SSH key pair, perhaps using PuTTY Key Generator. The public key was specified when your database instance was created; a copy of that public key was stored in the VM hosting your database. When you define in PuTTY an SSH connection to the VM hosting your database, you will specify a copy of the private key stored on your local PC. When you initiate a PuTTY connection, the VM compares the private key to the matching public key stored in the VM. The VM permits the connection when the private and public key match as a valid key pair. References: http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/dbaas/obe_dbaas_connecting_to_an_instance/obe_dbaas_connecting_to_an_instance.html
Before your DBaaS database was created, you or a coworker generated a private and public SSH key pair, perhaps using PuTTY Key Generator. 
The public key was specified when your database instance was created; a copy of that public key was stored in the VM hosting your database. 
When you define in PuTTY an SSH connection to the VM hosting your database, you will specify a copy of the private key stored on your local PC. When you initiate a PuTTY connection, the VM compares the private key to the matching public key stored in the VM. The VM permits the connection when the private and public key match as a valid key pair. 
References: http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/dbaas/obe_dbaas_connecting_to_an_instance/obe_dbaas_connecting_to_an_instance.html



Question 8

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


  1. OPC Console
  2. GlassFish Administration Console
  3. Storage Container Console
  4. Application Express Console
  5. User Console
  6. Database Express Manager Console
Correct answer: DEF
Explanation:
The menu for each deployment that provides the following options:Open DBaaS Monitor Console — Open the Oracle Cloud Database Monitor for the deployment. Open Application Express Console — Open the Oracle Application Express home page for the deployment. Open EM Console — Open the database console, either Enterprise Manager Database Express 12c or Enterprise Manager 11g Database Control. References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/service-console-services-page.html
The menu for each deployment that provides the following options:
  • Open DBaaS Monitor Console — Open the Oracle Cloud Database Monitor for the deployment. 
  • Open Application Express Console — Open the Oracle Application Express home page for the deployment. 
  • Open EM Console — Open the database console, either Enterprise Manager Database Express 12c or Enterprise Manager 11g Database Control. 
References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/service-console-services-page.html



Question 9

What are two ways to enable a port on your computer node of Database Deployment for access to your Database Deployment?. 


  1. Use your public and private key pairs to define a list of preferred ports that get enabled during your Database Deployment installation.
  2. Create a tunnel for port forwarding by using SSH.
  3. Configure all remote connections through port 22 that is assigned by default for SSH connections.
  4. Ask Oracle Database Cloud Service to open the required ports.
  5. Use the Oracle Compute Cloud Service Console to open ports to a set of IP addresses.
Correct answer: BC
Explanation:
C: SSH is a cryptographic network protocol that uses two keys, one public and one private, to provide secure communication between two networked computers.Port 22 is the standard TCP/IP port that is assigned to SSH servers. B: To access network protocols and services on a compute node by using a port other than port 22, you must either:Enable network access to the port You can use the Oracle Database Cloud Service console to enable access to a port on a compute node. Create an SSH tunnel to the port Creating an SSH tunnel enables you to access a specific compute node port by using an SSH connection as the transport mechanism. To create the tunnel, you must have the SSH private key file that matches the public key specified during the database deployment creation process. References: Using Oracle Database Cloud Service (February 2017), 3-2https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf
C: SSH is a cryptographic network protocol that uses two keys, one public and one private, to provide secure communication between two networked computers.
Port 22 is the standard TCP/IP port that is assigned to SSH servers. 
B: To access network protocols and services on a compute node by using a port other than port 22, you must either:
  • Enable network access to the port 
You can use the Oracle Database Cloud Service console to enable access to a port on a compute node. 
  • Create an SSH tunnel to the port 
Creating an SSH tunnel enables you to access a specific compute node port by using an SSH connection as the transport mechanism. To create the tunnel, you 
must have the SSH private key file that matches the public key specified during the database deployment creation process. 
References: Using Oracle Database Cloud Service (February 2017), 3-2
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf



Question 10

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


  1. They key pair is used to start up, shut down, and manage EM Express availability.
  2. The keys are used to control the encryption that is used by Database Deployment: the first is for network encryption and the second is for database encryption. 
  3. The keys replace password use. Database Deployment use only key pairs; password authentication is not enable for SSH default connections.
  4. Communication between instances in a Database Cloud Service account is controlled by network security rules and security lists.
Correct answer: C
Explanation:
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-7https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf
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









CONNECT US

Facebook

Twitter

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!

Get Now!


HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files