18 Questions
SQL stands for Standard Query Language.
False
SQL is a database sublanguage used in querying, updating, and managing relational databases.
True
SQL is derived from an IBM research group that created Structured English Query Language (SEQUEL) in the 1980s.
False
Data Manipulation Language (DML) is a module of the SQL language which enables you to create and modify the database itself.
False
The DROP DATABASE statement is used to create a database.
False
The ALTER TABLE statement is used to delete a specified table in a database.
False
The SELECT clause is used to list the relations to be scanned in evaluation of an expression.
False
The WHERE clause consists of a predicate involving attributes of relations that appear in the FROM clause.
True
SQL is designed for technical users only.
False
Data Definition Language (DDL) is used to retrieve data from a database.
False
Data Control Language (DCL) is used to update data in a database.
False
The CREATE TABLE statement is used to delete a specified table in a database.
False
The FROM clause is used to list the attributes desired in the result of a query.
False
SQL is used in querying, updating, and managing relational databases.
True
The DROP DATABASE statement is used to create a database.
False
Structured English Query Language (SEQUEL) was created in the 1990s.
False
SQL can be used in formulating interactive queries or be embedded in an application as instructions for handling data.
True
ALTER TABLE statement allows for the creation of a new database.
False
Study Notes
Introduction to SQL
- SQL stands for Structured Query Language, a database sublanguage used in querying, updating, and managing relational databases.
- SQL was derived from IBM's research group that created Structured English Query Language (SEQUEL) in the 1970s.
- SQL can be used for both interactive queries and embedded in applications as instructions for handling data.
- SQL is designed for both technical and non-technical users.
Major Components of SQL
- Data Manipulation Language (DML) allows you to retrieve, update, add, or delete data in a database.
- Data Definition Language (DDL) enables you to create and modify the database itself.
- Data Control Language (DCL) maintains the proper security for the database.
Database Manipulation
- The CREATE DATABASE statement creates a database.
- The DROP DATABASE statement deletes a database.
Database Table Manipulation
- The CREATE TABLE statement creates a table within a database.
- The ALTER TABLE statement allows for the modification of specific attributes of a table, such as adding and deleting columns.
- The DROP TABLE statement deletes a specified table in a database.
Basic Data Retrieval
- The SELECT clause lists the attributes desired in the result of a query, allowing retrieval of data in SQL.
- The FROM clause lists the relations to be scanned in the evaluation of an expression.
- The WHERE clause consists of a predicate involving attributes of relations that appear in the FROM clause.
Introduction to SQL
- SQL stands for Structured Query Language, a database sublanguage used in querying, updating, and managing relational databases.
- SQL was derived from IBM's research group that created Structured English Query Language (SEQUEL) in the 1970s.
- SQL can be used for both interactive queries and embedded in applications as instructions for handling data.
- SQL is designed for both technical and non-technical users.
Major Components of SQL
- Data Manipulation Language (DML) allows you to retrieve, update, add, or delete data in a database.
- Data Definition Language (DDL) enables you to create and modify the database itself.
- Data Control Language (DCL) maintains the proper security for the database.
Database Manipulation
- The CREATE DATABASE statement creates a database.
- The DROP DATABASE statement deletes a database.
Database Table Manipulation
- The CREATE TABLE statement creates a table within a database.
- The ALTER TABLE statement allows for the modification of specific attributes of a table, such as adding and deleting columns.
- The DROP TABLE statement deletes a specified table in a database.
Basic Data Retrieval
- The SELECT clause lists the attributes desired in the result of a query, allowing retrieval of data in SQL.
- The FROM clause lists the relations to be scanned in the evaluation of an expression.
- The WHERE clause consists of a predicate involving attributes of relations that appear in the FROM clause.
Learn the basics of SQL, a database sublanguage used for querying, updating, and managing relational databases. Discover its history, uses, and design.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free