This is one of the most popular and widely used languages for retrieving and manipulating database data.
What is Structured Query Language (SQL)?
100
This is a question represented in a way that the DBMS can understand.
What is query?
100
This is the column on which you want the database to sort data.
What is sort key or a key?
100
SUM and AVG can only be used with these type of columns containing numeric values.
What are numeric columns?
200
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?
200
In SQL, this command is used to query a database.
What is SELECT?
200
If you do not specify a sort order, the default is this.
What is ascending?
200
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?
300
This SQL command is used to describe the layout of a table.
What is CREATE TABLE?
300
These conditions are formed by connecting two or more simple conditions.
What are Compound conditions?
300
To sort records in descending order, use this operator following the name of the sort key.
What is DESC?
300
To determine how many parts are in item class SG, use the this function.
What is COUNT?
400
Table and column names cannot exceed this number of characters.
What is 30?
400
This operator lets you specify a range of values in a condition
What is BETWEEN?
400
The major sort key immediately follows these words.
What is ORDER BY?
400
To determine the total of all customer balances, use this function.
What is SUM?
500
This command also deletes any data that may have been inserted into a table.
What is the DROP TABLE command?
500
You can assign a name to a computed column by following the computation with this word and the desired name.
What is AS?
500
In the phrase "city within state", the major sort key is this.
What is state?
500
To calculate the smallest value in a column, use the this function.