Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

Chapter 2 Introduction to Structured Query Language

memorize.ai (lvl 286)

(0)

82 cards

()

Section 1

Preview this deck

To exclude one or more values using a condtion the OUT keyword must be used

Front

1 / 82

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (82)

Section 1

(50 cards)

To exclude one or more values using a condtion the OUT keyword must be used

Front

False

Back

To have SQL automatically eliminate duplicate rows from a result, use the keyword DISTINCT with the FROM keyword

Front

False

Back

The WHERE clause contains the condition that specifies which columns are to be selected

Front

FALSE

Back

The Microsoft Access wild card character "*" (asterisk) indicates a sequence of one or more unspecified characters in a Microsoft Access SQL query

Front

False

Back

The rows of the result table can be sorted by the values in one or more columns

Front

True

Back

A SELECT statement used in a WHERE clause is called a subquery

Front

True

Back

SQL stands for Standard Query Language

Front

False; SQL stands for Structured Query Language

Back

To obtain all columns,, use an asterisk (*) wildcard character instead of listing all the column names

Front

TRUE

Back

The wildcard character "#" indicates a single, unspecified character

Front

False

Back

SQL was developed by IBM in the late 1970s

Front

True

Back

The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column

Front

True

Back

An ad-hoc SQL query is typically written within an application program

Front

False

Back

The SQL built-in function MOST obtains the largest value in a numeric column

Front

False

Back

When two conditions must both be true for the rows to be selected, the conditions are separated by the SQL AND keyword

Front

True

Back

American National Standards Institute (ANSI) maintains the standards for SQL.

Front

True

Back

The columns to be obtained by an SQL command are listed after the FROM keyword

Front

False; The column names to be obtained by an SQL command are listed after the SELECT keyword

Back

Sorting is specified using the SORT BY phrase

Front

False

Back

The SQL keyword WHERE is used to specify the table(s) that contain(s) the data to be retrieved

Front

False, The SQL WHERE clause specifies which rows are to be listed in the query results

Back

SQL can only query a single table

Front

False

Back

To refer to a set of values in a condition, the values are placed inside parentheses () and separated by commas

Front

True

Back

The SQL keyword LIKE is used in SQL expressions to select partial string values

Front

True

Back

To sort the rows of the result table, the ORDER BY clause is specified

Front

True

Back

An asterisk (*) following the SELCT verb means that all columns are to be displayed

Front

True

Back

The SQL built-in function AVG computes the average of values in numeric columns

Front

True

Back

SQL is not a complete programming language. Rather it is a data sublanguage

Front

True; It is called a data sublanguage because it has only those statements needed for creating and processing database data and metadata

Back

The built-in function SUM can be used with any column

Front

False

Back

The SQL built-in function COUNT computes the number of rows in a query

Front

True

Back

The SQL wildcard character "%" represents a series of one or more unspecified characters

Front

True

Back

The SWL built-in function ADDUP totals values in numeric columns

Front

False

Back

The WHERE clause contains the condition that specifies which rows are to be selected

Front

True

Back

A WHERE clause can contain only one condition

Front

False

Back

The condition in WHERE clauses can refer to a set of values by using the IN operator

Front

True

Back

Columns can be sorted in descending sequence by using the DESC keyword

Front

True

Back

The cluase SELECT COUNT (*) results in a table with a single row and a single column

Front

True

Back

SQL commands can be embedded in application programs

Front

True

Back

The SQL built-in function MIN obtains the smallest value in a numeric column

Front

True

Back

The SQL keyword SELECT is used to specify the columns to be listed in the query results

Front

True

Back

To refeer to a set of values needed for a condition, use the IN operator

Front

True

Back

SQL includes a data definition language, a data manipulation language , and SQL/Persistent stored modules

Front

True

Back

The SQL keyword FROM is used to specify the table to be used

Front

True

Back

Business Intelligence (BI_) systems typically store their data in data warehouses

Front

True

Back

SQL, although very popular, has never become a national standard.

Front

False

Back

SQL statements end with a colon

Front

False; SQL statements end with a semicolon

Back

The result of a SELECT operation can contain duplicate rows

Front

True

Back

In addition to being a data sublanguage, SQL is also a programming language, like Java or C#

Front

False;

Back

SQL is only a data manipulation language

Front

False

Back

When SQL statements are executed, the statements transform tables

Front

True

Back

When using the COUNT function, the result is the count of all rows including those that are NULL

Front

False

Back

The Microsoft Access wildcard character "_" (underscore ) indicates a single, unspecified character in a specific location in a Microsoft Access SQL query

Front

False

Back

To remove duplicate rows from the result of a query, specify the DISTINCT keyword

Front

True

Back

Section 2

(32 cards)

The JOIN operator is used to combine two or more tables by concatenating (sticking together) the rows of one table with the rows of another table

Front

True

Back

In an SQL query, which of the following symbols is used by ANSI SQL to represent a single unspecified character?

Front

_ (underscore)

Back

In an SQL query, which SQL keyword is used to link two conditions that both must be true for the rows to be selected?

Front

AND

Back

An alternative to combining tables is to use a join

Front

True

Back

Outer joins can be either up joins or down joins

Front

False

Back

In an SQL query, a join operation is achieved by specifying the equality of the respective column names as a condition in the WHERE clause

Front

True

Back

In an SQL query, which SQL keyword is used to state the condition that specifies which rows are to be selected?

Front

WHERE

Back

In an SQL query, which of the following symbols is used by ANSI SQL to represent all the columns in a single table?

Front

* (asterisk)

Back

In an SQL query, which built-in function is used to compute the average value of numeric columns?

Front

AVG

Back

Joins that show the matching rows from the joined tables, plus unmatched rows from one other table in their results, are called outer joins

Front

True

Back

In an SQL query, which built in function is used to obtain the largest value of numeric columns?

Front

MAX

Back

In an SQL query, which built-in function is used to total numeric columns?

Front

SUM

Back

SQL is a

Front

data sublanguage

Back

When people use the term join they normally mean equijoin

Front

True

Back

In an SQL query, which SQL keyword is used to determine if a column value is equal to any one of a set of values?

Front

IN

Back

In an SQL query, which of the following symbols is used by Microsoft Access to represent a single unspecified character?

Front

? (question mark)

Back

Joins that show only matching rows from the joined tables in their results are called inner joins

Front

True

Back

The names of tables to be joined in an SQL query are listed in the FROM clause

Front

True

Back

In an SQL query, which SQL keyword begins the query?

Front

SELECT

Back

The UNION of two relations A and B consists of all rows that are either in relation A or in relation B or both

Front

True

Back

An ad hoc query is

Front

A question that c an be answered from the database using SQL

Back

The SQL syntax JOIN...ON can be used as an alternate way of writing an SQL join statement

Front

True

Back

While many subqueries can be alternatively written as joins, correlated subqueries do work that cannot be duplicated as a join

Front

True

Back

When making an SQL query, we are using SQL as a(n)

Front

DML (data manipulation language)

Back

SQL queries using subqueries still function like a single table query in the sense that columns from both the top-level query and subquery can be displayed in the query results

Front

False

Back

The INTERSECT of two relations A and B consists of all rows that are in relation B but are not in relation A

Front

False

Back

Two or more tables are joined by giving the table names in the WHERE clause and specifying the equality of the respective column names as a condition in the GROUP BY clause

Front

False

Back

A nested SELECT statement, one that appears within the WHERE clause of another SQL statement is called a subquery and must be enclosed in parentheses

Front

True

Back

In an SQL query, which SQL keyword is used to sort the result table by the values in one or more columns?

Front

ORDER BY

Back

In an SQL query, which SQL keyword must be used to remove duplicate rows from the result table?

Front

DISTINCT

Back

In an SQL query, which SQL keyword is used to specify the table(s) to be used?

Front

FROM

Back

A database extracted from the operation database for BI purposes typically

Front

contains just part of the operation database

Back