Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:
Which two statements are true about redefining the table?
A.
All the triggers for the table are disabled without changing any of the column names or column
types in the table.
B.
The primary key constraint on the EMPLOYEES table is disabled during redefinition.
C.
VPD policies are copied from the original table to the new table during online redefinition.
D.
You must copy the VPD policies manually from the original table to the new table during online
redefinition.
Explanation:
C (not D): CONS_VPD_AUTO
Used to indicate to copy VPD policies automatically
* DBMS_RLS.ADD_POLICY
/TheDBMS_RLSpackage contains the fine-grained access control administrative interface, which
is used to implementVirtual Private Database (VPD).DBMS_RLSis available with the Enterprise
Edition only.
Note:
* CONS_USE_PK and CONS_USE_ROWID are constants used as input to the “options_flag”
parameter in both the START_REDEF_TABLE Procedure and CAN_REDEF_TABLE Procedure.
CONS_USE_ROWID is used to indicate that the redefinition should be done using rowids while
CONS_USE_PK implies that the redefinition should be done using primary keys or pseudoprimary keys (which are unique keys with all component columns having NOT NULL constraints).
* DBMS_REDEFINITION.START_REDEF_TABLE
To achieve online redefinition, incrementally maintainable local materialized views are used.
These logs keep track of the changes to the master tables and are used by the materialized viewsduring refresh synchronization.
* START_REDEF_TABLE Procedure
Prior to calling this procedure, you must manually create an empty interim table (in the same
schema as the table to be redefined) with the desired attributes of the post-redefinition table, and
then call this procedure to initiate the redefinition.
Think about A,C not B. Any comments?
correct A,,C http://docs.oracle.com/cd/E16655_01/server.121/e17636/tables.htm#ADMIN13879
A and C
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.
Ref: http://www.oracle-base.com/articles/10g/online-table-redefinition-enhancements-10gr1.php
AC
A.
All the triggers for the table are disabled without changing any of the column names or column types in the table.
C.
VPD policies are copied from the original table to the new table during online redefinition.
B,C correct .
only during redefinition the triggle disabled so A not clear but B is clear.
B is wrong. Primary key enabled on original table during redefinition so normal transaction still going during redefinition . I checked all object status before and after redefinition and
primary,trigger always enabled on both tables original table & interim table even finish step for redefinition on 12c.
C correct
A is not true in the case of table EMPLOYEES, however it’s true in the case of INT_EMPLOYEES. So A answer is ambiguous.
exactly! ” the table ” is EMPLOYEES ! no where say interim table .
B is wrong. options flag is to use the primary key during redefinition so it’s A and C.
AC
AC
A & C
A:
https://oracle-base.com/articles/10g/online-table-redefinition-enhancements-10gr1
C:
https://docs.oracle.com/database/121/ARPLS/d_redefi.htm#ARPLS67531
Are these Q&A still valid?
A,C should be the right answer.
Reason:
A. All the triggers of this tables will be disables
B. Primary key of this tables will not be disabled.
A is not right!!! ” the table ” is EMPLOYEES ! None the triggers of EMPLOYEES will be disabled during this operating.
no where say interim table. so you can’t get A .
B is not true.
D id not true.
so can’t get 2 correct answer from here. the ORACLE EAXM QUESTION is shit.
Hi, i have passed my Oracle 1Z0-060 exam last week, score of my 1Z0-060 exam: Section 1 = 90%; Section 2 = 92% (the passing score: Section 1 = 64%; Section 2 = 65%, both sections must be passed to pass 1Z0-060 exam). All 85 questions (Section 1 = 51q; Section 2 = 34q) were multiple choice questions, most of them were easy to answer, but few questions on Core Administration and Performance Management were a little difficult.
And, I learned valid 1Z0-060 dumps here: http://www.passleader.com/1z0-060.html (recommend to get FULL VERSION 1Z0-060 VCE dumps and PDF dumps for learning).
Good Luck!
P.S. Free 1Z0-060 PDF dumps from Google Drive: https://drive.google.com/open?id=0B-ob6L_QjGLpNjQta2dQSmFJLWs
Thank you for every other fantastic article. Where else could anybody get that type of info in such a perfect approach of writing? I’ve a presentation next week, and I’m on the search for such information.
http://www.ck8V3FsWeJ.com/ck8V3FsWeJ
AC
We came across a cool site that you simply may well appreciate. Take a look in case you want.