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

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

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

A) BETWEEN
B) EXISTS
C) LIKE
D) IN

Correct Answer

verified

Show Answer

Question 53

True/False

Review LaterAdd Note

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

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

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

String comparisons are made from left to right.

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.

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

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

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

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

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

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

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

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.

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

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.

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

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