Copy and Edit

DBaaS Cloud Cert (1Z0-160) - N1 - 35-72

Description

Quiz on DBaaS Cloud Cert (1Z0-160) - N1 - 35-72, created by A A on 22/04/2018.
A A
Quiz by A A, updated more than 1 year ago
A A
Created by A A over 6 years ago
53
1
0

Resource summary

Question 1

Question
35. Identify the access that is initially available to connect to your Database as a Service (DBaaS) environment.
Answer
  • A.telnet on port 23
  • B.SSH on port 22
  • C.SSL/TLS on port 443
  • D.Cloud Control on port 7799
  • E.Enterprise Manager on port 1158

Question 2

Question
36. You are using access rules to control network traffic among your DBaaS instances. Which statement is true about access rules?
Answer
  • A. They are used only for configuring external server access to DBaaS and do not impact how network groups communicate.
  • B. They define a specific communication path, which consists of a source, destination, and protocol-port combination over which communication is allowed.
  • C. They are used to map an external user to a database user to allow the user to communicate with and access the database.
  • D. They are used to encrypt communication between DBaaS instances.

Question 3

Question
37. You want to migrate an Oracle Database 11.2.0.2 on-premises database to the Oracle Database 11g database of the Database as a Service (DBaaS) instance on Oracle Cloud. A subset of the data that you want to transfer includes data stored in LONG data type columns. All required data is contained in a dedicated tablespace. The tablespace is 100 GB in size and has 20% free space. The client wants the data migrated in the shortest possible time to minimize impact on end users. Select the most appropriate migration method to meet this requirement.
Answer
  • A. Data Pump TDB
  • B. Data Pump TTS
  • C. SQL*Loader Direct Path
  • D. Conventional export/import
  • E. Remote Cloning

Question 4

Question
38. 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 opc. Which three functions can the opc user perform?
Answer
  • A. dropping the database instance
  • B. any root-user operation
  • C. database tuning
  • D. database backup and recovery
  • E. administrative operations in the virtual machine
  • F. operations that requires root-user access

Question 5

Question
39. Which three statements are true about the service levels provided by Database as a Service (DBaaS)?
Image:
C17 (binary/octet-stream)
Answer
  • A. The Virtual Image service level provides a pre-created database.
  • B. The Virtual Image service level provides tools for backups and patching.
  • C. The automated service provides a pre-installed virtual machine image
  • D. The automated service provides a pre-created database.
  • E. The cloud tooling within the automated service level provides a tool for point-in-time database recovery.

Question 6

Question
40. Which three statements are true about SSH tunnels in a Database as a Service (DBaaS) Cloud configuration? IVAN DICE B – C – F y tiene sentido | yo he dicho A C F
Answer
  • A. A separate SSH tunnel is required for each port that is required for the environment.
  • B. The SSH tunnel should include all required ports for the environment.
  • C. The available protocols include ssh-2 DSA.
  • D. The default protocol is ssh-1 RSA.
  • E. The SSH tunnel is opened automatically by the Cloud Services VPN and remains open.
  • F. The SSH tunnel must be opened manually and must remain open.

Question 7

Question
41. Which three will be supported after migrating an on-premises database to a Database as a Service (DBaaS) instance on Oracle Cloud?
Answer
  • A. increased security of application roles
  • B. reduction in operational costs
  • C. ability to increase capacity on demand
  • D. provisioning of application testing
  • E. centralization of database management

Question 8

Question
43. What are two things can you do on the My Services Dashboard page?
Answer
  • A. You can customize the metric icon for each valid service.
  • B. You can add a data center and identity domain to your Cloud account.
  • C. You can activate services for the current data center and identity domain.
  • D. You can check the overall status of your active services for the current data center and identity domain.

Question 9

Question
44. You get complaints from users of several different applications that performance has degraded over time. These applications run in this configuration: 1. There is one database and database instance, which is an Oracle 12c multitenant Container Database (CDB) with five Pluggable Databases (PDBs). 2. One of the poorly performing applications run in one of the PDBs. 3. One of the poorly performing applications runs in a different PDB in the same CDB. 4. You have the Oracle Resource Manager configured for the CDB only. 5. Each PDB has all sessions in one consumer group. A check of wait events for the sessions belonging to these applications shows that the sessions are waiting longer and that there are more sessions from other applications in the same database instance. You wish to avoid scaling up your Database as a Service (DBaaS) instance in Oracle Cloud. Which four should you check and possibly reconfigure to avoid the need to scale up the DBaaS instance?
Answer
  • A. Modify the users that are using each application so that their sessions are associated with the correct consumer group in the PDB that is hosting their application.
  • B. Check the CDB plan to configure the shares allocated to all PDBs, including the PDBs that contain the two poorly performing applications.
  • C. Check the CDB plan only to configure the shares allocated to the PDBs that contain the two poorly performing applications.
  • D. Create separate consumer groups for the sessions for all applications in the PDB plans for the PDBs that are hosting the two poorly performing applications.
  • E. Check the PDB plan for all the PDBs in the CDB, including the PDB that is hosting the two poorly performing applications.
  • F. Create a PDB plan for each PDB in the CDB that has poorly performing applications.
  • G. Create a separate CDB plan for each PDB that has poorly performing applications.

Question 10

Question
45. You are creating a new Database as a Service (DBaaS) instance. Which statement is true about connections that are created by default? -- OK
Answer
  • A. A default network connection is created to your application server.
  • B. A default network connection is created to the other instances that you have created.
  • C. No default connections are created to other DBaaS instances or to any external servers.
  • D. All network connections are pre-created within DBaaS.

Question 11

Question
46. Which two statements are true about the Database as a Service (DBaaS) instances and Oracle database instances that are provided by Oracle Public Cloud?
Image:
C20 (binary/octet-stream)
Answer
  • A. A DBaaS instance Virtual Image always provides a pre-created Oracle database.
  • B. an Oracle database instance that is provided as part of DBaaS runs a different executable than would be run with the same version and release of Oracle Database on private premises.
    Image:
    C20 (binary/octet-stream)
  • C. A DBaaS instance Virtual Image always provides a Linux virtual machine.
  • D. A DBaaS instance Virtual Image requires customers to install their preferred version on the Oracle database software.
  • E. Multiple Oracle database instances can run in a DBaaS instance on Oracle Public Cloud.

Question 12

Question
47. You are configuring network connections to your database instance. What does each network group represent?
Answer
  • A. It is used to allow unrestricted communication among some of your DBaaS instances by using a set of defined policies and access rules.
  • B. It is used to define load balancing and failover configurations between RAC database instances.
  • C. It is used to define network connections to the Pluggable Databases (PDBs) within a Container Database.
  • D. It is used to manage the connections between your external application servers (application servers that you currently use in your business environment) and your DBaaS instances.

Question 13

Question
48. Which two can be increased to scale up the compute shape of a Database as a Service (DBaaS) instance in Oracle Cloud? - OK
Image:
C22 (binary/octet-stream)
Answer
  • A. Add more memory to the DBaaS instance by using the Scale up button on the DBaaS Instance Overview page.
  • B. Add more storage to the DBaaS instance by using the Scale up button on the DBaaS Instance Overview page.
  • C. Add more network adaptors (NICs) to the storage network used by the DBaaS instance by using the Scale Up button on the DBaaS Instance Overview page.
  • D. Add more network adaptors (NICs) to the public access network used by the DBaaS Instance by using the Scale Up button on the DBaaS Instance Overview page.
  • E. Add more CPUs to the DBaaS instance by using the Scale Up button on the DBaaS Instance.

Question 14

Question
49. Your Database as a Service (DBaaS) instance hosts a multitenant container database (CDB) with four pluggable database (PDB) tenants. Users of an application in one PDB and users of another application in another PDB complain of poor performance. Investigation shows that the application sessions are not using excessive CPU nor are they requesting an unusual amount of I/O. Which two steps should you perform to resolve this problem?
Answer
  • A. Add storage to the DBaaS instance.
  • B. Add CPU to the DBaaS instance.
  • C. Examine the shares of resources allocated to each PDB within the CDB.
  • D. Examine the shares of resources allocated to each consumer group within all four PDBs.
  • E. Examine the shares of resources allocated to each consumer group within the PDBs that contain the two applications.
  • F. Add memory to the DBaaS instance.

Question 15

Question
50. You have an Oracle Database 12c on-premise non-CDB database that is running on the AIX platform. Which two methods can be used to migrate the on-premise database to a database that is running in a Database as a Service (DBaaS) instance on Oracle Cloud?
Answer
  • A. Remote Cloning  No se puede pq AIX no es little endian
  • B. Transporting Tablespaces by using RMAN convert
    Image:
    C23 (binary/octet-stream)
  • C. Data Pump
  • D. Transporting Tablespaces by using RMAN “backup from platform”
    Image:
    C24 (binary/octet-stream)
  • E. SCP file copy

Question 16

Question
51. Which are two of the tasks that must be performed to enable SQL*NET access for your DBaaS database instance over SSL?
Answer
  • A. You must open a port on the virtual machine (VM) that is hosting the instance. (con la consola de cloud o bien haciendo port forwarding)
  • B. You use Net Manager (NETMGR) to configure a database alias and set the connect string. (en el lado cliente)
  • C. You use Oracle Connection Manager to configure the required network settings  ya viene configurado por defecto (conteido del sqlnet.ora)
  • D. You must configure SSL support on the instance.  ya viene configurado por defecto:
    Image:
    C25 (binary/octet-stream)

Question 17

Question
52. You get complaints from users of several different applications that performance has degraded over time. These applications run in this configuration: 1. There are three different databases and database instances. 2. Two of the poorly performing applications run in the same Pluggable Database (PDB) in an Oracle 12c multitenant Container Database (CDB) with four PDBs. 3. One of the poorly performing applications runs in a different PDB in the same CDB. 4. One of the poorly performing applications runs in an Oracle 12c non-CDB, which also hosts other applications. 5. You have the Oracle Resource Manager configured for the CDB, all PDBs, and the non-CDB. 6. Each application has a separate consumer group associated with the sessions that are running that application. A check of wait events for the sessions belonging to these applications shows that the sessions are waiting longer and that there are more sessions from other applications in the same database instance. You wish to avoid scaling up your Database as a Service (DBaaS) instance in Oracle Cloud. Which three should you check and possibly reconfigure to avoid the need to scale up the DBaaS instance?
Answer
  • A. Check the shares allocated only to the consumer group in the non-CDB that is used by the poorly performing application.
  • B. Check the shares allocated to all consumer groups in the non-CDB.
  • C. Check the CDB plan to configure the shares allocated to all PDBs, including the PDB that contains the two poorly performing applications.
  • D. Check the PDB plan for the PDB that is hosting the two poorly performing applications.
  • E. Check the CDB plan only to configure the shares allocated to the PDB that contains the two poorly performing applications.
  • F. Check the PDB plan for all the PDBs in the CDB, including the PDB that is hosting the two poorly performing applications.

Question 18

Question
53. You want to perform an on-demand backup. Which two statements are true?
Answer
  • A. Connect to the instance’s VM as the opc user.
  • B. Connect to the instance’s VM as the oracle user.
  • C. Disable the backup configuration (crontab).
  • D. Enable the backup configuration (crontab).

Question 19

Question
54. You are preparing the storage volume for use in an instance. Which two tasks must you perform?
Answer
  • A. Point to a mount point that has existing files and directories.
  • B. Connect to the DBaaS instance to which you attached the storage volume by using SSH or PuTTY as the opc user.
  • C. Create a mount point on your instance.
  • D. Connect to the DBaaS instance to which you attached the storage volume by using ssh or PuTTY as the oracle user.

Question 20

Question
55. You are monitoring resource usage on your Database Cloud Service. What two resource usage metrics can you find on the Instance Overview page?
Image:
C26 (binary/octet-stream)
Answer
  • A. number of days left on your subscription
  • B. number of processes allocated
  • C. I/O from reads and writes
  • D. memory
  • E. storage
  • F. number of current users

Question 21

Question
56. You want to make sure that your database administrators have a convenient way to monitor your DBaaS instance. To do so, you need to enable the Oracle DBaaS Monitor. How would you enable the Oracle DBaaS Monitor?
Answer
  • A. Use the enable_dbaas_monitor command.
  • B. Create an SSH tunnel to port 443.
  • C. Disable the ora_p2_httpssl security rule in Oracle Compute Cloud Service Console.
  • D. Use the Oracle GlassFish Server Administration Console.
  • E. Add ODBM access to each DBA’s user profile.

Question 22

Question
57. Which statement is true about Database Schema Service and Database as a Service in Oracle Public Cloud?
Answer
  • A. Database Schema Service requires no database administrators to administer the database.
  • B. Database as a Service (DBaaS) requires no database administrators to administer the database.
  • C. Database as a Service (DBaaS) provides complete database instances with shared control between the subscriber DBA and Oracle Support.
  • D. Database Schema Service provides database schemas with shared control between the subscriber DBA and Oracle Support.

Question 23

Question
58. A key pair is required to create a DBaaS instance. What can the key pair be used for?
Answer
  • A. They key pair is used to start up, shut down, and manage EM Express availability.
  • B. The keys are used to control the encryption that is used by DBaaS database instances: the first is for network encryption and the second is for database encryption.
  • C. The keys replace password use. DBaaS instance use only key pairs; password authentication is not enable for SSH default connections.
  • D. Communication between instances in a DBaaS account is controlled by network access rules and network groups.

Question 24

Question
59. What are two ways to enable a port on your DBaaS VM server for access to your DBaaS instance?
Answer
  • A. Use your public and private key pairs to define a list of preferred ports that get enabled during your DBaaS instance installation.
  • B. Create a tunnel for port forwarding by using SSH.
  • C. Configure all remote connections through port 22 that is assigned by default for SSH connections.
  • D. Ask Oracle DBaaS Support to open the required ports.
  • E. Use the DBaaS Compute Cloud Service Console to open ports to a set of IP addresses.

Question 25

Question
60. You are on the Database Cloud Service Instance View page. Which three consoles can you open?
Image:
C27 (binary/octet-stream)
Answer
  • A. OPC Console
  • B. GlassFish Administration Console
  • C. Storage Container Console
  • D. Application Express Console
  • E. User Console
  • F. Database Express Manager Console

Question 26

Question
61. How do you enable a default connection between Database as a Service (DBaaS) instances?
Answer
  • A. by creating network groups and adding the instances that you want to communicate to that group
  • B. by creating dedicated communication keys and setting them to be used only for your DBaaS instance-to-instance communication
  • C. by creating nothing for communication between the DBaaS instances because all instances are interconnected by default
  • D. by installing and configuring the NETMGR utility for your DBaaS environment, and then using it to set up the required communication channels

Question 27

Question
62. How would you connect from your local machine to the database instance on the DBaaS server by using SQL*Net?
Answer
  • A. You start an SSH process on your local machine to communicate to a tunnel created on the DBaaS server.
  • B. You must use port 1521 and the TCPS communication protocol.
  • C. You can use only the SSH connection that is defined on port 22 that is configured by default during DBaaS instance installation.
  • D. You must use Transparent Data Encryption (TDE) to secure connections to the DBaaS database instance when using SQL*Net connections from your local machine to DBaaS database instances.

Question 28

Question
63. 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?
Image:
C28 (binary/octet-stream)
Answer
  • A. dbsnmp
  • B. sys
  • C. dbaas_monitor
  • D. sysman

Question 29

Question
64. Where is the Oracle Database Cloud software for monitoring and backup installed?
Image:
C29 (binary/octet-stream)
Answer
  • A. The Oracle Database Cloud software is located in the Database Automatic Diagnostic Repository (ADR).
  • B. The installation is done at /var/opt/oracle/dbaascli and /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.

Question 30

Question
65. 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 the oracle user perform?
Answer
  • A. Grant privileges and roles to database users.
  • B. Create database users.
  • C. Back up and recover databases.  OPC user using sudo
  • D. Create tablespaces.
  • E. Reboot a VM.  ROOT
  • F. Use the sudo command to perform root user access operations.  OPC user

Question 31

Question
66. 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?
Image:
C30 (binary/octet-stream)
Answer
  • A. conventional export/import
  • B. Transportable Tablespace (TTS) with RMAN conversion
  • C. Transportable Tablespace (TTS) by using Oracle Data Pump
  • D. SQL *Loader  NO ESTÁ SOPORTADO
  • E. RMAN image restore  NO SE CONTEMPLA ESTE MÉTODO
  • F. Data Pump Transportable Database (TDB) export/import

Question 32

Question
67. You want to perform database recovery with the most recent backup. Which command would you execute?
Answer
  • A. dbaascli rec –args –latest
  • B. dbaascli orec –args -latest
  • C. dbaascli rec –args -last
  • D. dbaascli orec –args –last

Question 33

Question
68. Which two statements are true about the information that you see on the Database Cloud Service page?
Answer
  • 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.

Question 34

Question
QUESTION 16 You get complaints from users of several different applications that performance has degraded over time. These applications run in this configuration: 1. There are three different databases and database instances. 2. Two of the poorly performing applications run in the same Pluggable Database (PDB) in an Oracle 12c multitenant Container Database (CDB) with four PDBs. 3. One of the poorly performing applications runs in a different PDB in the same CDB. 4. One of the poorly performing applications runs in an Oracle 12c non-CDB, which also hosts other applications. 5. You have the Oracle Resource Manager configured for the CDB, all PDBs, and the non-CDB. 6. Each application has a separate consumer group associated with the sessions that are running that application. A check of wait events for the sessions belonging to these applications shows that the sessions are waiting longer and that there are more sessions from other applications in the same database instance. You wish to avoid scaling up your Database as a Service (DBaaS) instance in Oracle Cloud. Which three should you check and possibly reconfigure to avoid the need to scale up the DBaaS instance?
Answer
  • A. Check the shares allocated only to the consumer group in the non-CDB that is used by the poorly performing application.
  • B. Check the shares allocated to all consumer groups in the non-CDB.
  • C. Check the CDB plan to configure the shares allocated to all PDBs, including the PDB that contains the two poorly performing applications.
  • D. Check the PDB plan for the PDB that is hosting the two poorly performing applications.
  • E. Check the CDB plan only to configure the shares allocated to the PDB that contains the two poorly performing applications.
  • F. Check the PDB plan for all the PDBs in the CDB, including the PDB that is hosting the two poorly performing applications.

Question 35

Question
QUESTION 22 Which two statements are true about the Database as a Service (DBaaS) instances and Oracle database instances that are provided by Oracle Public Cloud?
Answer
  • A. A DBaaS instance Virtual Image always provides a pre-created Oracle database.
  • B. An Oracle database instance that is provided as part of DBaaS runs a different executable than would be run with the same version and release of Oracle Database on private premises.
  • C. A DBaaS instance Virtual Image always provides a Linux virtual machine.
  • D. A DBaaS instance Virtual Image requires customers to install their preferred version on the Oracle database software.
  • E. Multiple Oracle database instances can run in a DBaaS instance on Oracle Public Cloud.

Question 36

Question
QUESTION 30 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 opc. Which three functions can the opc user perform?
Answer
  • A. dropping the database instance
  • B. any root-user operation
  • C. database tuning
  • D. database backup and recovery
  • E. administrative operations in the virtual machine
  • F. operations that requires root-user access

Question 37

Question
QUESTION 37 Which statement is true about Database Schema Service and Database as a Service in Oracle Public Cloud?
Answer
  • A. Database as a Service (DBaaS) requires no database administrators to administer the database.
  • B. Database Schema Service requires a database administrator to administer the schemas.
  • C. Database as a Service (DBaaS) provides complete dedicated database instances with full administrative control for a subscriber
  • D. Database Schema Service provides database schemas with full administrative control for a subscriber.

Question 38

Question
QUESTION 73 Which statement is true about the Oracle sofware releases that are currently supported in a Database as a Service (DBaaS) instance in Oracle Public Cloud?
Answer
  • A. All versions and releases of Oracle Database 12c are supported.
  • B. All versions and releases of Oracle Database 11g are supported.
  • C. Oracle Database 11g Release 2 is supported.
  • D. Oracle Database 12c is supported but only for single container databases
Show full summary Hide full summary

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

Periodicity
hanalou
OCR AS Biology - Enzymes
Chris Osmundse
Mechanics
james_hobson
Media Studies Quiz
Amanda Louise Lord
Animal vs. Plant Cells
JimJam5
infrastructure midterm
maxwell3254
Computer Systems
lisawinkler10
GCSE REVISION TIMETABLE
neharaniga
“The knower’s perspective is essential in the pursuit of knowledge.” To what extent do you agree with this statement?
Lucia Rocha Mejia
World War I Practice Test Questions 2016
Chris Barth
VO QUALI uni wien
Jules D
Browse Library