单选题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？（）AThe statements remain suspended for at least 60 seconds.BThe statements are suspended for 60 seconds and then they are executed.CThe suspended statements error out if the problem is not rectified within 60 seconds.DThe statements are automatically suspended 60 seconds after an error is received， and then attempt toexecute normally again.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
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
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 issued the following statement： SQLALTER 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.
You execute the following command to start an Automatic Storage Management （ASM） instance： SQLSTARTUP； In which of the following modes will the ASM instance start？（）A、 OPENB、 MOUNTC、 NORMALD、 NOMOUNT
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.
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；
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 sessionB、execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking sessionC、execute the command， ALTER SYSTEM KILL SESSION ..， to kill the blocking sessionD、execute the command， ALTER SESSION UNLOCK ..， to release the lock for the blocking sessionE、execute the command， ALTER SYSTEM UNLOCK SESSION ..， to release the lock for the blocking session
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.
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 addressB、Install a third-party traffic analysis software to view the source IP address of the trafficC、Execute net session - at command on the serverD、Execute net stat/all command to view the traffic statisticsE、None of the above
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.
单选题You issued the following statement： SQLALTER DATABASE ENABLE RESUMABLE TIMEOUT n； What will be the result of issuing the above statement？（）AThe 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.
单选题You execute the following command to start an Automatic Storage Management （ASM） instance： SQLSTARTUP； In which of the following modes will the ASM instance start？（）A OPENB MOUNTC NORMALD NOMOUNT
单选题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（）AOne audit record is created for every successful DROP TABLE command executed in the session of SCOTT.BOne audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.COne audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.DOne audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.EOne audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT
单选题You execute the following command toauditdatabase activities： SQLAUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）AOneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.BOneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.COne audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.DOne audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.EOne audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.
单选题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？（）AOne audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.BOne audit record is created for every session when any user successfully drops a table owned by SCOTT.COne audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.DOne audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.EOne audit record is created for each successful DROP TABLE command executed in the session of SCOTT.
单选题Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?（）ABecause row IDs may change during the flashback operationBBecause the object number changes after the flashback operationCBecause the rows are retrieved from the recycle bin during the flashback operationDBecause the table is moved forward and back to a temporary during the flashback operation
单选题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？（）AThe database instance is not available.BThe ALTER TABLE command does not have WAIT optionCThe table or a row in the table is currently locked by another user session.DThe database instance is busy processing other user sessions commands.EThe CUSTOMERS table has no long running query active at the time when this request is made.FThe server process executing the ALTER TABLE command is busy with another command execution
单选题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.
单选题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?（）ARun the Changeuser /install command.BRun the Changeuser /execute command.CSet the Remote Desktop licensing mode t o RDS Per User CAL.DSet the Remote Desktop licensing mode to RDS Per Device CAL.
单选题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.
多选题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？ （）Awhen you change the name of a datafileBwhen you drop a table from the databaseCwhen you take an export of the databaseDwhen you back up the database using OS utilitiesEwhen you issue an ALTER SYSTEM SWITCH LOGFILE statementFwhen you issue a BACKUP command from inside the RMAN run block
单选题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
单选题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？（）AThe statements remain suspended for at least 60 seconds.BThe statements are suspended for 60 seconds and then they are executed.CThe suspended statements error out if the problem is not rectified within 60 seconds.DThe statements are automatically suspended 60 seconds after an error is received， and then attempt to execute normally again.
单选题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；