Which of the following database objects is considered executable using SQL?（）A、ViewB、TableC、RoutineD、Package
Which of the following database objects is considered executable using SQL?（）
- A、View
- B、Table
- C、Routine
- D、Package
相关考题：
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
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？（）AShut down the database.BSet the appropriate parameters in init.ora file.CStart the database in NOMOUNT state.DIssue the ALTER DATABASE ARCHIVELOG command.EOpen the database.FTake 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？（）ANORMALBTRANSACTIONALCABORTDIMMEDIATEEINCONSISTENT
单选题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? （）AClone BCopy CTemplate DTerminal
单选题You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?（）AWhen the instance is started BWhen the database is mounted CWhen the database is opened DWhen the database is closed
单选题Which of the following commands cannot be executed when the database open？（）ARECOVER DATABASEBRECOVER TABLESPACECRECOVER DATAFILEDALTER DATABASE RECOVER DATAFILE
单选题You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（）AV$DATABASE BDBA_TABLES CSYSAUD$ DEMP
单选题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？（）AOPENBMOUNTCNOMOUNTDCLOSE