What function can be used with SQL to encrypt user supplied-passwords to that they can be compared with the encrypted passwords stored on the SQL server?

• A. DESpassword()
• B. userencrypt()
• C. pwdencrypt()
• D. passwordin()

What will the following ASP script accomplish on a webpage?
<%
Response.CacheControl = "no-cache"
Response.AddHeader "Pragma", "no-cache"
Response.Expires = -1
if session("UID")="" then
Response.Redirect "Logon.asp"
Response.End
end if
%>

• A. Redirect users to the logon page if they do not have a valid certificate
• B. Checks the user's cache for personal information
• C. Logged on users will timeout after hour
• D. Checks whether user has already logged on

Harold is developing software for the company he works for to aid in their human resources and payroll procedures. Harold is almost done working on the program, currently working in the testing phase. Since Harold's supervisors and the company executives are going to consider this a mission critical program, they want it to be tested to the fullest. Harold decides to test the program using higher than normal simulated loads and requests. What type of testing is Harold performing against his program?

• A. User acceptance test
• B. Load-pressure test
• C. Load test
• D. Stress test

Fred has just finished developing a number of ASP pages that will be posted to his company's website. Fred does not want the page's source code viewed by anyone, so he decided to encode the pages to make the source code unusable. What will the following command accomplish?
screnc /e asp *.* c:\tmp

• A. Encode all ASP files in in the c:\tmp and place them in the default IIS virtual directory
• B. Encode all ASP files and place them in the c:\tmp directory
• C. Encode all ASP files in current directory as ASP files and place them in the c:\tmpdirectory
• D. Create an MD5 hash for all ASP files in the c:\tmp directory

Peter is writing a program that has a GUI front-end and uses a MS SQL database as a backend. Peter's application will repeatedly update and call upon specific tables in the database on a regular basis. Peter wants to make sure that his program always has the ability to update the database and that no other calls or updates can touch the database tables used at the same time. How could Peter accomplish this in his application?

• A. SET TRANSACTION EXCLUSIVE
• B. SET TRANSACTION WRITE
• C. Implicit lock
• D. Explicit lock