1z0-160: Oracle Database Cloud Service - Free download exam dump

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?

conventional export/import
Transportable Tablespace (TTS) with RMAN conversion
Transportable Tablespace (TTS) by using Oracle Data Pump
SQL *Loader
RMAN image restore
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

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?

Grant privileges and roles to database users.
Create database users.
Back up and recover databases.
Create tablespaces.
Reboot a VM.
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

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

The Oracle Database Cloud software is located in the Database Automatic Diagnostic Repository (ADR).
The installation is done at /var/opt/oracle/dbaascli and /var/opt/oracle/bkup_api.
The location must be set during installation as user-defined locations for the installation to start.
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.