Podcast
Questions and Answers
What is the purpose of the SQL data-manipulation language (DML)?
What is the purpose of the SQL data-manipulation language (DML)?
What does the 'select' clause in SQL do?
What does the 'select' clause in SQL do?
What does the 'alter table' statement do in SQL?
What does the 'alter table' statement do in SQL?
What is the result of an SQL query?
What is the result of an SQL query?
Signup and view all the answers
What is the purpose of the SQL 'drop table' statement?
What is the purpose of the SQL 'drop table' statement?
Signup and view all the answers
SQL allows duplicates in relations as well as in query results.
SQL allows duplicates in relations as well as in query results.
Signup and view all the answers
The 'delete from' statement in SQL deletes the table and its contents.
The 'delete from' statement in SQL deletes the table and its contents.
Signup and view all the answers
The 'alter table' statement in SQL can be used to add a new attribute to a relation.
The 'alter table' statement in SQL can be used to add a new attribute to a relation.
Signup and view all the answers
The select clause in SQL corresponds to the selection operation of the relational algebra.
The select clause in SQL corresponds to the selection operation of the relational algebra.
Signup and view all the answers
SQL names are case sensitive, meaning you cannot use upper- or lower-case letters interchangeably.
SQL names are case sensitive, meaning you cannot use upper- or lower-case letters interchangeably.
Signup and view all the answers
SQL allows duplicates in relations as well as in query results.
SQL allows duplicates in relations as well as in query results.
Signup and view all the answers
The 'alter table' statement in SQL can be used to add a new attribute to a relation.
The 'alter table' statement in SQL can be used to add a new attribute to a relation.
Signup and view all the answers
The select clause in SQL corresponds to the projection operation of the relational algebra.
The select clause in SQL corresponds to the projection operation of the relational algebra.
Signup and view all the answers
SQL names are case sensitive, meaning you cannot use upper- or lower-case letters interchangeably.
SQL names are case sensitive, meaning you cannot use upper- or lower-case letters interchangeably.
Signup and view all the answers
The 'delete from' statement in SQL deletes all contents of the table, but retains the table.
The 'delete from' statement in SQL deletes all contents of the table, but retains the table.
Signup and view all the answers
