Exam 7: Introduction to Structured Query Language Sql

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

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

All SQL commands must be issued on a single line.

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

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

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

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

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

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

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

words are words used by SQL to perform specific functions.

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

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

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

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.

The basic SQL vocabulary has fewer than words.

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

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

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