Class Participation Questions

Question 1

To display data retrieved using an SQL SELECT in ascending order, use the option:

Answer 1

ORDER BY

Question 2

The SQL option HAVING can only be used with the option:

Answer 2

GROUP BY

Question 3

Which of the following is NOT one of the standard parts of an SQL trigger?

Answer 3

condition

Question 4

In SQL, when creating a view, columns of the original table can be:

Answer 4

Renamed and reordered

Question 5

The SQL command to create a table is ____

Answer 5

CREATE TABLE

Question 6

To have Oracle diplay the structure of a table named Employee, write:

Answer 6

DESCRIBE Employee;

Question 7

In the relational model, a view can be used

Answer 7

in the INTO line in an SQL INSERT command,
as the basis of a derived view,
in the FROM line of an SQL query

Question 8

The problem caused by the difference between the set-oriented SQL SELECT statement and the host language record-at-time capabilities is referred to as

Answer 8

An impedance mismatch

Question 9

The SQL command to advance the cursor and obtain the next row or results is

Answer 9

FETCH

Question 10

The SQL ALTER TABLE command can be used to do all of the following except

Answer 10

drop the table….It can add new columns, drop columns, and add constraints

Question 11

Given an Employee table with columns for salary and dept, to raise the salaries of all employees in the sales
department by 10%, we could write

Answer 11

Update Employee SET salary = salary * 1.10 WHERE dept = ‘sales’;

Question 12

To erase all records in the Employee table, while keeping the structure of the table, we could write the SQL
command

Answer 12

DELETE FROM Employee;

Question 13

All of the following are SQL DDL commands except

Answer 13

ADD TABLE

Question 14

The specification in the SQL CREATE TABLE command that enforces referential integrity is the

Answer 14

FOREIGN KEY

Question 15

Languages such as JScript that can be used to embed code in HTML are called

Answer 15

Scripting languages

Question 16

ODBC works on the ____ operating system.

Answer 16

Windows, Linux, mainframe, and UNIX

Question 17

XML Schema is used to define the structure and contents of documents T/F

Answer 17

True

Question 18

The basic SQL aggregate function that gives the total of all values for a selected attribute in a given column is ____

Answer 18

SUM

Question 19

The most common type of subquery uses an inner SELECT subquery on the right side of a ____ comparison expression

Answer 19

WHERE