网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
he DBA is about to enable auditing on the Oracle database in an attempt to discover some suspicious activity. Audit trail information is stored in which of the following database object names?()
A

SYS.SOURCE$ 

B

SYS.AUD$ 

C

DBA_SOURCE 

D

DBA_AUDIT_TRAIL


参考答案

参考解析
解析: 暂无解析
更多 “单选题he DBA is about to enable auditing on the Oracle database in an attempt to discover some suspicious activity. Audit trail information is stored in which of the following database object names?()A SYS.SOURCE$ B SYS.AUD$ C DBA_SOURCE D DBA_AUDIT_TRAIL” 相关考题
考题 Which of the following statements about ORACLE is (are) correct?Ⅰ.ORACLE follows SQL standardⅡ.ORACLE database defines two logical types: table and viewA.ⅠonlyB.Ⅱ onlyC.Ⅰ and ⅡD.none of the above

考题 You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?()A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE path;C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE path;D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;

考题 You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.You executed the following RMAN commands:What are the implications of this command?()A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.

考题 You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:SQL@utlu111i.sqlWhich statement about the execution of this script is true?()A. It must be executed from the Oracle Database 11g environment.B. It must be executed only after the SYSAUX tablespace has been created.C. It must be executed from the environment of the database that is being upgraded.D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

考题 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.

考题 Which Oracle Database component is audited by default if the unified Auditing option is enabled?() A. Oracle Data PumpB. Oracle Recovery Manager (RMAN)C. Oracle Label SecurityD. Oracle Database VaultE. Oracle Real Application Security

考题 Which Oracle Database component is audited by default if the unified Auditing option is enabled?()A、Oracle Data PumpB、Oracle Recovery Manager (RMAN)C、Oracle Label SecurityD、Oracle Database VaultE、Oracle Real Application Security

考题 ou executed the command to create a password file in the database server: $ orapwd file=orapworcl entries=5 ignorecase=N  Which statement describes the purpose of the above password file()A、It records usernames and passwords of users when granted the DBA role.B、It contains usernames and passwords of users for whom auditing is enabled.C、It is used by Oracle to authenticate users for remote database administration.D、It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating system groups.

考题 In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? ()A、DBA_USERS B、DBA_OBJECTS C、DBA_TS_QUOTAS D、DBA_TAB_PRIVS 

考题 The company is evaluating using a new Active Directory domain to contain all customer user accounts. You need to design a monitoring or logging strategy that meets business and security requirements for the new Web-based ordering application. Your solution must minimize overhead on existing domain controllers and servers.  What should you do?()A、Enable logon auditing in both the new and the existing domainsB、Enable logon auditing only in the existing domainC、Enable logon auditing only in the new domainD、Enable logon auditing on only the Web server

考题 You have many users complaining about slow inserts into a large table. While investigating the reason, you find that the number of indexes on the table is high. You want to find out which indexes are not being used.  Which method would you follow to achieve this?()A、enable index monitoring and query the DBA_OBJECTS viewB、enable index monitoring and query the DBA_INDEXES viewC、enable index monitoring and query the V$OBJECT_USAGE viewD、enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view

考题 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.

考题 A user wants to connect to the database instance from an application that is running on a remote machine. Which tools should the DBA use to establish the required configuration to ensure that the user is able to connect to the database instance?()A、Data PumpB、Oracle Net ManagerC、Oracle Enterprise ManagerD、Oracle Universal Installer (OUI)E、Database Configuration Assistant (DBCA)

考题 You work as a database administrator for Supportcenter.cn. You suspect that in one of your applications the customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries being executed on the customer table?()A、Monitor thealert.logfileB、Enable server-side SQL tracing for user sessionsC、Enable fine-grained auditing for the customer tableD、Enable Fine-Grained Access Control (FGAC) for the customer tableE、Write a database trigger on the customer table on the SELECT event

考题 In order to enable remote administration of users and tablespaces on an Oracle database, which of the following types of files must exist in the database?()A、Password file B、Initialization file C、Datafile D、Control file E、Nothing - SYSDBA privileges are not required for these actions

考题 You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?() A、V$DATABASE B、DBA_TABLES C、SYSAUD$ D、EMP

考题 he DBA is about to enable auditing on the Oracle database in an attempt to discover some suspicious activity. Audit trail information is stored in which of the following database object names?()A、SYS.SOURCE$ B、SYS.AUD$ C、DBA_SOURCE D、DBA_AUDIT_TRAIL

考题 多选题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?()AIt records the usernames and passwords of users when granted the DBA role.BIt contains the usernames and passwords of users for whom auditing is enabled.CIs used by Oracle to authenticate users for remote database administration.DIt records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.EIt supports the SYSBACKUP, SYSDG, and SYSKM system privileges.

考题 单选题In order to enable remote administration of users and tablespaces on an Oracle database, which of the following types of files must exist in the database?()A Password file B Initialization file C Datafile D Control file E Nothing - SYSDBA privileges are not required for these actions

考题 单选题he DBA is about to enable auditing on the Oracle database in an attempt to discover some suspicious activity. Audit trail information is stored in which of the following database object names?()A SYS.SOURCE$ B SYS.AUD$ C DBA_SOURCE D DBA_AUDIT_TRAIL

考题 单选题You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?()A SYSTEM B OUTLN C INTERNAL D SYS

考题 单选题You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA?()A control fileB password fileC listener controller fileD control file and password file

考题 单选题You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database.  What additional information is available to you when you enable tracing?()A Information about each Oracle Net connection.B Information about each entry in theLinstener.orafileC Information about the changed done in the databaseD Information about the different listeners in your systemE Information about all thenondatabasefiles required to operate the database

考题 单选题ou executed the command to create a password file in the database server: $ orapwd file=orapworcl entries=5 ignorecase=N  Which statement describes the purpose of the above password file()A It records usernames and passwords of users when granted the DBA role.B It contains usernames and passwords of users for whom auditing is enabled.C It is used by Oracle to authenticate users for remote database administration.D It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating system groups.

考题 单选题You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.Which statement should you use to enable the block change tracking feature?()A ALTER DATABASE ENABLE BLOCK CHANGE TRACKINGB ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE C ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE D ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING

考题 单选题You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database. You executed the following RMAN commands:   RMAN CONNECT TARGET sys/sys@APPPROD RMAN CONNECT AUXILIARY sys/sys@DUPDB RMAN DUPLICATE TARGET DATABASE TO dupdb  FROM ACTIVE DATABASE PASSWORD FILE SPILE  NOFILENAMECHECK;   What are the implications of this command?()A  It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.B  It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.C  It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.D  It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.

考题 单选题Which Oracle Database component is audited by default if the unified Auditing option is enabled?()A Oracle Data PumpB Oracle Recovery Manager (RMAN)C Oracle Label SecurityD Oracle Database VaultE Oracle Real Application Security

考题 单选题You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.  Which statement should you use to enable the block change tracking feature?()A  ALTER DATABASE ENABLE BLOCK CHANGE TRACKINGB  ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE C  ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE D  ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING