simple programming language used for accessing and managing data in relational databases.
What is Structured Query Language (SQL)?
10
This is the SQL command used to add rows to a table.
What is INSERT?
10
This is a question represented in a way that the DBMS can understand.
What is query?
10
This is the column on which you want the database to sort data.
What is sort key or a key?
10
SUM and AVG can only be used with these type of columns containing numeric values.
What are numeric columns?
20
This indicates the type of data that the column can contain (for example, characters, numbers, or dates) as well as the maximum number of characters or digits that the column can store.
What is data type?
20
This clause in a CREATE TABLE command specifies columns that cannot contain empty values.
What is NOT NULL?
20
In SQL, this command is used to query a database.
What is SELECT?
20
If you do not specify a sort order, the default is this.
What is ascending?
20
SQL includes these special functions to calculate sums, averages, counts, maximum values, and minimum values. (These functions apply to groups of rows.)
What are aggregate functions?
30
This SQL command is used to describe the layout of a table.
What is CREATE TABLE?
30
You can use the values in columns of this data type for calculations.
What is SMALLINT or INT?
30
These conditions are formed by connecting two or more simple conditions.
What are Compound conditions?
30
To sort records in descending order, use this operator following the name of the sort key.
What is DESC?
30
To determine how many parts are in item class SG, use the this function.
What is COUNT?
40
Table and column names cannot exceed this number of characters.
What is 30?
40
This data type are numbers without the decimal part.
What are integers?
40
This operator lets you specify a range of values in a condition
What is BETWEEN?
40
The major sort key immediately follows these words.
What is ORDER BY?
40
To determine the total of all customer balances, use this function.
What is SUM?
50
This command also deletes any data that may have been inserted into a table.
What is the DROP TABLE command?
50
This data type stores only the actual character string, not the spaces between the characters.
What is VARCHAR?
50
You can assign a name to a computed column by following the computation with this word and the desired name.
What is AS?
50
In the phrase "city within state", the major sort key is this.
What is state?
50
To calculate the smallest value in a column, use the this function.