1Z0-160 Online Practice Questions and Answers
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.
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.
Which three will be supported after migrating an on-premises database to a Database as a Service (DBaaS) instance on Oracle Cloud?
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
Which three statements are true about SSH tunnels in an Oracle Database Cloud Service configuration?
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.
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.
A. Data Pump TDB
B. Data Pump TTS
C. SQL*Loader Direct Path
D. conventional export/import
E. Remote Cloning
Identify the access that is initially available to connect to your Oracle Database Cloud Service environment?
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
How do you access “none default ports” on a Database Deployment's compute node?
A. Review a file called portlist.ini in your installation directory to acquire the list of “none default ports” that are assigned to your compute node.
B. File a service request with your Oracle Database Cloud Service support team to have the “none default ports” opened for use.
C. Create an SSH tunnel to the “none default port”.
D. All communication to Oracle Database Cloud Service must be configured only by using the default ports that are assigned to your compute node during the installation of your Database Deployments.
Which statement is true about Oracle Database Schema Service or Oracle Database Cloud Service (DBCS)?
A. Oracle Database Cloud Service does not require database administrators to administer the database.
B. Oracle Database Schema Service requires a database administrator to administer the schemas.
C. Oracle Database Cloud Service provides complete dedicated database instances with full administrative control for a subscriber.
D. Oracle Database Schema Service provides database schemas with full administrative control for a subscriber.
You created a Database Deployment and predefined security rules were generated.
Which two predefined security rules were generated when you created the Database Deployment?
A. The ora_p2_ssh security rule for the public-internet security IP list was created to communicate with the ora_dbpredefined network group over SSH.
B. The ora_db_public security rules to manage database access through the default port 1521 and the ora_db_admin security rules for SSH connection via SQL*Net through port 5500 were created.
C. The ora_access db security rule for SSH connection via PuTTY is created to configure network rules and ora_access_consolefor HTTPS access to Oracle Cloud Services Console.
D. No security rules are created by default and users must manually configure all access rules.
E. The ora_p2_dblistener security rule for the public-internet security IP list (any host on the Internet) was created to communicate with the ora_dbpredefined network group over SQL*Net.
You want to control network traffic among your DBaaS instances.
Which two statements are true about network groups?
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.
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?
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.
Which two statements are true about a Database Deployment in Oracle Public Cloud?
A. A Secure Shell (SSH) key is provided by Oracle for accessing the compute nodes as the first step in creating a Database Deployment.
B. The billing frequency depends on the Oracle database software edition that is selected for the Database Deployment.
C. The public SSH key is provided when configuring the database in the Database Deployment.
D. Storage configuration must be selected for the Database Deployment.
E. The database that is configured may be an Oracle 11gR2 database.
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)?
A. Use Oracle Compute Cloud Service to enable the ora_p2_dblistenersecurity rule.
B. Run the lsnrctl reload listenercommand.
C. Use the Application Express Console to start the listener application.
D. Change the firewall rules.
Which two statements are true about the SSH tunnels within an Oracle Database Cloud Service environment?
A. An individual SSH tunnel is required for each port in the environment.
B. The client must provide the server with the SSH private key.
C. The SSH tunnel must be selected by a security rule to enable remote access.
D. The server must hold the SSH public and private keys in the SSH authorized_keysfile.
E. Oracle Database Cloud Service provides a centralized key server for all SSH connections.
Which three consoles can be accessed from the Oracle Database Deployment page?
A. Database Express Manager Console
B. OPC Console
C. Application Express Console
D. User Console
E. Storage Container Console
F. DBaaS Monitor Console
Why select/choose certbus.com?
Millions of interested professionals can touch the destination of success in exams by certbus.com. products which would be available, affordable, updated and of really best quality to overcome the difficulties of any course outlines. Questions and Answers material is updated in highly outclass manner on regular basis and material is released periodically and is available in testing centers with whom we are maintaining our relationship to get latest material.
Copyright © 2004-2025 certbus.com, All Rights Reserved.