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

题目内容 (请给出正确答案)
单选题
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


参考答案

参考解析
解析: 暂无解析
更多 “单选题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” 相关考题
考题 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 are maintaining subscriptions in an Oracle database. Which property of that subscription allowsyou to update it?() A. PhaseB. StatusC. Source TypeD. Rule FunctionE. Customization Level

考题 While planning to manage more than one database in your system, you perform the following activities:  1. Organize different categories of files into independent subdirectories.  2. Use consistent naming convention for database files.  3. Separate administrative information pertaining to each database.  Which option corresponds to the type of activities performed by you?()A、Oracle Managed FilesB、Oracle Grid ArchitectureC、Optimal Flexible ArchitectureD、Oracle database architecture

考题 You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario()A、You must shut down the database instance to perform the backups.B、You must configure the Flash Recovery Area (FRA) for the database.C、You can perform complete database backups without closing the database.D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

考题 You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.  Which three statements are true about these backups()A、The backups would be consistent.B、The backups would be inconsistent.C、The backups would be possible only if the database is running in ARCHIVELOG mode.D、The backups would be possible only if the database is running in NOARCHIVELOG mode.E、The backups need to be restored and the database has to be recovered in case of a media failure

考题 You are maintaining subscriptions in an Oracle database. Which property of that subscription allowsyou to update it?()A、PhaseB、StatusC、Source TypeD、Rule FunctionE、Customization Level

考题 You are defining areas on your Oracle database. Which of the following profile areas can be used to control the resource usage for the other four?()A、LOGICAL_READS_PER_SESSION B、CONNECT_TIME C、COMPOSITE_LIMIT D、CPU_PER_SESSION E、PRIVATE_SGA

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

考题 You administer an Oracle Database 10g and a third-party database. You use Recovery Manager (RMAN) to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command?()A、 target databaseB、 auxiliary databaseC、 third-party databaseD、 recovery catalog database

考题 单选题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 are maintaining subscriptions in an Oracle database. Which property of that subscription allowsyou to update it?()A PhaseB StatusC Source TypeD Rule FunctionE Customization Level

考题 多选题You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario()AYou must shut down the database instance to perform the backups.BYou must configure the Flash Recovery Area (FRA) for the database.CYou can perform complete database backups without closing the database.DAll the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

考题 单选题You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to thepoint of failure. Which configuration will you do to accomplish the task()A Multiplex all database files.B Configure the Flash Recovery Area.C Configure the database instance for ARCHIVELOG mode.D Configure the FAST_START_MTTR_TARGET initialization parameter

考题 单选题You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? ()A Shared pool B Control file C SGA D PGA

考题 单选题You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big filetablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each.Which method would accomplish the task quickly and efficiently?()A parallel image copy backupB backup with MAXPIECESIZE configured for the channelC parallel backup with MAXPIECESIZE configured for the channelD intrafile parallel backup

考题 单选题You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each.  Which method would accomplish the task quickly and efficiently?()A  parallel image copy backupB  backup with MAXPIECESIZE configured for the channelC  parallel backup with MAXPIECESIZE configured for the channeD  intrafile parallel backup

考题 多选题You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?()ABFILEBREF columnCObject tableDColumn objectEINSTEAD-OF trigger

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

考题 单选题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 analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?()A Writes buffers to disk B Writes current redo log number to datafile headers C Writes redo log information to disk D Reads information into memory for users

考题 单选题You are configuring the data source for an Oracle database. You will need to specify a test table for WebLogic to test the status of the database. Which option should you choose?()A a table name which has 100s of recordsB a table name which has 10s of recordsC a table name which has empty recordsD a table name which has 1000s of recordsE never use a table name

考题 单选题You are managing an Oracle Database 10g database that uses Oracle Managed Files (OMF). You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true?()A  One block change tracking file is created for each data file. By default, the file is created in DB_CREATE_FILE_DEST.B  One block change tracking file is created for each data file. By default, the file is created in BACKGROUND_DUMP_DEST.C  One block change tracking file is created for the database. By default, the file is created in DB_CREATE_FILE_DEST.D  One block change tracking file is created for the database. By default, the file is created in BACKGROUND_DUMP_DEST.

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

考题 单选题A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?()A Acquire locks on table queried B Generate redo for statement C Fetch data from disk into memory D Write changes to disk

考题 单选题You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure.  Which configuration will you do to accomplish the task()A Multiplex all database filesB Configure the Flash Recovery Area.C Configure the database instance for ARCHIVELOG mode.D Configure the FAST_START_MTTR_TARGET initialization parameter.

考题 单选题ou are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently?()A parallel image copy backup B backup with MAXPIECESIZE configured for the channel C parallel backup with MAXPIECESIZE configured for the channel D intrafile parallel backup

考题 单选题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 administer an Oracle Database 10g and a third-party database. You use Recovery Manager (RMAN) to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command?()A  target databaseB  auxiliary databaseC  third-party databaseD  recovery catalog database