单选题Which statement describes the effect on an index， when the indexed column for the rows is updatedin the base table（）AAn update in a leaf row takes place.BThe index becomes invalid after the update.CThe leaf block containing the row to be updated is marked as invalid.DA row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted
单选题
Which statement describes the effect on an index， when the indexed column for the rows is updatedin the base table（）
A
An update in a leaf row takes place.
B
The index becomes invalid after the update.
C
The leaf block containing the row to be updated is marked as invalid.
D
A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted
参考解析
解析：
暂无解析
相关考题：
You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os. Which statement describes a solution to the above?（）A. Set a threshold for the default system-defined moving window baseline.B. Add directives to the Automatic Database Diagnostic Monitor (ADDM).C. Modify the profile for the targeted users for which control needs to be imposed.D. Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.
Consider the following:Which statement best describes the meaning of the value for the key_len column?() A.It shows the total size of the index rowB.It shows how many columns in the index are examinedC.It shows the number of characters indexed in the keyD.It shows how many bytes will be used from each index row
Examine the SQL statements that creates ORDERS table:For which columns would an index be automatically created when you execute the above SQL statement? () A. SER_NOB. ORDER_IDC. STATUSD. PROD_IDE. ORD_TOTALF. Composite index on ORDER_ID and ORDER_DATE
Which statement describes the UTM licensing model?() A. Install the license key and all UTM features will be enabled for the life of the productB. Install one license key per feature and the license key will be enabled for the life of the product.C. Install one UTM license key, which will activate all UTM features; the license will need to be renewed when it expires.D. Install one UTM license key per UTM feature; the licenses will need to be renewed when they expire.
A large vessel is equipped with a controllable pitch propeller. Which statement is TRUE?A.When dead in the water，it is often difficult to find the neutral position and slight headway or sternway may resultB.When going directly from full ahead to full astern，there is complete steering controlC.When the vessel has headway and the propeller is in neutral，there is no effect on rudder controlD.When maneuvering in port，full ahead or astern power can usually be obtained without changing shaft RPM
Which statement about the free surface effect is TRUE ________．A.It increases in direct proportion to the length of the tank times the breadth squaredB.It decreases at increased angles of heel due to pocketing when a tank is 90% fullC.It decreases in direct proportion to increasing specific gravity of the liquid in the tankD.In practice，the correction is considered to be a virtual reduction of KG
Which statement describes the UTM licensing model?（）A、Install the license key and all UTM features will be enabled for the life of the productB、Install one license key per feature and the license key will be enabled for the life of the product.C、Install one UTM license key, which will activate all UTM features; the license will need to be renewed when it expires.D、Install one UTM license key per UTM feature; the licenses will need to be renewed when they expire.
Which statement describes the effect on an index， when the indexed column for the rows is updatedin the base table（）A、An update in a leaf row takes place.B、The index becomes invalid after the update.C、The leaf block containing the row to be updated is marked as invalid.D、A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted
In which scenarios would you rebuild an index？（）A、 when you need to disable the index usageB、 when you need to change storage optionsC、 when you need to enable index monitoringD、 when you need to move the index to another tablespace
You issued the following statement to monitor the usage of the index： SQL ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE； Which view will you query to ensure that the index is being monitored？（） A、 INDEX_STATSB、 DBA_INDEXESC、 DBA_IND_COLUMNSD、 V$OBJECT_USAGE
Which statement describes the effect of the execution of the above PL/SQL block?（）A、The plan baselines are verified with the SQL profiles.B、All fixed plan baselines are converted into nonfixed plan baselines.C、All the nonaccepted SQL profiles are accepted into the plan baseline.D、The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named named Dworks in the instance. The Dworks database has a table named Bills which contains several indexes and a great amount of rows. An enterprise Web environment is supported by the database. Onthe Bills table 28% of the indexes have been fragmented. You have to defragment the indexes， making sure that you reduce the effect on database availability to the least. In the ALTER INDEX statement， which option should be included？（）A、Sort in tempdb B、Online C、Fill factor D、Pad index
单选题Which statement describes the effect on an index， when the indexed column for the rows is updatedin the base table（）AAn update in a leaf row takes place.BThe index becomes invalid after the update.CThe leaf block containing the row to be updated is marked as invalid.DA row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted
单选题When does Oracle9i flag an index as being used in the V$OBJECT_USAGE view？（）ADuring a query’s parse time only. BDuring a query’s execution time only. CDuring any kind of DML statement execution. DDuring the execution of an INSERT statement only.
单选题View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table： ALTER TABLE emp ADD CONSTRAINT emp_id_pk PRIMARY KEY （emp_id） USING INDEX emp_id_idx； Which statement is true regarding the effect of the command？（）A The PRIMARY KEY is created along with a new index.B The PRIMARY KEY is created and it would use an existing unique index.C The PRIMARY KEY would be created in a disabled state because it is using an existing index.D The statement produces an error because the USING clause is permitted only in the CREATE TABLE command.
单选题Which statement describes the purpose of BGP route damping?（）AAvoid interface bandwidth saturation.BDrop BGP routes when the routing-table becomes full.CRemove unnecessary route attributes when not in use.DLimit the effects of a flaping interface on route removal and readvertisement.
单选题Which statement describes queue and buffer managment in the E-series router?（）ABuffer memory is managed dynamically in the I/O module.BBuffer memory is managed dynamically in the switch fabric.CBuffer memory is managed dynamically on egress line modules.DBuffer memory is managed dynamically on ingress line modules
单选题Which statement describes the effect of the execution of the above PL/SQL block?（）AThe plan baselines are verified with the SQL profiles.BAll fixed plan baselines are converted into nonfixed plan baselines.CAll the nonaccepted SQL profiles are accepted into the plan baseline.DThe nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.
单选题You are a DBA of your company. You created a database named SALES on an Oracle 10g instance. You have defined an index named INDEX1 on the database table named INVENTORY. Users are complaining that queries accessing the INVENTORY table are running slow. Upon investigation you determine that the tablespace where the index is located is experiencing high I/O and you decide to relocate the index to another tablespace. Which of these will be the best way to accomplish this objective？（）A Rebuild the index.B Coalesce the index.C Drop and re-create the index in the new tablespace.D Relocate the index using the ALTER INDEX...MOVE statement.
单选题A wedge of water building up between the bow and nearer bank which forces the bow out and away describes（）.Abank cushionBbank suctionCcombined effectDbend effect
单选题The word which best describes the tone of the poem When We Two Parted is _____.AsentimentalBironicCparadoxicalDrealistic
单选题Examine the command： SQL DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statement describes the effect of the above command（）AAutomatic statistics collection is stopped for the CUSTOMERS table.BStatistics for the CUSTOMERS table are locked and cannot be overwritten.CExisting statistics for the CUSTOMERS table become unusable for the query optimizer.DSubsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics.
单选题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 LOGGINGB 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.
单选题You issued the following statement to monitor the usage of the index： SQL ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE； Which view will you query to ensure that the index is being monitored？（）A INDEX_STATSB DBA_INDEXESC DBA_IND_COLUMNSD V$OBJECT_USAGE
单选题You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os. Which statement describes a solution to the above?（）ASet a threshold for the default system-defined moving window baseline.BAdd directives to the Automatic Database Diagnostic Monitor (ADDM).CModify the profile for the targeted users for which control needs to be imposed.DImplement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.
单选题Select the statement that best describes The cure for Amplification Principle in the Internetdomain， as explained in RFC 3429 （Internet Architectural Guidelines ）（）？AAmplification is prevented if global changes have only a local effect as opposed to systems in which global changes have a local effectBAmplification is prevented if local changes have only a local effect as opposed to system inwhich localchange have a global effectCInternet domain does not suffer from“The Amplification Principle”as BGP takes care of misbehaving advertisersDNone of the above
多选题Examine the SQL statements that creates ORDERS table: For which columns would an index be automatically created when you execute the above SQL statement? （）ASER_NOBORDER_IDCSTATUSDPROD_IDEORD_TOTALFComposite index on ORDER_ID and ORDER_DATE