Download Oracle.1z0-060.ExamLabs.2020-03-13.130q.tqb
| Vendor: | Oracle |
| Exam Code: | 1z0-060 |
| Exam Name: | Upgrade to Oracle Database 12c |
| Date: | Mar 13, 2020 |
| File Size: | 3 MB |
Demo Questions
Question 1
Examine these commands for redefining a table with Virtual Private Database (VPD) policies:
Which two statements are true about redefining the table? (Choose two.)
- All the triggers for the table are disabled without changing any of the column names or column types in the table.
- The primary key constraint on the EMPLOYEES table is disabled during redefinition.
- VPD policies are copied from the original table to the new table during online redefinition.
- You must copy the VPD policies manually from the original table to the new table during online redefinition.
Correct answer: AC
Explanation:
The triggers cloned to the interim table are disabled until the redefinition is completed. Once the redefinition is complete, all cloned objects are renamed to the original names used by they objects they were cloned from. References: http://www.oracle-base.com/articles/10g/online-table-redefinition-enhancements-10gr1.php The triggers cloned to the interim table are disabled until the redefinition is completed. Once the redefinition is complete, all cloned objects are renamed to the original names used by they objects they were cloned from.
References: http://www.oracle-base.com/articles/10g/online-table-redefinition-enhancements-10gr1.php
Question 2
Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column? (Choose two.)
- The procedures may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.
- The procedures may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.
- All the components may be moved into SYSAUX tablespace.
- All the components may be moved from the SYSAUX tablespace.
Correct answer: AB
Explanation:
References: http://www.dba-oracle.com/t_v_sysaux_contents_tips.htm References: http://www.dba-oracle.com/t_v_sysaux_contents_tips.htm
Question 3
Which statement is true about Oracle Net Listener?
- It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.
- A single listener can service only one database instance and multiple remote client connections.
- Service registration with the listener is performed by the listener registration process (LREG) process of each database instance.
- The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.
- The listener.ora configuration file must be located in the ORACLE_HOME/network/admin directory.
Correct answer: C
