Download Oracle.1z0-160.Pass4Sure.2019-02-27.51q.vcex

Download Exam

File Info

Exam Oracle Database Cloud Service
Number 1z0-160
File Name Oracle.1z0-160.Pass4Sure.2019-02-27.51q.vcex
Size 790 KB
Posted Feb 27, 2019
Download Oracle.1z0-160.Pass4Sure.2019-02-27.51q.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 users are created and can be used for database and host management of your DBaaS database servers?


  1. root, opc and oracle users
  2. root, oracle and cloud users
  3. root and oracle users
  4. opc and oracle users
  5. cloud and oracle users
Correct answer: D
Explanation:
Linux user accounts that are provisioned on an Oracle Database Cloud Service deployment that hosts an Oracle Real Application Clusters (Oracle RAC) database:* opc The system administrator account you use to connect to the compute node using SSH. This user can use the sudo command to perform operations that require root-user access. * oracle The Oracle Database administrator account you use to access the system and perform non-root database administration tasks. * grid The Oracle Grid Infrastructure administrator account you use to perform ASM, ACFS, and clusterware administration tasks. * root 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 user. References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/linux-user-accounts-rac.html
Linux user accounts that are provisioned on an Oracle Database Cloud Service deployment that hosts an Oracle Real Application Clusters (Oracle RAC) database:
* opc 
The system administrator account you use to connect to the compute node using SSH. This user can use the sudo command to perform operations that require root-user access. 
* oracle 
The Oracle Database administrator account you use to access the system and perform non-root database administration tasks. 
* grid 
The Oracle Grid Infrastructure administrator account you use to perform ASM, ACFS, and clusterware administration tasks. 
* root 
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 user. 
References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/linux-user-accounts-rac.html



Question 2

Which two situations require that your Database Deployment be scaled up?


  1. The Database Deployment instance is maxed out on semaphore sets.
  2. The database instance has reached the limit in the license_max_sessions database parameter.
  3. The Database Deployment is maxed out on CPU.
  4. The database instance is out of space in the sysaux and system tablespaces.
  5. The Database Deployment is maxed out on storage.
  6. The Database Deployment is maxed out on semaphores.
Correct answer: CE
Explanation:
Existing DBCS instances may scale up to bigger shapes in OCPU, Memory and Storage for vertical scaling. For horizontal scaling, DBCS provides RAC with the Extreme Performance option currently allowing applications to scale up to 2 nodes, each with a max of 16 OCPU shapes. Note: An Oracle CPU (OCPU) provides CPU capacity equivalent of one physical core of an Intel Xeon processor with hyper threading enabled. Each OCPU corresponds to two hardware execution threads, known as vCPUs.References: https://cloud.oracle.com/opc/database/faq
Existing DBCS instances may scale up to bigger shapes in OCPU, Memory and Storage for vertical scaling. For horizontal scaling, DBCS provides RAC with the Extreme Performance option currently allowing applications to scale up to 2 nodes, each with a max of 16 OCPU shapes. 
Note: An Oracle CPU (OCPU) provides CPU capacity equivalent of one physical core of an Intel Xeon processor with hyper threading enabled. Each OCPU corresponds to two hardware execution threads, known as vCPUs.
References: https://cloud.oracle.com/opc/database/faq



Question 3

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


  1. You would require access to the Oracle Compute Cloud Service console to open the ports to a set of IP addresses.
  2. You must contact your Oracle Database Cloud Service support team to update the port specifications for use.
  3. All ports that are available in Oracle Database Cloud Service servers must use an SSH tunnel and cannot be enabled persistently.
  4. 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.
Correct answer: D



Question 4

Which two functions can be managed by using the dbaascli tool?


  1. running health checks on your database
  2. creating users in the database instance
  3. restoring from the most recent backup
  4. creating a database instance
  5. applying a patch
Correct answer: CE
Explanation:
The dbaascli utility is provided on Oracle Database Cloud Service deployments to perform a variety of life-cycle and administration operations. Using the dbaascli utility, you can perform operations like:* Database recovery The orec latest subcommand restores the most recent backup and performs complete recovery. * Patching the database deployment The dbpatchm apply subcommand applies the patch. *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 * Rotating the master encryption key References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/dbaascli.html
The dbaascli utility is provided on Oracle Database Cloud Service deployments to perform a variety of life-cycle and administration operations. 
Using the dbaascli utility, you can perform operations like:
* Database recovery 
The orec latest subcommand restores the most recent backup and performs complete recovery. 
* Patching the database deployment 
The dbpatchm apply subcommand applies the patch. 
*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 
* Rotating the master encryption key 
References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/dbaascli.html



Question 5

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


  1. An Oracle database instance can support only one Database Deployment.
  2. A Database Deployment can support only one Oracle database instance.
  3. An Oracle database instance can support multiple Database Deployment.
  4. A Database Deployment runs in a pluggable database (PDB), which is contained in a multi-tenant container database (CDB).
  5. A Database Deployment can support multiple Oracle database instances.
Correct answer: E
Explanation:
References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/db-deployments.html#GUID-61C0A3F6-1760-47EC-8B3E-8B50AE1276D9
References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/db-deployments.html#GUID-61C0A3F6-1760-47EC-8B3E-8B50AE1276D9



Question 6

Which statement is true about the Oracle software releases that are currently supported in a Database as a Service (DBaaS) instance in Oracle Public Cloud?


  1. All versions and releases of Oracle Database 12c are supported.
  2. All versions and releases of Oracle Database 11g are supported.
  3. Oracle Database 11g Release 2 is supported.
  4. Oracle Database 12c is supported but only for single container databases.
Correct answer: C
Explanation:
Release 2 and 12c Release 1 (and 2) are supported.     References: http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/dbaas/obe_dbaas_creating_an_instance/obe_dbaas_creating_an_instance.html
Release 2 and 12c Release 1 (and 2) are supported. 
  
References: http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/dbaas/obe_dbaas_creating_an_instance/obe_dbaas_creating_an_instance.html



Question 7

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


  1. dbaascli rec –args –latest
  2. dbaascli orec –args -latest
  3. dbaascli rec –args -last
  4. dbaascli orec –args -last
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 8

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 9

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_1  Oracle 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 10

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. dbsnmp
  2. sys
  3. dbaas_monitor
  4. sysman
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









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