question

Most SQL implementations yield case-insensitive searches

answer

false

question

Although SQL commands can be grouped together on a single line, complex command sequences are best shown on separate lines, with space between the SQL command and the command's components.

answer

true

question

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

answer

like

question

SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT.

answer

true

question

The command is used with the ALTER TABLE command to modify the table by deleting a column.

answer

drop

question

In Oracle, the command is used to change the display for a column, for example, to place a $ in front of a numeric value.

answer

format

question

The COUNT function is designed to tally the number of non-null "values" of an attribute, and is often used in conjunction with the DISTINCT clause.

answer

true

question

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

answer

false

question

The COMMIT command does not permanently save all changes. In order to do that, you must use SAVE.

answer

false

question

String comparisons are made from left to right

answer

true

question

The conditional LIKE must be used in conjunction with wildcard characters.

answer

true

question

Mathematical operators cannot be used to place restrictions on character-based attributes.

answer

false

question

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

answer

false

question

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

answer

false

question

Data type selection is usually dictated by the nature of the data and by the intended use.

answer

true

question

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

answer

true

question

A table can be deleted from the database by using the command.

answer

drop

question

The SQL command that allows a user to list the contents of a table is .

answer

select

question

A(n) is an alternate name given to a column or table in any SQL statement.

answer

alias

question

SQL is considered difficult to learn; its command set has a vocabulary of more than 300 words.

answer

false

question

Any changes made to the contents of a table are not physically saved on disk until you use the SAVE command.

answer

false

question

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

answer

update

question

Only numeric data types can be added and subtracted in SQL.

answer

false

question

Date procedures are often more software-specific than other SQL procedures.

answer

true

question

All SQL commands must be issued on a single line.

answer

false

question

The command would be used to delete the table row where the P_CODE is 'BRT-345'.

answer

DELETE FROM PRODUCT WHERE P_CODE = 'BRT-345';

question

The SQL command that allows a user to insert rows into a table is .

answer

insert

question

A database language enables the user to create database and table structures to perform basic data management chores.

answer

true

question

The special operator used to check whether an attribute value is within a range of values is .

answer

between

question

The SQL command that allows a user to permanently save data changes is .

answer

commit

question

To list all the contents of the PRODUCT table, a user would use .

answer

wildcard

question

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

answer

update

Get an explanation on any task

Get unstuck with the help of our AI assistant in seconds

New

Database ch 7 – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards