Get real exam questions for 1z0-060 Upgrade to Oracle Database 12c. 100% Free.
Q1. You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?A. User session dataB. Stack spaceC. Private SQL areaD. Location of the runtime area for DML and DDL StatementsE. Location of a part of the runtime area for SELECT statementsView AnswerAnswer: ACQ2. Examine the followin
Q1. Examine this command:SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’,‘false’);Which three statements are true about the effect of this command?A. Statistics collection is not done for the CUSTOMERS table when schema stats are gathered. B. Statistics collection is not done for the CUSTOMERS table when database stats are gathered. C. Any existing statist
Q1. Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column?A. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.B. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.C. All the components ma
Q1. You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12C. Examine the table definition:Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?A. The valid time columns employee_time_start and employee_time_end are automatically created. B. The same statement may filter on bo
Q1. Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance.What should you use to achieve this?A. Database replayB. SQL Tuning AdvisorC. SQL Access AdvisorD. SQL Performance AnalyzerE. Automatic
Q1. You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).Examine the query and its output:Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?A. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.B. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the
Q1. A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:There is enough free space in the disk group for mirroring to be done.What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?A. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.B. Mirroring
Q1. You executed a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA. EXAM_RESULTS table to the OCP schema.The RECYCLE_BIN enabled before the DROP USER was executed and the OCP user has been granted the FLASHBACK ANY TABLE system privilege.What is the quickest way to recover the contents of the OCA. EXAM_RESULTS table to the OCP schema?
Q1. In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.How would you accomplish this?A. Setting a metric thresholdB. Implementing Database Resource ManagerC. Enabling resumable timeout for user sessionsD. Decreasing the value of the IDLE_TIME resource limit in the default profileView AnswerAnswer: DQ2. Y
Q1. 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_enameVARCHAR2, v_SALARY NUMBER, v_dept_id NUMBER)BEGININSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id); END;/GRANT EXECUTE ON CREATE_TEST TO
Q1. You created an encrypted tablespace:You then closed the encryption wallet because you were advised that this is secure. Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACEtablespace with the SALT option on the EMPLOYEE column.Which is true about the result?A. It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the
Q1. 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
Q1. In which two scenarios do you use SQL* Loader to load data?A. Transform the data while it is being loaded into the database.B. Use transparent parallel processing without having to split the external data first.C. Load data into multiple tables during the same load statement.D. Generate unique sequential key values in specified columns.View AnswerAnswer: CDQ2. Examine the following command;
Q1. Which two statement is true concerning dropping a pluggable database (PDB)?A. The PDB must be open in read-only mode.B. The PDB must be in mount state.C. The PDB must be unplugged. D. The PDB data files are always removed from disk.E. A dropped PDB can never be plugged back into a multitenant container database (CDB).View AnswerAnswer: CDQ2. You upgraded your database from pre-12c to a mul
Q1. Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In UNIX?A. Thread creation must be routed through a dispatcher processB. The local listener may spawn a now process and have that new process create a threadC. Each Oracle process runs an SCMN thread. D. Each multithreaded Oracle process has
Q1. An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges.A multitenant container database (CDB) instant has the following parameter set: THREADED_EXECUTION = FALSEWhich four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?A. You can conned as a common user by using the connect stat
Q1. Which three functions are performed by the SQL Tuning Advisor?A. Building and implementing SQL profilesB. Recommending the optimization of materialized viewsC. Checking query objects for missing and stale statisticsD. Recommending bitmap, function-based, and B-tree indexesE. Recommending the restructuring of SQL queries that are using bad plansView AnswerAnswer: ACEQ2. You execute the follo
Q1. You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.Which two are possible if table updates are performed which affect the invisible index columns?A. The index remains invisible.B. The index is not updated by the DML statements on the indexed table.C. The index automatically becomes visible in order to