Chapter 5 Introduction to SQL True False

48) A catalog is the structure that contains object descriptions created by a user. Answer: FALSE LO: 5.1: Define key terms. Difficulty: Easy Classification: Concept AACSB: Information Technology 49) DCL is used to update the database with new records. Answer: FALSE LO: 5.1: Define key terms. Difficulty: Moderate Classification: Concept AACSB: Information Technology 50) A database table is defined using the data definition language (DDL). Answer: TRUE LO: 5.1: Define key terms. Difficulty: Easy Classification: Concept AACSB: Information Technology 51) A database is maintained and queried using the data mapping language (DML). Answer: FALSE LO: 5.1: Define key terms. Difficulty: Easy Classification: Concept AACSB: Information Technology 52) The content of dynamic views is generated when they are referenced. Answer: TRUE LO: 5.1: Define key terms. Difficulty: Moderate Classification: Concept AACSB: Information Technology 53) The views are created by executing a CREATE VIEW SQL command. Answer: TRUE LO: 5.1: Define key terms. Difficulty: Easy Classification: Concept AACSB: Information Technology 54) When the SELECT clause in the create view statement contains the keyword DISTINCT, the view can be used to update data. Answer: FALSE LO: 5.1: Define key terms. Difficulty: Easy Classification: Concept AACSB: Information Technology 13 55) The CREATE SCHEMA DDL command is used to create a table. Answer: FALSE LO: 5.1: Define key terms. Difficulty: Easy Classification: Concept AACSB: Information Technology 56) SQL is both an American and international standard for database access. Answer: TRUE LO: 5.2: Interpret the history and role of SQL in database development. Difficulty: Easy Classification: Concept AACSB: Information Technology 57) SQL has been implemented only in the mainframe and midrange environments. Answer: FALSE LO: 5.2: Interpret the history and role of SQL in database development. Difficulty: Easy Classification: Concept AACSB: Information Technology 58) SQL originated from a project called System-S. Answer: FALSE LO: 5.2: Interpret the history and role of SQL in database development. Difficulty: Moderate Classification: Concept AACSB: Information Technology 59) One of the original purposes of the SQL standard was to provide a vehicle for portabi database definition and application modules between conforming DBMSs. Answer: TRUE LO: 5.2: Interpret the history and role of SQL in database development. Difficulty: Moderate Classification: Concept AACSB: Information Technology 60) A major benefit of SQL as a standard is reduced training costs. Answer: TRUE LO: 5.2: Interpret the history and role of SQL in database development. Difficulty: Easy Classification: Concept AACSB: Information Technology 61) Implementation of a standard can never stifle creativity and innovation. Answer: FALSE LO: 5.2: Interpret the history and role of SQL in database development. 14 lity of Difficulty: Moderate Classification: Concept AACSB: Information Technology 62) Applications can be moved from one machine to another when each machine uses SQL. Answer: TRUE LO: 5.2: Interpret the history and role of SQL in database development. Difficulty: Easy Classification: Concept AACSB: Information Technology 63) Some DBMS can handle graphic data types as well as text and numbers. Answer: TRUE LO: 5.2: Interpret the history and role of SQL in database development. Difficulty: Moderate Classification: Concept AACSB: Information Technology 64) When creating tables, it's important to decide which columns will allow null values before the table is created. Answer: TRUE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Easy Classification: Concept AACSB: Information Technology 65) In databases, null values are equivalent to zero. Answer: FALSE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Easy Classification: Concept AACSB: Information Technology 66) The DELETE TABLE DDL command is used to remove a table from the database. Answer: FALSE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Moderate Classification: Concept AACSB: Information Technology 67) The ALTER TABLE command is used to change a table definition. Answer: TRUE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Easy Classification: Concept AACSB: Information Technology 15 68) The SQL command used to populate tables is the INSERT command. Answer: TRUE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Easy Classification: Concept AACSB: Information Technology 69) An INSERT command does not need to have the fields listed. Answer: TRUE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Easy Classification: Concept AACSB: Information Technology 70) The following INSERT command would work fine: INSERT INTO budget values 121,222,111; Answer: FALSE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Easy Classification: Concept AACSB: Information Technology 71) The DROP command deletes rows from a table individually or in groups. Answer: FALSE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Easy Classification: Concept AACSB: Information Technology 72) In order to update data in SQL, one must inform the DBMS which relation, columns, and rows are involved. Answer: TRUE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Moderate Classification: Concept AACSB: Information Technology 73) Indexes generally slow down access speed in most RDMS. Answer: FALSE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Moderate Classification: Concept AACSB: Information Technology 16 74) Expressions are mathematical manipulations of data in a table that may be included as part of the SELECT statement. Answer: TRUE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Moderate Classification: Concept AACSB: Information Technology 75) COUNT(*) tallies only those rows that contain a value, while COUNT counts all rows. Answer: FALSE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Moderate Classification: Concept AACSB: Information Technology 76) The asterisk (*) wildcard designator can be used to select all fields from a table as well as in WHERE clauses when an exact match is not possible. Answer: TRUE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Easy Classification: Concept AACSB: Information Technology 77) The comparison operators = and != are used to establish a range of values. Answer: FALSE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Moderate Classification: Concept AACSB: Information Technology 78) If multiple Boolean operators are used in an SQL statement, NOT is evaluated first, then AND, then OR. Answer: TRUE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Moderate Classification: Concept AACSB: Information Technology 17 79) The following two SQL statements will produce the same results. SELECT last_name, first_name FROM customer WHERE credit_limit > 99 AND credit_limit < 10001; SELECT last_name, first_name FROM customer WHERE credit_limit BETWEEN 100 and 10000; Answer: TRUE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Moderate Classification: Concept AACSB: Information Technology 80) Adding the DISTINCT keyword to a query eliminates duplicates. Answer: TRUE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Easy Classification: Concept AACSB: Information Technology 81) The following two SQL statements will produce different results. SELECT last_name, first_name FROM customer WHERE state = 'MA' OR state = 'NY' OR state = 'NJ' OR state = 'NH' OR state = 'CT'; SELECT last_name, first_name FROM customer WHERE state in ('MA','NY','NJ','NH','CT'); Answer: FALSE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Moderate Classification: Concept AACSB: Information Technology 82) The ORDER BY clause sorts the final results rows in ascending or descending order. Answer: TRUE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Easy Classification: Concept AACSB: Information Technology 18 83) A single value returned from an SQL query that includes an aggregate function is called a vector aggregate. Answer: FALSE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Easy Classification: Concept AACSB: Information Technology 84) When a GROUP BY clause is included in an SQL statement, only those columns with a single value for each group can be included. Answer: TRUE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Moderate Classification: Concept AACSB: Information Technology 85) The HAVING clause and the WHERE clause perform the same operation. Answer: FALSE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Moderate Classification: Concept AACSB: Information Technology 86) The following query totals sales for each salesperson. SELECT salesperson_id, sum(sales) FROM salesperson GROUP BY salesperson_id; Answer: TRUE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Moderate Classification: Concept AACSB: Information Technology 87) The following query totals sales in state= 'MA' for each salesperson. SELECT salesperson_id, sum(sales) FROM salesperson GROUP BY salesperson_id HAVING state = 'MA'; Answer: FALSE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Difficult Classification: Concept AACSB: Information Technology 19 88) The ORDER BY clause is the first statement processed in an SQL command. Answer: FALSE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Easy Classification: Concept AACSB: Information Technology 89) The WHERE clause is always processed before the GROUP BY clause when both occur in a SELECT statement. Answer: FALSE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Moderate Classification: Concept AACSB: Information Technology 90) The FROM clause is the first statement processed in an SQL command. Answer: TRUE LO: 5.3: Define a database using the SQL data definition language. Difficulty: Moderate Classification: Concept AACSB: Information Technology 91) When creating a table, it is not important to consider foreign key–primary key mates. Answer: FALSE LO: 5.5: Establish referential integrity using SQL. Difficulty: Easy Classification: Concept AACSB: Information Technology 92) A referential integrity constraint specifies that the existence of an attribute in one table depends upon the existence of a foreign key in the same or another table. Answer: FALSE LO: 5.5: Establish referential integrity using SQL. Difficulty: Moderate Classification: Concept AACSB: Information Technology 20