You execute the following command to enable a session in res

题目
单选题
You execute the following command to enable a session in resumable mode:  SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60;  What is the impact of a timeout on the statements being suspended?()
A

 The statements remain suspended for at least 60 seconds.

B

 The statements are suspended for 60 seconds and then they are executed.

C

 The suspended statements error out if the problem is not rectified within 60 seconds.

D

 The statements are automatically suspended 60 seconds after an error is received, and then attempt to execute normally again.

参考答案和解析
正确答案: A
解析: 暂无解析
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You issued the following statement:   SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n;   What will be the result of issuing the above statement?()

  • A、The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.
  • B、 The command will not execute successfully because resumable space allocation is enabled at the session level.
  • C、 The command will execute successfully and resumable space will be allocated at the session level.
  • D、 The command will execute successfully and resumable space will be allocated at the instance level.

正确答案:B

第2题:

You execute the following command to enable a session in resumable mode:  SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60;  What is the impact of a timeout on the statements being suspended?() 

  • A、The statements remain suspended for at least 60 seconds.
  • B、The statements are suspended for 60 seconds and then they are executed.
  • C、The suspended statements error out if the problem is not rectified within 60 seconds.
  • D、The statements are automatically suspended 60 seconds after an error is received, and then attempt toexecute normally again.

正确答案:C

第3题:

Before a Flashback Table operation, you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed?()

A. Because row IDs may change during the flashback operation

B. Because the object number changes after the flashback operation

C. Because the rows are retrieved from the recycle bin during the flashback operation

D. Because the table is moved forward and back to a temporary during the flashback opertion


参考答案:A

第4题:

Cer-tech .com has a server named Server01.Server01 runs Windows Server 2008.A web server(IIS) roleis also installed on Server01.A public website is hosted on Server01.While monitoring the traffic on thepublic site,you notice an unusual high volume of traffic on the website. You need to find the source of thetraffic. What should you do to achieve this objective?()

  • A、Open the IIS server manager and enable website logging to filter the logs for the source IP address
  • B、Install a third-party traffic analysis software to view the source IP address of the traffic
  • C、Execute net session - at command on the server
  • D、Execute net stat/all command to view the traffic statistics
  • E、None of the above

正确答案:A

第5题:

One of the users in the PROD database,Adams,complains that his update on the table,TRANS, is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions,and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table, he should get the highest priority.  Which method would you use to overcome this problem?()

  • A、execute the command, ALTER SESSION KILL .., to kill the blocking session
  • B、execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking session
  • C、execute the command, ALTER SYSTEM KILL SESSION .., to kill the blocking session
  • D、execute the command, ALTER SESSION UNLOCK .., to release the lock for the blocking session
  • E、execute the command, ALTER SYSTEM UNLOCK SESSION .., to release the lock for the blocking session

正确答案:C

第6题:

You execute the following command to start an Automatic Storage Management (ASM) instance:   SQL>STARTUP;   In which of the following modes will the ASM instance start?()

  • A、 OPEN
  • B、 MOUNT
  • C、 NORMAL
  • D、 NOMOUNT

正确答案:B

第7题:

You discover an out-of-space condition in the database. You decide to suspend a session for five minutes. You issue the following command to suspend the session:   ALTER SESSION ENABLE RESUMABLE;   Which command could you issue to enable the resumable space allocation feature at the session level?()  

  • A、 ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 5;
  • B、 ALTER SYSTEM ENABLE RESUMABLE_TIMEOUT = 5;
  • C、 ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 300;
  • D、 ALTER SYSTEM ENABLE RESUMABLE TIMEOUT = 300;

正确答案:C

第8题:

For security reasons, an administrator is asked to modify the system to prevent someone from leaving a terminal logged in. To enable a five minute timeout for all users, what would need to be done to accomplish this task?()

  • A、Add the following line to /etc/environment:  TMOUT=300
  • B、Add the following lines to /.profile  TMOUT=5  export TMOUT
  • C、Execute the following command:  chuser -u ALL -a TIMEOUT=5M
  • D、Execute the following command:  chsec -u ALL -a TIMEOUT=600

正确答案:A

第9题:

You are an enterprise administrator for Cer-tech .com. The corporate network of the company consists ofan Active Directory domain. All the servers on the network run Windows Server 2008. The network runsTerminal services to enable remote users to run commonly required applications from their terminal. A remote user logged on to the Terminal Server, required some help on the application he wanted to run.However,when you connect to the Terminal Server session,you cannot operate any applications. Which of the following options would you choose to ensure that you can assist any user on the Terminal Server?()

  • A、From the Terminal Server, run the Chguserver /execute command and then reconnect to the session.
  • B、In the RDP-Tcp Properties on the Terminal Server, enable the Use remote control option with default user settings.
  • C、In the RDP-Tcp Properties on the Terminal Server, enable the Use remote control with the following settings option and then configure the Level of control policy setting to Interact with the session. Ask the user to log off and log back on.
  • D、From the Terminal Server, run the Tscon /v command and then reconnect to the session.

正确答案:C

第10题:

Your company runs Remote Desktop Services. You have a Remote Desktop Session Host (RD Session Host) se rver. You enable Microsoft Word as a RemoteApp application on the RD Session Host server. You need to ensure that the RemoteApp application opens when a user double - clicks a Word (.docx) file on a client computer. Which two actions should you perform?()

  • A、Create a Windows Installer (.msi) file.
  • B、Create a Remote Desktop Protocol (.rdp) file.
  • C、In the properties of the RemoteApp application, enable the Allow any command - line arguments setting.
  • D、Enable the Associate client extensions for this program with the RemoteApp program setting for the file.

正确答案:A,D

更多相关问题