SQL Quiz

What does DBMS stand for?

• Database Management System

• Data Base Management Software

• Database Model System

• Data Base Management Service

Which of the following is NOT a disadvantage of file systems?

• Lengthy development times

• Complex system administration

• High security

• Slow report generation

What is metadata?

• Raw facts of interest

• Data about data

• Data stored in a database

• None of the above

Which of the following is a part of a database system?

• Hardware

• Software

• Peopleware

• All of the above

What does SQL stand for?

• Structured Query Language

• Simple Query Language

• Standard Query Language

• Structured Question Language

Which SQL component is used to manipulate data?

• DDL

• DML

• DCL

• SQL

What does the CREATE TABLE statement do?

• Deletes a table

• Modifies a table

• Creates a new table

• Retrieves data from a table

Which SQL clause is used to filter records?

• SELECT

• FROM

• WHERE

• JOIN

What is the purpose of the DISTINCT keyword in SQL?

• To sort data

• To eliminate duplicates

• To join tables

• To create a new table

Which of the following is an aggregate function?

• SELECT

• JOIN

• COUNT

• WHERE