网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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.


参考答案

参考解析
解析: 暂无解析
更多 “单选题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.” 相关考题
考题 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?()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 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 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()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

考题 单选题You execute the following command toauditdatabase activities:  SQLAUDITDROP 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.

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

考题 单选题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 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?()A The database instance is not available.B The ALTER TABLE command does not have WAIT optionC 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

考题 单选题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?()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.

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