Introduction to SQL - Database MCQ Questions and answers- Technical Aptitude

Option B: False
The keyword LIKE in SQL is used in a WHERE clause to search for a specified pattern in a column. It is typically used with wildcard characters (% for zero or more characters and _ for a single character) to match patterns rather than ranges of values.

Conclusion:
The statement "The keyword LIKE can be used in a WHERE clause to refer to a range of values" is Option B: False. Hence, the correct answer is False.

The SQL statement SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of rows in the NAME_TABLE and displays this total alongside each unique Name in separate rows. The COUNT(*) function counts all rows returned by the query.

Conclusion:
The statement "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" is Option A: True. Hence, the correct answer is True.

The SQL keyword GROUP BY instructs the database management system (DBMS) to group rows that have the same value in specified columns into summary rows. It is used in conjunction with aggregate functions like SUM, COUNT, AVG, etc., to group the result-set by one or more columns.

Conclusion:
The statement "The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column" is Option A: True. Hence, the correct answer is True.

The wildcard asterisk (*) in SQL-92 is indeed the standard symbol used to represent "any sequence of characters" when used with the LIKE operator in SQL queries. It matches any string of zero or more characters, making it a powerful tool for pattern matching in SQL statements.

Conclusion:
The statement "The wildcard asterisk (*) is the SQL-92 standard for indicating 'any sequence of characters'" is Option A: True. Hence, the correct answer is True.

Option A: True
Microsoft Access has indeed become widely used, especially in environments where desktop databases are needed. Being proficient in programming with Microsoft Access can be considered a critical skill in various industries and organizations that use it extensively for managing databases and creating applications.

Conclusion:
The statement "Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill" is Option A: True. Hence, the correct answer is True.

SQL does indeed provide five built-in functions for aggregate operations:
COUNT: Counts the number of rows or non-null values in a column.
SUM: Calculates the sum of numeric values in a column.
AVG: Computes the average of numeric values in a column.
MAX: Retrieves the maximum value from a column.
MIN: Retrieves the minimum value from a column.
These functions are fundamental for data analysis and reporting tasks within SQL queries.
Conclusion:
The statement "SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN" is Option A: True. Hence, the correct answer is True.

The keyword BETWEEN in SQL is used in a WHERE clause to specify a range of values. It allows you to select rows based on a range defined by two values, inclusive of both endpoints. The syntax typically looks like this:

SELECT column_name
FROM table_name
WHERE column_name BETWEEN value1 AND value2;

This query will retrieve rows where column_name falls within the range defined by value1 and value2, inclusive.

Conclusion:
The statement "The keyword BETWEEN can be used in a WHERE clause to refer to a range of values" is Option A: True. Hence, the correct answer is True.

In SQL, the symbols < (less than) and > (greater than) are used to establish ranges of values in a WHERE clause. They allow you to specify conditions that include values less than or greater than a specified limit.

For example:
To find rows where a column value is greater than 10:

SELECT *
FROM table_name
WHERE column_name > 10;

To find rows where a column value is less than or equal to 100:

SELECT *
    FROM table_name
    WHERE column_name <= 100;

These symbols are essential for creating conditions that define ranges of values based on specific criteria.

Conclusion:
The statement "To establish a range of values, < and > can be used" is Option A: True. Hence, the correct answer is True.

In SQL, the NOT and NOT IN operators are used to negate conditions or exclude specific values from a result set, but they do not inherently simplify the use of complex combinations of AND and OR conditions.

When dealing with complex conditions involving three or more AND and OR operators, using proper grouping with parentheses and logical operators (AND, OR) is typically the standard approach. The NOT operator is used to negate a condition, while NOT IN is used to exclude specific values from a query result.

For example:
Using NOT to negate a condition:

SELECT *
FROM table_name
WHERE NOT column_name = 'value';

Using NOT IN to exclude specific values:

SELECT *
    FROM table_name
    WHERE column_name NOT IN ('value1', 'value2');

However, neither NOT nor NOT IN operators directly replace the need for properly structuring complex conditions with AND and OR.

Conclusion:
The statement "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" is Option B: False. Hence, the correct answer is False.