单选题Application A is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE employee SET salary = salary * 1.1 WHERE empno='000010' UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00'Application B is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE department SET deptname = 'OLD DEPT' WHERE deptno='A00' UPDATE employee SET salary = salary * 0.5 WHERE empno='000010' Application A and application B execute their first SQL statement at the same time. When application A and application B try to execute their second SQL statement, a deadlock occurs. What will happen?（）AThe database manager will rollback the transaction in both applications.BThe database manager will rollback the transaction in one of the two applications.CApplication B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.DApplication A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.
单选题
Application A is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE employee SET salary = salary * 1.1 WHERE empno='000010' UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00'Application B is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE department SET deptname = 'OLD DEPT' WHERE deptno='A00' UPDATE employee SET salary = salary * 0.5 WHERE empno='000010' Application A and application B execute their first SQL statement at the same time. When application A and application B try to execute their second SQL statement, a deadlock occurs. What will happen?（）
A
The database manager will rollback the transaction in both applications.
B
The database manager will rollback the transaction in one of the two applications.
C
Application B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.
D
Application A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.
参考解析
解析：
暂无解析
相关考题：
You have an SQL query that takes one minute to execute. You use the following code segment to execute theSQL query asynchronously.Dim ar As IAsyncResult = cmd.BeginExecuteReader()You need to execute a method named DoWork() that takes one second to run while the SQL query is executing.DoWork() must run as many times as possible while the SQL query is executing.Which code segment should you use?（）A.B.C.D.
You are working with a Windows Communication Foundation (WCF) client application that has a generated proxy named SampleServiceProxy.When the client application is executing, in line 04 of the following code, the channel faults (Line numbers are included for reference only.)01 SampleServiceProxy proxy = new SampleServiceProxy();02 try03 {04 proxy.ProcessInvoice(invoice);05 }06 catch07 {08 if(proxy.State == CommunicationState.Faulted)09 {10 ...11 }12 }13 proxy.UpdateCustomer(customer);You need to return proxy to a state in which it can successfully execute the call in line 13.Which code segment should you use at line 10?（）A. proxy.Close();B. proxy = new SampleServiceProxy();C. proxy.Abort();D. proxy.Open();
To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:The blocks of code execute successfully; however, you do not get the required outcome. What could be the reason?（）A. A template needs to be associated with the task.B.A workload needs to be associated with the task.C. The partial or complete workload scope needs to be associated with the task.D. The type of structures (indexes, materialized views, or partitions) to be recommended need to be specified for the task.
You perform an in-place upgrade on a Microsoft Windows XP Service Pack 2 (SP2) computer to Windows Vista.After the upgrade, you attempt to run a custom application. You receive the following error message: This application is only designed to run on Windows XP or later.”You need to run the application on Windows Vista.What should you do?（）A.AB.BC.CD.D
When designing a PC, which of the following components would help a large application load theFASTEST?（）A、Solid state driveB、1 MB L2 cache memoryC、High-end graphics cardD、Dual core CPU
Which of the following servers would execute SQL？（）A、 Database ServerB、 DNS ServerC、 NAS ServerD、 Web Server
Application A currently holds an exclusive lock on a single row and application B tries to access that row. If lock timeout is set to -1 and both applications are using isolation level RS, which of the following will occur?（）A、Applications A and B will cause a deadlock situationB、Application B will read the previous version of the rowC、Application B will read the row and see uncommitted changes made by application AD、Application B will be placed in a lock-wait state until application A releases its lock
Application A is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE employee SET salary = salary * 1.1 WHERE empno='000010' UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00'Application B is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE department SET deptname = 'OLD DEPT' WHERE deptno='A00' UPDATE employee SET salary = salary * 0.5 WHERE empno='000010' Application A and application B execute their first SQL statement at the same time. When application A and application B try to execute their second SQL statement, a deadlock occurs. What will happen?（） A、The database manager will rollback the transaction in both applications.B、The database manager will rollback the transaction in one of the two applications.C、Application B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.D、Application A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.
Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?（）A、Task CenterB、Command EditorC、Developer WorkbenchD、Command Line Processor
A step in the HACMP test plan is to gracefully stop the cluster on a node and to verify that the Shared resources fallover to the standby node. To prepare for this testing step， both nodes in the two-node cluster are in a stable state with the single resource group active on Node ’A’. Which of the following is the best way to execute this portion of the test plan？（） A、 Execute "lssrc -g cluster stop" on Node ’A’B、 Execute "cat /etc//motd /dev/kmem" on Node ’A’C、 Execute "/usr/es/sbin/cluster/utilities/sclstop -gr" on Node ’A’D、 Find the pid of cluster manager daemon on Node ’A’ and issue a "kill-9" against the pid
A customer asked a consultant to create the infrastructure for an application. The application is designed to charge customers for conferencing services based on usage. To determine if a Storage Area Network （SAN） is the best storage solution， which of the following questions is most appropriate？（）A、Will the application require a database？B、Which operating system does the application require？C、Will the data need to be backed up in real time？D、Does the application share data among the servers？
You plan to execute the following command to perform a Flashback Database operation in your database： SQL FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）； Which two statements are true about this？（）A、 The database must have multiplexed redo log filesB、 The database must be in the MOUNT state to execute the commandC、 The database must be in the NOMOUNT state to execute the commandD、 The database must be opened in RESTRICTED mode before this operationE、 The database must be opened with the RESETLOGS option after the flashback operation
Evaluate the following code： SQLVARIABLE task_name VARCHAR2（255）； SQLVARIABLE sql_stmt VARCHAR2（4000）； SQLBEGIN ：sql_stmt ：= ’SELECT COUNT（*） FROM customers WHERE cust_state_province =’’CA’’’； ：task_name ：= ’MY_QUICKTUNE_TASK’； DBMS_ADVISOR.QUICK_TUNE（DBMS_ADVISOR.SQLACCESS_ADVISOR， ：task_name， ：sql_stmt）； END； What is the outcome of this block of code？（） A、 It creates a task and workload， and executes the task.B、 It creates a task and workload but does not execute the task.C、 It produces an error because a template has not been created.D、 It produces an error because the SQL Tuning Set has not been created.
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The instance has databases for a finance application and a manufacturing application. You want to put some limitation on the maximum CPU query time allowed by the applications, so you configure the Resource Governor to achieve this. But you notice that certain reports do not execute successfully any longer on the manufacturing application. You have to allow the manufacturing application to consume more CPU time, so you have to change the Resource Governor configuration. Which Resource Governor component should you configure?（） A、The workload group which is used by default B、The workload group which is used by the finance application C、The classifier function which identifies the finance application D、The workload group which is used by the manufacturing application
TestKing.com uses SQL Server 2005. A user reports that an order processing application stopped responding in the middle of an order transaction. The users SQL Server session ID is 54. You need to find out if session 54 is blocked by another connection. If it is,you need to identify the blocking session ID. What are two possible ways to achieve this goal？（）A、In SQL Server Management Studio， open the Activity Monitor. Open the Process Info page. View the blockedBy column for session 54.B、In SQL Server Management Studio，open the Activity Monitor. Open the Locks by Process page. View the Request Mode column for session 54.C、In SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec requests WHERE session id = 54View the blocking session id column.D、In SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec sessionsWHERE session id = 54View the status column.
You are working with a Windows Communication Foundation (WCF) client application that has a generated proxy named SampleServiceProxy.When the client application is executing, in line 04 of the following code, the channel faults (Line numbers are included for reference only.) 01 SampleServiceProxy proxy = new SampleServiceProxy（ ）; 02 try 03 { 04 proxy.ProcessInvoice(invoice); 05 } 06 catch 07 { 08 if(proxy.State == CommunicationState.Faulted) 09 { 10 ... 11 } 12 } 13 proxy.UpdateCustomer(customer);You need to return proxy to a state in which it can successfully execute the call in line 13.Which code segment should you use at line 10?（）A、proxy.Close();B、proxy = new SampleServiceProxy();C、proxy.Abort();D、proxy.Open();
单选题A customer asked a consultant to create the infrastructure for an application. The application is designed to charge customers for conferencing services based on usage. To determine if a Storage Area Network （SAN） is the best storage solution， which of the following questions is most appropriate？（）AWill the application require a database？BWhich operating system does the application require？CWill the data need to be backed up in real time？DDoes the application share data among the servers？
多选题You plan to execute the following command to perform a Flashback Database operation in your database: SQL FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?（）AThe database must have multiplexed redo log filesBThe database must be in the MOUNT state to execute the commandCThe database must be in the NOMOUNT state to execute the commandDThe database must be opened in RESTRICTED mode before this operationEThe database must be opened with the RESETLOGS option after the flashback operation
单选题View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables. Evaluate the following SQL statement： SELECT oi.order_id， product_jd， order_date FROM order_items oi JOIN orders o USING （order_id）； Which statement is true regarding the execution of this SQL statement？（）A The statement would not execute because table aliases are not allowed in the JOIN clause.B The statement would not execute because the table alias prefix is not used in the USING clause.C The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.D The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.
单选题Which of the following servers would execute SQL？（）A Database ServerB DNS ServerC NAS ServerD Web Server
单选题Application A currently holds an exclusive lock on a single row and application B tries to access that row. If lock timeout is set to -1 and both applications are using isolation level RS, which of the following will occur?（）AApplications A and B will cause a deadlock situationBApplication B will read the previous version of the rowCApplication B will read the row and see uncommitted changes made by application ADApplication B will be placed in a lock-wait state until application A releases its lock
单选题Your virtual environment includes Windows Server 2008 R2 Hyper-V servers. The test and development teams are developing a distributed application. The application requires a domain controller， a server that runs Microsoft SQL Server， an application server， and a client computer. The application uses pass-through authentication. You need to ensure that at the time of a failure， the test team can reproduce the error and provide the application in the state in which it existed when the error occurred to the development team for continued analysis. You must achieve this goal while minimizing storage requirements. What should you do？（）ASnapshot and export all serversBSnapshot and export only the application serverCSnapshot the application server， and back up the SQL Server databaseDSnapshot and export only the domain controller and the client computer
单选题When designing a PC, which of the following components would help a large application load theFASTEST?（）ASolid state driveB1 MB L2 cache memoryCHigh-end graphics cardDDual core CPU
单选题You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously.IAsyncResult ar = cmd.BeginExecuteReader（ ）;You need to execute a method named Do Work（ ） that takes one second to run while the SQL query is executing. DoWork（ ） must run as many times as possible while the SQL query is executing. Which code segment should you use? （）Awhile（ar.AsyncWaitHandle==null）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；Bwhile（!ar.IsCompleted）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；Cwhile（Thread.CurrentThread.ThreadState==ThreadState.Running）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；Dwhile（!ar.AsyncWaitHandle.WaitOne（））{DoWork（）；}dr=cmd.EndExecuteReader（ar）；
单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further. Which tool should you use? （）AYou should use Dynamic Management Views BYou should use SQL Server Resource Governor CYou should use SQL Server Profiler DYou should use Windows System Monitor
多选题TestKing.com uses SQL Server 2005. A user reports that an order processing application stopped responding in the middle of an order transaction. The users SQL Server session ID is 54. You need to find out if session 54 is blocked by another connection. If it is,you need to identify the blocking session ID. What are two possible ways to achieve this goal？（）AIn SQL Server Management Studio， open the Activity Monitor. Open the Process Info page. View the blockedBy column for session 54.BIn SQL Server Management Studio，open the Activity Monitor. Open the Locks by Process page. View the Request Mode column for session 54.CIn SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec requests WHERE session id = 54View the blocking session id column.DIn SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec sessionsWHERE session id = 54View the status column.
单选题Evaluate the following code： SQLVARIABLE task_name VARCHAR2（255）； SQLVARIABLE sql_stmt VARCHAR2（4000）； SQLBEGIN ：sql_stmt ：= ’SELECT COUNT（*） FROM customers WHERE cust_state_province =’’CA’’’； ：task_name ：= ’MY_QUICKTUNE_TASK’； DBMS_ADVISOR.QUICK_TUNE（DBMS_ADVISOR.SQLACCESS_ADVISOR， ：task_name， ：sql_stmt）； END； What is the outcome of this block of code？（）A It creates a task and workload， and executes the task.B It creates a task and workload but does not execute the task.C It produces an error because a template has not been created.D It produces an error because the SQL Tuning Set has not been created.
单选题Application A is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE employee SET salary = salary * 1.1 WHERE empno='000010' UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00'Application B is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE department SET deptname = 'OLD DEPT' WHERE deptno='A00' UPDATE employee SET salary = salary * 0.5 WHERE empno='000010' Application A and application B execute their first SQL statement at the same time. When application A and application B try to execute their second SQL statement, a deadlock occurs. What will happen?（）AThe database manager will rollback the transaction in both applications.BThe database manager will rollback the transaction in one of the two applications.CApplication B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.DApplication A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.