网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
Which three statements are true regarding the fine/x7fgrained auditing （FGA）？（）
A
FGA is possible on SELECT statements only.
B
The audit trail for FGA is stored in the FGA_LOG$ table.
C
The audit trail for FGA is stored in the AUD_LOG$ table.
D
FGA enables a SQL predicate to define when to audit an event.
E
FGA audits DELETE statements only when audit columns are specified.
F
FGA includes the SQL statement used by the user as part of the audit event entry.
参考答案
参考解析
解析：
暂无解析
更多 “多选题Which three statements are true regarding the fine/x7fgrained auditing （FGA）？（）AFGA is possible on SELECT statements only.BThe audit trail for FGA is stored in the FGA_LOG$ table.CThe audit trail for FGA is stored in the AUD_LOG$ table.DFGA enables a SQL predicate to define when to audit an event.EFGA audits DELETE statements only when audit columns are specified.FFGA includes the SQL statement used by the user as part of the audit event entry.” 相关考题
考题
Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements.You run the following statements in the mydb database: Mysql＞ CALL prepare_db ( );Mysql＞ LOAD DATA INFILE ‘/tmp/data.cav‘ INTO TABLE mytable; Mysql＞ SHOW TABLES;How many events are added to the audit log as a result of the preceding statements?（）A.12; only top-level statements and stored procedure events are loggedB.111; top-level statements and all lower-level statements are loggedC.3; only the top-level statements are loggedD.102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event
考题
YouworkasadatabaseadministratorforCertkiller.com.Inyourdevelopmentenvironmentenvironment，thedevelopersareresponsibleformodifyingthetablestructureaccordingtotheapplicationrequirements.However，youwanttokeeptrackoftheALTERTABLEcommandsbeingexecutedbydevelopers，soyouenableauditingtoachievethisobjective.Whichtwoviewswouldyourefertofindouttheauditinformation？（）A.DBA_AUDIT_TRAILB.DBA_AUDIT_SESSIONC.DBA_FGA_AUDIT_TRAILD.DBA_COMMON_AUDIT_TRAIL
考题
To make audit information more productive， the DBA executes the following command before startingan audit operation： SQL ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE； Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase（）A、It contains only the plan for the SQL statement executed by the user.B、It contains the SQL text executed by the user and the bind variables used with it.C、It contains the plan and statistics associated with the SQL statement executed by the user.D、It contains the plan for the SQL statement executed by the user and the bind variables used with it.
考题
Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements. You run the following statements in the mydb database: Mysql＞ CALL prepare_db ( ); Mysql＞ LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable; Mysql＞ SHOW TABLES; How many events are added to the audit log as a result of the preceding statements?（）A、12; only top-level statements and stored procedure events are loggedB、111; top-level statements and all lower-level statements are loggedC、3; only the top-level statements are loggedD、102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event
考题
Which three statements are valid SDM configuration wizards？ （）A、NATB、VPNC、STPD、Security Audit
考题
An administrator requires a summary of current configuration for each system. This is needed for an audit trail. Which of the following will provide this information（）A、configassistB、prtconfC、IsattrD、listdgrp
考题
Identify three benefits of Unified Auditing.（）A、Decreased use of storage to store audit trail rows in the database.B、It improves overall auditing performance.C、It guarantees zero-loss auditing.D、The audit trail cannot be easily modified because it is read-only.E、It automatically audits Recovery Manager (RMAN) events.
考题
The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the year/x7fend tax and interest calculation process， all the rows in the table need to be accessed. The bank authorities want to track access to the rows containing balance amounts exceeding $200，000， and then send an alert message to the administrator. Which method would you suggest to the bank for achieving this task？（）A、implementing valuebased auditing by using triggersB、implementing finegrained auditing with audit condition and event handlerC、performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL parameter to EXTENDEDD、performing standard database auditing to audit SQL statements with granularity level set to ACCESS
考题
You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（） A、 The audit trail is stored in an operating system file.B、 Auditing is disabled for all privileges.C、 The audit trail is stored in the database.D、 Auditing is enabled for all privileges.E、 Auditing is enabled for certain privileges related to database security.
考题
Which three statements are true regarding the fine/x7fgrained auditing （FGA）？（）A、FGA is possible on SELECT statements only.B、The audit trail for FGA is stored in the FGA_LOG$ table.C、The audit trail for FGA is stored in the AUD_LOG$ table.D、FGA enables a SQL predicate to define when to audit an event.E、FGA audits DELETE statements only when audit columns are specified.F、FGA includes the SQL statement used by the user as part of the audit event entry.
考题
You execute the following PL/SQL:Which two statements are true?（）A、Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE 10000 is accessed.B、FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE 10000 is accessed.C、FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.D、FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.
考题
You execute the following commands to audit database activities: SQL ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?（）A、One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.B、One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.C、One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.D、One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.E、One audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.
考题
Which three statements are true regarding the fine-grained auditing （FGA）？（）A、FGA is possible on SELECT statements only.B、The audit trail for FGA is stored in the FGA_LOG$ table.C、The audit trail for FGA is stored in the AUD_LOG$ table.D、FGA enables a SQL predicate to define when to audit an event.E、FGA audits DELETE statements only when audit columns are specified.F、FGA includes the SQL statement used by the user as part of the audit event entry.
考题
Which two statements are true about standard database auditing（）A、DDL statements can be audited.B、Statements that refer to stand-alone procedure can be audited.C、Operations by the users logged on as SYSDBA cannot be audited.D、Only one audit record is ever created for a session per audited statement even though it is executedmore than once.
考题
he DBA is about to enable auditing on the Oracle database in an attempt to discover some suspicious activity. Audit trail information is stored in which of the following database object names?（）A、SYS.SOURCE$ B、SYS.AUD$ C、DBA_SOURCE D、DBA_AUDIT_TRAIL
考题
多选题Which two statements are true about record groups?（）AThey are stored in the database.BThey are stored in local Forms memory.CThe type is specified explicitly at design time.DThe type is implied by when and how it is created.
考题
多选题You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（）AThe audit trail is stored in an operating system file.BAuditing is disabled for all privileges.CThe audit trail is stored in the database.DAuditing is enabled for all privileges.EAuditing is enabled for certain privileges related to database security.
考题
多选题Which two statements are true about standard database auditing（）ADDL statements can be audited.BStatements that refer to stand-alone procedure can be audited.COperations by the users logged on as SYSDBA cannot be audited.DOnly one audit record is ever created for a session per audited statement even though it is executedmore than once.
考题
多选题Which two statements regarding a SQL profile are true？（）AIt is built by Automatic Tuning Optimizer.BIt cannot be stored persistently in the data dictionary.CIt can be used by the query optimizer automatically.DIt can be created manually by using the CREATE PROFILE command.
考题
多选题You execute the following PL/SQL:Which two statements are true?（）AFine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE 10000 is accessed.BFGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE 10000 is accessed.CFGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.DFGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.
考题
多选题Which three statements are true regarding the fine-grained auditing （FGA）？（）AFGA is possible on SELECT statements only.BThe audit trail for FGA is stored in the FGA_LOG$ table.CThe audit trail for FGA is stored in the AUD_LOG$ table.DFGA enables a SQL predicate to define when to audit an event.EFGA audits DELETE statements only when audit columns are specified.FFGA includes the SQL statement used by the user as part of the audit event entry.
考题
多选题Which three statements are valid SDM configuration wizards？ （）ANATBVPNCSTPDSecurity Audit
考题
多选题You work as a database administrator for Certkiller .com. In your development environmentenvironment， the developers are responsible for modifying the table structure according to the application requirements. However， you want to keep track of the ALTER TABLE commands being executed by developers， so you enable auditing to achieve this objective. Which two views would you refer to find out the audit information？（）ADBA_AUDIT_TRAILBDBA_AUDIT_SESSIONCDBA_FGA_AUDIT_TRAILDDBA_COMMON_AUDIT_TRAIL
考题
多选题Identify three benefits of Unified Auditing.（）ADecreased use of storage to store audit trail rows in the database.BIt improves overall auditing performance.CIt guarantees zero-loss auditing.DThe audit trail cannot be easily modified because it is read-only.EIt automatically audits Recovery Manager (RMAN) events.
考题
单选题To make audit information more productive， the DBA executes the following command before starting an auditoperation： SQL ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE； Which statement is true regarding the audit record generated when auditing starts after restarting Thedatabase（）A
It contains only the plan for the SQL statement executed by the user.B
It contains the SQL text executed by the user and the bind variables used with it.C
It contains the plan and statistics associated with the SQL statement executed by the user.D
It contains the plan for the SQL statement executed by the user and the bind variables used with it
考题
单选题To make audit information more productive， the DBA executes the following command before startingan audit operation： SQL ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE； Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase（）A
It contains only the plan for the SQL statement executed by the user.B
It contains the SQL text executed by the user and the bind variables used with it.C
It contains the plan and statistics associated with the SQL statement executed by the user.D
It contains the plan for the SQL statement executed by the user and the bind variables used with it.
考题
多选题Which two statements are true of the forwarding table?（）AThe forwarding table is stored in the control plane only.BThe forwarding table contains both active and inactive routes.CThe forwarding table is stored in the control plane and the forwarding plane.DThe forwarding table uses a longest match lookup for forwarding decisions.
热门标签
最新试卷
