网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?（）
A
Online
B
Pending online
C
Offline
D
Stale
参考答案
参考解析
解析：
暂无解析
更多 “单选题When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?（）A Online B Pending online C Offline D Stale” 相关考题
考题
Which describes the default behavior when you create a table? ()
A. The table is accessible to all users.B. Tables are created in the public schema.C. Tables are created in your schema.D. Tables are created in the DBA schema.E. You must specify the schema when the table is created.
考题
Which two are the prerequisites to enable Flashback Data Archive?() (Choose two.)
A. Database must be running in archivelog mode.B. Automatic undo management must be enabled.C. Undo retention guarantee must be enabled.D. The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).
考题
For anyinformation system to serve its purpose ，the ihformation must be（ ）when it s needed.A.integralB.availab1eC.irreplaceableD.confidential
考题
For anyinformation system to serve its purpose ，the ihformation must be( )when it ìs needed.A.integral
B.availab1e
C.irreplaceable
D.confidential
考题
In which two conditions are resumable statements suspended？（）A、 when a user exceeds the space quotaB、 when a user session is terminatedC、 when a table that is being accessed by the current transaction is not foundD、 when a user manually suspends the statementE、 when the maximum extents of a segment is reached
考题
When using the Call Subflow step, can variables be shared between the parent (calling) flow and the subflow?（）A、No. B、Yes. C、Yes, but they must be manually passed via input and output mapping. D、Yes, but they must be manually created in both flows and have the same name.
考题
When recovering from a disaster, the backup and restore operation you use is similar to the export/import configuration procedure, with one additional step. Which additional step must you take when recovering from a disaster?（）A、A new WebSphere profile is required to restore the configuration.B、The restored system requires the IBM Tivoli Access Manager for e-business （TAMeb） JRTE to be manually configured against the WebSphere’s Java Runtime to allow the IBM Tivoli Federated Identity Manager （ITFIM） Runtime to function properly.C、The ITFIM Domain needs to be created manually within the Integrated Solution Console.D、The ITFIM Runtime instance needs to be re-registered with the TAMeb policy server by running the SvrSslCfg command.
考题
You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（） A、 The database will not start.B、 The database will start but will not retain the undo data in the undo segment.C、 The database will start， and the undo segment will contain the undo data for at least one hour.D、 The database will start， and the undo segment will retain the undo data for at least 15 minutes.
考题
While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）A、 Memory AdvisorB、 Segment AdvisorC、 Undo AdvisorD、 SQL Tuning Advisor
考题
Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)A、Flash recovery area must be definedB、Undo retention guarantee must be enabled.C、Database must be running in archivelog mode.D、Automatic undo management must be enabled.E、The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).
考题
Which two statements are true regarding transactions in an Oracle database（）A、Multiple transactions can use the same undo segment.B、A transaction is assigned an undo segment when it is started.C、More than one transaction cannot share the same extent in the undo tablespace.D、The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.
考题
Which two are the prerequisites to enable Flashback Data Archive？（）A、 Database must be running in archivelog mode.B、 Automatic undo management must be enabled.C、 Undo retention guarantee must be enabled.D、 The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management （ASSM）.
考题
You work as a database administrator for Supportcenter.cn. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows： ERROR at Line 1： ORA-10635： Invalid segment or tablespace type What could be the reason？ （）A、The table is partitionedB、The table name is wrong.C、It is an index-Organized table （IOT）D、The table is stored in locally managedtablespace.E、The table is stored in atablespacewhere segment space is managed manually.
考题
You develop a Web application that writes data to a file on a server. You restrict access to the file to specific Windows users. The Web application runs as CONTOSO/ASPNET. You deny anonymous access to the application in IIS. You add the following XML segment in the Web.config file.You need to ensure that the application meets the following requirements:It must impersonate the user when it writes data to the file.It must run as CONTOSO/ASPNET when a user does not access the file. Which two actions should you perform? （）A、Use the following XML segment in the Web.config file. identity impersonate="false"/B、Use the following XML segment in the Web.config file. identity impersonate="true"/C、Use the following code segment to access the file. Dim wp As WindowsPrincipal = _CType(HttpContext.Current.User, WindowsPrincipal) Dim wi As WindowsIdentity = WindowsIdentity.GetCurrent() Dim wic As WindowsImpersonationContext = wi.Impersonate()' Access the file herewic.Undo()D、Use the following code segment to access the file. Dim wi As WindowsIdentity = WindowsIdentity.GetCurrent()Dim wic As WindowsImpersonationContext = _WindowsIdentity.Impersonate(wi.Token)' Access the file herewic.Undo()
考题
You are the administrator of ExamSheet.net's network. ExamSheet upgrades its network to 100 Mbps. You remove the old network adapter and install a new 10/100 Mbps network adapter into a Windows 2000 Professional computer. You configure the TCP/IP protocol settings so that IP and DNS addresses are obtained automatically. When you restart the computer you cannot access the network. When you attempt toPINGaddress 127.0.0.1 you receive the following error message: "Request timed out." You want this computer to communicate on the network. What should you do?（）A、Configure IP address settings manually.B、Replace the network adapter.C、Disable TCP/IP filtering for all network adapters.D、Configure DNS server address settings manually.E、Enable IEEE 802.1x authentication.
考题
You are creating an undo buffer that stores data modifications.You need to ensure that the undo functionality undoes the most recent data modifications first.You also need to ensure that the undo buffer permits the storage of strings only.Which code segment should you use？（）A、Stackstring undoBuffer=new Stackstring（）；B、Stack undoBuffer=new Stack（）；C、Queuestring undoBuffer=new Queuestring（）；D、Queue undoBuffer=new Queue（）；
考题
单选题You work as a database administrator for Supportcenter.cn. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows： ERROR at Line 1： ORA-10635： Invalid segment or tablespace type What could be the reason？ （）A
The table is partitionedB
The table name is wrong.C
It is an index-Organized table （IOT）D
The table is stored in locally managedtablespace.E
The table is stored in atablespacewhere segment space is managed manually.
考题
多选题You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）ASet the UNDO_RETENTION parameter to AUTO.BCreate an initial undo segment in undotablespace.CSet the UNDO_RETENTION parameter to 900 or moreDSet the initialization parameter UNDO_MANAGEMENT to AUTOESet the UNDO_MANAGEMENT parameter to the name of an undotablespace
考题
多选题Which two statements are true regarding transactions in an Oracle database（）AMultiple transactions can use the same undo segment.BA transaction is assigned an undo segment when it is started.CMore than one transaction cannot share the same extent in the undo tablespace.DThe transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.
考题
多选题You require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace， UNDO_TBS1， in your database. Which two additional steps would you perform to achieve this？（）ASet the UNDO_RETENTION parameter to 900 or more.BCreate an initial undo segment in the undo tablespace.CEnable the retention guarantee for the undo tablespace.DSet the UNDO_TABLESPACE parameter to UNDO_TBS1.ESet the UNDO_MANAGEMENT initialization parameter to AUTO.
考题
单选题You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）A
The database will not start.B
The database will start but will not retain the undo data in the undo segment.C
The database will start， and the undo segment will contain the undo data for at least one hour.D
The database will start， and the undo segment will retain the undo data for at least 15 minutes.
考题
单选题While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）A
Memory AdvisorB
Segment AdvisorC
Undo AdvisorD
SQL Tuning Advisor
考题
单选题Which describes the default behavior when you create a table? （）A
The table is accessible to all users.B
Tables are created in the public schema.C
Tables are created in your schema.D
Tables are created in the DBA schema.E
You must specify the schema when the table is created.
考题
单选题When using the Call Subflow step, can variables be shared between the parent (calling) flow and the subflow?（）A
No. B
Yes. C
Yes, but they must be manually passed via input and output mapping. D
Yes, but they must be manually created in both flows and have the same name.
考题
单选题In your test database， you have created the ORDERS table as an index-organized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions. While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）A
export and import the mapping tableB
drop and re-create the mapping tableC
truncate the mapping table and reinsert the valuesD
use the ALTER TABLE···REBUILD command to defragment the mapping table
考题
单选题You work as a database administrator for Supportcenter.cn. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go？（）A
3 hoursB
6 monthsC
until last yearD
until last commitE
until the point when the undotablespacewas refreshedF
until the database is shut down and the memory erased
考题
单选题You have a long-running process you want to assign to a specific UNDO segment brought online for that express purpose. You are not using automatic UNDO management. What statement can be used for this task? （）A
ALTER DATABASE B
SET TRANSACTION C
ALTER ROLLBACK SEGMENT D
ALTER TABLE
热门标签
最新试卷
