Can you audit SELECT statements?

Can you audit SELECT statements?
by

1 Answer

Answer :

YES. But beware; you will need a storage mechanism to hold your SQL SELECT audits, a high data volume that can  exceed the size of your whole database, every day.
SQL SELECT auditing can be accomplished in several ways:
▪ Oracle audit table command: audit SELECT table by FRED by access;
▪ Oracle Fined-grained Auditing
In a busy database, the volume of the SELECT audit trail could easily exceed the size of the database every data. Plus, all data in the audit trail must also be audited to see who has selected data from the audit trail.
by

Related questions

Where in the Oracle directory tree structure are audit traces placed?

Description : Where in the Oracle directory tree structure are audit traces placed?

Last Answer : In unix $ORACLE_HOME/rdbms/audit, in Windows the event viewer

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

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 select in FROM clause of SQL select ?

Description : Can you use select in FROM clause of SQL select ?

Last Answer : Yes.

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

maxvalue.sql Select the Nth Highest value from a table?

Description : maxvalue.sql Select the Nth Highest value from a table?

Last Answer : select level, max('col_name') from my_table where level = '&n' connect by prior ('col_name') > 'col_name') group by level; Example: Given a table called emp with the following columns: -- id number -- name ... , max(sal) from emp -- where level=2 -- connect by prior sal > sal -- group by level

minvalue.sql Select the Nth lowest value from a table?

Description : minvalue.sql Select the Nth lowest value from a table?

Last Answer : select level, min('col_name') from my_table where level = '&n' connect by prior ('col_name') < 'col_name') group by level; Example: Given a table called emp with the following columns: -- id number -- name ... , min(sal) from emp -- where level=2 -- connect by prior sal < sal -- group by level

What a SELECT FOR UPDATE cursor represent.?

Description : What a SELECT FOR UPDATE cursor represent.?

Last Answer : SELECT......FROM......FOR......UPDATE[OF column-reference][NOWAIT] The processing done in a fetch loop modifies the rows that have been retrieved by the cursor. A convenient way of ... the FOR UPDATE clause in the cursor declaration, WHERE CURRENT OF CLAUSE in an UPDATE or declaration statement.

How is it possible to select generate a select set for the query in the query property sheet?

Description : How is it possible to select generate a select set for the query in the query property sheet?

Last Answer : By using the tables/columns button and then specifying the table and the column names.

What is a difference between pre-select and pre-query?

Description : What is a difference between pre-select and pre-query?

Last Answer : Fires during the execute query and count query processing after oracle forms constructs the select statement to be issued, but before the statement is actually issued. The pre-query trigger fires ... the query criteria in enter query mode.Pre-query trigger fires before pre-select trigger.

Select ‘NORTH’, CUSTOMER From CUST_DTLS Where REGION = ‘N’ Order By CUSTOMER Union Select ‘EAST’, CUSTOMER From CUST_DTLS Where REGION = ‘E’ Order By CUSTOMER The above is a) Not an error b) Error - the string in single quotes ‘NORTH’ and ‘SOUTH’ c) Error - the string should be in double quotes d) Error - ORDER BY clause

Description : Select NORTH', CUSTOMER From CUST_DTLS Where REGION = N' Order By CUSTOMER Union Select EAST', CUSTOMER From CUST_DTLS Where REGION = E' Order By CUSTOMER The above is a) Not an error b) Error - ... ' and SOUTH' c) Error - the string should be in double quotes d) Error - ORDER BY clause

Last Answer : d) Error - ORDER BY clause

SQL> SELECT * FROM MY_SCHEMA.MY_TABLE; SP2-0678: Column or attribute type cannot be displayed by SQL*Plus Why I’m getting this error?

Description : SQL> SELECT * FROM MY_SCHEMA.MY_TABLE; SP2-0678: Column or attribute type cannot be displayed by SQL*Plus Why I’m getting this error?

Last Answer : The table has a BLOB column.

Will a user be able to modify a table with SELECT only privilege?

Description : Will a user be able to modify a table with SELECT only privilege?

Last Answer : He won’t be able to UPDATE/INSERT into that table, but for some reason, he will still be able to lock a certain table.

Is it possible to insert comments into sql statements return in the data model editor?

Description : Is it possible to insert comments into sql statements return in the data model editor?

Last Answer : Yes

How many types of Sql Statements are there in Oracle

Description : How many types of Sql Statements are there in Oracle

Last Answer : There are basically 6 types of sql statments.They are a) Data Defination Language(DDL) :: The DDL statments define and maintain objects and drop objects. b) Data Manipulation Language(DML) :: The DML ... e.g:: Using the Sql Statements in languages such as 'C', Open,Fetch, execute and close

What are the PL/SQL Statements used in cursor processing ?

Description : What are the PL/SQL Statements used in cursor processing ?

Last Answer : DECLARE CURSOR cursor name, OPEN cursor name, FETCH cursor name INTO or Record types, CLOSE cursor name.

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

Description : Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

Last Answer : It is not possible. As triggers are defined for each table, if you use COMMIT of ROLLBACK in a trigger, it affects logical transaction processing.

What are the factors causing the reparsing of SQL statements in SGA?

Description : What are the factors causing the reparsing of SQL statements in SGA?

Last Answer : Due to insufficient Shared SQL pool size. Monitor the ratio of the reloads takes place while executing SQL statements. If the ratio is greater than 1 then increase the SHARED_POOL_SIZE. LOGICAL & PHYSICAL ARCHITECTURE OF DATABASE.

What are the factors causing the reparsing of SQL statements in SGA?

Description : What are the factors causing the reparsing of SQL statements in SGA?

Last Answer : Due to insufficient shared pool size. Monitor the ratio of the reloads takes place while executing SQL statements. If the ratio is greater than 1 then increase the SHARED_POOL_SIZE.

What is the difference between DELETE and TRUNCATE statements?

Description : What is the difference between DELETE and TRUNCATE statements?

Last Answer : The DELETE command is used to remove rows from a table. A WHERE clause can be used to only remove some rows. If no WHERE condition is specified, all rows will be removed. After performing a DELETE operation ... be fired. As such, TRUCATE is faster and doesn't use as much undo space as a DELETE.

A(n) _ is a review of the quality plan, procedures, data collection, and analysis by an outside group. Select one: a. scope document b. project appraisal c. cost performance index d. analogous estimate e. quality audit

Description : A(n) _ is a review of the quality plan, procedures, data collection, and analysis by  an outside group. Select one: a. scope document b. project appraisal c. cost performance index d. analogous estimate e. quality audit

Last Answer : e. quality audit

The audit plan should (select the exception) a. Be flexible b. Precede performance of procedures c. Succeed action d. Be cost-beneficial

Description : The audit plan should (select the exception) a. Be flexible b. Precede performance of procedures c. Succeed action d. Be cost-beneficial

Last Answer : Succeed action

Select the proper reply as to the allowable form of the understanding with a client when an audit is being performed. a. While preferably written, it may be oral; but in all cases it should be documented in the working papers. b. While preferably written, it may be oral, in which case it need not be documented in the working papers. c. The understanding may be in any form, such as oral or written. d. The understanding must be obtained in written form and included in the working papers.

Description : Select the proper reply as to the allowable form of the understanding with a client when an audit is being performed. a. While preferably written, it may be oral; but in all cases it should be ... or written. d. The understanding must be obtained in written form and included in the working papers.

Last Answer : While preferably written, it may be oral; but in all cases it should be documented in the working papers

Which of the following are the tools of good governance? 1. Social Audit 2. Separation of Powers 3. Citizen’s Charter 4. Right to Information Select the correct answer from the codes given below: (A) 1, 3 and 4 (B) 2, 3 and 4 (C) 1 and 4 (D) 1, 2, 3, and 4

Description : Which of the following are the tools of good governance? 1. Social Audit 2. Separation of Powers 3. Citizen’s Charter 4. Right to Information Select the correct answer from the codes given below: (A) 1, 3 and 4 (B) 2, 3 and 4 (C) 1 and 4 (D) 1, 2, 3, and 4

Last Answer : Answer: D

Which one of the following statements is correct ? (A) Audit of an educational institution is compulsory if it is run by a charitable trust (B) A club is treated as a commercial establishment (C) The accounts of a charitable trust can be audited by any person who belongs to accountancy profession (D) Audit of a charitable trust is not compulsory under law

Description : Which one of the following statements is correct ? (A) Audit of an educational institution is compulsory if it is run by a charitable trust (B) A club is treated as a commercial establishment ( ... who belongs to accountancy profession (D) Audit of a charitable trust is not compulsory under law

Last Answer : Answer: Audit of an educational institution is compulsory if it is run by a charitable trust Free

Which one of the following statements is correct ? (A) Internal audit and Management audit are the same (B) Internal audit and statutory audit are the same (C) Internal audit is compulsory in all cases (D) Statutory audit of company accounts is compulsory

Description : Which one of the following statements is correct ? (A) Internal audit and Management audit are the same (B) Internal audit and statutory audit are the same (C) Internal audit is compulsory in all cases (D) Statutory audit of company accounts is compulsory

Last Answer : Answer: Statutory audit of company accounts is compulsory

Which of the following statements would least likely appear in an auditor's engagement letter? a. Our engagement is subject to the risk that material errors, fraud, and defalcations, if they exist, will not be detected. b. During the course of our audit we may observe opportunities for economy in, or improved controls over, your operations. c. After performing our preliminary analytical procedures we will discuss with you the other procedures we consider necessary to complete the engagement. d. Fees for our services are based on our regular per diem rates, plus travel and other out-of-pocket expenses

Description : Which of the following statements would least likely appear in an auditor's engagement letter? a. Our engagement is subject to the risk that material errors, fraud, and defalcations, if they exist, ... services are based on our regular per diem rates, plus travel and other out-of-pocket expenses

Last Answer : After performing our preliminary analytical procedures we will discuss with you the other procedures we consider necessary to complete the engagement.

Which of the following is the most likely first step an auditor would perform at the beginning of an initial audit engagement? a. Prepare a rough draft of the financial statements and of the auditor's report. b. Study and evaluate the system of internal administrative control. c. Tour the client's facilities and review the general records. d. Consult with and review the work of the predecessor auditor prior to discussing the engagement with the client management

Description : Which of the following is the most likely first step an auditor would perform at the beginning of an initial audit engagement? a. Prepare a rough draft of the financial statements and of ... and review the work of the predecessor auditor prior to discussing the engagement with the client management

Last Answer : Tour the client's facilities and review the general records

A review engagement differs in scope as compared to an audit due to a. The subject matter of the audit. b. The quantity and type of evidence obtained. c. Ethical requirements with respect to independence. d. The users of the financial statements

Description : A review engagement differs in scope as compared to an audit due to a. The subject matter of the audit. b. The quantity and type of evidence obtained. c. Ethical requirements with respect to independence. d. The users of the financial statements

Last Answer : The quantity and type of evidence obtained

Management’s assertions in the financial statements are relevant to the audit process because: a. They provide evidence that auditors have prepared financial statements in accordance with GAAP b. They embody the audit procedures that will be performed by the audit engagement team. c. They include representations of financial statements in accordance with the applicable reporting criteria d. They relate to regulator’s expectations about audit results

Description : Management's assertions in the financial statements are relevant to the audit process because: a. They provide evidence that auditors have prepared financial statements in accordance with GAAP b ... with the applicable reporting criteria d. They relate to regulator's expectations about audit results

Last Answer : They include representations of financial statements in accordance with the applicable reporting criteria

The overriding objective of the International Auditing Standards that are issued by the International Auditing Practices Committee of the IFAC is a. To override a country’s regulations governing the audit of financial statements. b. To improve the uniformity of auditing practices and related services throughout the world. c. To provide a uniform application of specific audit procedures that are acceptable worldwide. d. To replace generally accepted auditing standards.

Description : The overriding objective of the International Auditing Standards that are issued by the International Auditing Practices Committee of the IFAC is a. To override a country's regulations governing ... audit procedures that are acceptable worldwide. d. To replace generally accepted auditing standards.

Last Answer : To improve the uniformity of auditing practices and related services throughout the world

A CPA is criminally liable if he a. Refuses to turn over the schedules or working papers prepared by the client staff to the client. b. Performs an audit in a negligent manner. c. Intentionally allows an omission of a material fact required to be stated in a financial statement. d. Was not able to submit the audited financial statements on time

Description : A CPA is criminally liable if he a. Refuses to turn over the schedules or working papers prepared by the client staff to the client. b. Performs an audit in a negligent manner. c. Intentionally ... be stated in a financial statement. d. Was not able to submit the audited financial statements on time

Last Answer : Intentionally allows an omission of a material fact required to be stated in a financial statement

The term "accountant" has been used by Auditing and Assurance Standards Council to refer to a CPA in public practice who is engaged to: a. Audit financial statements. b. Review financial statements. c. Apply agreed-upon procedures. d. Compile financial statements

Description : The term "accountant" has been used by Auditing and Assurance Standards Council to refer to a CPA in public practice who is engaged to: a. Audit financial statements. b. Review financial statements. c. Apply agreed-upon procedures. d. Compile financial statements

Last Answer : Compile financial statements

Which of the following is the most likely first step an auditor would perform at the beginning of an initial audit engagement? a. Prepare a rough draft of the financial statements and of the auditor's report. b. Study and evaluate the system of internal administrative control. c. Tour the client's facilities and review the general records. d. Consult with and review the work of the predecessor auditor prior to discussing the engagement with the client management

Description : Which of the following is the most likely first step an auditor would perform at the beginning of an initial audit engagement? a. Prepare a rough draft of the financial statements and of ... and review the work of the predecessor auditor prior to discussing the engagement with the client management

Last Answer : Tour the client's facilities and review the general records

Which of the following is the most likely first step an auditor would perform at the beginning of an initial audit engagement? a. Prepare a rough draft of the financial statements and of the auditor's report. b. Study and evaluate the system of internal administrative control. c. Tour the client's facilities and review the general records. d. Consult with and review the work of the predecessor auditor prior to discussing the engagement with the client management

Description : Which of the following is the most likely first step an auditor would perform at the beginning of an initial audit engagement? a. Prepare a rough draft of the financial statements and of ... and review the work of the predecessor auditor prior to discussing the engagement with the client management

Last Answer : Tour the client's facilities and review the general records

Preplanning the audit involves several key activities which include the following except: a. Investigating the client's background. b. Communicating with the prospective client's prior auditor to inquire about any disagreements with the client. c. Understanding the client's reasons for obtaining an audit. d. Determining the likelihood of issuing an unqualified audit opinion on the client's financial statements.

Description : Preplanning the audit involves several key activities which include the following except: a. Investigating the client's background. b. Communicating with the prospective client's prior auditor to ... the likelihood of issuing an unqualified audit opinion on the client's financial statements.

Last Answer : Determining the likelihood of issuing an unqualified audit opinion on the client's financial statements.

The auditor is required to comply with all PSAs relevant to the audit of an entity's financial statements. A PSA is relevant to the audit when: I. The PSA is in effecII. The circumstances addressed by the PSA exist. a. I only b. II only c. Either I or II d. Both I and IIt

Description : The auditor is required to comply with all PSAs relevant to the audit of an entity's financial statements. A PSA is relevant to the audit when: I. The PSA is in effect II. The circumstances addressed by the PSA exist. a. I only b. II only c. Either I or II d. Both I and II

Last Answer : Both I and II

Broadly defined, the subject matter of any audit consists of a. Economic data b. Financial statements c. Assertions about economic actions and events d. Operating data

Description : Broadly defined, the subject matter of any audit consists of a. Economic data b. Financial statements c. Assertions about economic actions and events d. Operating data

Last Answer : Assertions about economic actions and events

Which of the following statements does not properly describe a limitation of an audit? a. Many audit conclusions are made on the basis of examining a sample of evidence. b. The work, under taken by the auditor is permeated by judgment. c. Fatigue and human weaknesses can cause auditors to overlook pertinent evidence. d. Many financial statement assertions cannot be audited

Description : Which of the following statements does not properly describe a limitation of an audit? a. Many audit conclusions are made on the basis of examining a sample of evidence. b. The ... weaknesses can cause auditors to overlook pertinent evidence. d. Many financial statement assertions cannot be audited

Last Answer : Fatigue and human weaknesses can cause auditors to overlook pertinent evidence

Reasonable assurance means: a. Gathering of all available corroborating evidence for the auditor to conclude that there are no material misstatements in the financial statements, taken as a whole. b. Gathering of the audit evidence necessary for the auditor to conclude that the financial statements, taken as a whole, are free from any misstatements. c. Gathering of the audit evidence necessary for the auditor to conclude that the financial statements are free of material unintentional misstatements. d. Gathering of the audit evidence necessary for the auditor to conclude that there are no material misstatements in the financial

Description : Reasonable assurance means: a. Gathering of all available corroborating evidence for the auditor to conclude that there are no material misstatements in the financial statements, taken as a whole. ... necessary for the auditor to conclude that there are no material misstatements in the financial

Last Answer : Gathering of the audit evidence necessary for the auditor to conclude that there are no material misstatements in the financial statements, taken as a whole

The best statement of the responsibility of the auditor with respect to audited financial statement is: a. The auditor's responsibility on fair presentation of financial statements is limited only up to the date of the audit report. b. The auditor's responsibility is confined to the expression of opinion on the financial statements audited. c. The responsibility over the financial statements rests with the management and the auditor assumes responsibility with respect to the notes of financial statements. d. The auditor is responsible only to his qualified opinion but not for any other type of opinion.

Description : The best statement of the responsibility of the auditor with respect to audited financial statement is: a. The auditor's responsibility on fair presentation of financial statements is limited only up to ... auditor is responsible only to his qualified opinion but not for any other type of opinion.

Last Answer : The auditor's responsibility is confined to the expression of opinion on the financial statements audited

Which of the following has the primary responsibility for the fairness of the representations made in the financial statements? a. Audit committee b. Client's management c. Independent auditor d. Board of Accountancy

Description : Which of the following has the primary responsibility for the fairness of the representations made in the financial statements? a. Audit committee b. Client's management c. Independent auditor d. Board of Accountancy

Last Answer : Client's management

Which of the following types of audits is performed to determine whether an entity's financial statements are fairly stated in conformity with generally accepted accounting principles? a. Operational audit b. Compliance audit c. Performance audit d. Financial statement audit

Description : Which of the following types of audits is performed to determine whether an entity's financial statements are fairly stated in conformity with generally accepted accounting principles? a. Operational audit b. Compliance audit c. Performance audit d. Financial statement audit

Last Answer : Financial statement audit

Why does a company choose to have an independent auditor report on its financial statements? a. Independent auditors will always detect management fraud. b. Independent auditors guarantee the accuracy of the financial statements. c. The company preparing the statements may have a vested interest in reporting certain results. d. An independent audit is designed to search for deficiencies in the company's internal control

Description : Why does a company choose to have an independent auditor report on its financial statements? a. Independent auditors will always detect management fraud. b. Independent auditors guarantee the accuracy ... . An independent audit is designed to search for deficiencies in the company's internal control

Last Answer : The company preparing the statements may have a vested interest in reporting certain results.

Which of the following statements does not properly describe an element of the theoretical framework of auditing? a. An audit benefits the public. b. The data to be audited can be verified. c. Auditors act on behalf of management. d. Short-term conflicts may exist between managers who prepare data and auditors who examine the data

Description : Which of the following statements does not properly describe an element of the theoretical framework of auditing? a. An audit benefits the public. b. The data to be audited can be verified. c. ... . d. Short-term conflicts may exist between managers who prepare data and auditors who examine the data

Last Answer : Auditors act on behalf of management

Which of the following is not one of the general principles governing the audit of financial statements? a. The auditor should conduct the audit in accordance with PSA. b. The auditor should comply with the Philippine Code of Professional Ethics. c. The auditor should plan and perform the audit with an attitude of professional skepticism. d. The auditor should obtain sufficient appropriate evidence primarily through inquiry and analyticaprocedures to be able to draw reasonable conclusions.l

Description : Which of the following is not one of the general principles governing the audit of financial statements? a. The auditor should conduct the audit in accordance with PSA. b. The ... appropriate evidence primarily through inquiry and analytical procedures to be able to draw reasonable conclusions.

Last Answer : The auditor should obtain sufficient appropriate evidence primarily through inquiry and analytical procedures to be able to draw reasonable conclusions

Which of the following statements does not properly describe a limitation of an audit? a. Many financial statement assertions cannot be audited. b. Many audit conclusions are made on the basis of examining a sample of evidence. c. The work, under taken by the auditor is permeated by judgment. d. Fatigue and human weaknesses can cause auditors to overlook pertinent evidence

Description : Which of the following statements does not properly describe a limitation of an audit? a. Many financial statement assertions cannot be audited. b. Many audit conclusions are made on the ... permeated by judgment. d. Fatigue and human weaknesses can cause auditors to overlook pertinent evidence

Last Answer : Fatigue and human weaknesses can cause auditors to overlook pertinent evidence