MIS-180 SQL Chapters 1-4

Chapter 1

--

Chapter 2

--

Chapter 3

--

Chapter 4

--

The aggregate function that is used to find the average of a set of numbers is the ______ function.

AVG

The From clause can contain a second name for a table. This name is called a(n) _____.

Alias

Conditions connected by OR will be true when _____ is/are true (either/both/none/all -- choose the best)

All

The aggregate function that is used to find out how many total customers Red Cat has is the _______ function.

Count

What is DBMS Data Security concerned with?

Enforcing restrictions about who is able to access what data

!= means "is not equal to" in the Where clause (T/F)

False

A clause that contains the condition for linking different tables is the Order by clause (T/F)

False

A phone number would be considered a fact and not information (T/F)

False

Knowledge about databases and how they function is only required for technical careers (T/F)

False

Only very large and complex databases are required to have a schema (T/F)

False

String functions can only be used in the Select clause.

False

The From clause can contain a second name for a table. This name is called an alternate (T/F)

False

The aggregate function that is used to find the average of a set of numbers is the "AVE" function.

False

The core of every type of information system is an intuitive and easy to use User Interface (T/F)

False

The order in which SQL Select clauses are executed is From, Select, Where, Order by

False

When using Aggregate functions because WHERE applies to individual records, it is not used; the HAVING clause is used instead.

False

When using Aggregate functions in the Select clause, a scalar function is not allowed, such as SQRT(AVG(x)).

False

The link between a particular Product and the Manufacturer that produces that product is maintained in the database through the use of a(n) ___________.

Foreign key

The clause that identifies the tables the query should access is the ______ clause.

From

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

The Where clause operator that is used to do pattern matching is the "______" operator.

Like

The clause that says how the rows in the query result should be sorted is the _____ clause.

Order by

A string function that can be used to find and replace a substring within a larger string is the "_____ (x,f,t)" function.

Replace

It is not allowed to include a HAVING clause unless there is also a GROUP BY clause.

True

The CONCAT function will work on string data, numeric data, and literals.

True

The From clause can contain a second name for a table. This name is called an alias.

True

To sort the result in reverse alphabetical order you use the key word Desc.

True

The String function that changes the value in a column to be all capital letters is called "_______(x)".

Upper

SQL Built-in functions that work across multiples rows are called what? a. Aggregate functions b. Row functions c. Group by functions d. Combination functions

a. Aggregate functions

What is the best phrase to use in the COUNT function to determine how many customers bought shoes during on May? Select COUNT( _____) from Customer C join Sale S on C.CustomerID = S.CustomerID where .... (month is May). a. COUNT (distinct CustomerID) b. COUNT (distinct * ) c. COUNT (CustomerID) d. COUNT (*)

a. COUNT (distinct CustomerID)

When using an aggregate function in the Select statement, what is the order of execution of the clauses? a. From, Where, Select b. Select, From, Where c. Select, Where, From d. From, Select, Where

a. From, Where, Select

Which of the following do you use to override the normal precedence of AND, OR, and NOT? a. Parentheses b. Square brackets c. Curly braces d. Angle brackets

a. Parentheses

In the syntax of a query which uses Aggregate functions, what is the sequence of the clauses for correct syntax? a. SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY b. SELECT, FROM, GROUP BY, WHERE, HAVING, ORDER BY c. SELECT, FROM, WHERE,, GROUP BY, ORDER BY, HAVING d. SELECT, FROM, WHERE, ORDER BY, GROUP BY, HAVING

a. SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY

The standard language used for querying an RDBMS is what? a. SQL b. PHP c. HTML d. JAVA

a. SQL

Typical relational DBMS in use today include all of the following EXCEPT... a. Symantec b. MySQL c. DB2 d. PostgresQL

a. Symantec

The maximum number of tables that can be joined in an SQL Select statement is: a. There is no maximum b. 6 c. 4 d. 2

a. There is no maximum

The From clause can contain a second name for a table. This name is called a. an alias b. aka c. also known as d. an alternate

a. an alias

Conditions connected by AND will be true a. only when both conditions are true b. when either condition is true c. when one condition is false d. when neither condition is true

a. only when both conditions are true

The purpose of the database schema is to a. Define the purpose of the database b. Define the structure of the database c. Define the data types allowed in the database d. Define the keys and indices required

b. Define the structure of the database

Which is NOT one of the responsibilities of a DBMS? a. Execute queries b. Display query results c. Ensure data integrity d. Define the data

b. Display query results

The clause that normally contains the condition for linking different tables is: a. Group by b. From c. Order by d. Select

b. From

The clause that says which columns to list in the query result is: a. Order by b. From c. Where d. Select

b. From

Which "Where" clause operator uses wild cards? a. Null b. Like c. Between d. In

b. Like

* in an SQL Select statement means: a. Many b. List all columns c. Exactly 1 character d. 0 or more characters

b. List all columns

The order of precedence for AND, OR, and NOT is: a. AND, OR, NOT b. NOT, AND, OR c. NOT, OR, AND d. AND, NOT, OR

b. NOT, AND, OR

The clause that says which columns to list in the query result is: a. Where b. Select c. Order by d. From

b. Select

The clause the gives the condition for selecting rows is: a. Select b. Where c. Order by d. From

b. Where

The minimum number of clauses in an SQL Select statement is: a. 8 b. 6 c. 2 d. 4

c. 2

What does the following statement return in Oracle: "EXTRACT(MONTH from PurchaseDate)"? a. An error because the syntax is incorrect b. An abbreviation of the description of the month, such as SEP c. An integer for the month of the purchase date such as 9 d. A description of the month of the purchase date, such as September

c. An integer for the month of the purchase date such as 9

Date functions can appear in which clauses? a. Where and Having b. Where and Order by c. Where and Select d. Where and From

c. Where and Select

How is a relationship between entities implemented in database tables? a. By duplicate attribute names b. With a line between tables c. With a foreign key attribute d. With attributes that have the same name

c. With a foreign key attribute

What does the following statement return In SQL for SQL Server: "MONTH(PurchaseDate)"? a. An abbreviation of the month of the purchase date, such as SEP b. This syntax will give an error because it is incorrect c. A description of the month of the purchase date, such as September d. An integer for the month of the purchase date such as 9

d. An integer for the month of the purchase date such as 9

The primary contributor to the availability of all kinds of information is what? a. Online libraries b. Internet availability c. Wikipedia d. Database technology

d. Database technology

What does the wild card "%" stand for in a Where clause operator? a. Match to zero or one characters b. Match to one or more characters c. Match to exactly one character d. Match to zero or more characters

d. Match to zero or more characters

In SQL Server, the string functions SUBSTRING(x,s,n) does the following: a. Returns the subsequent n characters starting at character location s in field s b. Returns the subsequent x characters starting at character location s in field n c. Returns the subsequent s characters starting at character location n in field x d. Returns the subsequent n characters starting at character location s in field x

d. Returns the subsequent n characters starting at character location s in field x

An SQL built-in function that operates on one field in a record is called a ______ function.

Scalar

The structure and organization of a database is defined by its ___________.

Schema

The clause that identifies the tables the query should access is the _____ clause.

Select

A query that accesses a single table is called a(n) ______ query.

Simple

A query that accesses a single table is called a(n) ________ query.

Simple

The aggregate function that is used to add up a set of numbers is the ______ function.

Sum

In a database a set of data that is organized in rows and columns is called a(n) _____________.

Table

A clause that contains the condition for linking different tables is the Where clause (T/F)

True

A course in database technology, such as this one, would benefit all business students (T/F)

True