SQL - Computer Questions and Answers

Attempt Mode

Computer » SQL

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

A

ADD

B

CREATE

C

INSERT

D

MAKE

Computer » SQL

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

A

REMOVE FROM CUSTOMER ...

B

DROP FROM CUSTOMER ...

C

DELETE FROM CUSTOMER WHERE ...

D

UPDATE FROM CUSTOMER ...

Computer » SQL

The SQL WHERE clause:

A

limits the column data that are returned.

B

limits the row data are returned.

C

Both A and B are correct.

D

Neither A nor B are correct.

Computer » SQL

Which of the following is the original purpose of SQL?

A

To specify the syntax and semantics of SQL data definition language

B

To specify the syntax and semantics of SQL manipulation language

C

To define the data structures

D

All of the above.

Computer » SQL

The wildcard in a WHERE clause is useful when?

A

An exact match is necessary in a SELECT statement.

B

An exact match is not possible in a SELECT statement.

C

An exact match is necessary in a CREATE statement.

D

An exact match is not possible in a CREATE statement.

Computer » SQL

A view is which of the following?

A

A virtual table that can be accessed via SQL commands

B

A virtual table that cannot be accessed via SQL commands

C

A base table that can be accessed via SQL commands

D

A base table that cannot be accessed via SQL commands

Computer » SQL

The command to eliminate a table from a database is:

A

REMOVE TABLE CUSTOMER;

B

DROP TABLE CUSTOMER;

C

DELETE TABLE CUSTOMER;

D

UPDATE TABLE CUSTOMER;

Computer » SQL

ON UPDATE CASCADE ensures which of the following?

A

Normalization

B

Data Integrity

C

Materialized Views

D

All of the above.

Computer » SQL

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

A

DDL

B

DML

C

HTML

D

XML

Computer » SQL

Which of the following is valid SQL for an Index?

A

CREATE INDEX ID;

B

CHANGE INDEX ID;

C

ADD INDEX ID;

D

REMOVE INDEX ID;

Computer » SQL

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

A

LIKE only

B

IN only

C

NOT IN only

D

IN and NOT IN

Computer » SQL

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

A

SELECT, FROM, WHERE

B

FROM, WHERE, SELECT

C

WHERE, FROM,SELECT

D

SELECT,WHERE,FROM

Computer » SQL

A subquery in an SQL SELECT statement is enclosed in:

A

braces -- {...}.

B

CAPITAL LETTERS.

C

parenthesis -- (...) .

D

brackets -- [...].

Computer » SQL

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

A

report

B

form

C

file

D

table

Computer » SQL

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

A

COUNT, SUM, AVG, MAX, MIN

B

SUM, AVG, MIN, MAX, MULT

C

SUM, AVG, MULT, DIV, MIN

D

SUM, AVG, MIN, MAX, NAME

Computer » SQL

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

A

all columns of the table are to be returned.

B

all records meeting the full criteria are to be returned.

C

all records with even partial criteria met are to be returned.

D

None of the above is correct.

Computer » SQL

The HAVING clause does which of the following?

A

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

B

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

C

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

D

Acts EXACTLY like a WHERE clause.

Computer » SQL

The SQL -92 wildcards are ____ and ____ .

A

asterisk (*); percent sign (%)

B

percent sign (%); underscore (_)

C

underscore(_); question mark (?)

D

question mark (?); asterisk (*)

Computer » SQL

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

A

ONLY

B

UNIQUE

C

DISTINCT

D

SINGLE

Computer » SQL

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

A

Reduced training costs

B

Increased dependence on a single vendor

C

Applications are not needed.

D

All of the above.