Free 1Z1-160 Questions for Oracle 1Z1-160 Exam

Question #1

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

A. The SSH tunnel must be selected by an access rule to enable remote access.

B. The client must provide the server with the SSH private key.

C. DBaaS provides a centralized key server for all SSH connections.

D. The server must hold the SSH public and private keys in the SSH authorized_keys file.

Discussion 0

Correct Answer: A,B Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #2

You created a Database Deployment. This action also created a virtual machine and configured it for the Database Deployment. It also created two user accounts. One of the users is opc.
Which three functions can the opc user perform?

A. dropping the database instance

B. administrative operations on the virtual machine

C. database tuning

D. any operation that can be performed by a root user

E. operations any user with root access can perform

F. database backup and recovery by using the cloud tool

Discussion 0

Correct Answer: B,E,F Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #3

Which statement is true about Oracle Database Schema Service or Oracle Database Cloud Service (DBCS)?

A. Oracle Database Schema Service provides database schemas with full administrative control for a subscriber.

B. Oracle Database Cloud Service does not require database administrators to administer the database.

C. Oracle Database Cloud Service provides complete dedicated database instances with full administrative control for a subscriber.

D. Oracle Database Schema Service requires a database administrator to administer the schemas.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #4

Which three are ways to scale a Database Deployment to solve performance degradation by resource shortage?

A. Add storage to the Database Deployment.

B. Increase the number of CPUs allocated to the Database Deployment.

C. Increase the memory allocated to the Database Deployment.

D. Increase the MEMORY_TARGET parameter value in each database instance that is running on the Database Deployment.

E. Add additional virtual network interfaces (VNICs) to the Database Deployment.

F. Increase the CPU_COUNT parameter value in each database instance that is running on the Database Deployment.

G. Use the Oracle Database 12c In-Memory database option in each database instance that is running on the Database Deployment.

Discussion 0

Correct Answer: A,B,C Vote an answer

Question #5

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. SQL *Loader

B. Transportable Tablespace (TTS) by using Oracle Data Pump

C. Transportable Tablespace (TTS) with RMAN conversion

D. Data Pump Transportable Database (TDB) export/import

E. RMAN image restore

F. conventional export/import

Discussion 0

Correct Answer: A,B,C,D Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #6

Your Database Deployment 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?

A. Add memory to the Database Deployment.

B. Add storage to the Database Deployment.

C. Examine the shares of resources allocated to each consumer group within the PDBs that contain the two applications.

D. Add CPU to the Database Deployment.

E. Examine the shares of resources allocated to each consumer group within all four PDBs.

F. Examine the shares of resources allocated to each PDB within the CDB.

Discussion 0

Correct Answer: A,C Vote an answer

Question #7

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?

A. Use the Oracle GlassFish Server Administration Console.

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 enable_dbaas_monitor command.

E. Add ODBM access to each DBA's user profile.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #8

What is the location of the associated database files of a Database Deployment?

A. All database instance files on the Database Deployment are stored at /u01/app/oracle/oradata.

B. The installer sets the database file locations during installation by configuring the data file storage options.

C. The database file locations are read from utldbfiles.ora and users can update this file to set their own locations.

D. 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

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #9

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?

A. You can use Data Pump TTS with the ENCRYPTION_PASSWORD parameter.

B. You can use Full Transportable (TDB).

C. You can use Data Pump TTS with the ENCRYPTED_PASSWORD parameter.

D. Data is sent in clear when the NETWORK_LINK option is used.

E. The on-premises database platform must be of the same endianness as the DBaaS platform.

Discussion 0

Correct Answer: A,E Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Free 1Z1-160 Questions for Oracle Database Cloud Service 1Z1-160 Exam as PDF & Practice Test Engine

Download Free Oracle 1Z1-160 Demo