What are the different Levels of Auditing ?

What are the different Levels of Auditing ?
by

1 Answer

Answer :

Statement Auditing, Privilege Auditing and Object Auditing.
by

Related questions

What is Fine Grained Auditing? (for DBA

Description : What is Fine Grained Auditing? (for DBA

Last Answer : Fine Grained Auditing (DBMS_FGA) allows auditing records to be generated when certain rows are selected from a table. A list of defined policies can be obtained from DBA_AUDIT_POLICIES. Audit ... that triggered the auditing condition... select sqltext from sys.fga_log$; delete from sys.fga_log$;

What is Auditing ?

Description : What is Auditing ?

Last Answer : Monitoring of user access to aid in the investigation of database use.

What is Object Auditing ?

Description : What is Object Auditing ?

Last Answer : Object auditing is the auditing of accesses to specific schema objects without regard to user.

What is Privilege Auditing ?

Description : What is Privilege Auditing ?

Last Answer : Privilege auditing is the auditing of the use of powerful system privileges without regard to specifically named objects.

What is Statement Auditing ?

Description : What is Statement Auditing ?

Last Answer : Statement auditing is the auditing of the powerful system privileges without regard to specifically named objects.

Describe the three levels of data abstraction?

Description : Describe the three levels of data abstraction?

Last Answer : There are three levels of abstraction: ∙ Physical level: The lowest level of abstraction describes how data are stored. ∙ Logical level: The next higher level of abstraction, describes what data are ... data. ∙ View level: The highest level of abstraction describes only part of entire database.

For initial audits, additional matters the auditor may consider in the overall audit strategy and audit plan include the following except a. Major issues including the application of accounting principles or any auditing and reporting standards discussed with management. b. Confirmation of material accounts receivable balance at the end of the year. c. Planned audit procedure to obtain sufficient appropriate audit evidence regarding opening balances. d. Assignment of firm personnel with appropriate levels of capabilities and competence to respond to anticipated significant risks

Description : For initial audits, additional matters the auditor may consider in the overall audit strategy and audit plan include the following except a. Major issues including the application of ... firm personnel with appropriate levels of capabilities and competence to respond to anticipated significant risks

Last Answer : Confirmation of material accounts receivable balance at the end of the year.

What are the different objects that you cannot copy or reference in object groups?

Description : What are the different objects that you cannot copy or reference in object groups?

Last Answer : Objects of different modules Another object groups Individual block dependent items Program units.

What are the different types of segments?

Description : What are the different types of segments?

Last Answer : Data segment, index segment, rollback segment and temporary segment.

What are the different modes of mounting a Database with the Parallel Server ?

Description : What are the different modes of mounting a Database with the Parallel Server ?

Last Answer : Exclusive Mode If the first instance that mounts a database does so in exclusive mode, only that Instance can mount the database. Parallel Mode If the first instance that mounts a database is started in parallel mode, other instances that are started in parallel mode can also mount the database.

What are the Different Optimisation Techniques

Description : What are the Different Optimisation Techniques

Last Answer : The Various Optimisation techniques are a) Execute Plan :: we can see the plan of the query and change it accordingly based on the indexes b) Optimizer_hint :: set_item_property('DeptBlock', ... SQL statements reuse the cursor. f45run module = my_firstform userid = scott/tiger optimize_Tp = No

Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?

Description : Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?

Last Answer : SELECT customer_no, payments from customer C1 WHERE 3

What are the different types of Coordinations of the Master with the Detail block?

Description : What are the different types of Coordinations of the Master with the Detail block?

Last Answer : POPULATE_GROUP(function) POPULATE_GROUP_WITH_QUERY(function) SET_GROUP_CHAR_CELL(procedure) SET_GROUPCELL(procedure) SET_GROUP_NUMBER_CELL(procedure)

What is a join ? Explain the different types of joins ?

Description : What is a join ? Explain the different types of joins ?

Last Answer : Join is a query which retrieves related columns or rows from multiple tables.Self Join - Joining the table with itself.Equi Join - Joining two tables by equating two common columns.Non-Equi Join - ... that query can also retrieve rows that do not have corresponding join value in the other table.

What are different modes of parameters used in functions and procedures?

Description : What are different modes of parameters used in functions and procedures?

Last Answer : IN -OUT -INOUT

What are different Oracle database objects?

Description : What are different Oracle database objects?

Last Answer : TABLES -VIEWS INDEXES -SYNONYMS -SEQUENCES -TABLESPACES etc

What is an UTL_FILE.What are different procedures and functions associated with it?

Description : What is an UTL_FILE.What are different procedures and functions associated with it?

Last Answer : UTL_FILE is a package that adds the ability to read and write to operating system files. Procedures associated with it are FCLOSE, FCLOSE_ALL and 5 procedures to output data to a file PUT, ... , PUTF, FFLUSH.PUT, FFLUSH.PUT_LINE,FFLUSH.NEW_LINE. Functions associated with it are FOPEN, ISOPEN.

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Description : What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Last Answer : Procedures and Functions,Packages and Database Triggers.

What are the different type of a record group?

Description : What are the different type of a record group?

Last Answer : Query record group Static record group Non query record group

What are the different types of windows?

Description : What are the different types of windows?

Last Answer : Root window, secondary window.

What are the different types of Package Procedure ?

Description : What are the different types of Package Procedure ?

Last Answer : 1. Restricted package procedure. 2. Unrestricted package procedure.

What are the different types of key triggers ?

Description : What are the different types of key triggers ?

Last Answer : Function Key Key-function Key-others Key-startup

What are the different methods of backing up oracle database ?

Description : What are the different methods of backing up oracle database ?

Last Answer : Logical Backups - Cold Backups - Hot Backups (Archive log)

How will you swap objects into a different table space for an existing database ?

Description : How will you swap objects into a different table space for an existing database ?

Last Answer : Export the user Perform import using the command imp system/manager file=export.dmp indexfile=newrite.sql. This will create all definitions into newfile.sql. Drop necessary objects. Run the script newfile.sql after altering the tablespaces. Import from the backup for the necessary objects.

What are the different kind of export backups?

Description : What are the different kind of export backups?

Last Answer : Full back - Complete database Incremental - Only affected tables from last incremental date/full backup date. Cumulative backup - Only affected table from the last cumulative date/full backup date.

What are different types of images?

Description : What are different types of images?

Last Answer : Boiler plate imagesImage Items

Can one import/export between different versions of Oracle? (for DBA

Description : Can one import/export between different versions of Oracle? (for DBA

Last Answer : Different versions of the import utility is upwards compatible. This means that one can take an export file created from an old export version, and import it using a later version of the import utility. ... database to allow the Oracle 7.3 exp/imp utilities to run against an Oracle 8 database.

What are the different types of Delete details we can establish in Master-Details?

Description : What are the different types of Delete details we can establish in Master-Details?

Last Answer : Cascade Isolate Non-isolate

What are the different types of Delete details we can establish in Master-Details?

Description : What are the different types of Delete details we can establish in Master-Details?

Last Answer : Content canvas views Stacked canvas views Horizontal toolbar vertical toolbar.

What are different types of modules available in oracle form?

Description : What are different types of modules available in oracle form?

Last Answer : Form module - a collection of objects and code routines Menu modules - a collection of menus and menu item commands that together make up an application menu library module - a collection of user named procedures, functions and packages that can be called from other modules in the application

What are the different styles of activation of ole Objects?

Description : What are the different styles of activation of ole Objects?

Last Answer : In place activationExternal activation

How is link tool operation different bet. reports 2 & 2.5?

Description : How is link tool operation different bet. reports 2 & 2.5?

Last Answer : In Reports 2.0 the link tool has to be selected and then two fields to be linked are selected and the link is automatically created. In 2.5 the first field is selected and the link tool is then used to link the first field to the second field.

What are the different default triggers created when Master Deletes Property is set to Cascade?

Description : What are the different default triggers created when Master Deletes Property is set to Cascade?

Last Answer : Master Deletes Property Resulting Triggers --------------------------------------------------- Cascading On-Clear-Details On-Populate-Details Pre-delete

What are the different default triggers created when Master Deletes Property is set to isolated?

Description : What are the different default triggers created when Master Deletes Property is set to isolated?

Last Answer : Master Deletes Property Resulting Triggers --------------------------------------------------- Isolated On-Clear-Details On-Populate-Details

What are the different default triggers created when Master Deletes Property is set to Non-isolated?

Description : What are the different default triggers created when Master Deletes Property is set to Non-isolated?

Last Answer : Master Deletes Property Resulting Triggers ---------------------------------------------------- Non-Isolated(the default) On-Check-Delete-Master On-Clear-Details On-Populate-Details

What are the different modals of windows?

Description : What are the different modals of windows?

Last Answer : Modalless windows Modal windows

What are the different display styles of list items?

Description : What are the different display styles of list items?

Last Answer : Pop_listText_listCombo box

What are the different types of Record Groups?

Description : What are the different types of Record Groups?

Last Answer : Query Record Groups NonQuery Record Groups State Record Groups

What are the different file extensions that are created by oracle reports?

Description : What are the different file extensions that are created by oracle reports?

Last Answer : Rep file and Rdf file.

What are the different Parameter types?

Description : What are the different Parameter types?

Last Answer : Text ParametersData Parameters

What are the different windows events activated at runtimes?

Description : What are the different windows events activated at runtimes?

Last Answer : When_window_activated When_window_closed When_window_deactivated When_window_resized Within this triggers, you can examine the built in system variablesystem. event_window to determine the name of the window for which the trigger fired.

What are the different approaches used by Optimizer in choosing an execution plan ?

Description : What are the different approaches used by Optimizer in choosing an execution plan ?

Last Answer : Rule-based and Cost-based.

What are the different type of Segments ?

Description : What are the different type of Segments ?

Last Answer : Data Segment, Index Segment, Rollback Segment and Temporary Segment.

Can objects of the same Schema reside in different tablespaces.?

Description : Can objects of the same Schema reside in different tablespaces.?

Last Answer : Yes.

Can a Tablespace hold objects from different Schemes ?

Description : Can a Tablespace hold objects from different Schemes ?

Last Answer : Yes.

Can a tablespace hold objects from different schemes?

Description : Can a tablespace hold objects from different schemes?

Last Answer : Yes.

Can objects of the same schema reside in different tablespaces?

Description : Can objects of the same schema reside in different tablespaces?

Last Answer : Yes.

What are the different plan types available in Fusion Absence Management? Accrual

Description : What are the different plan types available in Fusion Absence Management?

Last Answer : There are three different plan types available in Fusion Absence Management, which are given below: Accrual Use this type to create absence plans that enable workers to accrue time for the ... plan to pay workers if they are not eligible for a standard maternity absence qualification plan.

What are the different absence type patterns available in Fusion Absence Management?

Description : What are the different absence type patterns available in Fusion Absence Management?

Last Answer : An absence pattern contains a predefined set of rules that you can use as a starting point to create an absence type. The pattern that you select determines whether special fields ... patterns available in Fusion Absence Management. ∙Illness or injury ∙Childbirth or placement ∙Generic absence

What are the different types of JOIN operations?

Description : What are the different types of JOIN operations?

Last Answer : Equi Join: This is the most common type of join which involves only equality comparisions. The disadvantage in this type of join is that there