DON'T WANT TO MISS A THING?

Certification Exam Passing Tips

Latest exam news and discount info

Curated and up-to-date by our experts

Yes, send me the newsletter

Pass Your Oracle 1Z0-060 Certification Questions & Practice Tests, Oracle Database 12c | SPOTO

Welcome to SPOTO's Oracle 1Z0-060 Certification Questions & Practice Tests page, dedicated to helping you ace your Oracle Database 12c exam. Our platform offers a wealth of resources including practice tests, free tests, online exam questions, sample questions, exam dumps, exam questions and answers, mock exams, and comprehensive exam materials. Designed to cater to candidates aiming to master topics such as Configuring and Creating CDBs and PDBs, Information Lifecycle Management and Storage Enhancements, Auditing, Resource Manager, and Other Performance Enhancements, as well as the Basics of Multitenant Container Database (CDB), our latest practice tests are crafted to guide you towards success in passing the certification exam. Trust in SPOTO's expertise and unlock your potential for success today.

Take other online exams
Question #1
Examine the current value for the following parameters in your database instance: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issue the following command to increase the value of DB_8K_CACHE_SIZE: SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M; Which statement is true?
A. It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically
B. It succeeds only if memory is available from the autotuned components if SG
C. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET
D. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE
View answer
Correct Answer: ABD
Question #2
Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container: Which two statements are true?
A. Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs
B. The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root
C. The command will, create a common user whose description is contained in the root and each PD
D. The schema for the common user C # # A_ADMIN can be different in each container
E. The command will create a user in the root container only because the container clause is not use
View answer
Correct Answer: D
Question #3
You execute the following PL/SQL: Which two statements are true?
A. Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accesse
B. FGA is enabled for the PRODUCTS
C. FGA is enabled for all DML operations by JIM on the PRODUCTS
D. FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial
View answer
Correct Answer: AD
Question #4
In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you find that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?
A. Decreasing PCTUSED
B. Decreasing PCTFREE
C. Increasing the number of DBWN process
D. Using Automatic Segment Space Management (ASSM)
E. Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation
View answer
Correct Answer: CE
Question #5
Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp. A user issues a query on a table on one of the PDBs and receives the following error: ERROR at line 1: ORA-01565: error in identifying file ‘/u01/app/oracle/oradata/CDB1/temp01.tmp’ ORA-27037: unable to obtain file status Identify two ways to rectify the error.
A. Add a new temp file to the temporary tablespace and drop the temp file that that produced the error
B. Shut down the database instance, restore the temp01
C. Take the temporary tablespace offline, recover the missing temp file by applying redo logs, and then bring the temporary tablespace online
D. Shutdown the database instance, restore and recover the temp file from the backup, and then open the database with RESETLOGS
E. Shut down the database instance and then restart the CDB and PDBs
View answer
Correct Answer: B

View Answers after Submission

Please submit your email and WhatsApp to get the answers of questions.

Note: Please make sure your email ID and Whatsapp are valid so that you can get the correct exam results.

Email:
Whatsapp/phone number:


Copyright © 2024. Designer by SPOTO Official Website. All Rights Reserved.