Examine the following statement that is used to modify the constraint on the SALES table:
SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE;
Which three statements are true regarding the above command? (Choose three.)
A.The constraint remains valid.
B.The index on the constraint is dropped.
C.It allows the loading of data into the table using SQL *Loader.
D.New data conforms to the constraint, but existing data is not checked.
E.It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
Answer: ABC
Identify the memory component from which memory may be allocated for:
1: Session memory for the shared server
2: Buffers for I/O slaves
3: Oracle Database Recovery Manager (RMAN) backup and restore operations
A.Large Pool
B.Redo Log Buffer
C.Database Buffer Cache
D.Program Global Area (PGA)
Answer: A
it's Oracle 11g 1Z0-052 real test questions .with these you will pass your exam easily .It is well known that testpassport exam test is the hot exam of Oracle certification. testpassport offer you all the Q&A of the 1z0-052 real test . It is the examination of the perfect combination and it will help you pass 1z0-052 exam at the first time!
