Explain what partitioning is and what its benefits are?
Partitioning is a method of taking large tables and indexes and splitting them into smaller, more manageable pieces.
Benefits are :
Improved Query performance.
Easy to maintain data in a structured manner.
Easy to drop the partition during purging activity.
Table backup is easier as we can do it partition wise.
How would you determine who has added a row to a table?
Enable fine grain auditing. Check the details in audit views DBA_AUDIT_TRAIL / AUD$.
Where in the Oracle directory tree structure are audit traces placed?
In unix $ORACLE_HOME/rdbms/audit.
SQL>sho parameter audit
What does DBMS_FGA package do?
The dbms_fga package allows you to specify the auditing rules for a particular column of a table and report on anyone whose queries match the criteria.
you can add policies with certain audit rules, drop/enable/disable policies.
Can you audit SELECT statements?
yes.
SQL>audit select on scott.emp;
Partitioning is a method of taking large tables and indexes and splitting them into smaller, more manageable pieces.
Benefits are :
Improved Query performance.
Easy to maintain data in a structured manner.
Easy to drop the partition during purging activity.
Table backup is easier as we can do it partition wise.
How would you determine who has added a row to a table?
Enable fine grain auditing. Check the details in audit views DBA_AUDIT_TRAIL / AUD$.
Where in the Oracle directory tree structure are audit traces placed?
In unix $ORACLE_HOME/rdbms/audit.
SQL>sho parameter audit
What does DBMS_FGA package do?
The dbms_fga package allows you to specify the auditing rules for a particular column of a table and report on anyone whose queries match the criteria.
you can add policies with certain audit rules, drop/enable/disable policies.
Can you audit SELECT statements?
yes.
SQL>audit select on scott.emp;
No comments:
Post a Comment