Which two statements are true about redefining the table?

Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:

Which two statements are true about redefining the table?

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 views

during 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.



Leave a Reply 21

Your email address will not be published. Required fields are marked *


Jeroen

Jeroen

Think about A,C not B. Any comments?

Mohammad Rafiq

Mohammad Rafiq

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.

john001

john001

B,C correct .

only during redefinition the triggle disabled so A not clear but B is clear.

John

John

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.

Piotr

Piotr

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.

Bing Liu

Bing Liu

exactly! ” the table ” is EMPLOYEES ! no where say interim table .

buggerit

buggerit

B is wrong. options flag is to use the primary key during redefinition so it’s A and C.

Hest

Hest

Are these Q&A still valid?

Zakir Hossain Pervez

Zakir Hossain Pervez

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.

Bing Liu

Bing Liu

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.

Matthew Cunham

Matthew Cunham

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!

Hector Farlin

Hector Farlin

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

Google

Google

We came across a cool site that you simply may well appreciate. Take a look in case you want.