You wish to enable an audit pol

题目

You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT; For which database users is the audit policy now active?()

  • A、All users except SYS
  • B、All users except SCOTT
  • C、All users except sys and SCOTT
  • D、All users except sys, system, and SCOTT
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following statements:SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;For which database users is the audit policy now active?()

A. All users except SYS

B. All users except SCOTT

C. All users except sys and SCOTT

D. All users except sys, system, and SCOTT


参考答案:B

第2题:

打开审计开关的操作是什么()。

  • A、ENABLE_AUDIT=0
  • B、ENABLE_ENCRYPT=0
  • C、ENABLE_AUDIT=1
  • D、ENABLE_ENCRYPT=1

正确答案:C

第3题:

2.I _________to visit Guilin and I_________ you to go with me.

A. wish ; hope

B. hope; wish

C. hope; wish for

D. wish; hope that


正确答案:B
2.B【解析】wish与hope后都可接to do作宾语, hope后不可以跟宾语再加to do。

第4题:

You discover audit log entries that report attempts to log on to your computer. You need to be notified of all logon attempts that occur on your computer.  What should you do?()

  • A、Enable the Problem Reporting feature for all users.
  • B、Configure a custom view to monitor failed logon events on your computer.
  • C、Use the Computer Management console to connect to your computer from another computer and monitor the audit logs.
  • D、In the Event Viewer window, attach a task to a failed logon event. Configure this task to send an e-mail message to your e-mail account.

正确答案:D

第5题:

Your company has file servers located in an organizational unit named Payroll. The file servers contain payroll files located in a folder named Payroll. You create a GPO. You need to track which employees access the Payroll files on the file servers. What should you do()

  • A、Enable the Audit object access option. Link the GPO to the Payroll organizational unit. On the file servers, configure Auditing for the Everyone group in the Payroll folder.
  • B、Enable the Audit object access option. Link the GPO to the domain. On the domain controllers, configure Auditing for the Authenticated Users group in the Payroll folder.
  • C、Enable the Audit process tracking option. Link the GPO to the Domain Controllers organizational unit. On the file servers, configure Auditing for the Authenticated Users group in the Payroll folder.
  • D、Enable the Audit process tracking option. Link the GPO to the Payroll organizational unit. On the file servers, configure Auditing for the Everyone group in the Payroll folder.

正确答案:A

第6题:

Following a competitive tender, your audit firm Cal & Co has just gained a new audit client Tirrol Co. You are the manager in charge of planning the audit work. Tirrol Co’s year end is 30 June 2009 with a scheduled date to complete the audit of 15 August 2009. The date now is 3 June 2009.

Tirrol Co provides repair services to motor vehicles from 25 different locations. All inventory, sales and purchasing systems are computerised, with each location maintaining its own computer system. The software in each location is

the same because the programs were written specifically for Tirrol Co by a reputable software house. Data from each location is amalgamated on a monthly basis at Tirrol Co’s head office to produce management and financial accounts.

You are currently planning your audit approach for Tirrol Co. One option being considered is to re-write Cal & Co’s audit software to interrogate the computerised inventory systems in each location of Tirrol Co (except for head office)

as part of inventory valuation testing. However, you have also been informed that any computer testing will have to be on a live basis and you are aware that July is a major holiday period for your audit firm.

Required:

(a) (i) Explain the benefits of using audit software in the audit of Tirrol Co; (4 marks)

(ii) Explain the problems that may be encountered in the audit of Tirrol Co and for each problem, explain

how that problem could be overcome. (10 marks)

(b) Following a discussion with the management at Tirrol Co you now understand that the internal audit department are prepared to assist with the statutory audit. Specifically, the chief internal auditor is prepared to provide you with documentation on the computerised inventory systems at Tirrol Co. The documentation provides details of the software and shows diagrammatically how transactions are processed through the inventory system. This documentation can be used to significantly decrease the time needed to understand the computer systems and enable audit software to be written for this year’s audit.

Required:

Explain how you will evaluate the computer systems documentation produced by the internal audit

department in order to place reliance on it during your audit. (6 marks)


正确答案:
(a)(i)BenefitsofusingauditsoftwareStandardsystemsatclientThesamecomputerisedsystemsandprogramsasusedinall25branchesofTirrolCo.Thismeansthatthesameauditsoftwarecanbeusedineachlocationprovidingsignificanttimesavingscomparedtothesituationwhereclientsystemsaredifferentineachlocation.UseactualcomputerfilesnotcopiesorprintoutsUseofauditsoftwaremeansthattheTirrolCo’sactualinventoryfilescanbetestedratherthanhavingtorelyonprintoutsorscreenimages.Thelattercouldbeincorrect,byaccidentorbydeliberatemistake.Theauditfirmwillhavemoreconfidencethatthe‘real’fileshavebeentested.TestmoreitemsUseofsoftwarewillmeanthatmoreinventoryrecordscanbetested–itispossiblethatallproductlinescouldbetestedforobsolescenceratherthanasampleusingmanualtechniques.Theauditorwillthereforegainmoreevidenceandhavegreaterconfidencethatinventoryisvaluedcorrectly.CostTherelativecostofusingauditsoftwaredecreasesthemoreyearsthatsoftwareisused.Anycostoverrunsthisyearcouldbeoffsetagainsttheauditfeesinfutureyearswhentheactualexpensewillbeless.(ii)ProblemsontheauditofTirrolTimescale–sixweekreportingdeadline–auditplanningTheauditreportisduetobesignedsixweeksaftertheyearend.Thismeansthattherewillbeconsiderablepressureontheauditortocompleteauditworkwithoutcompromisingstandardsbyrushingprocedures.Thisproblemcanbeovercomebycarefulplanningoftheaudit,useofexperiencedstaffandensuringotherstaffsuchassecondpartnerreviewsarebookedwellinadvance.Timescale–sixweekreportingdeadline–softwareissuesTheauditreportisduetobesignedaboutsixweeksaftertheyearend.Thismeansthatthereislittletimetowriteandtestauditsoftware,letaloneusethesoftwareandevaluatetheresultsoftesting.Thisproblemcanbealleviatedbycarefulplanning.AccesstoTirrolCo’ssoftwareanddatafilesmustbeobtainedassoonaspossibleandworkcommencedontailoringCal&Co’ssoftwarefollowingthis.Specialistcomputerauditstaffshouldbebookedassoonaspossibletoperform.thiswork.FirstyearauditcostsTherelativecostsofanauditinthefirstyearataclienttendtobegreaterduetotheadditionalworkofascertainingclientsystems.ThismeansthatCal&Comayhavealimitedbudgettodocumentsystemsincludingcomputersystems.Thisproblemcanbealleviatedtosomeextentagainbygoodauditplanning.Themanagermustalsomonitortheauditprocesscarefully,ensuringthatanyadditionalworkcausedbytheclientnotprovidingaccesstosystemsinformationincludingcomputersystemsisidentifiedandaddedtothetotalbillingcostoftheaudit.StaffholidaysMostoftheauditworkwillbecarriedoutinJuly,whichisalsothemonthwhenmanyofCal&Costafftaketheirannualholiday.Thismeansthattherewillbeashortageofauditstaff,particularlyasauditworkforTirrolCoisbeingbookedwithlittlenotice.Theproblemcanbealleviatedbybookingstaffassoonaspossibleandthenidentifyinganyshortages.Wherenecessary,staffmaybeborrowedfromotherofficesorevendifferentcountriesonasecondmentbasiswhereshortagesareacute.Non-standardsystemsTirrolCo’scomputersoftwareisnon-standard,havingbeenwrittenspecificallyfortheorganisation.Thismeansthatmoretimewillbenecessarytounderstandthesystemthanifstandardsystemswereused.Thisproblemcanbealleviatedeitherbyobtainingdocumentationfromtheclientorbyapproachingthesoftwarehouse(withTirrolCo’spermission)toseeiftheycanassistwithprovisionofinformationondatastructuresfortheinventorysystems.ProvisionofthisinformationwilldecreasethetimetakentotailorauditsoftwareforuseinTirrolCo.IssuesoflivetestingCal&Cohasbeeninformedthatinventorysystemsmustbetestedonalivebasis.Thisincreasestheriskofaccidentalamendmentordeletionofclientdatasystemscomparedtotestingcopyfiles.Tolimitthepossibilityofdamagetoclientsystems,Cal&CocanconsiderperforminginventorytestingondayswhenTirrolCoisnotoperatinge.g.weekends.Attheworst,backupsofdatafilestakenfromthepreviousdaycanbere-installedwhenCal&Co’stestingiscomplete.ComputersystemsTheclienthas25locations,witheachlocationmaintainingitsowncomputersystem.Itispossiblethatcomputersystemsarenotcommonacrosstheclientduetoamendmentsmadeatthebranchlevel.Thisproblemcanbeovercometosomeextentbyaskingstaffateachbranchwhethersystemshavebeenamendedandfocusingauditworkonmaterialbranches.UsefulnessofauditsoftwareTheuseofauditsoftwareatTirrolCodoesappeartohavesignificantproblemsthisyear.Thismeansthateveniftheauditsoftwareisready,theremaystillbesomeriskofincorrectconclusionsbeingderivedduetolackoftesting,etc.Thisproblemcanbealleviatedbyseriouslyconsideringthepossibilityofusingamanualauditthisyear.Themanagermayneedtoinvestigatewhetheramanualauditisfeasibleandifsowhetheritcouldbecompletedwithinthenecessarytimescalewithminimalauditrisk.(b)RelianceoninternalauditdocumentationTherearetwoissuestoconsider;theabilityofinternalaudittoproducethedocumentationandtheactualaccuracyofthedocumentationitself.Theabilityoftheinternalauditdepartmenttoproducethedocumentationcanbedeterminedby:–Ensuringthatthedepartmenthasstaffwhohaveappropriatequalifications.Provisionofarelevantqualificatione.g.membershipofacomputerrelatedinstitutewouldbeappropriate.–Ensuringthatthisandsimilardocumentationisproducedusingarecognisedplanandthatthedocumentationistestedpriortouse.Theuseofdifferentstaffintheinternalauditdepartmenttoproduceandtestdocumentationwillincreaseconfidenceinitsaccuracy.–Ensuringthatthedocumentationisactuallyusedduringinternalauditworkandthatproblemswithdocumentationarenotedandinvestigatedaspartofthatwork.Beinggivenaccesstointernalauditreportsontheinventorysoftwarewillprovideappropriateevidence.Regardingtheactualdocumentation:–Reviewingthedocumentationtoensurethatitappearslogicalandthattermsandsymbolsareusedconsistentlythroughout.Thiswillprovideevidencethattheflowcharts,etcshouldbeaccurate.–Comparingthedocumentationagainstthe‘live’inventorysystemtoensureitcorrectlyreflectstheinventorysystem.Thiscomparisonwillincludetracingindividualtransactionsthroughtheinventorysystems.–UsingpartofthedocumentationtoamendCal&Co’sauditsoftware,andthenensuringthatthesoftwareprocessesinventorysystemdataaccurately.However,thisstagemaybelimitedduetotheneedtouselivefilesatTirrolCo.

第7题:

Consider the MySQL Enterprise Audit plugin, You add the following lines to the my.cnf configuration tile: [mysqld] Plugin-load=audit_log.so Audit-log=FORCE_PLUS_PERMANENT You attempt to start up the MySQL service and notice that it fails to start. Which two statements would explain why the service did not start?()

  • A、FORCE_PLUS_PERMANENT is not valid for the audit-log option
  • B、The audit_log.so library does not exist
  • C、The audit_log.so library is in a location that is different from that defined by the plugin_dir option
  • D、The audit plugin must be loaded dynamically by using the INSTALL PLUGIN command
  • E、The audit log file does not exist in which to write audit events
  • F、The audit_log.so library is not an executable file

正确答案:B,C

第8题:

I wish () every success in your new post!

A、you to have

B、you to achieve

C、you

D、you have


参考答案:C

第9题:

A user reports that each day some files are deleted from the department share. The administrator needs to find who deleted these files.  Which of the following actions should the administrator perform?()

  • A、 Enable audit object access and specify files and folders to monitor using Task Manager.
  • B、 Enable audit policy change and specify files and folders to monitor using Windows Explorer.
  • C、 Enable audit object access and specify files and folders to monitor using Windows Explorer.
  • D、 Open Performance Monitor and monitor folder activity.

正确答案:C

第10题:

Your company has file servers located in an organizational unit named Payroll. The file servers  contain payroll files located in a folder named Payroll.     You create a GPO. You need to track which employees access the Payroll files on the file  servers.   What should you do()    

  • A、Enable the Audit object access option. Link the GPO to the Payroll organizational unit. On the file servers, configure
  • B、Enable the Audit object access option. Link the GPO to the domain. On the domain controllers, configure Auditing f
  • C、Enable the Audit process tracking option. Link the GPO to the Domain Controllers organizational unit. On the file se
  • D、Enable the Audit process tracking option. Link the GPO to the Payroll organizational unit. On the file servers, config

正确答案:A

更多相关问题