MIS 380 Quiz 2- Jawad

Ace your homework & exams now with Quizwiz!

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


Related study sets

Chapter 7- personal family finance

View Set

Government Unit 2 Potential Test Questions

View Set

MARK 3000 CH 12, MARK 3000 CH 11, Mark 3000 Ch 10

View Set

Філософська етика

View Set

Chapter 8 - Process Management - SCM

View Set

Psych and Soc Ch 6.1 Personality

View Set

Ap European History Final Review

View Set

PrepU - Ch. 36: Management of Patients with MSK Disorders

View Set