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

Best Oracle 1Z0-060 Practice Exams and Real Exam Simulations, Oracle Database 12c | SPOTO

Welcome to SPOTO's Best Oracle 1Z0-060 Practice Exams and Real Exam Simulations page, your ultimate destination for mastering the Oracle Database 12c certification. Our platform offers a comprehensive range of resources including practice tests, free tests, online exam questions, sample questions, exam dumps, exam questions and answers, mock exams, and top-notch exam materials. Tailored to cover key 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 meticulously designed to equip you with the knowledge and skills needed to pass the certification exam with flying colors. Trust in SPOTO's proven track record and elevate your chances of success today.
Take other online exams

Question #1
The following parameter are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You want to manage the SQL plan evolution task manually. Examine the following steps: 1. Set the evolve task parameters. 2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function. 3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function. 4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE
A. 2, 4, 5
B. 2, 1, 4, 3, 5
C. 1, 2, 3, 4, 5
D. 1, 2, 4, 5
View answer
Correct Answer: B
Question #2
In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure: CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2, v_SALARY NUMBER, v_dept_id NUMBER) BEGIN INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id); END; / GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king; How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure fro
A. Create the CREATE_TEST procedure with definer’s rights
B. Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure
C. Create the CREATE_TEST procedure with invoker’s rights
D. Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package
View answer
Correct Answer: AC
Question #3
What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving enabled?
A. It fails with the ORA-665610 Invalid DDL statement on history-tracked message
B. The rows in the table are truncated without being archive
C. The rows in the table are archived, and then truncate
D. The rows in both the table and the archive are truncate
View answer
Correct Answer: AD
Question #4
Which two are prerequisites for performing a flashback transaction?
A. Flashback Database must be enable
B. Undo retention guarantee for the database must be configure
C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction
D. Supplemental logging must be enable
E. Recycle bin must be enabled for the database
F. Block change tracking must be enabled tor the database
View answer
Correct Answer: B
Question #5
Examine the parameters for your database instance: Which three statements are true about the process of automatic optimization by using cardinality feedback?
A. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics
B. The optimizer can re optimize a query only once using cardinality feedback
C. The optimizer enables monitoring for cardinality feedback after the first execution of a query
D. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enable
E. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer
View answer
Correct Answer: AD
Question #6
Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container. The steps to recover the tablespace are as follows: \\1.Mount the CDB. \\2.Close all the PDBs. \\3.Open the database. \\4.Apply the archive redo logs. \\5.Restore the data file. \\6.Take the SYSAUX tablespace offline. \\7.Place the SYSAUX tablespace online. \\8.Open all the PDBs with RESETLOGS. \\9.Open the database with RESETLOGS
A. 6, 5, 4, 7
B. 10, 1, 2, 5, 8
C. 10, 1, 2, 5, 4, 9, 8
D. 10, 1, 5, 8, 10
View answer
Correct Answer: A
Question #7
You must track all transactions that modify certain tables in the sales schema for at least three years. Automatic undo management is enabled for the database with a retention of one day. Which two must you do to track the transactions?
A. Enable supplemental logging for the database
B. Specify undo retention guarantee for the database
C. Create a Flashback Data Archive in the tablespace where the tables are store
D. Create a Flashback Data Archive in any suitable tablespace
E. Enable Flashback Data Archiving for the tables that require tracking
View answer
Correct Answer: C
Question #8
Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database. You issue the command to open ACCOUNTS_PDB and find that the USERDATA. DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupteD. What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?
A. Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PD
B. Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE comman
C. Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED comman
D. Take the USERDATA tablespace offline in ACCOUNTS_PD
View answer
Correct Answer: D
Question #9
Which two statements are true about variable extent size support for large ASM files?
A. The metadata used to track extents in SGA is reduce
B. Rebalance operations are completed faster than with a fixed extent size
C. An ASM Instance automatically allocates an appropriate extent size
D. Resync operations are completed faster when a disk comes online after being taken offline
E. Performance improves in a stretch cluster configuration by reading from a local copy of an extent
View answer
Correct Answer: BCF
Question #10
Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?
A. Reduced logical I/O
B. Reduced virtual memory utilization
C. Improved parallel Execution performance
D. Improved Serial Execution performance
E. Reduced physical I/O
F. Reduced CPU utilization
View answer
Correct Answer: C
Question #11
In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute the following command from the root container: SQL > REVOKE create table FROM C # # A_ADMIN; What is the result?
A. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only
B. It fails and reports an error because the CONTAINER=ALL clause is not use
C. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs
D. It fails and reports an error because the CONTAINER=CURRENT clause is not use
E. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs
View answer
Correct Answer: A
Question #12
On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $> sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?
A. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database
B. It fails because no SQL *Loader data file location is specifie
C. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege
D. It fails because no SQL *Loader control file location is specifie
View answer
Correct Answer: AC
Question #13
You plan to migrate your database from a File system to Automata Storage Management (ASM) on same platform. Which two methods or commands would you use to accomplish this task?
A. RMAN CONVERT command
B. Data Pump Export and import
C. Conventional Export and Import
D. The BACKUP AS COPY DATABASE
E. DBMS_FILE_TRANSFER with transportable tablespace
View answer
Correct Answer: DE

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: