Introduction SQL(Ict-SQL)Q1

Which of the following is valid SQL for an Index?

1 Mark(s)

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

The SQL WHERE clause:

1 Mark(s)

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

Which of the following is the original purpose of SQL?

1 Mark(s)

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

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

1 Mark(s)

IN only
NOT IN only
IN and NOT IN
LIKE only

Find the SQL statement below that is equal to the following:

1 Mark(s)

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

The Microsoft Access wildcards are ____ and ____ .

1 Mark(s)

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

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

1 Mark(s)

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

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

1 Mark(s)

HTML
DML
DDL
XML

SQL can be used to:

1 Mark(s)

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

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

1 Mark(s)

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

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

1 Mark(s)

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

@@The HAVING clause does which of the following?

1 Mark(s)

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

A subquery in an SQL SELECT statement is enclosed in:

1 Mark(s)

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

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

1 Mark(s)

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

The command to eliminate a table from a database is:

1 Mark(s)

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

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

1 Mark(s)

Default values
Primary keys
All of the above.
Data types

The SQL keyword BETWEEN is used:

1 Mark(s)

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

The wildcard in a WHERE clause is useful when?

1 Mark(s)

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

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

1 Mark(s)

use FROM 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.
use USING 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 WHERE.

To sort the results of a query use:

1 Mark(s)

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

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

1 Mark(s)

SINGLE
ONLY
UNIQUE
DISTINCT

SQL is:

1 Mark(s)

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

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

1 Mark(s)

form
table
report
file

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

1 Mark(s)

QUERY
SELECT
READ
None of the above is correct.

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

1 Mark(s)

INSERT
CREATE
ADD
MAKE

The SQL -92 wildcards are ____ and ____ .

1 Mark(s)

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

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

1 Mark(s)

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

A subquery in an SQL SELECT statement:

1 Mark(s)

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

ON UPDATE CASCADE ensures which of the following?

1 Mark(s)

Normalization
Data Integrity
Materialized Views
All of the above.

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

1 Mark(s)

Oracle
DBase
Microsoft Access
SQL

Introduction SQL(Ict-SQL)Q1 : Question 1 of 30

Career Academy