网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
You are maintaining subscriptions in an Oracle database. Which property of that subscription allowsyou to update it?()
A
Phase
B
Status
C
Source Type
D
Rule Function
E
Customization Level
参考答案
参考解析
解析:
暂无解析
更多 “单选题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 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 upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that coordinates the sizing of the memory components?() A、 MMANB、 PMONC、 MMOND、 MMNL
考题
You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem?()A、 Increase the value of the FAST_START_MTTR_TARGET initialization parameter.B、 Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.C、 Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.D、 Increase the value of the SGA_TARGET initialization parameter.
考题
You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?()A、BFILE B、REF column C、Object table D、Column object E、INSTEAD-OF trigger
考题
You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA?()A、 SQL Tuning AdvisorB、 Undo AdvisorC、 ADDMD、 Memory Advisor
考题
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 maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter?()A、 0B、 1C、 NONED、 DEFAULT
考题
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 can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback?()A、Oracle Flashback uses undo information to construct consistent data. B、You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session. C、You can only use Oracle Flashback view of the data if the required records are still in the online redo log files. D、Oracle Flashback lists the DML that was executed during the period you identify when initiating your session.
考题
You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()A、 online redo log filesB、 alert log filesC、 control fileD、 datafiles associated with the SYSTEM tablespace
考题
You are maintaining the SALES database. You have added a new disk to a disk group. Automatic StorageManagement performs the rebalancing activity. You want to speed up the rebalancing activity.Which parameter should you specify to control the speed of the rebalancing activity?()A、ASM_POWER_LIMITB、ASM_DISKSTRINGC、ASM_DISKGROUPSD、INSTANCE_TYPE
考题
You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command?()A、DatafilesB、 Current control fileC、 Server parameter file (spfile)D、 Password file
考题
单选题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 can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback?()AOracle Flashback uses undo information to construct consistent data.BYou can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session.CYou can only use Oracle Flashback view of the data if the required records are still in the online redo log files.DOracle Flashback lists the DML that was executed during the period you identify when initiating your session.
考题
单选题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 maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()A
online redo log filesB
alert log filesC
control fileD
datafiles associated with the SYSTEM tablespace
考题
单选题You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA?()A
SQL Tuning AdvisorB
Undo AdvisorC
ADDMD
Memory Advisor
考题
单选题You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem?()A
Increase the value of the FAST_START_MTTR_TARGET initialization parameter.B
Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.C
Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.D
Increase the value of the SGA_TARGET initialization parameter.
考题
多选题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 maintaining your database in Oracle10g. You are required to view the list of files that have not been backed up for the last seven days. Which RMAN command will you use?()A
LIST commandB
CROSSCHECK commandC
REPORT commandD
SHOW command
考题
单选题You are maintaining the SALES database. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity. Which parameter should you specify to control the speed of the rebalancing activity?()A
ASM_POWER_LIMITB
ASM_DISKSTRINGC
ASM_DISKGROUPSD
INSTANCE_TYPE
考题
单选题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 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 upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that coordinates the sizing of the memory components?()A
MMANB
PMONC
MMOND
MMNL
考题
单选题You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter?()A
0B
1C
NONED
DEFAULT
考题
单选题You are maintaining the SALES database. You have added a new disk to a disk group. Automatic StorageManagement performs the rebalancing activity. You want to speed up the rebalancing activity.Which parameter should you specify to control the speed of the rebalancing activity?()A
ASM_POWER_LIMITB
ASM_DISKSTRINGC
ASM_DISKGROUPSD
INSTANCE_TYPE
考题
单选题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
热门标签
最新试卷