FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 7: Introduction to Structured Query Language (SQL)

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Multiple Choice

Review LaterAdd Note

Review Later

An example of a command you would use when making changes to a PRODUCT table is ____.

A) CHANGE PRODUCT
SET P_INDATE = '18-JAN-2004'
WHERE P_CODE = '13-Q2/P2';
B) ROLLBACK PRODUCT
SET P_INDATE = '18-JAN-2004'
WHERE P_CODE = '13-Q2/P2';
C) EDIT PRODUCT
SET P_INDATE = '18-JAN-2004'
WHERE P_CODE = '13-Q2/P2';
D) UPDATE PRODUCT
SET P_INDATE = '18-JAN-2004'
WHERE P_CODE = '13-Q2/P2';

Correct Answer

verified

Show Answer

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

The most recent fully approved version of standard SQL prescribed by the ANSI is ____.

A) SQL-99
B) SQL-2003
C) SQL-4
D) SQL-07

Correct Answer

verified

Show Answer

Question 53

Short Answer

Review LaterAdd Note

If you add a new column to a table that already has rows,the existing rows will default to a value of ____________________ for the new column.

All SQL commands must be issued on a single line.

In a 1:M relationship,you must always create the table for the ____________________ side first.

String comparisons are made from left to right.

The SQL aggregate function that gives the average for the specific column is ____.

What is a view? What is the command used to create a view?

What is a schema? How many schemas can be used in one database?

The SQL command that modifies an attribute's values in one or more table's rows is ____.

Since computers identify all characters by their numeric codes,mathematical operators cannot be used to place restrictions on character-based attributes.

A(n)____________________ is performed when data is retrieved from more than one table at a time.

In an INSERT command,you can indicate just the attributes that have required values by listing the ____________________ inside parentheses after the table name.

The CHECK constraint is used to define a condition for the values that the attribute domain cannot have.

UPDATE tablename ***** [WHERE conditionlist]; The ____ command replaces the ***** in the syntax of the UPDATE command,shown above.

The ____ special operator is used to check whether an attribute value is null.

When you issue the DELETE FROM tablename command without specifying a WHERE condition,____.

A database language enables the user to perform complex queries designed to transform the raw data into useful information.

A(n)____________________ order sequence is a multilevel ordered sequence that can be created easily by listing several attributes,separated by commas,after the ORDER BY clause.

The special operator used to check whether a subquery returns any rows is ____.