网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）
单选题
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

参考答案

参考解析
解析： 暂无解析
更多 “单选题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” 相关考题
考题 You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?() A. Drop the table.B. Partition the tableC. Truncate the table.D. Add a column to the table.E. Rename a column in the table.
查看答案
考题 Examine the following command that is executed for the TRANSPORT table in the SH schema:Which statement describes the significance of this command?() A. It collects statistics into the pending area in the data dictionaryB. It creates a virtual hidden column in the CUSTOMERS_OBE tableC. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENTD. It creates a histogram to hold skewed information about the data in the columns
查看答案
考题 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.
查看答案
考题 In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）A、if a table is not in a clusterB、if a table has an active triggerC、if a table has an encryptedD、if a table has a column of data type LONG defined on itE、if a table has a referential integrity constraint defined on it
查看答案
考题 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.
查看答案
考题 You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?（）A、Drop the table.B、Partition the tableC、Truncate the table.D、Add a column to the table.E、Rename a column in the table.
查看答案
考题 You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?（）A、BFILE B、REF column C、Object table D、Column object E、INSTEAD-OF trigger
查看答案
考题 On Jan 11， 2005 at 2：30 P.M.， an erroneous update operation modified all the values of column LASTNAME in the EMPLOYEE table in the Scott schema to an empty string. You are the system administrator， and you want to return the original values in the table. To do so， you decided to flash back the table. Which two options can you use to flash back a table？（）A、 by using Oracle Enterprise ManagerB、 by issuing the FLASHBACK TABLE statement at the RMAN promptC、 by issuing the FLASHBACK TABLE statement at the SQL promptD、 by issuing the FLASHBACK TABLE statement at the LSNRCTL prompt
查看答案
考题 You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（）  A、 Drop the table.B、 Partition the table.C、 Truncate the table.D、 Add a column to the table.E、 Rename a column in the table.
查看答案
考题 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
查看答案
考题 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
查看答案
考题 You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add anew column to the EMPLOYEE table to achieve this.  Which data type would you use for the new column（）A、CLOBB、BLOBC、BFILED、LONG RAW
查看答案
考题 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 tablespaceB、 space required for the bitmap index on a column of the tableC、 space remaining in the tablespace after creating the tableD、 estimated value of the PCTFREE storage parameter
查看答案
考题 The EMPLOYEES table has these columns: LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement: ALTER TABLE EMPLOYEES MODIFY (SALARY DEFAULT 5000); Which is true about your ALTER statement?（） A、Column definitions cannot be altered to add DEFAULT values.B、A change to the DEFAULT value affects only subsequent insertions to the table.C、Column definitions cannot be altered to add DEFAULT values for columns with a NUMBER data type.D、All the rows that have a NULL value for the SALARY column will be updated with the value 5000.
查看答案
考题 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.
查看答案
考题 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.’
查看答案
考题 单选题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 tablespaceB  space required for the bitmap index on a column of the tableC  space remaining in the tablespace after creating the tableD  estimated value of the PCTFREE storage parameter
查看答案
考题 单选题You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?（）A Drop the table.B Partition the tableC Truncate the table.D Add a column to the table.E Rename a column in the table.
查看答案
考题 多选题In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）Aif a table is not in a clusterBif a table has an active triggerCif a table has an encryptedDif a table has a column of data type LONG defined on itEif a table has a referential integrity constraint defined on it
查看答案
考题 单选题You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（）A  Drop the table.B  Partition the table.C  Truncate the table.D  Add a column to the table.E  Rename a column in the table.
查看答案
考题 单选题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
查看答案
考题 单选题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.’
查看答案
考题 单选题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.
查看答案
考题 单选题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.
查看答案
考题 单选题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
查看答案
考题 单选题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.
查看答案
热门标签
最新试卷