DBMS and RDBMS – Quiz

This quiz tests your understanding of the lesson introducing DBMSes and RDBMSes. For a more thorough testing of your SQL knowledge, go to our full list of SQL quizzes.

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

Which of the following sentences is true?:
a DBMS is a group of hardware components.
a DBMS is a group of software applications.
a DBMS is a group of tables.
a DBMS is an editor.

Question 2

Which of the following sentences does not apply to a DBMS:
it translates SQL queries sent by the user or by other software programs.
it manages access to the data by users.
it send commands directly to the hard drive.
it can stop functioning if it starts using too much memory.
it manages transactions.

Question 3

RDBMS stands for:
Relationship Database Management Systems.
Relational Database Management Software.
Relational Database Management System.

Question 4

Which of the following problem can be solved by an action on the DBMS (without any other actions performed):
you enter an SQL command, submit it, and the editor returns a syntax error.
the hard drive on which the data is stored is broken.
the only installed hard drive is completely full.
you enter an SQL command, submit it, and you receive no response.
the computer cannot communicate with the hard drive.
a virus attacked the computer on which the DBMS is installed.

Question 5

Which action is the less likely to help in case the DBMS is responding extremely slowly to all your SQL queries:
increase RAM memory on your computer.
killing a process not belonging to the DBMS but using an abnormal amount of memory.
run an antivirus on the computer on which the DBMS is installed.
replace your hard drive by a faster one.
start and stop DBMS processes.
all of the above can help.

Question 6

If I change my hard drive, do I need to modify my DBMS:
yes, I need to get a DBMS adapted to this new hard drive.
no, it is transparent for the DBMS, as the operating system is taking care of the direct access to the hard drive.

Question 7

Which of the following function the DBMS is not responsible for:
communicating with the operating system.
translating SQL queries sent by the user.
translating data entered by user on a web page into an SQL query.
transaction management.
user access.
organization of the data in the database.

 

 

Once you have completed the quiz, calculated your score and reviewed your answers, I invite you to go to the next lesson: Database Administration.
 
Share on:


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