DBaaS Cloud Cert (1Z0-160) - N1 - 1a34

Question 1 of 34

1

1. Which two statements are true about the Database as a Service (DBaaS) instances and
Oracle database instances that are provided by Oracle Public Cloud?

Select one or more of the following:

A. A DBaaS instance requires customers to install any additional management tools for
their environment.
B. A DBaaS instance never provides a pre-created Oracle database.
C. an Oracle database instance that is provided as part of DBaaS runs the same
executable that would be run with the same version and release of Oracle Database on
private premises.
D. A DBaaS instance always provides a customer-selected version of the Oracle database
software.
E. Only one Oracle database instance can run in a DBaaS instance on Oracle Public
Cloud.

Explanation

Question 2 of 34

1

2. Which users are created and can be used for database and host management of your
DBaaS database servers?

Select one or more of the following:

A. root,opc and oracle users
B. root, oracle and cloud users
C. root and oracle users
D. opc and oracle users
E. cloud and oracle users

Explanation

Question 3 of 34

1

3. You are working on a DBaaS database instance. Identify the location for the associated database files for your instance.

Select one or more of the following:

A. The installer sets the database file locations during installation by configuring the data
file storage options.
B. the DBaaS database instance 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 DBaaS data base files are stored at /u01/app/oracle/oradata.
D. The database file locations are read from utl_dbfiles.ora and users can update this file to
set their own locations.

Explanation

Question 4 of 34

1

4. There are two ways to enable a port to a Database as a Service (DBaaS) instance. The
first requires access to the Compute Cloud Service Console to open the ports to a set of IP
addresses. The second is to create a tunnel for port forwarding by using SSH.
Which statement is true about port forwarding by using SSH?

Select one or more of the following:

A. The SSH tunneling the configured SSH process must be running on the consumer side
of the tunnel.
B. The SSH tunneling the configured SSH process must be running on the instance side of
the tunnel.
C. The SSH tunneling to access the DBaaS instance database via SQL Developer or
SQL*Plus must be configured to port 1522.
D. The SSH tunneling to access the DBaaS instance database via APEX must be
configured to port 8080

Explanation

Question 5 of 34

1

5. Which three statements are true about the Oracle Cloud Service storage volumes that are
created as part of a Database as a Service (DBaaS) instance in Oracle Public Cloud?

Select one or more of the following:

A. The database data file storage and tempfile storage are placed on the same storage
volume.  Tengo duda con esta: /u02 vs u04 pero la elijo por descarte ya que pide 3
B. The database backup storage and redo log storage are placed on the same storage
volume.
C. The Oracle database product software storage and the database data file storage are
placed on the same storage volume.
D. The database backup storage and database product software storage are placed on
different storage volumes.
E. The database data file storage and redo log storage are placed on different storage
volumes.

Explanation

Question 6 of 34

1

6. ¿¿¿???? 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)?

Select one or more of the following:

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 or DBaaS Database Operator role to existing users.  DBaaS Database Operator role no existe
C.- Identity domain administrators can assign and remove roles for users in any identity domains.
D. the DBaaS Database Operator role permits the ability to scale, patch, and backup or
restore service instances.  Non Existing Role
E. DBaaS network administrators can grant access privileges to designated users.
Elijo esta por eliminación

Explanation

Question 7 of 34

1

7.¿¿¿¿???? 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?

Select one or more of the following:

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.  I chose this because the question asks for two statements
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.

Explanation

Question 8 of 34

1

8. How would you stop Oracle REST Data Services (ORDS)?

Select one or more of the following:

A. Disable the APEX application in the Oracle GlassFish Server Administration Console.
B. Use the listener control tool (lsnrctl).
C. Stop the APEX resource in Enterprise Manager.
D. Use the ords stop command.

Explanation

Question 9 of 34

1

9. Which statement is true about the Database as a Service (DBaaS) instances and Database
instances in Oracle Public Cloud?

Select one or more of the following:

A. an Oracle database instance can support only one DBaaS instance.
B. A DBaaS instance can support only one Oracle database instance.
C. an Oracle database instance can support multiple DBaaS instances.
D. A DBaaS instance runs in a pluggable database (PDB), which is contained in a multitenant container database (CDB).
E. A DBaaS instance can support multiple Oracle database instances.

Explanation

Question 10 of 34

1

10. When you are using Oracle Compute Service Console and reviewing the network
configuration of your database instance, what do the arrows that are shown within the
Access Rules define?

Select one or more of the following:

A. They are used to show if the connection was completely secured.
B. They define the availability of network access to the database instance.
C. They define the direction of network access to the database instance.
D. They show the status of the database instance.

Explanation

Question 11 of 34

1

11. You wish to perform database recovery and restore the most recent backup.
Which two steps will you perform?

Select one or more of the following:

A. Disable the scheduled backup configuration.
B. Disable the scheduled recovery configuration.
C. Perform the restore with the dbaascli orec –args –latest command.
D. Perform the restore with the dbaascli orec –-args –last command.
E. Perform the restore with the dbaascli orec –-args –stop-last command.
F. Perform the restore with the dbaascli orec –-args –close –last command.

Explanation

Question 12 of 34

1

12. You use GUI tools on the Virtual Machine to create and administer the Database as a
Service (DBaaS) databases.
You wish to use the Oracle Database Configuration Assistant (DBCA) to create a database
instance. To run DBCA, you will need to use an SSH connection.
You need to perform several steps to establish this connection in DBCA and to create the
database.
What are two of these steps?

Select one or more of the following:

A. Connect to the DBaaS instance with the SSH terminal session as the oracle user.
B. Configure a PuTTY or SSH session to perform X11 forwarding.
C. Install an Xterminal program if required.
D. Update the tnsnames.ora file with the name of the service to which you want to connect.

Explanation

Question 13 of 34

1

13. dbaascli is a command-line interface for managing a database instance on cloud.
Which two functions can you manage with dbaascli?

Select one or more of the following:

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

Explanation

Question 14 of 34

1

14. Which two situations require that your Database as a Service (DBaaS) instance be scaled
up?

Select one or more of the following:

A. The DBaaS instance is maxed out on semaphore sets.
B. The database instance has reached the limit in the license_max_sessions database
parameter.
C. The DBaaS instance is maxed out on CPU.
D. The database instance is out of space in the sysaux and system tablespaces.
E. The DBaaS instance is maxed out on storage.
F. The DBaaS instance is maxed out on semaphores.

Explanation

Question 15 of 34

1

15. You want to access your database over SQL*Net with a client application that is running
locally on your machine.
How would you enable access to port 1521 of the Compute Node (VM)?

Select one or more of the following:

A. Use Oracle Compute Cloud Service to enable the ora_p2_dblistener security rule.
B. Run the lsnrctl reload listener command.
C. Use the Oracle GlassFish Server Administration Console to start the listener application.
D. Change the firewall rules.

Explanation

Question 16 of 34

1

16. You want to make sure that Oracle Application Express (APEX) is enabled and accessible.
Which two steps must you perform? Ivan dice A-B

Select one or more of the following:

A. Unblock the APEX instance’s VM and follow the URL to instance-ip-address:4848.
B. Enable APEX in the Oracle GlassFish Server Administration Console.
C. Create an SSH tunnel to port 443 on the instance’s VM.
D. Select deploy_enable from the DBaaS instance monitor.
E. Select apex_launch from the GlassFish Server Administration Console monitor.

Explanation

Question 17 of 34

1

17. You may need to create an on-demand backup of a database instance, or restore a
backup.
Which two steps are true about performing an on-demand backup?

Select one or more of the following:

A. You must first connect to the instance VM as the ROOT user.
B. You must disable the scheduled backup configuration.
C. You must first connect to the instance VM as the oracle user.
D. You must execute bkup_api with the bkup_start option.
E. You must execute bkup_api with the bkup_create option.

Explanation

Question 18 of 34

1

18. You did not configure Backup and Recovery during instance creation. You therefore need
to schedule your backup strategy with RMAN.
Which two tasks would you need to perform to customize the backup configuration?

Select one or more of the following:

A. Use the bkup_api utility logged in as the oracle user to reconfigure the retention period and
cycle period of the backups.
B. Edit the /home/oracle/bkup/oscfg.spec specification file that is used by the DBaaS backup
feature to maintain the list of system files and folders that are to be backed up.
C. Edit the /home/oracle/bkup/dbcfg.spec specification file that is used by the DBaaS backup
feature to maintain the list of database configuration files that are to be backed up.
D. Use dbms_scheduler to perform automatic backups.

Explanation

Question 19 of 34

1

19. You have an Oracle Database 11g on-premises database with encrypted tablespaces.
You want to migrate this database to the pre-created database of the Database as a
Service (DBaaS) instance on Oracle Cloud.
Which two statements are true about this migration?

Select one or more of the following:

A. The on-premises database platform must be of the same endianness as the DBaaS
platform.
B. You can use Full Transportable (TDB).
C. You can use Data Pump TTS with the ENCRYPTION_PASSWORD parameter.
D. You can use Data Pump TTS with the ENCRYPTED_PASSWORD parameter.
E. Data is sent in clear when the NETWORK_LINK option is used.

Explanation

Question 20 of 34

1

20. You want to use traditional GUI tools on a Database as a Service (DBaaS) instance. You
have configured PuTTY and SSH sessions.
What two things would you need to configure?

Select one or more of the following:

A. X server program
B. VPN connection
C. X11 forwarding
D. Remote Desktop Connection

Explanation

Question 21 of 34

1

21. You want all your colleagues to be able to access the compute node associated with an Oracle Database Cloud – Database as a Service (DBaaS) instance. 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?

Select one or more of the following:

A.Configure the Advanced Security Option (ASO).
B.Enable secure access to the DBaaS instance VM 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/hosts file.
E.Resolve your domain name to the IP address of the DBaaS compute node by using the
third-party domain registration vendor console.

Explanation

Question 22 of 34

1

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

Select one or more of the following:

A. To enable a port persistently, you must contact your DBaaS support team to update the
port specifications for use.
B. You can use server certificates to map a server’s identity to enable persistent
connection through a port to DBaaS instances.
C. All ports that are available in DBaaS servers must use an SSH tunnel and cannot be
enabled persistently.
D. To enable a port persistently, you would require access to the Compute Cloud Service
Console to open the ports to a set of IP addresses.

Explanation

Question 23 of 34

1

23.¿¿??? Which two statements are true about the SSH tunnels within a Database as a Service
(DBaaS) Cloud environment?

Select one or more of the following:

A.The SSH tunnel must be selected by an access rule to enable remote access.  I chose this because the question asks for two statements
B. The server must hold the SSH public and private keys in the SSH authorized_keys file.
C. DBaaS provides a centralized key server for all SSH connections.
D. The client must provide the server with the SSH private key.

Explanation

Question 24 of 34

1

24. Which two statements are true about Database as a Service (DBaaS) or about Database Schema Service in Oracle Public Cloud?

Select one or more of the following:

A. with Database Schema Service, there is a separate database for each schema.
B. with DBaaS, you get a dedicated database instance or instances.
C. with Database Schema Service, the schema or schemas may be in the same database as other schemas that belong to other subscribers.
D. with DBaaS, you cannot decide when to patch the database home.
E. with Database Schema Service, the schema may be in an Oracle Database 12c pluggable.

Explanation

Question 25 of 34

1

25. Which two statements are true about the sequence of steps that are performed when creating a Database as a Service (DBaaS) instance in Oracle Public Cloud?

Select one or more of the following:

A. A Secure Shell (SSH) key is provided by Oracle for accessing the DBaaS environment as the first step in creating a DBaaS instance.
B. The billing frequency depends on the Oracle database software edition that is selected for the DBaaS instance.  No. La frecuencia de pago es semanal o mensual y se elige en el momento de crear la DB con independencia de la versión y opciones. Lo que no es lo mismo es el precio de cada tipo de instancia
C. The public SSH key is provided when configuring the database in the DBaaS instance.
D. Storage configuration must be selected for the DBaaS instance.
E. The database that is configured may be an Oracle 11g database.

Explanation

Question 26 of 34

1

26. You are migrating an Oracle Database 11.2.0.2 on-premise database to an Oracle Database Cloud Service (Database as a Service) that provides a pre-created Oracle Database 11.2.0.4 database.
Which two migration methods are possible?

Select one or more of the following:

A.Data Pump Transportable Database (TDB) export/import
B.Remote Cloning
C.Data Pump Transportable Tablespace (TTS) export/import
D.RMAN Transportable Tablespace (TTS)

Explanation

Question 27 of 34

1

27. Which three are ways to scale a Database as a Service (DBaaS) instance that is hosting three Oracle 12c databases?

Select one or more of the following:

A. Add additional virtual network interfaces (VNICs) to the DBaaS instance.
B. Increase the MEMORY_TARGET parameter value in each database instance that is running on the DBaaS instance.
C. Increase the CPU_COUNT parameter value in each database instance that is running on the DBaaS instance.
D. Increase the number of CPUs allocated to the DBaaS instance.
E. Add storage to the DBaaS instance.
F. Use the Oracle Database 12c In-Memory database option in each database instance that is running on the DBaaS instance.
G. Increase the memory allocated to the DBaaS instance.

Explanation

Question 28 of 34

1

28. Which two tasks can you perform on the Database Cloud Service Instance View page?

Select one or more of the following:

A. You can add pluggable databases (PDBs) to the database.
B. You can decrease the storage of an instance.
C. You can see patching information.
D. You can create new users to access an instance.
E. You can scale up to increase the shape of the current instance.

Explanation

Question 29 of 34

1

29. Which two must be true when you migrate an Oracle Database 12.1.0.2 non-CDB to a database that is running in a Database as a Service (DBaaS) instance on Oracle Cloud by using the Remote Cloning method?

Select one or more of the following:

A. The non-CDB may be opened in READ WRITE mode as long as ARCHIVELOG is enabled.
B. The database link owner must have the CREATE PDB system privilege.
C. The source platform must have the same endian format.
D. The non-CDB must be in archivelog mode.
E. The non-CDB must be opened in READ ONLY mode.
F. The database link owner must have the CREATE PLUGGABLE DB system privilege.

Explanation

Question 30 of 34

1

30. You want to control network traffic among your DBaaS instances. Which two statements are true about network groups?

Select one or more of the following:

A. By default, the DBaaS instances in a network group are accessible from hosts outside the network group.
B. You can add a DBaaS instance to a network group, but this enables communication only within this network group.
C. You can add a DBaaS instance to a network group, thus enabling communication with all other DBaaS instances both inside and outside the network group.
D. You can create a network group to enable unrestricted communication among your DBaaS instances.
E. DBaaS prevents network groups from having unrestricted communication among DBaaS instances.

Explanation

Question 31 of 34

1

31. You want to apply a patch to your Oracle Database Cloud – Database as a Service. What command will you execute to patch your database instance?

Select one or more of the following:

A. dbaascli dbpatchm –run –config
B. dbaascli dbpatchm –run -setup
C. dbaascli dbpatchm –run -apply
D. dbaascli dbpatchm –run -patch

Explanation

Question 32 of 34

1

32. You created your Database as a Service (DBaaS) database instance. Predefined network access rules are also created.
Which two predefined network access rules are created when you created the DBaaS database instance?

Select one or more of the following:

A. The ora_p2_ssh access rule for the public-internet network group is created to communicate with the ora_db predefined network group over SSH.
B. The ora_db_public access rules to manage database access through the default port 1521 and the ora_db_admin access rules for SSH connection via
SQL*Net through port 5500 are created.
C. The ora_db access rule for SSH connection via PuTTY is created to configure network rules and ora_access_console for HTTPS access to Oracle
Cloud Services Console.
D. No access rules are created by default and users must manually configure all access rules.
E. The ora_p2_dblistener access rule for the public-internet network group (any host on the Internet) is created to communicate with the ora_db predefined network group over SQL*Net.

Explanation

Question 33 of 34

1

33. How do you access “none default ports” on your DBaaS VM server?

Select one or more of the following:

A. Review a file called portlist.ini in your installation directory to acquire the list of “none default ports” that are assigned to your VM server.
B. You file a service request with your DBaaS support team to have the “none default ports” opened for use.
C. You create an SSH tunnel to the “none default port”.
D. All communication to DBaaS services must be configured only by using the default ports that are assigned to your VM server during the installation of your DBaaS instances.

Explanation

Question 34 of 34

1

34. Which two problems indicate that you should consider scaling up your Database as a Service (DBaaS) instance that hosts an Oracle Database 12c multitenant
container database (CDB) with four pluggable databases (PDBs)?

Select one or more of the following:

A. shortage of CPU for two PDBs in the CDB
B. shortage of I/O bandwidth for the parallel queries that are issued by the CDB instance
C. shortage of memory for the DBaaS instance
D. shortage of memory in the Shared Pool of the CDB
E. shortage of CPU for the DBaaS instance

	Created by A A about 6 years ago

Quiz on DBaaS Cloud Cert (1Z0-160) - N1 - 1a34, created by A A on 11/04/2018.

DBaaS Cloud Cert (1Z0-160) - N1 - 1a34

Question 1 of 34

1. Which two statements are true about the Database as a Service (DBaaS) instances and Oracle database instances that are provided by Oracle Public Cloud?

Select one or more of the following:

Explanation

Question 2 of 34

2. Which users are created and can be used for database and host management of your DBaaS database servers?

Select one or more of the following:

Explanation

Question 3 of 34

3. You are working on a DBaaS database instance. Identify the location for the associated database files for your instance.

Select one or more of the following:

Explanation

Question 4 of 34

Select one or more of the following:

Explanation

Question 5 of 34

5. Which three statements are true about the Oracle Cloud Service storage volumes that are created as part of a Database as a Service (DBaaS) instance in Oracle Public Cloud?

Select one or more of the following:

Explanation

Question 6 of 34

6. ¿¿¿???? 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)?

Select one or more of the following:

Explanation

Question 7 of 34

7.¿¿¿¿???? 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?

Select one or more of the following:

Explanation

Question 8 of 34

8. How would you stop Oracle REST Data Services (ORDS)?

Select one or more of the following:

Explanation

Question 9 of 34

9. Which statement is true about the Database as a Service (DBaaS) instances and Database instances in Oracle Public Cloud?

Select one or more of the following:

Explanation

Question 10 of 34

10. When you are using Oracle Compute Service Console and reviewing the network configuration of your database instance, what do the arrows that are shown within the Access Rules define?

Select one or more of the following:

Explanation

Question 11 of 34

11. You wish to perform database recovery and restore the most recent backup. Which two steps will you perform?

Select one or more of the following:

Explanation

Question 12 of 34

Select one or more of the following:

Explanation

Question 13 of 34

13. dbaascli is a command-line interface for managing a database instance on cloud. Which two functions can you manage with dbaascli?

Select one or more of the following:

Explanation

Question 14 of 34

14. Which two situations require that your Database as a Service (DBaaS) instance be scaled up?

Select one or more of the following:

Explanation

Question 15 of 34

15. You want to access your database over SQL*Net with a client application that is running locally on your machine. How would you enable access to port 1521 of the Compute Node (VM)?

Select one or more of the following:

Explanation

Question 16 of 34

16. You want to make sure that Oracle Application Express (APEX) is enabled and accessible. Which two steps must you perform? Ivan dice A-B

Select one or more of the following:

Explanation

Question 17 of 34

17. You may need to create an on-demand backup of a database instance, or restore a backup. Which two steps are true about performing an on-demand backup?

Select one or more of the following:

Explanation

Question 18 of 34

18. You did not configure Backup and Recovery during instance creation. You therefore need to schedule your backup strategy with RMAN. Which two tasks would you need to perform to customize the backup configuration?

Select one or more of the following:

Explanation

Question 19 of 34

19. You have an Oracle Database 11g on-premises database with encrypted tablespaces. You want to migrate this database to the pre-created database of the Database as a Service (DBaaS) instance on Oracle Cloud. Which two statements are true about this migration?

Select one or more of the following:

Explanation

Question 20 of 34

20. You want to use traditional GUI tools on a Database as a Service (DBaaS) instance. You have configured PuTTY and SSH sessions. What two things would you need to configure?

Select one or more of the following:

Explanation

1. Which two statements are true about the Database as a Service (DBaaS) instances and
Oracle database instances that are provided by Oracle Public Cloud?

2. Which users are created and can be used for database and host management of your
DBaaS database servers?

5. Which three statements are true about the Oracle Cloud Service storage volumes that are
created as part of a Database as a Service (DBaaS) instance in Oracle Public Cloud?

6. ¿¿¿???? 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)?

7.¿¿¿¿???? 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?

9. Which statement is true about the Database as a Service (DBaaS) instances and Database
instances in Oracle Public Cloud?

10. When you are using Oracle Compute Service Console and reviewing the network
configuration of your database instance, what do the arrows that are shown within the
Access Rules define?

11. You wish to perform database recovery and restore the most recent backup.
Which two steps will you perform?

13. dbaascli is a command-line interface for managing a database instance on cloud.
Which two functions can you manage with dbaascli?

14. Which two situations require that your Database as a Service (DBaaS) instance be scaled
up?

15. You want to access your database over SQL*Net with a client application that is running
locally on your machine.
How would you enable access to port 1521 of the Compute Node (VM)?

16. You want to make sure that Oracle Application Express (APEX) is enabled and accessible.
Which two steps must you perform? Ivan dice A-B

17. You may need to create an on-demand backup of a database instance, or restore a
backup.
Which two steps are true about performing an on-demand backup?

18. You did not configure Backup and Recovery during instance creation. You therefore need
to schedule your backup strategy with RMAN.
Which two tasks would you need to perform to customize the backup configuration?

19. You have an Oracle Database 11g on-premises database with encrypted tablespaces.
You want to migrate this database to the pre-created database of the Database as a
Service (DBaaS) instance on Oracle Cloud.
Which two statements are true about this migration?

20. You want to use traditional GUI tools on a Database as a Service (DBaaS) instance. You
have configured PuTTY and SSH sessions.
What two things would you need to configure?

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

23.¿¿??? Which two statements are true about the SSH tunnels within a Database as a Service
(DBaaS) Cloud environment?

26. You are migrating an Oracle Database 11.2.0.2 on-premise database to an Oracle Database Cloud Service (Database as a Service) that provides a pre-created Oracle Database 11.2.0.4 database.
Which two migration methods are possible?

32. You created your Database as a Service (DBaaS) database instance. Predefined network access rules are also created.
Which two predefined network access rules are created when you created the DBaaS database instance?

34. Which two problems indicate that you should consider scaling up your Database as a Service (DBaaS) instance that hosts an Oracle Database 12c multitenant
container database (CDB) with four pluggable databases (PDBs)?