AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-062





Question ID 2495

In your production database, data manipulation language (DML) operations are executed on the SALES table.
You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the action for this particular period but the changes in data are not tracked. You decide to keep track of both the old data and new data in the table long with the user information.
What action would you take to achieve this task?
 

Option A

A.    Apply fine-grained auditing.
 

Option B

B.    Implement value-based auditing.
 

Option C

C.    Impose standard database auditing to audit object privileges.

 

Option D

D.    Impose standard database auditing to audit SQL statements.

Correct Answer B
Explanation


Question ID 2496

The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user SCOTT opens a session and executes commands as follows:
SQL> INSERT INTO cust VALUES(101, 'JACK'); 1 row created.
SQL> INSERT INTO cust VALUES(102, 'SMITH'); 1 row created.
As a DBA, you execute the following command from another session: ALTER TABLESPACE sales READ ONLY;
Which statement is true regarding the effect of this command on the transaction in Scott's session?
 

Option A

A. The command fails as a transaction is still pending.

 

Option B

B.    The transaction in Scott's session is rolled back and the tablespace becomes readonly.
 

Option C

C.    The command waits and the user SCOTT can execute data manipulation language (DML) statements only as part of the current transaction.
 

Option D

D.    The command hangs until all transactions on the objects in the tablespace commit or rollback, and then the tablespace is placed in readonly mode.
 

Correct Answer D
Explanation

Send email to admin@getfreedumps for new dumps request!!!