网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
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 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
热门标签
最新试卷