topic: sql

Question 1

what does sql stand for

Answer 1

structured query language

Question 2

Sometimes users can have their accounts locked if they behave inappropriately. When this is
the case the locked field is set to 1 rather than 0.
Write an SQL statement that locks the account of the user Hades
using fields: users, locked , and username

Answer 2

UPDATE Users
SET locked=
WHERE username=’Hades’

Question 3

The function checkAccess takes in the password the user has entered (givenPassword)
along with the password hash (passwordHash) and locked value (locked).
passwordHash and locked have already been extracted from the database before being
passed to the function. It should return the value true if a user should be allowed access to
a system and false if they aren’t.
Your function should make use of the pre-written function hash() which takes in a string and
returns the hash of that string.
e.g.
hash(“Hello”) returns f7ff9e8b7bb2e09b70935a5d785e0cc5d9d0abf0
Complete the function checkAccess.
function checkAccess(givenPassword, passwordHash, locked)

Answer 3

temp = hash(givenPassword)
if temp==passwordHash and locked==0 then
return true
else
return false
endif