单选题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？（）Acolumn sizesBcolumn data typesCPCTFREEDprojected number of rowEPCTUSED

题目内容(请给出正确答案)

单选题

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？（）

column sizes

column data types

PCTFREE

projected number of row

PCTUSED

参考答案和解析

正确答案： E

解析：暂无解析

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

更多相关问题

第1题

单选题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？（）Acolumn sizesBcolumn data typesCPCTFREEDprojected number of rowEPCTUSED

点击查看答案
第2题

单选题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 jobB Truncate the Certkiller STAFF table and run the jobC Delete all rows from the Certkiller STAFF table and run the jobD Increase the size of the USERStablespacethe and run the jobE Increase the size of the database default permanenttablespaceand run the job

点击查看答案
第3题

单选题You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column named FriendlyName to the Product table. A friendly name for each product will be stored in this column. The table currently contains data. The sales department has not yet created a friendly name for each product. FriendlyName is a required value for each product. You want to add this new column by using the least amount of effort. What should you do？（）A Define the new column as NULL.Update the FriendlyName column to the same value as the productName column. Alter the FriendlyName column to be NOT NULL.B Define the new column as NOT NULL with a default value of ’Undefined.’C Define the new column as NULL. Use application logic to enforce the data constraint.D Define the new column as NULL with a default value of ’Undefined.’

点击查看答案
第4题

单选题You create a data block based on a relation table containing a REF column. You select the REF column for your form module. Which statement about the REF column is true?（）A It is created as a nondisplay item. B The Lock Record property is set to Yes. C It cannot be referenced in item level triggers. D It is placed on the canvas with the highest sequence number.

点击查看答案
第5题

单选题Consider the following statement： SQL> EXECUTE DBMS_STATS.GATHER_SHEMA_STATS （- 2> ownname => ‘OE’， - 3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE， - 4> method opt => ‘for all columns size AUTO’）； What is the effect of ‘for all columns size AUTO’ of the METHOD_OPT option？（）A The Oracle server creates a new histogram based on existing histogram definitions for all table, column, and index statistics for the OE schema. B The Oracle server creates a histogram based on data distribution regardless of how the application uses the column/s for all table, column, and index statistics for the OE schema.C The Oracle server creates a histogram based on data and application usage of the column/s for all table, column, and index statistics for the OE schema. D The Oracle server creates a histogram based on application usage, regardless of data distribution, for all table, column, and index statistics for the OE schema.

点击查看答案
第6题

单选题You want to access employee details contained in flat files as part of the EMPLOYEE table. You planto add a new column to the EMPLOYEE table to achieve this. Which data type would you use for the new column（）A CLOBB BLOBC BFILED LONG RAW

点击查看答案
第7题

单选题You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform? （）A MERGEB INSERTC UPDATED ADDE ENTERF You cannot enter the phone numbers for the existing employee records.

点击查看答案

单选题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 sizesB column data typesC PCTFREED projected number of rowE PCTUSED

题目内容(请给出正确答案)

参考答案和解析

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容