单选题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

题目
单选题
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.

相似考题

1.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 operationB. Because the object number changes after the flashback operationC. Because the rows are retrieved from the recycle bin during the flashback operationD. Because the table is moved forward and back to a temporary during the flashback opertion

2. 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.

3. 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、 OPENB、 MOUNTC、 NORMALD、 NOMOUNT

4.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=300B、Add the following lines to /.profile  TMOUT=5  export TMOUTC、Execute the following command：  chuser -u ALL -a TIMEOUT=5MD、Execute the following command：  chsec -u ALL -a TIMEOUT=600

更多“You execute the following command to enable a session in res”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第5题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第6题：

    单选题
    You execute the following command toauditdatabase activities：  SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command（）
    A

    Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.

    B

    Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.

    C

    One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.

    D

    One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.

    E

    One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.


    正确答案： B
    解析： 暂无解析

  • 第7题：

    单选题
    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 operation


    正确答案： D
    解析： 暂无解析

  • 第8题：

    单选题
    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
    解析： 暂无解析

  • 第9题：

    单选题
    Your company has an Active Directory domain. The company runs Terminal Services.  A user has remotely logged on to the Terminal Server. The user requires help to use an application. When you connect to the Terminal Server session， you cannot operate any applications. You need to ensure that you can assist any user on the Terminal Server. What should you do？（）
    A

     From the Terminal Server run the Tscon /v command. Then reconnect to the session.

    B

     Run the Chgusr /execute command on the Terminal Server. Then reconnect to the session.

    C

     Enable Use remote control with default user settings in the RDP-Tcp Properties.

    D

     Enable Use remote control with the following settings in the RDP-Tcp Properties. Configure the Level of control policy setting to Interact with the session. Instruct the user to log off and log back on.


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    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；


    正确答案： B
    解析： 暂无解析

  • 第12题：

    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

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第16题：

    单选题
    You execute the following command to audit database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）
    A

    One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.

    B

    One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.

    C

    One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.

    D

    One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.

    E

    One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT


    正确答案： C
    解析： 暂无解析

  • 第17题：

    单选题
    You execute the following command to audit the database activities：  SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;  What is the effect of this command？（）
    A

    One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.

    B

    One audit record is created for every session when any user successfully drops a table owned by SCOTT.

    C

    One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.

    D

    One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.

    E

    One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.


    正确答案： A
    解析： 暂无解析

  • 第18题：

    单选题
    You execute the following command in your Certkiller .com production database to change the width of the CUST_NAME column of the CUSTOMERS table： ALTER TABLE customers  MODIFY （cust_nameVARCHAR2 （40）） /  When you execute the command， it displays the following error message：  ERROR at line 1：  ORA-00054： resource busy and acquire with NOWAIT specified  What could be the reason for the error message？（）
    A

    The database instance is not available.

    B

    The ALTER TABLE command does not have WAIT option

    C

    The table or a row in the table is currently locked by another user session.

    D

    The database instance is busy processing other user sessions commands.

    E

    The CUSTOMERS table has no long running query active at the time when this request is made.

    F

    The server process executing the ALTER TABLE command is busy with another command execution


    正确答案： C
    解析： 暂无解析

  • 第19题：

    单选题
    Your comp any runs Remote Desktop Services on Windows Server 2008. You have a Remote Desktop Session Host (RD Session Host) server. You plan to install an application on the RD Session Host server by running a setup.exe file. You need to ensure that the application will install properly and be useable by all users on the RD Session Host server. What should you do first on the RD Session Host server?（）
    A

    Run the Changeuser /install command.

    B

    Run the Changeuser /execute command.

    C

    Set the Remote Desktop licensing mode t o  RDS Per User CAL.

    D

    Set the Remote Desktop licensing mode to RDS Per Device CAL.


    正确答案： D
    解析： 暂无解析

  • 第20题：

    多选题
    Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）
    A

    when you change the name of a datafile

    B

    when you drop a table from the database

    C

    when you take an export of the database

    D

    when you back up the database using OS utilities

    E

    when you issue an ALTER SYSTEM SWITCH LOGFILE statement

    F

    when you issue a BACKUP command from inside the RMAN run block


    正确答案： C,B
    解析： 暂无解析

  • 第21题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

相关内容