Related Essays

  • Acct 553 Quiz

    Which clause is used to list the attributes desired in the result of a query? a) Where b) Select c) From d) Distinct Answer:b 26. Select name, course_idfr...

  • Assignment 1 True/False Questions: Database Development

    3) Whenever you have an aggregate function in a query criteria, you must use the HAVING keyword. 4) Any column in a SELECT that contains an aggrega...

  • Nt1310 Unit 9 Essay

    Task 9 COMPARE the usefulness of MySQL and QBE Query by example is a language used for relational databases like SQL. Its development was parallel to that o...

  • Risk Analysis Assignment

    If applicable, use examples to support your definitions. Consult your notes or course textbook(s) as references or the Internet by visiting Web sites such ...

  • Questions: In Oracle When Is It Better To Use Materialized Views

    B. Dual does not exist in Oracle, only in SQL Server C. Dual is an SQL command used to provide the dual value of a complex number D. Dual is an inte...

  • Pt1420 Unit 3 Assignment 1 Data Type Analysis

    • Addition, subtraction, multiplication, division are examples when integer data types are used. When the integer is added, subtracted, multiplied or

  • Nt1310 Unit 1 Database Assignment

    Homework #1 1. The search term I used is “database security” because I am interested in it when I read through it. Moreover, I want to know more about the t...

  • Major Objectives Of Oracle Troubleshrorage And Scenarios

    5. To fully understand the techniques that are used to locate and fix SQL issues. 6. To comprehend bottleneck and ratio-based troubleshooting examination...

  • Nt1320 Unit 2

    2. D H C I J E K A B F G 4. SQL-92 was a major revision and was structured into three levels: Entry, Intermediate, and Full.

  • End-Of-Chapter Quiz

    Correct answer Query An organized collection of data related to a particular topic or purpose. Correct answer Database Facts about people...

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

Card Range To Study

through

image

Play button

image

Play button

image

Progress

1/93

Click to flip

Use LEFT and RIGHT arrow keys to navigate between flashcards;

Use UP and DOWN arrow keys to flip the card;

H to show hint;

A reads text to speech;

93 Cards in this Set

  • Front
  • Back

1) SQL stands for Standard Query Language.
Answer: FALSE
2) SQL includes a data definition language, a data manipulation language, and SQL/Persistent stored modules.
Answer: TRUE
3) SQL is only a data manipulation language (DML).
Answer: FALSE
4) The American National Standards Institute (ANSI) maintains the standards for SQL.
Answer: TRUE
5) SQL was developed by IBM in the late 1970s.
Answer: TRUE
6) SQL is not a complete programming language. Rather it is a data sublanguage.
Answer: TRUE
7) In addition to being a data sublanguage, SQL is also a programming language, like Java or C#.
Answer: FALSE
8) SQL commands can be embedded in application programs.
Answer: TRUE
9) SQL, although very popular, has never become a national standard.
Answer: FALSE
10) The SQL keyword SELECT is used to specify the columns to be listed in the query results.
Answer: TRUE
11) The SQL keyword WHERE is used to specify the table(s) that contain(s) the data to be retrieved.
Answer: FALSE
12) The SQL keyword FROM is used to specify the table to be used.
Answer: TRUE
13) SQL can only query a single table.
Answer: FALSE
14) SQL statements end with a colon.
Answer: FALSE
15) The columns to be obtained by an SQL command are listed after the FROM keyword.
Answer: FALSE
16) To remove duplicate rows from the result of a query, specify the SQL DISTINCT keyword.
Answer: TRUE
17) To obtain all columns, use an asterisk (*) wildcard character instead of listing all the column names.
Answer: TRUE
18) The SQL WHERE clause contains the condition that specifies which rows are to be selected.
Answer: TRUE
19) The result of an SQL SELECT operation can contain duplicate rows.
Answer: TRUE
20) To have SQL automatically eliminate duplicate rows from a result, use the keyword DISTINCT with the FROM keyword.
Answer: FALSE
21) An asterisk (*) following the SELECT verb means that all columns are to be displayed.
Answer: TRUE
22) The WHERE clause contains the condition that specifies which columns are to be selected.
Answer: FALSE
23) The rows of the result table can be sorted by the values in one or more columns.
Answer: TRUE
24) Sorting is specified by the use of the SORT BY phrase.
Answer: FALSE
25) To sort the rows of the result table, the ORDER BY clause is specified.
Answer: FALSE
26) Columns can be sorted in descending sequence by using the SQL DESC keyword.
Answer: TRUE
27) A WHERE clause can contain only one condition.
Answer: FALSE
28) When two conditions must both be true for the rows to be selected, the conditions are separated by the SQL AND keyword.
Answer: TRUE
29) To refer to a set of values needed for a condition, use the SQL IN operator.
Answer: TRUE
30) To exclude one or more values using a condition, the SQL OUT keyword must be used.
Answer: FALSE
31) To refer to a set of values in a condition, the values are placed inside parentheses ( ) and separated by commas.
Answer: TRUE
32) The condition in WHERE clauses can refer to a set of values by using the IN operator.
Answer: TRUE
33) The SQL keyword LIKE is used in SQL expressions to select on partial values.
Answer: TRUE
34) The SQL wildcard character "%" represents a series of one or more unspecified characters.
Answer: TRUE
35) The SQL wildcard character "#" indicates a single, unspecified character in a specific location in an SQL query.
Answer: FALSE
36) The Microsoft Access wildcard character "*" (asterisk) indicates a sequence of one or more unspecified characters in a Microsoft Access SQL query.
Answer: TRUE
37) The Microsoft Access wildcard character "_" (underscore) indicates a single, unspecified character in a specific location in a Microsoft Access SQL query.
Answer: FALSE
38) The SQL built-in function ADDUP totals values in numeric columns.
Answer: FALSE
39) The SQL built-in function AVG computes the average of values in numeric columns.
Answer: TRUE
40) The SQL built-in function MOST obtains the largest value in a numeric column.
Answer: TRUE
41) The SQL built-in function MIN obtains the smallest value in a numeric column.
Answer: TRUE
42) The SQL built-in function COUNT computes the number of rows in a query.
Answer: TRUE
43) The built-in function SUM can be used with any column.
Answer: FALSE
44) The clause SELECT COUNT (*) results in a table with a single row and a single column.
Answer: TRUE
45) Arithmetic in SQL statements is limited to the operations provided by the built-in functions.
Answer: FALSE
46) The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.
Answer: TRUE
47) A WHERE clause can contain another SELECT statement enclosed in parentheses.
Answer: TRUE
48) A SELECT statement used in a WHERE clause is called a subquery.
Answer: TRUE
49) 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.
Answer: TRUE
50) Only two tables can be queried by using a subquery.
Answer: FALSE
51) An alternative to combining tables by a subquery is to use a join.
Answer: TRUE
52) When people use the term "join" they normally mean an "equijoin."
Answer: TRUE
53) 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.
Answer: FALSE
54) The names of tables to be joined in an SQL query are listed in the FROM clause.
Answer: TRUE
55) 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.
Answer: TRUE
56) Every subquery can be alternatively expressed by a join.
Answer: FALSE
57) While many subqueries can be alternatively written as joins, correlated subqueries do work that cannot be duplicated as a join.
Answer: TRUE
58) The SQL syntax JOIN . . . ON can be used as alternate way of writing an SQL join statement.
Answer: TRUE
59) Joins that show only matching rows from the joined tables in their results are called inner joins.
Answer: TRUE
60) Joins that show the matching rows from the joined tables plus unmatched rows from one other table in their results are called outer joins.
Answer: TRUE
61) Outer joins can be either up joins or down joins.
Answer: FALSE
62) SQL is a ________.
A) data sublanguage
B) product of IBM research
C) national standard
D) combination that includes a data definition language and a data manipulation language
E) All of the above
Answer: E
63) When making an SQL query, we are using SQL as a(n) ________.
A) DDL
B) DML
C) embedded language
D) SET
E) WHERE
Answer: B
64) In an SQL query, which SQL keyword actually creates the query?
A) EXISTS
B) FROM
C) SELECT
D) SET
E) WHERE
Answer: C
65) In an SQL query, which SQL keyword is used to specify the table(s) to be used?
A) EXISTS
B) FROM
C) SELECT
D) SET
E) WHERE
Answer: B
66) In an SQL query, which SQL keyword must be used to remove duplicate rows from the result table?
A) DELETE
B) DISTINCT
C) NOT EXISTS
D) UNIQUE
E) KEY
Answer: B
67) In an SQL query, which of the following symbols is used by ANSI SQL to represent all the columns in a single table?
A) _ (underscore)
B) ? (question mark)
C) * (asterisk)
D) % (percent)
E) # (pound)
Answer: C
68) In an SQL query, which SQL keyword is used to state the condition that specifies which rows are to be selected?
A) EXISTS
B) FROM
C) SELECT
D) SET
E) WHERE
Answer: E
69) In an SQL query, which SQL keyword is used to join two conditions that both must be true for the rows to be selected?
A) AND
B) EXISTS
C) HAVING
D) IN
E) OR
Answer: A
70) 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?
A) AND
B) EXISTS
C) HAVING
D) IN
E) OR
Answer: D
71) In an SQL query, which of the following symbols is used by ANSI SQL to represent a single unspecified character?
A) _ (underscore)
B) ? (question mark)
C) * (asterisk)
D) % (percent)
E) # (pound)
Answer: A
72) In an SQL query, which of the following symbols is used by Microsoft Access to represent a single unspecified character?
A) _ (underscore)
B) ? (question mark)
C) * (asterisk)
D) % (percent)
E) # (pound)
Answer: B
73) In an SQL query, which SQL keyword is used to sort the result table by the values in one or more columns?
A) GROUP BY
B) ORDER BY
C) SELECT
D) SORT BY
E) WHERE
Answer: B
74) Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following would find all employees whose name begins with the letter "S" using standard SQL?
A) SELECT *
FROM EMPLOYEE
WHERE Name IN ['S'];
B) SELECT EmpNo
FROM EMPLOYEE
WHERE Name LIKE 'S';
C) SELECT *
FROM Name
WHERE EMPLOYEE LIKE 'S*';
D) SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S%';
E) None of the above.
Answer: D
75) Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following would find all employees whose name begins with the letter "S" using Microsoft Access?
A) SELECT *
FROM EMPLOYEE
WHERE Name IN ['S'];
B) SELECT EmpNo
FROM EMPLOYEE
WHERE Name LIKE 'S';
C) SELECT *
FROM Name
WHERE EMPLOYEE LIKE 'S*';
D) SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S%';
E) None of the above.
Answer: C
76) In an SQL query, which built-in function is used to total numeric columns?
A) AVG
B) COUNT
C) MAX
D) MEAN
E) SUM
Answer: E
77) In an SQL query, which built-in function is used to compute the average value of numeric columns?
A) AVG
B) MEAN
C) MAX
D) MIN
E) SUM
Answer: A
78) In an SQL query, which built-in function is used to obtain the largest value of numeric columns?
A) AVG
B) COUNT
C) MAX
D) MIN
E) SUM
Answer: C
79) In an SQL query, which built-in function is used to obtain the smallest value of numeric columns?
A) AVG
B) COUNT
C) MAX
D) MIN
E) SUM
Answer: D
80) In an SQL query, the built-in functions SUM and AVG work with columns containing data of which of the following data types?
A) Integer
B) Numeric
C) Char
D) A and B
E) A, B, and C
Answer: D
81) In an SQL query, which built-in function is used to compute the number of rows in a table?
A) AVG
B) COUNT
C) MAX
D) MIN
E) MEAN
Answer: B
82) In an SQL query, the built-in function COUNT works with columns containing data of which of the following data types?
A) Integer
B) Numeric
C) Char
D) A and B
E) A, B, and C
Answer: E
83) In an SQL query, which SQL keyword is used with built-in functions to group together rows that have the same value in a specified column?
A) GROUP BY
B) ORDER BY
C) SELECT
D) SORT BY
E) DISTINCT SET
Answer: A
84) In an SQL query, which SQL keyword is used with GROUP BY to select groups meeting specified criteria?
A) AND
B) EXISTS
C) HAVING
D) IN
E) WHERE
Answer: C
85) Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following is not a valid ANSI SQL command?
A) SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'Ja%';
B) SELECT COUNT(*)
FROM EMPLOYEE
WHERE Salary < 30000;
C) SELECT COUNT(EmpNo)
FROM EMPLOYEE;
D) SELECT HireDate, COUNT(*)
FROM EMPLOYEE
WHERE Salary < 30000;
E) SELECT HireDate, COUNT(*)
FROM EMPLOYEE
GROUP BY HireDate;
Answer: D
88) In an SQL query, which SQL keyword is used to implement a subquery?
A) GROUP BY
B) HAVING
C) ORDER BY
D) SELECT
E) SORT BY
Answer: D
89) When one SQL query is embedded in another SQL query, this is referred to as a ________.
A) subset
B) join
C) WHERE Query
D) subquery
E) set query
Answer: D
90) When one SQL query is embedded in another SQL query, the second SQL query is embedded in the ________ of the first query.
A) SELECT
B) FROM
C) WHERE
D) GROUP BY
E) HAVING
Answer: C
91) When one SQL query is embedded in another SQL query, the first SQL query can still contain an SQL ________ clause.
A) FROM THE
B) WHERE THE
C) ORDER BY
D) GROUP BY
E) C and D
Answer: E
92) In an SQL query, which SQL keyword is used to specify the names of tables to be joined?
A) FROM
B) HAVING
C) JOIN
D) SELECT
E) WHERE
Answer: A
93) In an SQL query, which SQL keyword is used to specify the column names to be used in a join?
A) FROM
B) HAVING
C) JOIN
D) SELECT
E) WHERE
Answer: E
94) Regarding the interchangeability of subqueries and joins,
A) a join can always be used as an alternative to a subquery, and a subquery can always be used as an alternative to a join.
B) a join can sometimes be used as an alternative to a subquery, and a subquery can sometimes be used as an alternative to a join.
C) a join can always be used as an alternative to a subquery, and a subquery can sometimes be used as an alternative to a join.
D) a join can sometimes be used as an alternative to a subquery, and a subquery can always be used as an alternative to a join.
E) a join can never be used as an alternative to a subquery, and a subquery can never be used as an alternative to a join.
Answer: B

95) In an SQL query of two tables, which SQL keyword indicates that we want data from all the rows of one table to be included in the result, even if the row does not correspond to any data in the other table?
A) LEFT JOIN
B) RIGHT JOIN
C) INCLUDE
D) A and B
E) A, B, and C

Answer: D