What is Statement Auditing ?

What is Statement Auditing ?
by

1 Answer

Answer :

Statement auditing is the auditing of the powerful system privileges without regard to specifically named objects.
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 are the different Levels of Auditing ?

Description : What are the different Levels of Auditing ?

Last Answer : Statement Auditing, Privilege Auditing and Object Auditing.

How to add conditions in select statement in oracle?

Description : How to add conditions in select statement in oracle?

Last Answer : Just add the decode

What are the types of SQL Statement ?

Description : What are the types of SQL Statement ?

Last Answer : Data Definition Language : CREATE,ALTER,DROP,TRUNCATE,REVOKE,NO AUDIT & COMMIT.

How do u implement the If statement in the Select Statement

Description : How do u implement the If statement in the Select Statement

Last Answer : We can implement the if statement in the select statement by using the Decode statement. e.g select DECODE (EMP_CAT,'1','First','2','Second'Null); Here the Null is the else statement where null is done .

Can a formula column be obtained through a select statement?

Description : Can a formula column be obtained through a select statement?

Last Answer : Yes

Can you use a commit statement within a database trigger?

Description : Can you use a commit statement within a database trigger?

Last Answer : No

What will happen after commit statement ?

Description : What will happen after commit statement ?

Last Answer : Cursor C1 is Select empno, ename from emp; Begin open C1; loop Fetch C1 into eno.ename; Exit When C1 %notfound;----- commit; end loop; end; The cursor having query as SELECT .... FOR ... after COMMIT/ROLLBACK. The cursor having query as SELECT.... does not get closed even after COMMIT/ROLLBACK.

Can you see Execution Plan of a statement?

Description : Can you see Execution Plan of a statement?

Last Answer : YES. In many ways, for example from GUI based tools like TOAD, Oracle SQL Developer. Configuring AUTOTRACE, a SQL*Plus facility AUTOTRACE is a facility within SQL*Plus to show us the explain plan of the ... - Like SET AUTOTRACE ON, but suppresses the printing of the user's query output, if any.

.In financial statement audits, the audit process should be conducted in accordance with a. The audit program b. Philippine Accounting Standards c. Philippine Standards on Auditing d. Philippine Financial Reporting Standards

Description : .In financial statement audits, the audit process should be conducted in accordance with a. The audit program b. Philippine Accounting Standards c. Philippine Standards on Auditing d. Philippine Financial Reporting Standards

Last Answer : Philippine Standards on Auditing

In financial statement audits, the audit process should be conducted in accordance with a. Philippine Financial Reporting Standards b. International Accounting Standards c. Philippine Standards on Auditing d. Philippine Accounting Standards

Description : In financial statement audits, the audit process should be conducted in accordance with a. Philippine Financial Reporting Standards b. International Accounting Standards c. Philippine Standards on Auditing d. Philippine Accounting Standards

Last Answer : Philippine Standards on Auditing

Which of the following is expected of AASC to do? a. AASC should normally expose its opinion on specific queries from a practicing CPA. b. AASC should normally expose a proposed interpretation of statements. c. To make the statements on Philippine Standards on Auditing operative, the final statement shall be submitted to the Board of Accountancy for approval. d. When it is deemed necessary to expose a statement for a comment on proposed interpretations of statements, the exposure period is understandably shorter than those of the regular drafts of standards

Description : Which of the following is expected of AASC to do? a. AASC should normally expose its opinion on specific queries from a practicing CPA. b. AASC should normally expose a proposed ... of statements, the exposure period is understandably shorter than those of the regular drafts of standards

Last Answer : To make the statements on Philippine Standards on Auditing operative, the final statement shall be submitted to the Board of Accountancy for approval.

Which statement best describes the emphasis of the systems and substantive approaches in the audit plan? a. A thoroughly designed systems approach to auditing can eliminate the need for any substantive procedures. b. The systems approach focuses on detailed testing of specific accounts for accuracy, while the substantive approach is the testing controls to make sure they are effective. c. The systems approach focuses on testing controls to make sure they are effective, while the substantive approach is the detailed testing of specific accounts for accuracy. d. The systems approach focuses on the use of computer systems to aid in the audit while the substantive approach focuses on more manual tests

Description : Which statement best describes the emphasis of the systems and substantive approaches in the audit plan? a. A thoroughly designed systems approach to auditing can eliminate the need for any ... computer systems to aid in the audit while the substantive approach focuses on more manual tests

Last Answer : The systems approach focuses on testing controls to make sure they are effective, while the substantive approach is the detailed testing of specific accounts for accuracy

The internal auditing profession has advanced primarily as a result of a. Increased interest by Bachelor of Science in Accountancy (BSA) graduates and experienced auditors. b. The limitation of financial statement audit scope. c. Job qualification specifications that include added emphasis on background knowledge and skills. d. Increased complexity and sophistication of business operations.

Description : The internal auditing profession has advanced primarily as a result of a. Increased interest by Bachelor of Science in Accountancy (BSA) graduates and experienced auditors. b. The ... emphasis on background knowledge and skills. d. Increased complexity and sophistication of business operations.

Last Answer : Increased complexity and sophistication of business operations.

Auditors perform analytical procedures in the planning stage of an audit for the purpose of: a. Determining which of the financial statement assertions are the most important for the client's financial statements. b. Determining the nature, timing, and extent of audit procedures for auditing the inventory. c. Deciding the matters to cover in an engagement. d. Identifying unusual conditions that deserve more auditing effort

Description : Auditors perform analytical procedures in the planning stage of an audit for the purpose of: a. Determining which of the financial statement assertions are the most important for the client's ... matters to cover in an engagement. d. Identifying unusual conditions that deserve more auditing effort

Last Answer : Identifying unusual conditions that deserve more auditing effort

Which statement is correct regarding the relationship between internal auditing and the external auditor? a. Some judgments relating to the audit of the financial statements are those of the internal auditor. b. The external audit function's objectives vary according to management's requirements. c. Certain aspects of internal auditing may be useful in determining the nature, timing and extent of external audit procedures. d. The external auditor is responsible for the audit opinion expressed, however that responsibility may be reduced by any use made of internal auditing

Description : Which statement is correct regarding the relationship between internal auditing and the external auditor? a. Some judgments relating to the audit of the financial statements are those of the ... opinion expressed, however that responsibility may be reduced by any use made of internal auditing

Last Answer : Certain aspects of internal auditing may be useful in determining the nature, timing and extent of external audit procedures.

Which of the following is an incorrect statement relating to the theoretical framework of auditing? a. Effective internal control structure reduces the probability of fraud or irregularities in an organization. b. Application of generally accepted accounting principles results in a fair presentation of financial statements. c. When examining financial data foropinion thereon, the auditor actsexclusively in the capacity of an auditor.d. In collecting evidence, auditorsshould maintain an attitude of trustabout their clients' assertions. the purpose of expressing an independent

Description : Which of the following is an incorrect statement relating to the theoretical framework of auditing? a. Effective internal control structure reduces the probability of fraud or irregularities in ... collecting evidence, auditors should maintain an attitude of trust about their clients' assertions.

Last Answer : In collecting evidence, auditors should maintain an attitude of trust about their clients' assertions.

In financial statement audits, the audit should be conducted in accordance with a. PAS / PFRS b. Generally accepted auditing standards c. Philippine Standards on Auditing d. Code of Ethics for CPAs in the Philippines

Description : In financial statement audits, the audit should be conducted in accordance with a. PAS / PFRS b. Generally accepted auditing standards c. Philippine Standards on Auditing d. Code of Ethics for CPAs in the Philippines

Last Answer : Philippine Standards on Auditing

Point out the correct statement. a) The cloud service model you choose does not determine the variety of security features, compliance auditing, and other requirements b) To determine the particular security mechanisms you need, you must perform a mapping of the particular cloud service model to the particular application you are deploying c) A security control model includes the security that you normally use for your applications only CSE-R17.BLOGSPOT.COM d) All of the mentioned

Description : Point out the correct statement. a) The cloud service model you choose does not determine the variety of security features, compliance auditing, and other requirements b) To determine the particular ... you normally use for your applications only CSE-R17.BLOGSPOT.COM d) All of the mentioned

Last Answer : To determine the particular security mechanisms you need, you must perform a mapping of the particular cloud service model to the particular application you are deploying

What does "jumps off the screen" mean?

Description : What does "jumps off the screen" mean?

Last Answer : answer:AMD is a relatively small manufacturer but well established in the industry. In this context, AMD jumps off the screen at the guy doing the research into acquiring companies for ... chip manufacturing division, but AMD is the one that really stands out from an acquisition perspective.

How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Description : How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Last Answer : By connecting and spooling are you excluding the exp/imp commands (or expdb/impdb in 10g)?

What are the two ways to incorporate images into a oracle forms application?

Description : What are the two ways to incorporate images into a oracle forms application?

Last Answer : Boilerplate Images Image_items

Can one export a subset of a table? (for DBA

Description : Can one export a subset of a table? (for DBA

Last Answer : From Oracle8i one can use the QUERY= export parameter to selectively unload a subset of the data from a table. Look at this example: exp scott/tiger tables=emp query=\"where deptno=10\"

What are the types of visual attribute settings?

Description : What are the types of visual attribute settings?

Last Answer : Custom Visual attributes Default visual attributes Named Visual attributes. Window

How does one use the import/export utilities? (for DBA

Description : How does one use the import/export utilities? (for DBA

Last Answer : Look for the "imp" and "exp" executables in your $ORACLE_HOME/bin directory. One can run them interactively, using command line parameters, or using parameter files. Look at the imp/exp parameters ... and export data with the "Schema Manager" GUI that ships with Oracle Enterprise Manager (OEM).

what is a display item?

Description : what is a display item?

Last Answer : Display items are similar to text items but store only fetched or assigned values. Operators cannot navigate to a display item or edit the value it contains.

What is import/export and why does one need it? (for DBA

Description : What is import/export and why does one need it? (for DBA

Last Answer : The Oracle export (EXP) and import (IMP) utilities are used to perform logical database backup and recovery. They are also used to move Oracle data from one machine, database or schema to ... corruption. Ensure that all the data can be read. . Transporting tablespaces between databases . Etc.

Are there any troubleshooting tips for OEM? (for DBA

Description : Are there any troubleshooting tips for OEM? (for DBA

Last Answer : . Create the OEM repository with a user (which will manage the OEM) and store it in a tablespace that does not share any data with other database users. It is a bad practice to create ... successfully. Check the log to see the results of the execution rather than relying on this status.

Where can one get more information about TCL? (for DBA

Description : Where can one get more information about TCL? (for DBA

Last Answer : One can write custom event checking routines for OEM using the TCL (Tool Command Language) language. Check the following sites for more information about TCL: . The Tcl Developer Xchange - ... the OraTCL package . Tom Poindexter's Tcl Page - Oratcl was originally written by Tom Poindexter

How does one start the Oracle Intelligent Agent? (for DBA

Description : How does one start the Oracle Intelligent Agent? (for DBA

Last Answer : One needs to start an OIA (Oracle Intelligent Agent) process on all machines that will to be managed via OEM. For OEM 9i and above:

What is the Oracle Intelligent Agent? (for DBA

Description : What is the Oracle Intelligent Agent? (for DBA

Last Answer : The Oracle Intelligent Agent (OIA) is an autonomous process that needs to run on a remote node in the network to make the node OEM manageable. The Oracle Intelligent Agent is ... events registered in Enterprise Manager; and . Executing tasks associated with jobs submitted to Enterprise Manager.

How does one backout events and jobs during maintenance slots? (for DBA

Description : How does one backout events and jobs during maintenance slots? (for DBA

Last Answer : Managemnet and data collection activity can be suspended by imposing a blackout. Look at these examples: agentctl start blackout # Blackout the entrire agent agentctl stop blackout # Resume normal monitoring ... management agentctl start blackout -s jobs -d 00:20 # Blackout jobs for 20 minutes

What are the pre requisites ?

Description : What are the pre requisites ?

Last Answer : I. to modify data type of a column ? ii. to add a column with NOT NULL constraint ? To Modify the datatype of a column the column must be empty. to add a column with NOT NULL constrain, the table must be empty.

What kind of jobs can one schedule with OEM? (for DBA

Description : What kind of jobs can one schedule with OEM? (for DBA

Last Answer : OEM comes with pre-defined jobs like Export, Import, run OS commands, run sql scripts, SQL*Plus commands etc. It also gives you the flexibility of scheduling custom jobs written with the TCL language.

Difference between SUBSTR and INSTR ?

Description : Difference between SUBSTR and INSTR ?

Last Answer : INSTR (String1,String2(n,(m)),INSTR returns the position of the mth occurrence of the string 2 instring1. The search begins from nth position of string1.SUBSTR (String1 n,m)SUBSTR returns a character string of size m in string1, starting from nth position of string1.

Should the OEM Console be displayed at all times (when there are scheduled jobs)? (for DBA

Description : Should the OEM Console be displayed at all times (when there are scheduled jobs)? (for DBA

Last Answer : When a job is submitted the agent will confirm the status of the job. When the status shows up as scheduled, you can close down the OEM console. The processing of the job is managed by the OIA ... that OEM will not be able to send e-mail and paging notifications when the Console is not started.

Explain UNION,MINUS,UNION ALL, INTERSECT ?

Description : Explain UNION,MINUS,UNION ALL, INTERSECT ?

Last Answer : INTERSECT returns all distinct rows selected by both queries.MINUS - returns all distinct rows selected by the first query but not by the second.UNION - returns all distinct rows selected by either queryUNION ALL - returns all rows selected by either query, including all duplicates.

WHY USE RMAN ? (for DBA

Description : WHY USE RMAN ? (for DBA

Last Answer : No extra costs Its available free ?RMAN introduced in Oracle 8 it has become simpler with newer versions and easier than user managed backups ?Proper security ?You are 100% sure your ... what need to backed up Knows what is required for recovery Knows what backups are redundant

WHAT IS RMAN ? (for DBA

Description : WHAT IS RMAN ? (for DBA

Last Answer : Recovery Manager is a tool that: manages the process of creating backups and also manages the process of restoring and recovering from them.

What is the basic structure of PL/SQL ?

Description : What is the basic structure of PL/SQL ?

Last Answer : PL/SQL uses block structure as its basic structure. Anonymous blocks or nested blocks can be used in PL/SQL.

What are the two parts of a procedure ?

Description : What are the two parts of a procedure ?

Last Answer : Procedure Specification and Procedure Body.

What are the datatypes a available in PL/SQL ?

Description : What are the datatypes a available in PL/SQL ?

Last Answer : Some scalar data types such as NUMBER, VARCHAR2, DATE, CHAR, LONG, BOOLEAN. Some composite data types such as RECORD & TABLE.

What are the return values of functions SQLCODE and SQLERRM ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Description : What are the return values of functions SQLCODE and SQLERRM ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Last Answer : SQLCODE returns the latest code of the error that has occurred. SQLERRM returns the relevant error message of the SQLCODE.

What is Overloading of procedures ?

Description : What is Overloading of procedures ?

Last Answer : The Same procedure name is repeated with parameters of different datatypes and parameters in different positions, varying number of parameters is called overloading of procedures. e.g. DBMS_OUTPUT put_line

s it possible to set a filter condition in a cross product group in matrix reports?

Description : s it possible to set a filter condition in a cross product group in matrix reports?

Last Answer : No

Can a repeating frame be created without a data group as a base?

Description : Can a repeating frame be created without a data group as a base?

Last Answer : No