SQL Vocabulary

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

SMALLINT

A 16-bit integer (-32768 to 32767).

INTEGER or INT

A 32-bit integer (-2147483648 to 2147483647).

query

A SQL command which retrieves data based on specific criteria.

INSERT

A SQL statement used to add data to a database table.

CREATE TABLE

A SQL statement used to construct new tables in a relational database.

UPDATE

A SQL statement used to modify data in a database.

DELETE

A SQL statement used to remove data from a database.

SELECT

A SQL statement used to retrieve data from a database.

SQL Injection

A code injection technique, used to attack data driven applications, in which malicious SQL statements are inserted into an entry field for execution.

statement

A command issued to a relational database, which may have a persistent effect on schemata and data, or which may control transactions, program flow, connections, sessions, or diagnostics.

TIMESTAMP

A date and time combination stored as the number of seconds since the epoch (January 1, 1970).

TIME

A date and time combination.

DATE

A date.

DOUBLE

A normal-size (double-precision) floating-point number.

WHERE clause

A portion of a SQL statement used to filter records.

FLOAT

A small (single-precision) floating-point number.

SQL

A special-purpose programming language designed for managing data held in a relational database management system (RDBMS).

NUMERIC(precision

A type which stores exact numeric data values, such as for currency.

predicate

Component of a SQL command which specifies conditions that can be evaluated and which are used to limit the effects of statements and queries, or to change program flow.

expression

Component of a SQL statement which can produce either scalar values, or tables consisting of columns and rows of data.

clause

Constituent component of a statement or query.

CHARACTER(n) or CHAR(n)

Fixed-width n-character string, padded with spaces as needed.

CHARACTER VARYING(n) or VARCHAR(n)

Variable-width string with a maximum size of n characters.

BOOL or BOOLEAN

Zero or one (TRUE or FALSE)

BIT(n)

an array of n bits.


संबंधित स्टडी सेट्स

Chapter 19 Environmental Regulations: Hazardous Substances and Wastes

View Set

Chapter 3 | Beginning the Accounting Cycle

View Set

Linear Search Algorithm (Sequential Search)

View Set

Antihyperlipidemics and Peripheral Vasodilators Bile-Acid Sequestrant and Fibrate Therapy

View Set

Chapter 2 - Near East Empires and the Reemergence of Civilization in Greece 1000-500 B.C.E. - The Making of The West - HIST 1111

View Set

Data Analytics and Visualization Final

View Set

Which of the following statements are true of the quantity weight?

View Set