Oracle 1Z0-160 問題集

質問 1：
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

質問 2：
Which three statements are true about the Oracle Cloud Service storage volumes that are created as part of a Database Deployment in Oracle Public Cloud?
A. The database backup storage and the redo log storage are placed on the same storage volume.
B. The database data file storage and the tempfile storage are placed on the same storage volume.
C. The database backup storage and the database product software storage are placed on different storage volumes.
D. The Oracle database product software storage and the database data file storage are placed on the same storage volume.
E. The database data file storage and the redo log storage are placed on different storage volumes.
正解：B,C,E
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which three actions can you perform from the Oracle Cloud My Services Dashboard page?
A. Create a Database Deployment.
B. View the date and time of the last access to each database instance.
C. Activate services for the current data center and identity domain.
D. Add a data center and identity domain to your Cloud account.
E. Get Oracle GoldenGate Cloud Service details.
F. Get Oracle Compute Cloud Service details.
正解：C,E,F

質問 4：
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?
A. None. No backups required. You are responsible for configuring the database backups.
B. Backing up to Oracle Cloud Service storage volumes which is equal to five times the value that was provided in Usable Data Storage when the instance was created.
C. Backing up to cloud storage and local compute storage. 30 (thirty) days worth of backups are kept, with seven most recent days worth of backups available directly on local compute node storage.
D. Backing up to cloud storage and local compute storage. 10 (ten) days worth of backups are kept, with five most recent days worth of backups available directly on the local compute node storage.
正解：A,B

質問 5：
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?
A. dbsnmp
B. dbaas_monitor
C. sys
D. sysman
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which two situations require that your Database Deployment be scaled up?
A. The Database Deployment instance is maxed out on semaphore sets.
B. The Database Deployment is maxed out on storage.
C. The database instance is out of space in the sysaux and system tablespaces.
D. The Database Deployment is maxed out on CPU.
E. The Database Deployment is maxed out on semaphores.
F. The database instance has reached the limit in the license_max_sessions database parameter.
正解：B,D
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which two functions can be managed by using the dbaascli tool?
A. creating a database instance
B. running health checks on your database
C. creating users in the database instance
D. applying a patch
E. restoring from the most recent backup
正解：D,E
解説: (Topexam メンバーにのみ表示されます)