CIST1220-Structured Query Language, SQL Server Express 2008
New
Long-Term Learning
Learn efficiently and remember over time.
Start Long-Term Learning
Get personalized study reminders at intervals optimized for better retention.
Track your progress on this set by creating a folder
Or add to an existing folder
Add this set to a folder
The process of determining the particular tables and columns that will comprise a database is known as____
database design
In the SELECT clause, you can use the ____ symbol to indicate that you want to include all columns.
C) *
The ____ table indicates the number of copies of a particular book that are currently on hand at a particular branch of Henry Books.
INVENTORY
Each line in the Premiere Products order form contains a part number, the number of units of the ordered part, the quoted price, and ______
Part description.
Any column (or collection of columns) that determines another column is called a(n) ___
Determinant.
You form compound conditions by connecting two or more simple conditions using the ____ operator.
All of the above (AND,OR,NOT).
___ can occur then there is a column in a table that is dependent on only a portion of the primary key.
Update anomalies.
the ____ operator is inclusive meaning that a value equal to either value would be selected.
BETWEEN.
When you need to sort data on two columns, the less important column is called the ____ sort key.
minor
Which of the following is the primary key of the ORDER_LINE (ORDER_NUM, PART_NUM, NUM_ORDERED, QUOTED_PRICE) table?
ORDER_NUM ANDPART_NUM.
In SQL for Orable and SQL Server, the ___ symbol is used as a wildcard to represent any collection of characters.
%
The REP table consists of the sales representatives number, last name, first name, address, total commission, and ___
Commission rate.
You can use the ____ operator followed by a collection a values to provide a concise way of phrasing certain conditions.
IN
The ___ command defines a table's structure by listing its columns, data types, and column lengths.
CREATE TABLE.
The ___ field of the WROTE table of Henry Books indicates the order in which the authors of a particular are listed on the cover.
SEQUENCE.
Use the ____ date type for columns that contain letters and special characters and for columns that will not be use in calculations.
CHAR.
To display all the rows and columns in a table, type the word SELECT, followed by (n)____, followed by the word FROM and then the name of the table containing the data you want to view.
ASTERISK.