Introduction to SQL Test(1st)

Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.

1 Mark(s)

False
True

Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';

1 Mark(s)

SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
SELECT NAME IN CUSTOMER WHERE STATE = 'V';
SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');

A view is which of the following?

1 Mark(s)

A base table that cannot be accessed via SQL commands
A base table that can be accessed via SQL commands
A virtual table that cannot be accessed via SQL commands
A virtual table that can be accessed via SQL commands

The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.

1 Mark(s)

False
True

SUM, AVG, MIN, and MAX can only be used with numeric columns.

1 Mark(s)

True
False

Indexes can usually be created for both primary and secondary keys.

1 Mark(s)

False
True

The command to eliminate a table from a database is:

1 Mark(s)

REMOVE TABLE CUSTOMER;
DELETE TABLE CUSTOMER;
UPDATE TABLE CUSTOMER;
DROP TABLE CUSTOMER;

ORDER BY can be combined with the SELECT statements.

1 Mark(s)

False
True

SQL is a programming language.

1 Mark(s)

True
False

Indexes may be created or dropped at any time.

1 Mark(s)

True
False

The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.

1 Mark(s)

False
True

In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:

1 Mark(s)

all records with even partial criteria met are to be returned.
all records meeting the full criteria are to be returned.
all columns of the table are to be returned.
None of the above is correct.

SQL is a data sublanguage.

1 Mark(s)

False
True

To establish a range of values, < and > can be used.

1 Mark(s)

True
False

The SQL WHERE clause:

1 Mark(s)

Neither A nor B are correct.
Both A and B are correct.
limits the column data that are returned.
limits the row data are returned.

The HAVING clause does which of the following?

1 Mark(s)

Acts like a WHERE clause but is used for rows rather than columns.
Acts like a WHERE clause but is used for columns rather than groups.
Acts like a WHERE clause but is used for groups rather than rows.
Acts EXACTLY like a WHERE clause.

To sort the results of a query use:

1 Mark(s)

GROUP BY.
SORT BY.
ORDER BY.
None of the above is correct.

Which one of the following sorts rows in SQL?

1 Mark(s)

ALIGN BY
SORT BY
GROUP BY
ORDER BY

The SQL keyword BETWEEN is used:

1 Mark(s)

None of the above is correct.
to limit the columns displayed.
for ranges.
as a wildcard.

Which of the following do you need to consider when you make a table in SQL?

1 Mark(s)

Data types
Default values
All of the above
Primary keys

A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.

1 Mark(s)

True
False

There is an equivalent join expression that can be substituted for all subquery expressions.

1 Mark(s)

False
True

The ADD command is used to enter one row of data or to add multiple rows as a result of a query.

1 Mark(s)

True
False

The benefits of a standard relational language include which of the following?

1 Mark(s)

Increased dependence on a single vendor
Applications are not needed
Reduced training costs
All of the above

The wildcard in a WHERE clause is useful when?

1 Mark(s)

An exact match is not possible in a SELECT statement.
An exact match is not possible in a CREATE statement.
An exact match is necessary in a SELECT statement.
An exact match is necessary in a CREATE statement.

ON UPDATE CASCADE ensures which of the following?

1 Mark(s)

All of the above
Data Integrity
Normalization
Materialized Views

SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.

1 Mark(s)

False
True

A dynamic view is one whose contents materialize when referenced.

1 Mark(s)

True
False

The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.

1 Mark(s)

False
True

You can add a row using SQL in a database with which of the following?

1 Mark(s)

CREATE
INSERT
MAKE
ADD

Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

1 Mark(s)

True
False

To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.

1 Mark(s)

ONLY
DISTINCT
SINGLE
UNIQUE

To define what columns should be displayed in an SQL SELECT statement:

1 Mark(s)

use USING to name the source table(s) and list the columns to be shown after WHERE.
use FROM to name the source table(s) and list the columns to be shown after SELECT.
use USING to name the source table(s) and list the columns to be shown after SELECT.
use SELECT to name the source table(s) and list the columns to be shown after USING.

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.

1 Mark(s)

True
False

The command to remove rows from a table 'CUSTOMER' is:

1 Mark(s)

UPDATE FROM CUSTOMER ...
DROP FROM CUSTOMER ...
REMOVE FROM CUSTOMER ...
DELETE FROM CUSTOMER WHERE ...

SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.

1 Mark(s)

False
True

A subquery in an SQL SELECT statement:

1 Mark(s)

can always be duplicated by a join.
can only be used with two tables.
has a distinct form that cannot be duplicated by a join.
cannot have its results sorted using ORDER BY.

The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."

1 Mark(s)

False
True

Which of the following are the five built-in functions provided by SQL?

1 Mark(s)

COUNT, SUM, AVG, MAX, MIN
SUM, AVG, MIN, MAX, NAME
SUM, AVG, MULT, DIV, MIN
SUM, AVG, MIN, MAX, MULT

SQL data definition commands make up a(n) ________ .

1 Mark(s)

HTML
DML
DDL
XML

SQL query and modification commands make up a(n) ________ .

1 Mark(s)

DDL
DML
HTML
XML

A subquery in an SQL SELECT statement is enclosed in:

1 Mark(s)

parenthesis -- (...) .
CAPITAL LETTERS.
brackets -- [...].
braces -- {...}.

DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.

1 Mark(s)

True
False

Which of the following is the original purpose of SQL?

1 Mark(s)

All of the above
To specify the syntax and semantics of SQL manipulation language
To define the data structures
To specify the syntax and semantics of SQL data definition language

SQL can be used to:

1 Mark(s)

All of the above can be done by SQL.
modify database data only.
query database data only.
create database structures only.

The SQL statement that queries or reads data from a table is ________ .

1 Mark(s)

QUERY
None of the above is correct
READ
SELECT

The SQL -92 wildcards are ____ and ____ .

1 Mark(s)

asterisk (*); percent sign (%)
question mark (?); asterisk (*)
underscore(_); question mark (?)
percent sign (%); underscore (_)

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.

1 Mark(s)

True
False

SQL is:

1 Mark(s)

an operating system.
a programming language.
a DBMS.
a data sublanguage.

The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.

1 Mark(s)

False
True

Which of the following is the correct order of keywords for SQL SELECT statements?

1 Mark(s)

SELECT, FROM, WHERE
WHERE, FROM,SELECT
SELECT,WHERE,FROM
FROM, WHERE, SELECT

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.

1 Mark(s)

True
False

The result of every SQL query is a table.

1 Mark(s)

False
True

Which of the following is valid SQL for an Index?

1 Mark(s)

CHANGE INDEX ID;
ADD INDEX ID;
REMOVE INDEX ID;
CREATE INDEX ID;

Most companies keep at least two versions of any database they are using.

1 Mark(s)

False
True

Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.

1 Mark(s)

False
True

The keyword LIKE can be used in a WHERE clause to refer to a range of values.

1 Mark(s)

False
True

The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.

1 Mark(s)

False
True

COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.

1 Mark(s)

False
True

________ was adopted as a national standard by ANSI in 1992.

1 Mark(s)

Oracle
Microsoft Access
SQL
DBase

The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.

1 Mark(s)

True
False

The result of a SQL SELECT statement is a(n) ________ .

1 Mark(s)

table
file
report
form

The condition in a WHERE clause can refer to only one value.

1 Mark(s)

True
False

Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.

1 Mark(s)

False
True

The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.

1 Mark(s)

False
True

When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

1 Mark(s)

LIKE only.
Both IN and NOT IN.
NOT IN only.
IN only.

SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.

1 Mark(s)

True
False

The Microsoft Access wildcards are ____ and ____ .

1 Mark(s)

question mark (?); asterisk (*)
asterisk (*); percent sign (%)
percent sign (%); underscore (_)
underscore(_); question mark (?)

The SQL keyword(s) ________ is used with wildcards.

1 Mark(s)

NOT IN only
IN only
LIKE only
IN and NOT IN

Introduction to SQL Test(1st) : Question 1 of 69