Updated 1Z0-160 Dumps – Preparing for Passing the Oracle Exam
To ensure you are fully prepared for the 1Z0-160 exam, we have provided an updated 1Z0-160 dumps 2023 with precise questions and answers.
Passitdump’s updated 1Z0-160 dumps as your study material features 86 exam questions covering all the topics and skills you need to master to pass the 1Z0-160 exam. Just work hard, and it is very necessary to do practice questions.
We have sample questions for 1Z0-160 free dumps. You can download and check the real questions of updated 1Z0-160 dumps.
Question 1:
You want all your colleagues to be able to access the compute node associated with an Oracle Database Cloud – Database Deployment. You want them to do so by using a custom host name rather than an IP address regardless of the client machine (personal or provided by the company) that they use for the access.
How would you enable this access?
A. Configure the Advanced Security Option (ASO).
B. Enable secure access to the Database Deployment compute node and database instance from remote hosts by using SSH.
C. Contact the administrator of your company\’s intranet DNS and request a custom DNS record for the compute node\’s public IP address.
D. Edit the machine\’s /etc/hostsfile.
E. Resolve your domain name to the IP address of the Database Deployment compute node by using the third-party domain registration vendor console.
Correct Answer: C
Explanation:
You can associate a custom host name or domain name to the public IP address of a compute node
associated with your Oracle Database Cloud Service environment.
To associate a custom host name to the public IP address of a compute node, contact the administrator of
your DNS (Domain Name Service) and request a custom DNS record for the compute node\’s public IP
address. For example, if your domain is example.com and you wanted to use clouddb1 as the custom host
name for a compute node, you would request a DNS record that associates clouddb1.example.com to
your compute node\’s public IP address.
References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/define-custom-host-ordomain-name.html
Question 2:
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 required. You are responsible for configuring the database backups.
B. Backup to cloud storage and VM block storage. Ten days worth of backups are kept, with five most recent days worth of backups available directly on VM block storage.
C. 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.
D. Backup to cloud storage and VM block storage. Fourteen days worth of backups are kept, with seven most recent days worth of backups available directly on VM block storage.
Correct 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
Question 3:
Users must be granted roles to manage Cloud services.
Which three statements are true about roles and role assignment in Database as a Service (DBaaS)?
A. Service administrators can assign and remove roles only for users of the services that they manage.
B. The DBaaS Database Administrator role permits granting the DBaaS Database Administrator role to existing users.
C. Identity domain administrators can assign and remove roles for users in any identity domains.
D. The DBaaS Database Operator role permits scaling, patching, and backing up or restoring service instances.
E. DBaaS network administrators can grant access privileges to designated users.
Correct Answer: ADE
Explanation:
A: A Service administrator manages administrative functions related to Oracle Cloud services within an identity domain.
D: The privileges given to the DBaaS Database Administrator role include: Can scale, patch, and back up or restore database deployments
Incorrect Answers:
B: The privileges given to the DBaaS Database Administrator role are:
1.
Can create and delete database deployments
2.
Can scale, patch, and back up or restore database deployments
3.
Can monitor and manage service usage in Oracle Cloud
C: Only identity domain administrators can manage user accounts, and they are allowed to add, modify, and remove user accounts only in the identity domains that they have been designated to administer.
References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/service-roles-andusers.html
Question 4:
Which users are created and can be used for database and host management of your DBaaS database servers?
A. root, opc and oracle users
B. root, oracleand cloud users
C. root and oracle users
D. opc and oracle users
E. cloudand 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-accountsrac.html
Question 5:
Which two situations require that your Database Deployment be scaled up?
A. The Database Deployment instance is maxed out on semaphore sets.
B. The database instance has reached the limit in the license_max_sessionsdatabase parameter.
C. The Database Deployment is maxed out on CPU.
D. The database instance is out of space in the sysaux and system tablespaces.
E. The Database Deployment is maxed out on storage.
F. 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
Question 6:
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.
Correct Answer: D
Question 7:
Which two functions can be managed by using the dbaascli tool?
A. running health checks on your database
B. creating users in the database instance
C. restoring from the most recent backup
D. creating a database instance
E. 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
Question 8:
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.
Correct Answer: E
References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/dbdeployments.html#GUID-61C0A3F6-1760-47EC-8B3E-8B50AE1276D9
Question 9:
Which two statements are true about the information that you see on the Database Cloud Service page?
A. It shows the date the instance was last accessed.
B. It shows the number of active sessions for each instance in your domain.
C. It shows the total memory for all instances in your domain.
D. It lists the memory for each instance in your domain.
E. It shows the name of each database instance.
Correct Answer: CE
Explanation:
The Oracle Database Cloud Service Services page displays all deployments on Oracle Database Cloud
Service.
Use the Oracle Database Cloud Service Services page to perform the following tasks:
1.
Viewing All Database Deployments
2.
Creating a Database Deployment
3.
Viewing Detailed Information for a Database Deployment
Deleting a Database Deployment The Activity page displays activities for all Oracle Database Cloud Service deployments in your identity domain.
Example:
References: http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/sscs/ProvisionDB/ SOACS_prereq%20_DBCS.html https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/service-console-services-page.html
Question 10:
What is the location of the associated database files of a Database Deployment?
A. The installer sets the database file locations during installation by configuring the data file storage options.
B. The Database Deployment data files are stored at: /u01: Oracle product software; the entire bits Compute Cloud storage volume /u02: Oracle Database data storage; the entire data Compute Cloud storage volume /u03: Database backup storage; the entire fra Compute Cloud storage volume /u04: Database redo logs; the entire redo Compute Cloud storage volume
C. All database instance files on the Database Deployment are stored at /u01/app/oracle/oradata.
D. The database file locations are read from utldbfiles.oraand users can update this file to set their own locations.
Correct Answer: B
Explanation:
Compute Cloud Service Storage Volumes
When a Database Cloud Service database deployment is created at the Oracle
Database Cloud Service service level, the following storage volumes are created.
References: Using Oracle Database Cloud Service (February 2017), page A-9
http://docs.oracle.com/cloud/latest/dbcs_dbaas/CSDBI/CSDBI.pdf
Question 11:
Which command would you execute to perform DBaaS recovery with the latest backup?
A. dbaascli rec -args -latest
B. dbaascli orec -args -latest
C. dbaascli rec -args -last
D. 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
Question 12:
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?
A. conventional export/import
B. Transportable Tablespace (TTS) with RMAN conversion
C. Transportable Tablespace (TTS) by using Oracle Data Pump
D. SQL *Loader
E. RMAN image restore
F. 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.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 13:
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?
A. Grant privileges and roles to database users.
B. Create database users.
C. Back up and recover databases.
D. Create tablespaces.
E. Reboot a VM.
F. 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.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 14:
Where is the Oracle Database Cloud software for monitoring and backup installed?
A. The Oracle Database Cloud software is located in the Database Automatic Diagnostic Repository (ADR).
B. The installation is done at /var/opt/oracle/dbaascliand /var/opt/oracle/bkup_api.
C. The location must be set during installation as user-defined locations for the installation to start.
D. 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:
1.
Oracle Database 12c: /u01/app/oracle/product/12.1.0/dbhome_1
2.
Oracle Database 11g: /u01/app/oracle/product/11.2.0/dbhome_1
Note: Using the dbaascli utility, you can perform operations like:
1.
Changing the password of the SYS user
2.
Checking the status of the Oracle Data Guard configuration
3.
Switchover and failover in an Oracle Data Guard configuration
4.
Patching the database deployment
5.
Database recovery
6.
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-cloudservice.pdf
Question 15:
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
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-2
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloudservice.pdf