A.The sessions are able to perform only queries.B.The s……

单项选择题You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA.  While observing the server settings， you find that the following parameter has been set in the parameter file of the database：  REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE？（）

A.to enable operating system authentication for a remote client
B.to restrict the scope of administration to identical operating systems
C.to allow the start up and shut down of the database from a remote client
D.to enable the administration of the operating system from a remote client
E.to disable the administration of the operating system from a remote client

多项选择题Youplantousestaticdatabaseregistrationforanewlistenerwhenyoucreateit.Whatcouldbethetworeasonsforthis？（）

A.More than one database is to be registered with the listener.
B.The users will connect the database by using the host naming method.
C.The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.
D.The database that is to be registered with the listener is configured in shared server mode.
E.The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.

多项选择题Whichthreestatementsaretrueregardingthefine­grainedauditing（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.

单项选择题The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the year­end 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 value­based auditing by using triggers
B.implementing fine­grained auditing with audit condition and event handler
C.performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL parameter to EXTENDED
D.performing standard database auditing to audit SQL statements with granularity level set to ACCESS

单项选择题You execute the following command to audit the database activities：  SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL  What is the effect of this command？（）

A.One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
B.One audit record is created for every session when any user successfully drops a table owned by SCOTT.
C.One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
D.One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
E.One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.