Computer Science Medium

Databases

Practice Databases MCQs as part of Computer Science.

20 MCQs
Medium difficulty

Questions in this Topic

What does "SQL" stand for?
Easy
Which SQL command is used to retrieve data from a database?
Easy
A collection of related tables in a database is called a:
Medium
What is a "primary key" in a database table?
Medium
Which SQL command is used to add new data into a table?
Easy
What is a "foreign key" used for?
Medium
What type of database uses tables with rows and columns?
Medium
Which SQL command is used to remove a table entirely?
Medium
Which SQL command is used to modify existing records in a table?
Easy
Which SQL command is used to remove rows from a table?
Easy
What is the purpose of the WHERE clause in SQL?
Medium
Which SQL clause is used to sort the result set?
Medium
What does a JOIN operation do in SQL?
Medium
Which SQL function returns the number of rows that match a condition?
Medium
What does "DBMS" stand for?
Easy
Which of the following is an example of a NoSQL database?
Medium
In the ACID properties of database transactions, what does the letter "A" stand for?
Hard
What is the main purpose of database normalization?
Medium
Which SQL clause is used with aggregate functions to group rows that have the same values?
Medium
Which SQL keyword is used to return only different (unique) values?
Medium
Topic Info
SubjectComputer Science
TopicDatabases
Total MCQs20
DifficultyMedium
Start Practice