Oracle 1Z0-160 問題集

質問 1：
Where is the Oracle Database Cloud software for monitoring and backup installed?
A. The installation is done at /var/opt/oracle/dbaascli and /var/opt/oracle/bkup_api.
B. The Oracle Database Cloud software is located in the Database Automatic Diagnostic Repository (ADR).
C. The location is based on Oracle Flex Architecture, which is similar to non-DBaaS systems.
D. The location must be set during installation as user-defined locations for the installation to start.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You get complaints from users of several applications that performance has degraded over time.
These applications run in this configuration:
There are three different databases and database instances.
Two of the poorly performing applications run in the same Pluggable Database (PDB) in an Oracle 12c multitenant Container Database (CDB) with four PDBs.
One of the poorly performing applications runs in a different PDB in the same CDB.
One of the poorly performing applications runs in an Oracle 12c non-CDB, which also hosts other applications.
You have the Oracle Resource Manager configured for the CDB, all PDBs, and the non-CDB.
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 want to avoid scaling up your Database Deployment in Oracle Cloud.
Which three should you check and possibly reconfigure to avoid scaling up the Database Deployment?
A. Check the CDB plan only to configure the shares allocated to the PDB that contains the two poorly performing applications.
B. Check the PDB plan for the PDB that is hosting the two poorly performing applications.
C. Check the PDB plan for all the PDBs in the CDB, including the PDB that is hosting the two poorly performing applications.
D. Check the shares allocated to all consumer groups in the non-CDB.
E. Check the shares allocated only to the consumer group in the non-CDB that is used by the poorly performing application.
F. Check the CDB plan to configure the shares allocated to all PDBs, including the PDB that contains the two poorly performing applications.
正解：C,D,F

質問 3：
Examine these commands:
1. # dbaascli dbpatchm --run -prereq
2. # dbpatchmdg -precheck_async patch_id
3. $ raccli apply patch -db -tag tag-name -prechecks
Which is true?
A. Only 1 and 3 will execute successfully and check the prerequisites.
B. Only 1 and 2 will execute successfully and check the prerequisites.
C. Only 2 and 3 will execute successfully and check the prerequisites.
D. All three commands will execute successfully and check the prerequisites.
正解：D

質問 4：
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. conventional export/import
B. Remote Cloning
C. SQL*Loader Direct Path
D. Data Pump TTS
E. Data Pump TDB
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which two can be increased to scale up the compute shape of a Database Deployment in Oracle Database Cloud Service?
A. Add more network adaptors (NICs) to the storage network used by the Database Deployment by using the Scale Up button on the Oracle Database Cloud Service Overview page.
B. Add more storage to the Database Deployment by using the Scale up button on the Oracle Database Cloud Service Overview page.
C. Add more network adaptors (NICs) to the public access network used by the Database Deployment by using the Scale Up button on the Oracle Database Cloud Service Overview page.
D. Add more memory to the Database Deployment by using the Scale up button on the Oracle Database Cloud Service Overview page.
E. Add more CPUs to the Database Deployment by using the Scale Up button on the Oracle Database Cloud Service Overview page.
正解：D,E
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You want to make sure that Oracle Application Express (APEX) is enabled and accessible.
Which two steps must you perform?
A. Enable the ora_p2_httpssl security rule in the Oracle Compute Cloud Service console.
B. Select deploy_enable from the DBaaS monitor.
C. Create an SSH tunnel to port 443 on a Database Deployment's compute node.
D. Select apex_launch from the GlassFish Server Administration Console monitor.
E. Unblock the APEX instance's VM and follow the URL to instance-ip-address: 4848.
正解：C,E
解説: (Topexam メンバーにのみ表示されます)

質問 7：
How would you enable a port persistently to keep communication always open through that port?
A. All ports that are available in Oracle Database Cloud Service servers must use an SSH tunnel and cannot be enabled persistently.
B. You would require access to the Oracle Compute Cloud Service console to open the ports to a set of IP addresses.
C. You must contact your Oracle Database Cloud Service support team to update the port specifications for use.
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.
正解：D