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 41

Multiple Choice

Review LaterAdd Note

Review Later

The special operator used to check whether an attribute value matches a given string pattern is .

A) BETWEEN
B) IS NULL
C) LIKE
D) IN

E) B) and C)
F) None of the above

Correct Answer

verified

Show Answer

Question 42

Short Answer

Review LaterAdd Note

Review Later

words are words used by SQL to perform specific functions.

Correct Answer

verified

Show Answer

Question 43

Short Answer

Review LaterAdd Note

Rows can be grouped into smaller collections quickly and easily using the clause within the SELECT statement.

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

The condition is generally composed of an equality comparison between the foreign key and the primary key of related tables.

SQL requires the use of the ADD command to enter data into a table.

The constraint assigns a value to an attribute when a new row is added to a table.

The current fully approved version of standard SQL prescribed by the ANSI is .

You cannot insert a row containing a null attribute value using SQL.

To list the contents of a table, you must use the DISPLAY command.

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

A specialty field in mathematics, known as algebra, is dedicated to the use of logical operators.

How can a table be deleted from the database? Provide an example.

All SQL commands must be issued on a single line.

In the SQL environment, the word covers both questions and actions.

The basic SQL vocabulary has fewer than words.

A(n) is a logical group of database objects, such as tables and indexes, that are related to each other.

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

You can select partial table contents by naming the desired fields and by placing restrictions on the rows to be included in the output.

When a user issues the DELETE FROM tablename command without specifying a WHERE condition, .