niusouti.com

单选题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 th

题目
单选题
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

相似考题

1.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 ManagerB. Listener Control utilityC. Database Configuration AssistantD. Oracle Net Configuration Assistant

2.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_SIZEB、 SHARED_POOL_SIZEC、 LARGE_POOL_SIZED、 JAVA_POOL_SIZEE、 SGA_MAX_SIZEF、 SORT_AREA_SIZE

3.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.

4.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.

参考答案和解析
正确答案： A
解析： 暂无解析
更多“You are using Oracle Enterprise Manager to estimate the size”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor， you can set values for which of the following initialization parameters？（）

    • 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,C,D

  • 第5题：

    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

    正确答案:A

  • 第6题：

    Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g？（） 

    • A、 Generate reports on data failure such as data file failures.
    • B、 You can track the Service Request （SR） and implement repairs.
    • C、 You can package and upload diagnostic data to Oracle Support.
    • D、 You can manually run health checks to gather diagnostic data for a problem.

    正确答案:B,C,D

  • 第7题：

    单选题
    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
    解析： 暂无解析

  • 第8题：

    多选题
    To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor， you can set values for which of the following initialization parameters？（）
    A

    DB_CACHE_SIZE

    B

    SHARED_POOL_SIZE

    C

    LARGE_POOL_SIZE

    D

    JAVA_POOL_SIZE

    E

    SGA_MAX_SIZE

    F

    SORT_AREA_SIZE


    正确答案： B,D
    解析： 暂无解析

  • 第9题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第10题：

    多选题
    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


    正确答案： B,C
    解析： 暂无解析

  • 第11题：

    单选题
    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


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    You want to estimate the size of a table by using the Oracle Enterprise Manager.  On which data is the size of the table NOT based？（）

    • A、 column sizes
    • B、 column data types
    • C、 PCTFREE
    • D、 projected number of row
    • E、 PCTUSED

    正确答案:E

  • 第17题：

    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

  • 第18题：

    You are using the backup scheduler in Enterprise Manager （EM） to schedule a backup of your database. Which type of script does the backup scheduler generate？（）

    • A、SQL script
    • B、PL/SQL script
    • C、Operating System （OS） script
    • D、Enterprise Manager （EM） script
    • E、Recovery Manager （RMAN） script

    正确答案:E

  • 第19题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

  • 第20题：

    单选题
    You are using Enterprise Manager to schedule backups for your database.  Which type of script wouldbe generated by the backup scheduler（）
    A

    XML script

    B

    PL/SQL script

    C

    Operating system script

    D

    Recovery Manager （RMAN） script


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    You work as a database administrator for Certkiller .com. While loading data into the Certkiller STAFF table using Oracle Enterprise Manager 10g Database Control， you find the status of the job as failed. On further investigation， you find the following error message in the output log： ORA-01653 unable to extend table HR. Certkiller STAFF by 8 intablespaceUSERS Which task would you perform to load the data successfully without affecting the users who are accessing the table？（）
    A

    Restart the database instance and run the job

    B

    Truncate the Certkiller STAFF table and run the job

    C

    Delete all rows from the Certkiller STAFF table and run the job

    D

    Increase the size of the USERStablespacethe and run the job

    E

    Increase the size of the database default permanenttablespaceand run the job


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    You want to estimate the size of a table by using the Oracle Enterprise Manager.  On which data is the size of the table NOT based？（）
    A

     column sizes

    B

     column data types

    C

     PCTFREE

    D

     projected number of row

    E

     PCTUSED


    正确答案： C
    解析： 暂无解析

  • 第23题：

    多选题
    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


    正确答案： C,A
    解析： 暂无解析

  • 第24题：

    多选题
    You work as a database administrator for Supportcenter.cn. 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


    正确答案： A,D
    解析： 暂无解析

相关内容