Database Administration – Quiz

For each question below, select the best answer. To select the best answer, click on the circle located on the left of this answer. When all questions are answered, click on the Submit button

Question 1

Backing up a database means:
making a copy of the database.
putting back the database to its previous state.
preventing users from using it.

Question 2

Restoring a database means:
making a copy of the database.
repairing a database.
putting back the database to its previous state.

Question 3

To prevent the situation where any user can do any action in the database:
we backup the database.
we restore the database.
we assign user names and passwords, and assign rights to these user names.
we monitor the user activity and block unwanted users.

Question 4

The ability to do an action on a table is called:
a right
a token
a password
an action

Question 5

We prevent a user from updating a table by:
blocking the table
blocking the columns
revoking a right
granting a right

 

 

Once you have completed the quiz, calculated your score and reviewed your answers, I invite you to go to the next chapter: Retrieve Information using SQL.
 
Share on:

Something not clear? Ask your question here:

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

 
 

Author:
Last udpated: September 10, 2017
Created: September 2, 2014