Which of the following is NOT a condition for deadlock?A．StarvationB．Circular waitC．No preemptioD．Mutual Exclusion

第1题：

If all client exclusion policies are enabled， on which number of tries will 802.1X authentications be excludedusing controller-based access points？（）

• A、three
• B、four
• C、five
• D、six

第2题：

public void test（） {     try { oneMethod（）；  System.out.println（"condition 1"）；  }  catch （ArrayIndexOutOfBoundsException e） {     System.out.println（"condition 2"）；     }  catch（Exception e） {  System.out.println（"condition 3"）；     }  finally {  System.out.println（"finally"）；    }  }  Which will display if oneMethod run normally？（）    

• A、 condition 1
• B、 condition 2
• C、 condition 3
• D、 finally

第3题：

If all client exclusion policies are enabled，on which number of tries will 802.1x authentications be excluded using controller-based access points？（）

• A、five
• B、three
• C、six
• D、four

第4题：

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

第5题：

Which three are true regarding the use of outer joins?（）

• A、You cannot use IN operator in a condition that involves an outerjoin.
• B、You use (+) on both sides of the WHERE condition to perform an outerjoin.
• C、You use (*) on both sides of the WHERE condition to perform an outerjoin.
• D、You use an outerjoin to see only the rows that do not meet the join condition.
• E、In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin.
• F、You cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.

第6题：

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 Dworks in the instance. Now you get a report from users saying that DB1 meets deadlock problems. As the technical support, you have to capture the deadlock information to the SQL Server error log. What should you do?（）  

• A、For the AdventureWorks database, enable Server Auditing 
• B、First you should set the appropriate trace flags as a startup parameter, and then restart the SQL Server instance 
• C、You should configure the data collector and make it capture the deadlock graphs
• D、You should configure a SQL Profiler trace, and make it capture the deadlock graphs

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

Client exclusion policies are used to mitigate which of the following attacks？（）

• A、dictionary
• B、bit-flip and replay
• C、mac spoofing
• D、man-in-the-middle

第13题：

Which of the following would be the safest environmental condition for working on multiple systems at one time？（）

• A、A tiled room with anti-static mats and wrist straps.
• B、A clean， carpeted room with anti-static mats and wrist straps.
• C、A tiled room in a warehouse with outside ventilation.
• D、A clean， carpeted room with air purifiers and dehumidifiers.

第14题：

Which of the following printer failure symptoms can be described as a condition where the internal feed mechanism has stopped working temporarily?（）

• A、Power cycle
• B、Paper jam
• C、No connectivity
• D、Corrupt printer driver

第15题：

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.

第16题：

Your alert log file has the following information： Tue May 25 17：43：38 2004  ORA-00060： Deadlock detected. More info in file  /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc.  What would you do to ensure that database is still running correctly？（）

• A、examine the trace file and kill the session that caused the deadlock
• B、examine the trace file and kill both the sessions responsible for the deadlock
• C、examine the trace file for details and ask the user who caused the deadlock to roll back the transaction
• D、examine the trace file for details and remember that deadlocks are resolved automatically by Oracle database
• E、examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock

第17题：

TestKing.com uses SQL Server 2005. Users report with increasing frequency that they receive deadlock error messages in an order processing application.   You need to monitor which objects and SQL Server session IDs are involved when deadlock conditions occur. You want information about each participant in the deadlock. What should you do？（）

• A、Trace the Lock：Timeout event by using SQL Server Profiler.
• B、Observe the SQLServer：Locks - Number of Deadlocks/sec counter by using System Monitor.
• C、Trace the Lock：Deadlock event by using SQL Server Profiler.
• D、Trace the Lock：Deadlock Chain event by using SQL Server Profiler.

第18题：

第19题：

第20题：

第21题：