placeholder image to represent content

Users and Privileges

Quiz by Rosanne Birney

Feel free to use or edit a copy

includes Teacher and Student dashboards

Measure skills
from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

With a free account, teachers can

edit the questions
save a copy for later
start a class game
automatically assign follow-up activities based on students’ scores
assign as homework
share a link with colleagues
print as a bubble sheet

Q 1/5
Score 0
Which of the following is the correct way to create a user called 'Student' with the password '1234'?
29
add user Student identified as '1234';
create user Student password '1234';
add user STUDENT identified by 1234;
create user Student identified by '1234';

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes

5 questions

Show answers

Q1
Which of the following is the correct way to create a user called 'Student' with the password '1234'?
add user Student identified as '1234';
create user Student password '1234';
add user STUDENT identified by 1234;
create user Student identified by '1234';
30s
Q2
Which of these will grant full privileges to the Management user on all tables in the car_sales database?
grant all on car_sales.tables to Management;
grant full on car_sales.* to Management;
grant all on car_sales.* to Management;
grant * on car_sales.* to Management;
30s
Q3
To give the salesperson user in the car_sales database permission to read, write and edit records in the Car table, which of the following commands should we execute?
grant select, insert, update on car to salesperson;
grant read, write, edit on car to salesperson;
grant to salesperson select, insert, update on car;
grant read, insert, update to salesperson on car;
30s
Q4
If we want to remove the salesperson's ability to add new cars into the car table, which of these commands should we use?
remove insert on cars from salesperson;
remove add on car from salesperson;
revoke update from salesperson on car;
revoke insert on car from salesperson;
30s
Q5
Which is the correct syntax to allow the salesperson user to update ONLY the reg field in the car table?
grant update on car.reg to salesperson;
grant update(car.reg) to salesperson;
grant update(reg) on car to salesperson;
grant insert(reg) to salesperson on car;
30s

Teachers give this quiz to your class