All Terms Flashcards
What are the ‘3 V’s”?
Three basic characteristics of Big Data databases: volume, velocity, and variety.
What is abstract data type(ADT)?
Data type that describes a set of similar objects with shared and encapsulated data
representation and methods. An abstract data type is generally used to describe complex
objects. See also class.
What is an ad-hoc query?
A “spur-of-the-moment” question.
What is an alias?
An alternative name for a column or table in a SQL statement.
What is alter table?
Alter table is the SQL command used to make changes to table structure. When the command is followed by
a keyword (ADD or MODIFY), it adds a column or changes column characteristics.
What is the American National Standards Institute (ANSI)?
The group that accepted the DBTG recommendations and augmented database standards in
1975 through its SPARC committee.
What is an analytical database?
A database focused primarily on storing historical data and business metrics used for tactical or
strategic decision making.
What is AND?
The SQL logical operator used to link multiple conditional expressions in a WHERE or HAVING
clause. It requires that all conditional expressions evaluate to true.
What is the application programming interface (API)?
Software through which programmers interact with middleware. An API allows the use of
generic SQL code, thereby allowing client processes to be database server-independent.
What is a query?
A query is a command for a database that typically inserts new data, retrieves data, updates data, or deletes data from a database.
What is query language?
A query language is a computer programming language for writing database queries.
What is meant by ‘CRUD’ operations?
The four common queries are sometimes referred to as CRUD operations, an acronym for Create, Read, Update, and Delete data.
What is the standard query language for relational databases?
Structured Query Language (SQL)
What is a statement in SQL?
An SQL statement is a database command, such as a query that inserts, retrieves, updates, or deletes data:
What are four of the SQL statements?
INSERT inserts rows into a table.
SELECT retrieves data from a table.
UPDATE modifies data in a table.
DELETE deletes rows from a table.
