Q.1
Which of the following are the five built-in functions provided by SQL?
Q.2
SQL data definition commands make up a(n) ________ .
Q.3
Which of the following is valid SQL for an Index?
Q.4
SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.
Q.5
The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.
Q.6
To establish a range of values, < and > can be used.
Q.7
The keyword LIKE can be used in a WHERE clause to refer to a range of values.
Q.8
The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.
Q.9
If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators.
Q.10
The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.
Q.11
The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."
Q.12
Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.
Q.13
Indexes may be created or dropped at any time.
Q.14
The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.
Q.15
ORDER BY can be combined with the SELECT statements.
Q.16
Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.
Q.17
Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.
Q.18
The result of every SQL query is a table.
Q.19
COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.
Q.20
SUM, AVG, MIN, and MAX can only be used with numeric columns.
0 h : 0 m : 1 s