Create an account
SQL is considered difficult to learn; its command set has a vocabulary of more than 300 words.
You can select partial table contents by naming the desired fields and by placing restrictions on the rows to be included in the output.
Some RDBMSs, such as Microsoft Access, automatically make the necessary conversions to eliminate case sensitivity.
To join tables, simply enumerate the tables in the FROM clause of the SELECT statement. The DBMS will create a Cartesian product of every table in the FROM clause. To get the correct results, you need to select the rows in which the common attribute values do not match.
In Oracle, the ___ command is used to change the display of a column, for example, to place a $ in front of a numeric value.
all rows will be deleted
When you issue the DELETE FROM tablename command without specifying a WHERE condition, ____.
The SQL aggregate function that gives the number of rows containing non-null values for a given column is ___.
A ___ is a logical group of database objects, such as tables and indexes, that are related to each other.
U.S. state abbrev. are always 2 characters, so _____ is a logical choice for data type representing a state column.
Date & SYSDATE are special functions that return today's date in MA ACCESS AND ___ respectively.
Using the ___ command, SQL indexes can be created on the basis of any selected attribute.
In an INSERT command, you can indicate just that attributes that have required values by listing the ___ inside parentheses after the table name.
A ____ character is a symbol that can be used as a general substitute for other characters or commands.
Please allow access to your computer’s microphone to use Voice Recording.
Having trouble? Click here for help.
We can’t access your microphone!
Click the icon above to update your browser permissions and try again
Reload the page to try again!Reload
Press Cmd-0 to reset your zoom
Press Ctrl-0 to reset your zoom
It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.
Please upgrade Flash or install Chrome
to use Voice Recording.
For more help, see our troubleshooting page.
Your microphone is muted
For help fixing this issue, see this FAQ.
Star this term
You can study starred terms together