15 Questions
What is the purpose of the SQL data-manipulation language (DML)?
To query information and manipulate data
What does the 'select' clause in SQL do?
List the attributes desired in the result of a query
What does the 'alter table' statement do in SQL?
Adds a new attribute to a relation
What is the result of an SQL query?
A relation
What is the purpose of the SQL 'drop table' statement?
Deletes the table and its contents
SQL allows duplicates in relations as well as in query results.
True
The 'delete from' statement in SQL deletes the table and its contents.
False
The 'alter table' statement in SQL can be used to add a new attribute to a relation.
True
The select clause in SQL corresponds to the selection operation of the relational algebra.
False
SQL names are case sensitive, meaning you cannot use upper- or lower-case letters interchangeably.
False
SQL allows duplicates in relations as well as in query results.
True
The 'alter table' statement in SQL can be used to add a new attribute to a relation.
True
The select clause in SQL corresponds to the projection operation of the relational algebra.
True
SQL names are case sensitive, meaning you cannot use upper- or lower-case letters interchangeably.
False
The 'delete from' statement in SQL deletes all contents of the table, but retains the table.
True
Test your knowledge of SQL basic query structure, set operations, aggregate functions, nested subqueries, and database modification with this quiz. Evaluate your understanding of SQL commands such as DROP TABLE, DELETE FROM, and ALTER TABLE.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free