FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Structured Query Language

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

Given the table STUDENT(StudentID,Name,Advisor) ,which of the following SQL statements would be used to change the value of the Advisor field to 'Smith' for all rows in the STUDENT table?

A) UPDATE STUDENT SET Advisor = 'Smith';
B) MODIFY STUDENT SET Advisor = 'Smith';
C) MODIFY Advisor SET STUDENT = 'Smith';
D) UPDATE Advisor = 'Smith';
E) SET STUDENT Advisor = 'Smith';

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

Which of the following is the correct SQL clause to sort the results of a SELECT query in reverse-alphabetic order using the Department field?

A) SORT BY Department
B) REVERSE Department
C) ORDER BY Department DESC
D) SORT BY Department DESC
E) SORT BY Department REVERSE

Correct Answer

verified

Show Answer

Question 23

Short Answer

Review LaterAdd Note

SQL was developed by ________ in the late 1970s.

Using SQL commands,multiple tables can be queried using either subqueries or ________.

Using SQL commands,multiple tables can be queried so that all the values from one table appear in the results,regardless of whether they have one or more corresponding values in the other table,by using the SQL ________ command.

The TOP built-in function in SQL is used to find the maximum value in a numeric column.

Using standard SQL,unmatched rows will not appear in the result of a join.

In SQL,to refer to a range of values in a WHERE clause,use the WITHIN keyword.

Referential integrity constraints can be created using the ON DELETE phrase when the table is created using the CREATE TABLE statement.

Existing tables in a database can be structurally modified by using the SQL ________ command.

The ON DELETE CASCADE referential integrity constraint does not apply when rows are deleted using the SQL DELETE command.

Discuss SQL data types.

In Microsoft Access,tables are added to a QBE Query window by selecting the tables from the ________ dialog box.

Which SQL keyword can be used in conjunction with wildcards to select partial values?

Given the table CUSTOMER(CustID,Name,PhoneNum,AcctBalance) What is the standard SQL query phrase to retrieve data for customers with an account balance greater than 50?

If you need to create a primary key that is a composite key using SQL,the key may be defined when the table is created using the CREATE TABLE statement.

The order of the columns returned by an SQL SELECT statement is determined by the:

In SQL,the NOT keyword can be combined with the IN keyword to form the NOT IN condition for selecting values.

Built-in SQL functions cannot be applied to data combined using the GROUP BY keyword.

A composite primary key can be defined using the CONSTRAINT phrase in which SQL command?