网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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 situation
B
Application B will read the previous version of the row
C
Application B will read the row and see uncommitted changes made by application A
D
Application B will be placed in a lock-wait state until application A releases its lock
参考答案
参考解析
解析：
暂无解析
更多 “单选题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” 相关考题
考题
You work as an application developer at Certkiller .com. Certkiller .com uses an application that calculates monthly payments based upon client input.You are currently debugging this application using the Microsoft Visual Studio 2005 IDE.The application contains the following code:public double CalculateMonthlyPayment (Single rate, double principal) {//Implementation code}You have discovered that unexpected results are being returned by the application. You would like to pause execution and display a message box containing an error message in the event of a negative or zero rate value is Passed to the CalculateMonthlyPayment method.You need to ensure that this only occurs during debugging mode.What should you do?（）A.B.C.D.
考题
Identify three features of shared entities.() (Choose three.)
A.enable one-time definition of objectsB.are referenced by several Oracle Application modulesC.are defined in each Oracle Application module separatelyD.are owned by a single Oracle Application module for table purposes onlyE.are owned by a single Oracle Application module to designate the primary user or decision maker
考题
A cluster administrator decides ti implement application monitoring in order to monitor both a web application and its supporting database. The plan is to use a single resource group prod_rg and to configure one monitor method for the web app and one monitor method for the database. Which of the following statements best describes the need for custom resource monitor？（） A、 Multiple application servers must be in a single resource group.B、 Multiple application servers per resource group may be monitored.C、 Multiple resource groups must each contain a single application server.D、 Multiple application servers in a cluster cannot use process monitoring.
考题
A SAN attached production file server is required to be backed up nightly according to company policy.Recently the data to be backed up has increased to approximately 4TB. Currently， the server has a single attached LTO2 tape drive. Which of the following should the server administrator do to provide enough backup capacity for the nightly job？ （）A、 Replace the backup software with a more efficient application.B、 Reduce the amount of data to be backed up.C、 Replace the LTO2 tape drive with an LTO3 tape drive.D、 Replace the single tape drive with a tape library.
考题
A server needs to have memory added to support a new application. It currently is using PC4200 in a single channel configuration. Which of the following would be the correct memory upgrade？（）A、Install larger capacity PC2100 dual channel memory modules.B、Add a PCI expansion card with PC2100 single channel memory modules.C、Install smaller capacity PC4200 single channel memory modules.D、Install larger capacity PC4200 single channel memory modules.
考题
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.
考题
Application A holds an Update lock on a single row and application B is trying to read that row. If both applications are using isolation level UR, which of the following will occur?（）A、Application B will read the row.B、Applications A and B will cause a deadlock situation.C、Application B will wait until application A releases the Update lock.D、Application A will be terminated so that application B can read the row.
考题
A batch application executes a large number of update statements. The service level agreement for the application states that the application must complete its work as quickly as possible to ensure that dependent workloads can start ontime. What is one way to help the application complete quickly?（）A、Code the application to issue a LOCK TABLE statement. B、Code the application to issue a LOCK ROW statement. C、Decrease the number of I/O servers. D、Increase the locklist parameter.
考题
Identify three features of shared entities.（） (Choose three.)A、enable one-time definition of objectsB、are referenced by several Oracle Application modulesC、are defined in each Oracle Application module separatelyD、are owned by a single Oracle Application module for table purposes onlyE、are owned by a single Oracle Application module to designate the primary user or decision maker
考题
Users notify you that their application is failing every time they try to add new records. Because of poor application design， the actual ORA error message is unavailable. What might be the problem？（）A、 The application user has exceeded their undo quota.B、 The FLASHBACK GUARANTEE option is set on the undo tablespace.C、 The table is currently being queried by a Flashback Transaction Query operation.D、 The table is currently being queried by a Flashback Versions Query operation.E、 The RETENTION GUARANTEE option is set on the undo tablespace.
考题
User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to？（）A、null lock on the row being updatedB、null lock on the table containing the rowC、ROW SHARE lock for the row being updatedD、ROW EXCLUSIVE lock for the row being updatedE、shared row-exclusive lock for the row being updatedF、a shareable table lock for the table containing the rowG、exclusive table-level lock for the table containing the row
考题
Your network consists of Windows XP computers in a single Active Directory directory service domain. All computers are located in a single Active Directory site. You need to design and deploy a new Group Policy object （GPO） that automatically installs a custom application on computers. What are two possible ways to achieve this goal？（）A、 Link the GPO to the domain and assign the application.B、 Link the GPO to the site and assign the application.C、 Link the GPO to the domain and publish the application.D、 Link the GPO to the site and publish the application.
考题
单选题A flashing red light displayed at a single lock means that the lock（）.A
is ready to use but vessels must stand clearB
is ready to use and vessels may approachC
cannot be made ready immediately and vessels shall stand clearD
cannot be made ready immediately but vessels may approach
考题
多选题User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to？（）Anull lock on the row being updatedBnull lock on the table containing the rowCROW SHARE lock for the row being updatedDROW EXCLUSIVE lock for the row being updatedEshared row-exclusive lock for the row being updatedFa shareable table lock for the table containing the rowGexclusive table-level lock for the table containing the row
考题
单选题Application A holds an Update lock on a single row and application B is trying to read that row. If both applications are using isolation level UR, which of the following will occur?（）A
Application B will read the row.B
Applications A and B will cause a deadlock situation.C
Application B will wait until application A releases the Update lock.D
Application A will be terminated so that application B can read the row.
考题
多选题Identify three features of shared entities.（） (Choose three.)Aenable one-time definition of objectsBare referenced by several Oracle Application modulesCare defined in each Oracle Application module separatelyDare owned by a single Oracle Application module for table purposes onlyEare owned by a single Oracle Application module to designate the primary user or decision maker
考题
单选题A flashing green light displayed at a single lock means that the lock is（）.A
ready for entranceB
ready for entrance，but gates cannot be closed completelyC
being made ready for entranceD
not ready for entrance
考题
多选题Users notify you that their application is failing every time they try to add new records. Because of poor application design， the actual ORA error message is unavailable. What might be the problem？（）AThe application user has exceeded their undo quota.BThe FLASHBACK GUARANTEE option is set on the undo tablespace.CThe table is currently being queried by a Flashback Transaction Query operation.DThe table is currently being queried by a Flashback Versions Query operation.EThe RETENTION GUARANTEE option is set on the undo tablespace.
考题
单选题You are designing a Windows Azure application that will allow for the processing of image files. Images will be processed in batches by remote applications running on multiple servers. The application must meet the following requirements： - Remain operational during batch-processing operations. - Allow users to roll back each image to previous versions. Each remote application must have exclusive access to an image while processing it. You need to recommend an approach for storing the images. What should you recommend？（）A
Store the images in a Windows Azure Queue.B
Store theimages in Windows Azure Blob storage.C
Store the images in Windows Azure Table storage.D
Store images in a single Windows Azure Drive attached to the web role.
考题
单选题A cluster administrator decides ti implement application monitoring in order to monitor both a web application and its supporting database. The plan is to use a single resource group prod_rg and to configure one monitor method for the web app and one monitor method for the database. Which of the following statements best describes the need for custom resource monitor？（）A
Multiple application servers must be in a single resource group.B
Multiple application servers per resource group may be monitored.C
Multiple resource groups must each contain a single application server.D
Multiple application servers in a cluster cannot use process monitoring.
考题
单选题If DB2 detects a deadlock between application A and application B (each waiting for a lock held by the other one), what action will DB2 take?（）A
Rollback the transaction in both applications.B
Rollback the transaction in one of the two applications.C
Decrease the lock timeout value for both applications, thereby causing a lock timeout situation.D
Send a message to let the administrator know of the situation and decide which application or applications should be terminated.
考题
问答题写出下列Application对象的集合属性和方法所表示的含义 1.Application_onEnd 2.Application_onStart 3.Lock 4.unLock
考题
多选题You are a systems administrator responsible for managing a Windows Server 2008 Web Server Currently，there are no Web sites configured on the server. You need to configure the server to host two Web applications： Engineering App and Sales App. Both Web applications must be accessible by using HTTPport 80 without the use of host headers. Also， you must protect against problems in one Web applicationaffecting the performance or reliability of the other Web application. Which two steps should you take tomeet these requirements？（）ACreate a single Web site that contains both Web applications.BCreate two Web sites， one for each Web application.CAssign both Web applications to the same application pool.DAssign each Web application to its own application pool.
考题
单选题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.
热门标签
最新试卷