多选题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.PR

题目
多选题
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.

相似考题

1.Which two statements are true regarding proxy ARP？（）A、Proxy ARP is enabled by default.B、Proxy ARP is not enabled by default.C、JUNOS security devices can forward ARP requests to a remote device when proxy ARP is enabled.D、JUNOS security devices can reply to ARP requests intended for a remote device when proxy ARP is enabled

2.Which two statements about subqueries are true? （）A、A subquery should retrieve only one row.B、A subquery can retrieve zero or more rows.C、A subquery can be used only in SQL query statements.D、Subqueries CANNOT be nested by more than two levels.E、A subquery CANNOT be used in an SQL query statement that uses group functions.F、When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.

3.Which two are true about aggregate functions? （）A、You can use aggregate functions in any clause of a SELECT statement.B、You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.C、You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.D、You can pass column names, expressions, constants, or functions as parameter to an aggregate function.E、You can use aggregate functions on a table, only by grouping the whole table as one single group.F、You cannot group the rows of a table by more than one column while using aggregate functions.

4. You Execute the Following command to create a password file in the database server: $ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’ Which two statements are true about the password file?（）A、It records the usernames and passwords of users when granted the DBA role.B、It contains the usernames and passwords of users for whom auditing is enabled.C、Is used by Oracle to authenticate users for remote database administration.D、It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.E、It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.

参考答案和解析
正确答案： C,B
解析： 暂无解析
更多“多选题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.PRI”相关问题

  • 第1题：

    In which scenario will you use the Flashback Transaction Query feature？（）

    • A、 when you want to restore an important table that is dropped from the Recycle Bin
    • B、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction
    • C、when you want to restore a dropped user’s schema
    • D、 when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period

    正确答案:B

  • 第2题：

    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.

    正确答案:C,E

  • 第3题：

    You enabled an audit policy by issuing the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM; For which database users and for which executions is the audit policy now active? （）

    • A、SYS, SYSTEM
    • B、SCOTT
    • C、Only for successful executions
    • D、Only for failed executions
    • E、Both successful and failed executions

    正确答案:A,E

  • 第4题：

    Which two statements are true when row archival management is enabled?（）

    • A、The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
    • B、The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
    • C、The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
    • D、The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
    • E、The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.

    正确答案:A,B

  • 第5题：

    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.

    正确答案:A,B

  • 第6题：

    Which of the following statements is true regarding implementing a Flashback Table recovery？  （）

    • A、 An SCN is never used to perform a Flashback Table recovery.
    • B、 If a significant number of changes have been made to the table， row movement must be enabled.
    • C、 The tablespace must be offline before performing a Flashback Table recovery.
    • D、 Flashback Table recovery is completely dependent on the availability of undo data in the undo  tablespace.

    正确答案:D

  • 第7题：

    Which two statements are true regarding single row functions?（）

    • A、They accept only a single argument 
    • B、They can be nested only to two levels 
    • C、Arguments can only be column values or constants 
    • D、They always return a single result row for every row of a queried table 
    • E、They can return a data type value different from the one that is referenced

    正确答案:D,E

  • 第8题：

    多选题
    You Execute the Following command to create a password file in the database server: $ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’ Which two statements are true about the password file?（）
    A

    It records the usernames and passwords of users when granted the DBA role.

    B

    It contains the usernames and passwords of users for whom auditing is enabled.

    C

    Is used by Oracle to authenticate users for remote database administration.

    D

    It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.

    E

    It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.


    正确答案： E,B
    解析： 暂无解析

  • 第9题：

    多选题
    Which two statements are correct regarding the Oracle Flashback Drop feature？ （）
    A

    Recycle bin exists for the tables only in non-SYSTEM， locally managed tablespaces.

    B

    You can flash back a dropped table provided row movement has been enabled on the table.

    C

    If you drop an index before dropping its associated table， then the recovery of the index is not supported when you flash back the dropped table.

    D

    When you execute the DROP TABLESPACE？ INCLUDING CONTENTS command， the objects in the tablespace are places in the recycle bin.

    E

    When a dropped table is moved to the recycle bin， only the table is renamed to a system-generated name； its associated objects and constraints are not renamed.

    F

    If you drop a table that is protected by the recycle bin， then associated bitmap-joined indexes and materialized view logs are also stored in the recycle bin.


    正确答案： B,D
    解析： 暂无解析

  • 第10题：

    多选题
    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.


    正确答案： C,A
    解析： 暂无解析

  • 第11题：

    多选题
    Which two statements are true when row archival management is enabled?（）
    A

    The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.

    B

    The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.

    C

    The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.

    D

    The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.

    E

    The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.


    正确答案： A,B
    解析： 暂无解析

  • 第12题：

    多选题
    Which two statements are true regarding single row functions?（）
    A

    They accept only a single argument

    B

    They can be nested only to two levels

    C

    Arguments can only be column values or constants

    D

    They always return a single result row for every row of a queried table

    E

    They can return a data type value different from the one that is referenced


    正确答案： E,B
    解析： 暂无解析

  • 第13题：

    Which two statements are correct regarding the Flashback Versions Query feature？（）

    • A、 You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.
    • B、 You can use this feature to identify the versions of V$ views.
    • C、 You can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.
    • D、 You can use this feature for a table only if row movement is enabled for the table.
    • E、 You can use this feature to identify the versions of external and fixed tables.

    正确答案:A,C

  • 第14题：

    Examine the following command: CREATE TABLE (prod_id number(4), Prod_name varchar2 (20), Category_id number(30), Quantity_on_hand number (3) INVISIBLE); Which three statements are true about using an invisible column in the PRODUCTS table?（）

    • A、The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.
    • B、The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.
    • C、Referential integrity constraint cannot be set on the invisible column.
    • D、The invisible column cannot be made visible and can only be marked as unused.
    • E、A primary key constraint can be added on the invisible column.

    正确答案:A,B,C

  • 第15题：

    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.

    正确答案:B,D,F

  • 第16题：

    Which two statements are correct regarding the Oracle Flashback Drop feature？ （）

    • A、 Recycle bin exists for the tables only in non-SYSTEM， locally managed tablespaces.
    • B、 You can flash back a dropped table provided row movement has been enabled on the table.
    • C、 If you drop an index before dropping its associated table， then the recovery of the index is not supported when you flash back the dropped table.
    • D、 When you execute the DROP TABLESPACE？ INCLUDING CONTENTS command， the objects in the tablespace are places in the recycle bin.
    • E、 When a dropped table is moved to the recycle bin， only the table is renamed to a system-generated name； its associated objects and constraints are not renamed.
    • F、 If you drop a table that is protected by the recycle bin， then associated bitmap-joined indexes and materialized view logs are also stored in the recycle bin.

    正确答案:A,C

  • 第17题：

    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.

    正确答案:A

  • 第18题：

    You have just performed a FLASHBACK TABLE operation using the following command：   flashback table employees to scn 123456；   The employees table has triggers associated with it.  Which of the following statements is true regarding the state of the triggers during the Flashback Table operation？（）  

    • A、 All the triggers are disabled.
    • B、 All the triggers are enabled by default.
    • C、 Enabled triggers remain enabled and disabled triggers remain disabled.
    • D、 Triggers are deleted when a Flashback Table operation is performed.

    正确答案:A

  • 第19题：

    多选题
    Examine the following command: CREATE TABLE (prod_id number(4), Prod_name varchar2 (20), Category_id number(30), Quantity_on_hand number (3) INVISIBLE); Which three statements are true about using an invisible column in the PRODUCTS table?（）
    A

    The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.

    B

    The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.

    C

    Referential integrity constraint cannot be set on the invisible column.

    D

    The invisible column cannot be made visible and can only be marked as unused.

    E

    A primary key constraint can be added on the invisible column.


    正确答案： A,D
    解析： 暂无解析

  • 第20题：

    单选题
    You have just performed a FLASHBACK TABLE operation using the following command：   flashback table employees to scn 123456；   The employees table has triggers associated with it.  Which of the following statements is true regarding the state of the triggers during the Flashback Table operation？（）
    A

     All the triggers are disabled.

    B

     All the triggers are enabled by default.

    C

     Enabled triggers remain enabled and disabled triggers remain disabled.

    D

     Triggers are deleted when a Flashback Table operation is performed.


    正确答案： C
    解析： 暂无解析

  • 第21题：

    多选题
    You execute the following piece of code with appropriate privileges: User SCOTT has been granted theCREATE SESSION privilege and the MGR role.Which two statements are true when a session logged in as SCOTT queries the SAL column in the viewand the table?（）
    A

    Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.

    B

    Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.

    C

    Data is never redacted for the EMP_V.SAL column.

    D

    Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.

    E

    Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.


    正确答案： E,A
    解析： 暂无解析

  • 第22题：

    多选题
    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.


    正确答案： B,D
    解析： 暂无解析

  • 第23题：

    多选题
    Which two statements about subqueries are true? （）
    A

    A subquery should retrieve only one row.

    B

    A subquery can retrieve zero or more rows.

    C

    A subquery can be used only in SQL query statements.

    D

    Subqueries CANNOT be nested by more than two levels.

    E

    A subquery CANNOT be used in an SQL query statement that uses group functions.

    F

    When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.


    正确答案： C,D
    解析： 暂无解析

  • 第24题：

    多选题
    Which two statements are true regarding proxy ARP？（）
    A

    Proxy ARP is enabled by default.

    B

    Proxy ARP is not enabled by default.

    C

    JUNOS security devices can forward ARP requests to a remote device when proxy ARP is enabled.

    D

    JUNOS security devices can reply to ARP requests intended for a remote device when proxy ARP is enabled


    正确答案： B,D
    解析： 暂无解析

相关内容