Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

SQL

memorize.ai (lvl 286)

(0)

24 cards

()

Section 1

Preview this deck

DROP INDEX

Front

1 / 24

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (24)

Section 1

(24 cards)

DROP INDEX

Front

deletes an index

Back

Fields

Front

Every table is broken up into smaller entities called _. A is a column in a table that is designed to maintain specific information about every record in the table. The _s in the Customers table consist of CustomerID, CustomerName, ContactName, Address, City, PostalCode and Country.

Back

IN

Front

To specify multiple possible values for a column

Back

SELECT

Front

extracts data from a database

Back

Table

Front

The data in RDBMS is stored in these database objects. A _____ is a collection of related data entries and it consists of columns and rows.

Back

BETWEEN

Front

Between a certain range

Back

DROP TABLE

Front

deletes a table

Back

LIKE

Front

Search for a pattern

Back

UPDATE

Front

updates data in a database

Back

Are SQL queries case sensitive?

Front

SQL keywords are NOT case sensitive: select is the same as SELECT

Back

<>

Front

Not equal. Note: In some versions of SQL this operator may be written as !=

Back

CREATE INDEX

Front

creates an index (search key)

Back

Record

Front

Also called a row, is each individual entry that exists in a table. A ______ is a horizontal entity in a table.

Back

CREATE DATABASE

Front

creates a new database

Back

ALTER TABLE

Front

modifies a table

Back

ALTER DATABASE

Front

modifies a database

Back

result-set

Front

The data that's retrieved by a Select statement is called a

Back

CREATE TABLE

Front

creates a new table

Back

varchar

Front

Can hold n values or less

Back

RDBMS

Front

(Relational Database Management System) A software application that contains tools to manage data, answer queries, create user-friendly forms for data entry, and generate printed reports. It is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.

Back

DELETE

Front

deletes data from a database

Back

Column

Front

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

Back

INSERT INTO

Front

inserts new data into a database

Back

WHERE clause

Front

The ______ clause is used to extract only those records that fulfill a specified criterion.

Back

SQL

Preview this deck

DROP INDEX

0.0

Cards (24)

DROP INDEX

deletes an index

Fields

Every table is broken up into smaller entities called _____. A ____ is a column in a table that is designed to maintain specific information about every record in the table. The _____s in the Customers table consist of CustomerID, CustomerName, ContactName, Address, City, PostalCode and Country.

IN

To specify multiple possible values for a column

SELECT

extracts data from a database

Table

The data in RDBMS is stored in these database objects. A _____ is a collection of related data entries and it consists of columns and rows.

BETWEEN

Between a certain range

DROP TABLE

deletes a table

LIKE

Search for a pattern

UPDATE

updates data in a database

Are SQL queries case sensitive?

SQL keywords are NOT case sensitive: select is the same as SELECT

<>

Not equal. Note: In some versions of SQL this operator may be written as !=

CREATE INDEX

creates an index (search key)

Record

Also called a row, is each individual entry that exists in a table. A ______ is a horizontal entity in a table.

CREATE DATABASE

creates a new database

ALTER TABLE

modifies a table

ALTER DATABASE

modifies a database

result-set

The data that's retrieved by a Select statement is called a

CREATE TABLE

creates a new table

varchar

Can hold n values or less

RDBMS

DELETE

deletes data from a database

Column

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

INSERT INTO

inserts new data into a database

WHERE clause

The ______ clause is used to extract only those records that fulfill a specified criterion.

Every table is broken up into smaller entities called _. A is a column in a table that is designed to maintain specific information about every record in the table. The _s in the Customers table consist of CustomerID, CustomerName, ContactName, Address, City, PostalCode and Country.