Learn efficiently and remember over time.
Start Long-Term Learning
Add this set to a folder
The process of determining the particular tables and columns that will comprise a database is known as____
In the SELECT clause, you can use the ____ symbol to indicate that you want to include all columns.
The ____ table indicates the number of copies of a particular book that are currently on hand at a particular branch of Henry Books.
Each line in the Premiere Products order form contains a part number, the number of units of the ordered part, the quoted price, and ______
Any column (or collection of columns) that determines another column is called a(n) ___
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.
the ____ operator is inclusive meaning that a value equal to either value would be selected.
When you need to sort data on two columns, the less important column is called the ____ sort key.
Which of the following is the primary key of the ORDER_LINE (ORDER_NUM, PART_NUM, NUM_ORDERED, QUOTED_PRICE) table?
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 ___
You can use the ____ operator followed by a collection a values to provide a concise way of phrasing certain conditions.
The ___ command defines a table's structure by listing its columns, data types, and column lengths.
The ___ field of the WROTE table of Henry Books indicates the order in which the authors of a particular are listed on the cover.
Use the ____ date type for columns that contain letters and special characters and for columns that will not be use in calculations.
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.