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
Unlock the answer
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
Unlock the answer
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
Unlock the answer
question
You cannot insert a row containing a null attribute value using SQL.
answer
false
Unlock the answer
question
The COMMIT command does not permanently save all changes. In order to do that, you must use SAVE.
answer
false
Unlock the answer
question
String comparisons are made from left to right
answer
true
Unlock the answer
question
The conditional LIKE must be used in conjunction with wildcard characters.
answer
true
Unlock the answer
question
Mathematical operators cannot be used to place restrictions on character-based attributes.
answer
false
Unlock the answer
question
SQL requires the use of the ADD command to enter data into a table.
answer
false
Unlock the answer
question
To list the contents of a table, you must use the DISPLAY command.
answer
false
Unlock the answer
question
Data type selection is usually dictated by the nature of the data and by the intended use.
answer
true
Unlock the answer
question
A database language enables the user to perform complex queries designed to transform the raw data into useful information.
answer
true
Unlock the answer
question
A table can be deleted from the database by using the command.
answer
drop
Unlock the answer
question
The SQL command that allows a user to list the contents of a table is .
answer
select
Unlock the answer
question
A(n) is an alternate name given to a column or table in any SQL statement.
answer
alias
Unlock the answer
question
SQL is considered difficult to learn; its command set has a vocabulary of more than 300 words.
answer
false
Unlock the answer
question
Any changes made to the contents of a table are not physically saved on disk until you use the SAVE command.
answer
false
Unlock the answer
question
The SQL command that modifies an attribute's values in one or more table's rows is _____.
answer
update
Unlock the answer
question
Only numeric data types can be added and subtracted in SQL.
answer
false
Unlock the answer
question
Date procedures are often more software-specific than other SQL procedures.
answer
true
Unlock the answer
question
All SQL commands must be issued on a single line.
answer
false
Unlock the answer
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';
Unlock the answer
question
The SQL command that allows a user to insert rows into a table is .
answer
insert
Unlock the answer
question
A database language enables the user to create database and table structures to perform basic data management chores.
answer
true
Unlock the answer
question
The special operator used to check whether an attribute value is within a range of values is .
answer
between
Unlock the answer
question
The SQL command that allows a user to permanently save data changes is .
answer
commit
Unlock the answer
question
To list all the contents of the PRODUCT table, a user would use .
answer
wildcard
Unlock the answer
question
An example of a command a user would use when making changes to a PRODUCT table is .
answer
update
Unlock the answer
Haven't found what you were looking for?
Search for samples, answers to your questions and flashcards
Get an explanation on any task
Get unstuck with the help of our AI assistant in seconds
New
Get unstuck with AI assistant right now
Enter your topic/question
Receive an explanation
Pro tips to get quality response
Ask one question at a time
Enter a specific assignment topic
Aim at least 500 characters
Question
What is the right structure for an essay
Answer
A paragraph is a related group of sentences that develops one main idea. Each paragraph in the body of the essay should contain:
a topic sentence that states the main or controlling idea
supporting sentences to explain and develop the point you’re making
evidence from your reading or an example from the subject area that supports your point
analysis of the implication/significance/impact of the evidence finished off with a critical conclusion you have drawn from the evidence.
