搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

The SCOTT user has an index on the ITEM_DESC column of the ITEM table. As part of the year-ending task， SCOTT updates the ITEM_DESC column for most of the rows in the ITEM table. How does this change to the table affect the index？（）

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 deleted and inserted.

查看正确答案
更多“The SCOTT user has an index on the ITEM_DESC column of the ITEM table. As part of the year-ending task， SCOTT updates the ITEM_DESC column for most of the rows in the ITEM table. How does this change to the table affect the index？（）”相关的问题
第1题
[单选题] What will be the result of using the SQL> DROP USER SCOTT CASCADE； command？（）

A、 The user， Scott， is dropped， all the objects in Scott’s schema are placed in the Recycle Bin， and the objects that are  already in the Recycle Bin are dropped.  B、 The user， Scott， is dropped， all the objects in Scott’s schema are placed in the Recycle Bin， and all the objects in the Recycle Bin， belonging to the user Scott， are not dropped.  C、 The user， Scott， is dropped， all the objects in the Scott’s schema are not placed in the Recycle Bin， and the objects in the Recycle Bin， belonging to the user， Scott， are not dropped.  D、 The user， Scott， is dropped， all the objects in Scott’s schema are not placed in the Recycle Bin， and the objects in the Recycle Bin are dropped.  

点击查看答案
第2题
[多选题] You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）

A、 The batch operation started by the user， SCOTT， terminates with an error.  B、 The batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.  C、 The batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.  D、 The user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.  E、 The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.  

点击查看答案
第3题
[单选题] You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）

A、 You must enable the block change tracking feature.  B、 You must have enable the flashback feature.  C、 You must use the OMF in your database.  D、 You must define the tablespace of the SCOTT.EMP table for automatic segment space management.  

点击查看答案
第4题
[单选题] You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation？（）

A、 You must enable the row movement on the SCOTT.EMP table.  B、 You must define the tablespace of the SCOTT.EMP table for automatic segment space management.  C、 You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.  D、 You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.  

点击查看答案
第5题
[单选题] You are maintaining your database in ARCHIVELOG mode. An important table， SCOTT.EMPLOYEE， is dropped and purged from the Recycle Bin on Monday at 2：00 P.M. You do not use RMAN to perform backups. You performed the last full user-managed backup at 9：00 P.M. on Sunday.  How will you recover the dropped table， SCOTT.EMPLOYEE？（）

A、 by using the Flashback Table feature  B、 by using the Flashback Database feature  C、 by performing incomplete recovery using RMAN utility  D、 by performing incomplete recovery using user-managed recovery  

点击查看答案
第6题
[多选题] User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA， which commands must you execute to enable SCOTT to flash back the transactions？（）

A、 ALTER DATABASE FLASHBACK ON  B、 GRANT SELECT any transaction TO scott  C、 GRANT EXECUTE ON dbms_flashback TO scott  D、 ALTER DATABASE ADD SUPPLEMENTAL LOG DATA  E、 ALTER TABLESPACE undots1 RETENTION GUARANTEE  F、 ALTER DATABASE ADD SUPPLEMENTAL LOG DATA （PRIMARY KEY） COLUMNS  

点击查看答案
第7题
[单选题] You are configuring a roaming user profile for a Scott Peters. You create a user account named ScottP on a Windows 2000 Server. You define a network profile directory path named \\Server1\Profiles\%Username%. When Scott logs onto the computer， he receives the error message， "Windows cannot locate your roaming profile and is attempting to log you on with your local profile which will not be propagated to the server. The details of network cannot be found". What should you do？（）

A、Change the %Username% variable to ScottP.  B、Create a home folder for the Client computer.  C、Map a device to network profile directory.  D、Share the directory， which holds his profile.  

点击查看答案
第8题
[判断题] If the instructions are D/P the importer’s bank will release the documents to the importer only against payment.

点击查看答案
第9题
[单选题] You are creating a Windows Forms application by using the .Net Framework 3.5.You plan to display detailed help instructions for each control in the form.You create a help file.You configure a HelpProvider component on the form. You need to display the help file for the control that is focused when the F1 key is pressed.Which method of the HelpProvider class should you call for each control？（）

A、SetShowHelp  B、SetHelpString  C、SetHelpKeyword  D、SetHelpNavigator  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服