You have not configured Oracle Managed Files (OMF) in your d

题目
单选题
You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.  Which statement should you use to enable the block change tracking feature?()
A

 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING

B

 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE 

C

 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE 

D

 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING

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

第1题:

You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.You plan to create the database using SQL statements.Which three techniques can you use to achieve this?()

A. Use Oracle Managed Files (OMF).

B. Specify the SEED FILE_NAME_CONVERT clause.

C. Specify the PDB_FILE_NAME_CONVERT initialization parameter.

D. Specify the DB_FILE_NAMECONVERT initialization parameter.

E. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).


参考答案:A, B, C

第2题:

You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. While studying the parameter file of the ASM instance, you find the following entry:  ASM_DISKSTRING = /devices/*  What could be the reason for this setting?()

  • A、to enable the ASM instance to identify the alert log file
  • B、to enable the ASM instance to identify the server parameter file
  • C、to enable the ASM instance to define the locations for Oracle Managed Files (OMF)
  • D、to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory

正确答案:B

第3题:

You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?()

A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;

B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>;

C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;

D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;


参考答案:C

第4题:

If you create your database using Oracle Managed Files (OMF), what is true?()

  • A、You must use Oracle predefined names to identify raw partitions that will hold OMF structures. 
  • B、You must define directories for two online redo log groups and three copies of the control file. 
  • C、If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. 
  • D、You must use only OMF data files when adding new tablespaces or data files to your database in the future.

正确答案:D

第5题:

You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting?()

  • A、The Oracle kernel will be placed in this location.
  • B、The Oracle software will be placed in this location.
  • C、The server parameter file (SPFILE) will be placed in this location.
  • D、The database files will be placed in this location, if not specified explicitly.
  • E、The location will be considered for the base of Oracle Managed Files (OMF).
  • F、The location will be considered for the base of Optimal Flexible Architecture (OFA).

正确答案:F

第6题:

You work as a database administrator for Certkiller .com. You want to administer your database servers,which are running on different host machines,using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective?()

  • A、Application Server Control
  • B、Oracle Management Service
  • C、Oracle Enterprise Manager Repository
  • D、Oracle Enterprise Manager Database Control

正确答案:C,D

第7题:

You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement will you use to enable the block change tracking feature?()

  • A、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;
  • B、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
  • C、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE 
  • D、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE 

正确答案:D

第8题:

Which two statements are true about Oracle Managed Files (OMF)?()

A. OMF cannot be used in a database that already has data files created with user-specified directions.

B. The file system directions that are specified by OMF parameters are created automatically.

C. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.

D. OMF automatically creates unique file names for table spaces and control files.

E. OMF may affect the location of the redo log files and archived log files.


参考答案:B, D

第9题:

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 Files
  • B、Oracle Grid Architecture
  • C、Optimal Flexible Architecture
  • D、Oracle database architecture

正确答案:C

第10题:

You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories. You plan to create the database using SQL statements. Which three techniques can you use to achieve this?()

  • A、Use Oracle Managed Files (OMF).
  • B、Specify the SEED FILE_NAME_CONVERT clause.
  • C、Specify the PDB_FILE_NAME_CONVERT initialization parameter.
  • D、Specify the DB_FILE_NAMECONVERT initialization parameter.
  • E、Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

正确答案:A,B,C

更多相关问题