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 SQL command that modifies an attribute's values in one or more table's rows is _____.

A) INSERT
B) SELECT
C) COMMIT
D) UPDATE

Correct Answer

verified

Show Answer

Question 42

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

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

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

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

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

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

words are words used by SQL to perform specific functions.

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

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

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

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

All SQL commands must be issued on a single line.

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

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

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

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

The basic SQL vocabulary has fewer than words.

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

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