Logo

Go on. Explore!

lvl 0 • 0 xp

lvl 1

HomeMarketDecksInterests
SQL

SQL

memorize.aimemorize.ai (lvl 286)
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%
(0)
(0)
(0)
19 cards
()
Section 1

Preview this deck

RDBMS

Front

1 / 19

SQL
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Active users

0

All-time users

0

Favorites

0

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (19)

Section 1

(19 cards)

RDBMS

Front

Relational Database Management System.

Back

What does the "ALTER TABLE" Command do?

Front

modifies a table

Back

What does the "DELETE" Command do?

Front

deletes data from a database

Back

SQL Statements

Front

Aren't Case Sensitive,

Back

What is a SQL Column?

Front

A column is a vertical entity in a table that contains all information associated with a specific field in a table.

Back

What does the "DROP TABLE" Command do?

Front

deletes a table

Back

What does the "CREATE DATABASE" Command do?

Front

creates a new database

Back

SQL

Front

Structured Query Language

Back

What does the "UPDATE" Command do?

Front

updates data in a database

Back

What is a SQL Table?

Front

A table is a collection of related data entries and it consists of columns and rows.

Back

What does the "DROP INDEX" Command do?

Front

deletes an index

Back

What is a SQL Field?

Front

A field is a column in a table that is designed to maintain specific information about every record in the table.

Back

What does the "SELECT" Command do?

Front

extracts data from a database

Back

Major SQL Commands?

Front

SELECT, UPDATE, DELETE, INSERT, WHERE

Back

What does the "CREATE INDEX" Command do?

Front

creates an index (search key)

Back

What is a record / row?

Front

A row is each individual entry that exists in a table. For example, there are 91 records in the above Customers table. A record is a horizontal entity in a table.

Back

What does the "ALTER DATABASE" Command do?

Front

modifies a database

Back

What does the "CREATE TABLE" Command do?

Front

creates a new table

Back

What does the "INSERT INTO" Command do?

Front

inserts new data into a database

Back