Which of the following database objects is considered executable using SQL?()
Which of the following database objects can be used to raise an error if a table is updated?()A、PackageB、TriggerC、Stored ProcedureD、Informational Constraint
点击查看答案
You are managing a single instance Oracle 10g database that utilizes the following parameters: Which of the following set of commands must you execute to enable Flashback Database?()A、 STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON; ALTER DATABASE OPEN;B、 STARTUP MOUNT ALTER DATABASE FLASHBACK ON; ALTER DATABASE OPEN RESETLOGS;C、 STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG; ALTER DATABASE FLASHBACK ON; ALTER DATABASE OPEN RESETLOGS;D、 STARTUP MOUNT ALTER DATABASE ARCHIVELOG; ALTER DATABASE FLASHBACK ON; ALTER DATABASE OPEN;
Which of the following steps is incorrect in the following sequence of enabling the ARCHIVELOG mode of a database?()A、Shut down the database.B、Set the appropriate parameters in init.ora file.C、Start the database in NOMOUNT state.D、Issue the ALTER DATABASE ARCHIVELOG command.E、Open the database.F、Take a full closed backup.
Which of the following files cannot be backed up by RMAN? ()(Choose all that apply.)A、Database datafilesB、Control filesC、Online redo logsD、Database pfilesE、Archived redo logs
In a two-tier configuration, it is recommended to put which of the following components on different nodes?()A、Database client and database serverB、WebSphere Application Server and Database ServerC、WebSphere Commerce Server and WebSphere Application ServerD、Web server and WebSphere Application Server
单选题Which of the following steps is incorrect in the following sequence of enabling the ARCHIVELOG mode of a database?()A Shut down the database.B Set the appropriate parameters in init.ora file.C Start the database in NOMOUNT state.D Issue the ALTER DATABASE ARCHIVELOG command.E Open the database.F Take a full closed backup.
多选题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? ()ASYS, SYSTEMBSCOTTCOnly for successful executionsDOnly for failed executionsEBoth successful and failed executions