违法和不良信息举报 联系客服
免费注册 登录

You plan to use the In Database Archiving feature of Oracle

题目
多选题
You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format. Which three storage options support the use of HCC?（）
A

ASM disk groups with ASM disks consisting of Exadata Grid Disks.

B

ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array

C

ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files

D

Database files stored in ZFS and accessed using conventional NFS mounts.

E

Database files stored in ZFS and accessed using the Oracle Direct NFS feature

F

Database files stored in any file system and accessed using the Oracle Direct NFS feature

G

ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

参考答案和解析
正确答案： A,E,G
解析： 暂无解析
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.Which three storage options support the use of HCC?（）

A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.

B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array

C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files

D. Database files stored in ZFS and accessed using conventional NFS mounts.

E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature

F. Database files stored in any file system and accessed using the Oracle Direct NFS feature

G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays


参考答案：A, E, G

第2题：

You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）

  • A、 You must use automatic undo management in the database.
  • B、 You must configure OMF in your database.
  • C、 You must configure ASM for storing the datafiles.
  • D、 You must multiplex the online redo log file.

正确答案:A

第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题：

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

第5题：

You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the Oracle database（）

  • A、Use the external table population.
  • B、Use the Oracle Data Pump export and import utility.
  • C、Use the conventional path data load of the SQL*Loader utility.
  • D、Use the INSERT INTO...SELECT command to load the data

正确答案:C

第6题：

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、 MMAN
  • B、 PMON
  • C、 MMON
  • D、 MMNL

正确答案:A

第7题：

You plan to use static database registration for a new listener when you create it.What could be the two reasons for this？（）

  • A、More than one database is to be registered with the listener.
  • B、The users will connect the database by using the host naming method.
  • C、The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.
  • D、The database that is to be registered with the listener is configured in shared server mode.
  • E、The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.

正确答案:C,E

第8题：

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

第9题：

You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）

  • A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. 
  • B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. 
  • C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. 
  • D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. 
  • E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.

正确答案:D

第10题：

You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database（）

  • A、Use the external table population.
  • B、Use the Oracle Data Pump export and import utility.
  • C、Use the conventional path data load of the SQL*Loader utility.
  • D、Use the INSERT INTO...SELECT command to load the data.

正确答案:C

更多相关问题
相关内容