You are using Oracle Enterprise Manager to estimate the size

题目
单选题
You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names, data types, sizes of the columns, and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return?()
A

 space allocated in the tablespace

B

 space required for the bitmap index on a column of the table

C

 space remaining in the tablespace after creating the table

D

 estimated value of the PCTFREE storage parameter

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

第1题:

Using Oracle Enterprise Manager to set SGA pool values manually, for which of the following pools does Oracle EM offer advice to set the value appropriately?() 

  • A、 DB_CACHE_SIZE
  • B、 SHARED_POOL_SIZE
  • C、 LARGE_POOL_SIZE
  • D、 JAVA_POOL_SIZE
  • E、 SGA_MAX_SIZE
  • F、 SORT_AREA_SIZE

正确答案:A,B

第2题:

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

第3题:

Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?()

A. Oracle Net Manager

B. Listener Control utility

C. Database Configuration Assistant

D. Oracle Net Configuration Assistant


参考答案:B

第4题:

You disabled the Flashback Database feature by using the following command:  SQL> ALTER DATABASE FLASHBACK OFF;  What would be the effect of this command on the existing flashback logs?()

  • A、 Flashback logs are not deleted.
  • B、 Flashback logs are deleted automatically.
  • C、 Flashback logs are deleted only if you are using Recovery Manager (RMAN)
  • D、 Flashback logs are deleted only if you are using Oracle Manager Files (OFM)
  • E、 Flashback logs are deleted only if you are using Automatic Storage Management (ASM)

正确答案:B

第5题:

Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace()

  • A、The retention period to support flashback
  • B、The expected length of the longest-running query
  • C、The number of undo tablespaces in the database
  • D、The size of the Flash Recovery Area for the database instance

正确答案:A,B

第6题:

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

第7题:

Which important factor is taken into account when determining an estimate for the maximum network bandwidth to be used by a customer?()

  • A、the size of the hard drives for each PC connected to the client’s network
  • B、the average size of the wallet based on the number of profiles and accounts
  • C、if any users will use IBM Tivoli Access Manager for Enterprise Single Sign-On during non-work hours
  • D、the number of users that will be connected using the wireless network, as opposed to a wired connection

正确答案:B

第8题:

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?()

A. By default, EM express is available for a database after database creation.

B. You can use EM express to manage multiple databases running on the same server.

C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.

D. You cannot start up or shut down a database Instance by using EM express.

E. You can create and configure pluggable databases by using EM express.


参考答案:D

第9题:

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

第10题:

You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true? ()

  • A、It is a SQL script.
  • B、It is a PL/SQL file.
  • C、It is an operating system (OS) file.
  • D、It is a Recovery Manager (RMAN) script

正确答案:D

更多相关问题