You are maintaining the PROD database of TeleSoft Corporatio

题目
单选题
You are maintaining the PROD database of TeleSoft Corporation. You have initialized the following DB_BLOCK_CHECKING parameter in the init.ora file:  DB_BLOCK_CHECKING = TRUE;  What will be the result of setting this parameter?()
A

 Only data blocks of the SYSTEM tablespace will be checked.

B

 Only data blocks of the SYSAUX tablespace will be checked.

C

 A checksum will occur only on the checkpoint.

D

 A checksum will occur every time a block is modified.

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set.   How will you migrate your database from UTF8 to AL16UTF16?()  

  • A、 by using the RMAN utility
  • B、 by using the export/import utility
  • C、 by using the ALTER DATABASE command
  • D、 by enabling the change tracking feature

正确答案:C

第2题:

You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations.  Which view would you query to estimate the flashback space required?()

  • A、 V$DATABASE
  • B、 V$FLASHBACK_DATABASE_STAT
  • C、 V$FLASHBACK_DATABASE_LOG
  • D、 V$RECOVERY_FILE_DEST

正确答案:B

第3题:

You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:What is the outcome of the above commands?()

A. They execute and create a virtual catalog for pre-Oracle 11g clients.

B. They produce an error because PROD1 and PROD2 databases belong to the older version.

C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.

D. They produce an error because you need to connect to the target database to execute this packaged procedure.


参考答案:A

第4题:

You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday, you issued the following commands:   CONFIGURE DEFAULT DEVICE TYPE TO sbt;   CONFIGURE BACKUP OPTIMIZATION ON;   CONFIGURE RETENTION POLICY TO REDUNDANCY 3;   From Monday to Saturday, you performed the following actions:   Day                         Action  Monday                BACKUP DATABASE  Tuesday                BACKUP DATABASE  Wednesday              BACKUP DATABASE  Thursday               BACKUP DATABASE  Friday                 BACKUP DATABASE  Saturday               BACKUP DATABASE  How many times will the backup of the USERS tablespace be performed?()

  • A、 The backup will not be performed at all.
  • B、 three times
  • C、 four times
  • D、 six times

正确答案:C

第5题:

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

正确答案:E

第6题:

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 Advisor
  • B、 Undo Advisor
  • C、 ADDM
  • D、 Memory Advisor

正确答案:D

第7题:

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、 0
  • B、 1
  • C、 NONE
  • D、 DEFAULT

正确答案:A

第8题:

Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt:     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF;   RMAN> BACKUP DATABASE;   Which files from the database will be backed up as a result of this BACKUP command?()

  • A、 control file
  • B、 all datafiles
  • C、 password file
  • D、 online redo log file
  • E、 archive redo log file
  • F、 server parameter file
  • G、 only the SYSTEM datafile

正确答案:A,B,F

第9题:

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 files
  • B、 alert log files
  • C、 control file
  • D、 datafiles associated with the SYSTEM tablespace

正确答案:C

第10题:

You are maintaining your database in Oracle10g. While performing an incremental backup of the database, you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database?()

  • A、 redo log files
  • B、 password file
  • C、 control file
  • D、 change tracking file

正确答案:D

更多相关问题