You have created an Oracle 10g database named SALES, which w

题目
单选题
You have created an Oracle 10g database named SALES, which will be used by an application named SalesOrders. Users of the SalesOrders application complain that application response time is slow when they generate reports. The SalesOrders application accesses a table that contains 10 million rows. You decide to create an index on this table using the NOLOGGING option so that the index creation process is completed in the least amount of time. Which of the following is NOT true about an index created with the NOLOGGING option?()
A

 The index can be changed from NOLOGGING to LOGGING

B

 The index cannot be recovered even in the ARCHIVELOG mode.

C

 The index can only be created if the base table is created with the NOLOGGING option.

D

 The index can be recovered if you perform a backup after the CREATE INDEX statement.

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

第1题:

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

第2题:

You are maintaining the SALES database on Oracle 10g. 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 will you specify to control the speed of the rebalancing activity? () 

  • A、 ASM_POWER_LIMIT
  • B、 ASM_DISKSTRING
  • C、 ASM_DISKGROUPS
  • D、 LARGE_POOL_SIZE

正确答案:A

第3题:

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

第4题:

You have a single Automatic Storage Management (ASM) instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file?()

  • A、 INSTANCE_TYPE
  • B、 DB_UNIQUE_NAME
  • C、 ASM_DISKSTRING
  • D、 ASM_POWER_LIMIT

正确答案:A

第5题:

Identify four uses of the Oracle Scheduler.()

  • A、 enables Oracle database to schedule which processes execute on which processors in a multiple CPU environment
  • B、 enables Oracle database to do patches according to a DBA-defined schedule
  • C、 enables you to schedule the execution of jobs based on time
  • D、 enables you to execute jobs in a clustered environment
  • E、 enables you to periodically execute operating systemscript files located on the same server as the database
  • F、 enables you to create a job that makes use of saved programs and schedules
  • G、 enables you to automate the management of the jobs that are created using the DBMS_JOB package

正确答案:C,D,E,F

第6题:

You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces?()

  • A、SQL*Plus
  • B、iSQL*Plus
  • C、Management Server
  • D、Management Repository
  • E、Oracle Enterprise Manager 10g Database Control

正确答案:E

第7题:

You dropped a schema of a user in an Oracle 10g by mistake. You decide to flash the database back to its previous state to restore the deleted schema.   Which process writes the before images of the physical database blocks to the flashback database logs?()

  • A、 LGWR
  • B、 DBWR
  • C、 MMON
  • D、 RVWR

正确答案:D

第8题:

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

第9题:

You work as a database administrator for Certkiller .com. In your organization, you have four databases, Certkiller DB01, Certkiller DB02, Certkiller DB03, and Certkiller DB04, which are located in Berlin, Frankfurt,Rammstein, and Munich respectively, and which were created using Database Configuration Assistant (DBCA).  You want to perform administrative tasks on these databases that include startup and shutdown, taking regular backups, and so on, fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task?()

  • A、Control file
  • B、Password file
  • C、Parameter file
  • D、Online redo log file
  • E、Listener controller file
  • F、Server parameter file

正确答案:B

第10题:

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 database
  • B、 auxiliary database
  • C、 third-party database
  • D、 recovery catalog database

正确答案:C

更多相关问题