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

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.

第2题：

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

第3题：

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

第4题：

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

第5题：

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.

第6题：

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.

第7题：

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.

第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.

第9题：

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.

第10题：

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.