Which Oracle Database component is audited by default if the unified Auditing option is enabled?（）

相似题目

• 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 data types in Oracle Database 10g/11g?（）

  A . Only one LONG column can be used per table  B . A TIMESTAMP data type column stores only time values with fractional seconds  C . The BLOB data type column is used to store binary data in an operating system file  D . The minimum column width that can be specified for a VARCHAR2 data type column is one  E . The value for a CHAR data type column is blank-padded to the maximum defined column width

  查看最佳答案

• Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?（）

  A . By default, EM express is available for a database after database creation. B . You can use EM express to manage multiple databases running on the same server. C . You can perform basic administrative tasks for pluggable databases by using the EM express interface. D . You cannot start up or shut down a database Instance by using EM express. E . You can create and configure pluggable databases by using EM express.

  查看最佳答案

• Which two statements are true regarding transactions in an Oracle database（）

  A . Multiple transactions can use the same undo segment. B . A transaction is assigned an undo segment when it is started. C . More than one transaction cannot share the same extent in the undo tablespace. D . The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.

  查看最佳答案

• You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）

  A .  Flashback logs are not archived. B .  Flashback logs are maintained in redo log files. C .  Flashback logs are maintained in the Flash Recovery Area. D .  Flashback logs are used to maintain Flashback Database related errors. E .  Flashback logs need to be cleared manually after you disable Flashback Database.

  查看最佳答案

• You are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）

  A .  One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST. B .  One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST. C .  One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST. D .  One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.

  查看最佳答案

• You work as a database administrator for Certkiller .com. In your Oracle database10g installation you have set ORACLE_BASE to /u01/app/oracle.  Which objective will be achieved by this setting？（）

  A . The Oracle kernel will be placed in this location. B . The Oracle software will be placed in this location. C . The server parameter file （SPFILE） will be placed in this location. D . The database files will be placed in this location， if not specified explicitly. E . The location will be considered for the base of Oracle Managed Files （OMF）. F . The location will be considered for the base of Optimal Flexible Architecture （OFA）.

  查看最佳答案

• Which three statements are true regarding the logical structure of the Oracle database？（）

  A . Each segment contains one or more extents. B . Multiple tablespaces can share single data file. C . A data block is the smallest unit of I/O for data files. D . It is possible to have tablespaces of different block sizes in a database. E . Each data block in the database always corresponds to one OS block.

  查看最佳答案

• Which three tasks can be performed using regular expression support in Oracle Database 10g？（）

  A .  it can be used to concatenate two strings. B .  it can be used to find out the total length of the string. C .  it can be used for string manipulation and searching operations. D .  it can be used to format the output for a column or expression having string data. E .  it can be used to find and replace operations for a column or expression having string data.

  查看最佳答案

• For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）  

  A .  Automatic PGA Memory Management B .  Automatic SGA Memory Management C .  Automatic Shared Memory Management D .  Automatic Memory Management E .  Manual SGA Memory Management F .  None of the above

  查看最佳答案

• Which statement about the enabling of table compression in Oracle Database 11g is true？（）  

  A .  Compression can be enabled at the table， tablespace， or partition level for direct loads only. B .  Compression can be enabled only at the table level for both direct loads and conventional DML. C .  Compression can be enabled at the table， tablespace， or partition level for conventional DML only. D .  Compression can be enabled at the table， tablespace， or partition level for both direct loads and conventional DML.

  查看最佳答案

• Which tablespaces are mandatory in an Oracle database for it to be operational（）

  A . Undo tablespace B . USERS tablespace C . SYSAUX tablespace D . SYSTEM tablespace E . Temporary tablespace

  查看最佳答案

• You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）

  A . The Oracle kernel will be placed in this location. B . The Oracle software will be placed in this location. C . The server parameter file （SPFILE） will be placed in this location. D . The database files will be placed in this location， if not specified explicitly. E . The location will be considered for the base of Oracle Managed Files （OMF）. F . The location will be considered for the base of Optimal Flexible Architecture （OFA）.

  查看最佳答案

• Which two statements are true regarding Health Monitor checks in Oracle Database 11g？（）  

  A .  Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption. B .  Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible，corrupt or inconsistent. C .  Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically. D .  Health Monitor checks are always initiated manually when there is some critical error.

  查看最佳答案

• You are using the Database Configuration Assistant to configure your Oracle database. Which of the following terms pertains to the creation of an object from which creation of the other database can be based? （）

  A . Clone  B . Copy  C . Template  D . Terminal&e

  查看最佳答案

• Which setting enables the baselines by default in Oracle Database 11g？（）  

  A .  setting the STATISTICS_LEVEL parameter to TYPICAL B .  adding filters to the Automatic Database Diagnostic Monitor （ADDM） C .  enabling Automated Maintenance Task using Oracle Enterprise Manager D .  setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE

  查看最佳答案

• Which statements are true about logical structures of the Oracle database（）

  A . Each segment contains one or more extents. B . Multiple tablespaces can share a single data file C . A data block is the smallest unit of input/output （I/O） in data files. D . It is possible to have tablespaces of different block sizes in a database. E . Each data block in the database always corresponds to one operating system block

  查看最佳答案

• You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario（）

  A . You must shut down the database instance to perform the backups. B . You must configure the Flash Recovery Area （FRA） for the database. C . You can perform complete database backups without closing the database. D . All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

  查看最佳答案

• Which two are valid locking levels that are used by transactions in an Oracle database？（）

  A . row level B . block level C . object level D . schema level E . database level

  查看最佳答案

• Which two statements are true about the roles in the Oracle database？（）

  A . A role can be granted to itself. B . Roles are owned by the SYS user. C . Roles can be granted to other roles. D . A role cannot be assigned external authentication. E . A role can contain both system and object privileges.

  查看最佳答案

• Which three statements are true about logical structures of the Oracle database（）

  A . Each segment contains one or more extents. B . Multiple tablespaces can share a single data file. C . A data block is the smallest unit of input/output （I/O） in data files. D . It is possible to have tablespaces of different block sizes in a database. E . Each data block in the database always corresponds to one operating system block.

  查看最佳答案

• You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）

  A .  To recover a dropped table. B .  To recover a dropped schema. C .  To recover data from a truncated table. D .  To view changes made by all the transactions during a given period of time. E .  To view changes made by a single transaction during a given period of time.

  查看最佳答案

• Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g？（） 

  A .  Generate reports on data failure such as data file failures. B .  You can track the Service Request （SR） and implement repairs. C .  You can package and upload diagnostic data to Oracle Support. D .  You can manually run health checks to gather diagnostic data for a problem.

  查看最佳答案

• You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode.  Which two statements are true in this scenario（）

  A . You must shut down the database instance to perform the backups. B . You must configure the Flash Recovery Area （FRA） for the database. C . You can perform complete database backups without closing the database. D . All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

  查看最佳答案