搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

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？（）”相关的问题
第1题
[单选题] You are developing a tax report for the payroll application. You created a before parameter form report trigger to create three temporary tables to store text that are need while the report is executed. Which report trigger would you use to delete these temporary tables?（）

A、Before parameter form.   B、After parameter form.   C、Before report.   D、After report.  

点击查看答案
第2题
[单选题] You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. DB1 has a table which is named Table01 and a stored procedure named Procedure01. Procedure01 choose data from Table01 by using a sp_executesql Transact-SQL statement. You company security rules forbid users to access tables directly in any database. Look at th

A、You should execute the GRANT SELECT ON dbo.Table01 TO User1 Transact-SQL statement.   B、You should execute the GRANT EXECUTE ON dbo.Procedure1 TO User1 Transact-SQL statement.   C、You should alter Procedure01 and add the WITH EXECUTE AS OWNER option to its header   D、You should alter Procedure01 and add the EXECUTE AS USER = 'dbo' option immediately before the call to the sp_executesql stored procedure.  

点击查看答案
第3题
[单选题] You are designing a security group strategy to meet the business and technical requirements. What should you do?（）

A、Create one global group named G_Executives. Make all executives user accounts members of that group.  B、Create two global groups named G_Executives and one universal group named U_Executives. Make the two global members of U_Executives. Make the executive user accounts members of the appropriate global group.  C、Create three global groups named G_NY_Executives and G_Chi_Executives and G_Executives. Make G_NY_Executives and G_Chi_Executives members of G_Executives. Make the executive user accounts members of the appropriate global group.    D、Create one domain local group named DL_Executives. Make all executive user accounts members of that group.  

点击查看答案
第4题
[单选题] You previously secured your listener with an encrypted password. However， you need to set a new password for security reasons. What is the correct method for setting a new encrypted password for the listener using the Listener Control utility？（）

A、 executing the SET PASSWORD command and then the SAVE_CONFIG command  B、 executing the CHANGE_PASSWORD command and then the SAVE_CONFIG command  C、 executing the CHANGE_PASSWORD command and then the SET PASSWORD command  D、 executing the SET PASSWORD command， then the CHANGE_PASSWORD command and finally， the SAVE_CONFIG command  

点击查看答案
第5题
[单选题] Your network contains an Active Directory domain named contoso.com. All domain controllers run Windows Server 2012 R2. You create and enforce the default AppLocker executable rules. Users report that they can no longer execute a legacy application installed in the root of drive C. You need to ensure that the users can execute the legacy application. What should you do？（）

A、Modify the action of the existing rules  B、Create a new rule.  C、Add an exception to the existing rules  D、Delete an existing rule  

点击查看答案
第6题
[] You work as a database administrator for Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this？（）

A、A.Execute the ALTER DATABASE ARCHIVELOG statement  B、B.Select ARCHIVELOG option in the database control and restart the database to apply the changes.  C、C.Shut down and start the instance， and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.  D、D.Shut down and start the instance， mount the database， then execute the ALTER DATABASE ARCHIVELOG statement.  

点击查看答案
第7题
[单选题] Using the reports server how would you force the orders report in the orders entry application to run every six hours?（）

A、Schedule the report's execution in the queue manager.   B、Schedule the reports execution using the R30RQM command line with scheduled parameter.   C、Create a trigger in the application to execute the report every six hours.   D、You cannot schedule a reports execution.  

点击查看答案
第8题
[单选题] You want to purge job entries older than 5 days from the job log. You do not want to purge window log entries. Which command will you use to accomplish this task？（）  

A、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（log_history => 5， job_name => ’JOB1’）；  B、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， job_name => ’JOB_LOG’）；  C、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， which_log => ’JOB1’）；  D、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， which_log =>’JOB_LOG’）；  

点击查看答案
第9题
[] You want to create a temporary table while executing a procedure in a form. Which statement is true?（）

A、A.You cannot create a table form within Forms.   B、B.You must use the FORMS_DDL built-in to create the table.   C、C.You must use the DBMS_DYNAMIC_DDL package to create the table.   D、D.You can write the CREATE TABLE statement directly into the trigger.  

点击查看答案
第10题
[多选题] You want to analyze a SQL Tuning Set （STS） using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set？（）

A、 Every SQL statement in the STS is considered only once for execution.  B、 The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.  C、 The execution plan and execution statistics are computed for each SQL statement in the STS.   D、 The effects of DDL and DML are considered to produce the execution plan and execution statistics.  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服