Download Oracle.1z0-160.Pass4Sure.2018-07-15.51q.tqb

Download Exam

File Info

Exam Oracle Database Cloud Service
Number 1z0-160
File Name Oracle.1z0-160.Pass4Sure.2018-07-15.51q.tqb
Size 949 KB
Posted Jul 15, 2018
Download Oracle.1z0-160.Pass4Sure.2018-07-15.51q.tqb

How to open VCEX & EXAM Files?

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

Purchase

Coupon: MASTEREXAM
With discount: 20%






Demo Questions

Question 1

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 2

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

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









CONNECT US

Facebook

Twitter

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!



HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files