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

题目内容 (请给出正确答案)

Which of the following database objects can be used to raise an error if a table is updated?()

  • A、Package
  • B、Trigger
  • C、Stored Procedure
  • D、Informational Constraint

参考答案

更多 “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” 相关考题
考题 Which of the following is not responsibility of DBA(Data Base Administrator)?A.Database management system designB.Database schema definitionC.Database schema modificationD.Integrity constraint specification

考题 Which of the following OSPF messages contains entire complete LSAs used during the database exchange process?()A、LSRB、LSAckC、LSUD、DDE、Hello

考题 A bare metal backup requires which of the following backup method ologies?()A、 FullB、 DifferentialC、 IncrementalD、 Database

考题 A bare metal backup requires which of the following backup methodologies?()A、FullB、DifferentialC、IncrementalD、Database

考题 which one of the following database elements is not updated when the design task is run?()A、formsB、viewsC、rolesD、agents

考题 Which of the following has an integrated database?()A、AIXB、IBM iC、LinuxD、VIO Server

考题 Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?()A、REVOKE ACCESS ON DATABASE FROM USER bobB、REVOKE CONNECT ON DATABASE FROM USER tomC、REVOKE tom FROM ACCESS ON DATABASE BY USER bobD、REVOKE tom FROM CONNECT ON DATABASE BY USER bob

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

考题 单选题Which of the following shut down options should not be used before performing a consistent whole database backup?()A NORMALB TRANSACTIONALC ABORTD IMMEDIATEE INCONSISTENT

考题 单选题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 

考题 单选题You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?()A When the instance is started B When the database is mounted C When the database is opened D When the database is closed

考题 单选题Which of the following commands cannot be executed when the database open?()A RECOVER DATABASEB RECOVER TABLESPACEC RECOVER DATAFILED ALTER DATABASE RECOVER DATAFILE

考题 单选题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

考题 单选题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;

考题 单选题To perform a database point-in-time recovery using RMAN, after database restoration, you must ensure that the database is in which of the following states?()A OPENB MOUNTC NOMOUNTD CLOSE