MIS 380 Quiz 2- Jawad
The SQL statement used to enter new rows into a table is:
Insert
What is the DROP statement used for?
The DROP statement completely removes a table from the database.
The From clause can contain a second name for a table. This name is called an alias.
True
The first column listed in the Order by clause is the primary sort key.
True
The maximum number of clauses in an SQL Select statement is:
6
Which of the following is not a comparison operator used in the Where clause? != > <> <=
!=
The minimum number of clauses in an SQL Select statement is _____.
2
What is a foreign key and what does it provide?
A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables
Numeric literal values are always represented
As is, with no special punctuation
What is the Delete command?
DELETE FROM Sale WHERE SaleDate < '2014-01-01'
The SQL statement used to take rows out of a table is:
Delete
To eliminate duplicate values in the answer use this word in the Select clause: _____.
Distinct
To eliminate duplicate values you put into the Select clause the key word
Distinct
!= means "is not equal to" in the Where clause.
False
Month in Month(SaleDate) is a function that returns the name of the month in the date.
False
Numeric literal values are always represented surrounded by single quote
False
T or F: The number 0 or leaving a value blank is equivalent to null
False
To sort the result in alphabetical order you use the key word Alphabetic.
False
The order in which the four SQL query clauses are executed is _____ _____ _____ _____.
From, Where, Select, Order by
What is the Insert command?
INSERT INTO table-name [(list of column-names)] VALUES (list of values) *do not have to list the column names
Where can you first use an alias?
In the From clause, because the query is executed in the order From, Where, select, order by
The process of linking records in different tables to execute a query is called a(n) _____.
Join
A column whose value is always unique in every row in a table is called a(n) _____.
Key
* in an SQL Select statement means:
List all columns
The order of precedence for AND, OR, and NOT is:
Not, and , or
What value represents missing data when updating or inserting a table?
Null
What are the 6 clauses in a query?
Select, From, Where, Group By, Having, Order by
A query that accesses a single table is called a(n) ________ query.
Simple
The first column listed in the Order by clause is:
The primary sort key
The maximum number of tables that can be joined in an SQL Select statement is:
There is no maximum
What is the Update command?
UPDATE Customer SET LastName = 'West' WHERE FirstName = 'Margaret' and LastName = 'Smith'
The SQL statement used to change data in an existing row is:
Update
The clause that gives the condition for selecting rows is the _____ clause.
Where
To override precedence of AND, OR, and NOT, use:
parentheses
