Introduction SQL(Ict-SQL)Q1

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

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.

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.

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 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 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

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

1 Mark(s)

form
table
report
file

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

1 Mark(s)

Oracle
DBase
Microsoft Access
SQL

SQL is:

1 Mark(s)

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

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 SQL keyword(s) ________ is used with wildcards.

1 Mark(s)

IN only
NOT IN only
IN and NOT IN
LIKE only

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.

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.

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

To sort the results of a query use:

1 Mark(s)

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

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

A subquery in an SQL SELECT statement is enclosed in:

1 Mark(s)

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

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.

ON UPDATE CASCADE ensures which of the following?

1 Mark(s)

Normalization
Data Integrity
Materialized Views
All of the above.

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

1 Mark(s)

HTML
DML
DDL
XML

@@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.

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

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;

The Microsoft Access wildcards are ____ and ____ .

1 Mark(s)

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

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 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 ...

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

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

1 Mark(s)

INSERT
CREATE
ADD
MAKE

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

1 Mark(s)

QUERY
SELECT
READ
None of the above is correct.

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

Career Academy