先試後買

A. By using the LSINVENTORY Command to query the Oracle Database Software Library.

B. By executing DBMS_AUDIT_MGMT PL/SQL package in Verify mode.

C. By querying the DBA_UNIFIED_AUDIT_OPTION view.

D. By querying V$OPTION for parameter Unified Auditing.

A. FGA policies can be created by a user having the AUDIT_ADMIN privilege.

B. FGA policies can be created by a user having granted the CREATE_FGA_POLICY role.

C. FGA policies by default can be created by a schema owner on an object in their schema.

D. FGA policies can only be created by a user with SYSDBA privilege.

E. FGA policies can be created by a user having EXECUTE privilege on the DBMS_FGA package.

A. Optimizer Statistics are collected automatically by Automatic Workload Repository (AWR) Snapshot.

B. Optimizer Statistics are collected automatically by an automatic maintenance job that runsduring predefined maintenance windows.

C. Optimizer Statistics are collected in real-time as data is inserted, deleted, or updated.

D. Optimizer Statistics are collected by the Statistics Advisor.

E. Optimizer Statistics can be manually collected at multiple levels using DBMS_STATS.GATHER_*_STATS PL/SQL procedures.

A. They can be written by background processes to a file system.

B. They can be written by server processes to a file system.

C. All trace files contain error information that requires contacting Oracle Support.

D. Trace file names are based on the database name concatenated with a sequential number.

E. They can be written by server processes to the Fast Recovery Area (FRA).

A. Broadcasting shared server session responses back to requesters on all connections.

B. True. Dispatchers monitor the response queue.

C. Sending each connection input request to the appropriate shared server input queue.

D. Receiving inbound requests from processes using shared server connections.

E. Writing inbound requests to the common request queue from all shared server connections.

F. Checking for outbound shared server responses on the common outbound response queue.

G. Sending shared server session responses back to requesters on the appropriate connection.

A. The file is renamed and stored in the same location.

B. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.

C. DML may be performed on tables with one or more extents in this data file during the execution of this command.

D. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.

E. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.

A. Analysis of privileges that a user has on other schemas' objects.

B. Analysis of all privileges used by the SYS user.

C. Analysis of privileges that a user has on their own schema objects.

D. Analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role.

E. Analysis of privileges granted directly to a role that are then used by a user who has been granted that role.

A. Segments can span multiple tablespaces.

B. All tablespaces may have one or more data files.

C. A segment can span multiple data files in some tablespaces.

D. A segment's blocks can be of different sizes.

E. A segment might have only one extent.

F. A segment's blocks can be of different sizes.

A. Two or more instances on separate servers all mounting and opening the same database.

B. One instance on one server mounting and opening one database.

C. One instance on one server mounting multiple databases.

D. One instance on one server that has no database mounted.

E. One instance on one server mounting and opening multiple databases.

A. It is available to manage a database only when that database is open.

B. It uses a web-based console built into the Oracle database using XML DB.

C. It provides management for Oracle-engineered systems.

D. It is integrated with My Oracle Support.

E. It provides management for Oracle middleware.