DB Chapter 3 MULTIPLE

Which type of join, although not included in standard SQL, was created to allow unmatched rows to appear in the result of a join operation? A) ODD JOIN B) OPEN JOIN C) OUTER JOIN D) INNER JOIN E) COMBINE JOIN

C) OUTER JOIN

Which of the following SQL commands would be used to remove both the data and the table structure of a table named STUDENT? A) DROP TABLE STUDENT; B) DELETE TABLE STUDENT; C) REMOVE TABLE STUDENT; D) SELECT * FROM STUDENT THEN DROP; E) DELETE FROM STUDENT;

A) DROP TABLE STUDENT;

Which symbol is used in standard SQL as a wildcard to represent a series of one or more unspecified characters? A) % (percent sign) B) ! (exclamation mark) C) _ (underscore) D) ? (question mark) E) ; (semi-colon)

A) % (percent sign)

Which SQL keyword is used to apply conditions to restrict groups that appear in the results of a SELECT query that uses GROUP BY? A) WHERE B) HAVING C) LIKE D) SORT E) DISTINCT

B) HAVING

Given the table STUDENT(StudentID, Name, Advisor), which of the following SQL statements would be used to add new student data to the STUDENT table? A) INSERT DATA STUDENT SET StudentID=123, Name='Jones', Advisor='Smith'; B) INSERT INTO STUDENT VALUES (123, 'Jones', 'Smith'); C) INSERT INTO STUDENT (New Student Data) VALUES (123, 'Jones', 'Smith'); D) INPUT DATA STUDENT SET StudentID=123, Name=' Jones', Advisor='Smith'; E) INPUT INTO STUDENT (123, 'Jones', 'Smith');

B) INSERT INTO STUDENT VALUES (123, 'Jones', 'Smith');

Which of the following data types used in SQL would define a fixed-length text field of 10 characters? A) text(10) B) char(10) C) varchar(10) D) fixed(10) E) length(10)

B) char(10)

Which of the following cannot be done using the CONSTRAINT phrase? A) Create a single attribute primary key. B) Define a foreign key. C) Establish a referential integrity constraint. D) All of the above can be done using the CONSTRAINT phrase. E) None of the above can be done using the CONSTRAINT phrase.

D) All of the above can be done using the CONSTRAINT phrase.

Which of the following is not one of the five SQL built-in functions? A) MODE B) SUM C) COUNT D) MAX E) AVG

A) MODE

Which of the following is not a standard data type used in SQL? A) Text B) Char C) Varchar D) Integer E) Numeric

A) Text

Given the table STUDENT(StudentID, Name, Advisor), which of the following SQL statements would be used to change the value of the Advisor field to 'Smith' for all rows in the STUDENT table? A) UPDATE STUDENT SET Advisor = 'Smith'; B) MODIFY STUDENT SET Advisor = 'Smith'; C) MODIFY Advisor SET STUDENT = 'Smith'; D) UPDATE Advisor = 'Smith'; E) SET STUDENT Advisor = 'Smith';

A) UPDATE STUDENT SET Advisor = 'Smith';

In Microsoft Access, tables are added to a Query window by: A) selecting the tables from the Use Table dialog box. B) selecting the tables from the Show Table dialog box. C) selecting the tables from the Tables section of the Navigation Pane. D) selecting the tables from the Queries section of the Navigation Pane. E) selecting the tables from the Relationships window.

B) selecting the tables from the Show Table dialog box.

In Microsoft Access, standard SQL table creation syntax items not supported by Access SQL can generally be implemented by: A) setting the Data Types in Access table Design View. B) setting the field properties in Access table Design View. C) setting the relationship properties in the Edit Relationship dialog box. D) setting the referential integrity properties in the Edit Relationship dialog box. E) running an ALTER TABLE query in Access SQL.

B) setting the field properties in Access table Design View.

A composite primary key can be defined using the CONSTRAINT phrase in which SQL command? A) MODIFY TABLE B) CHANGE TABLE C) CREATE TABLE D) SET TABLE E) BUILD TABLE

C) CREATE TABLE

Which of the following is the correct SQL clause to sort the results of a SELECT query in reverse-alphabetic order using the Department field? A) SORT BY Department B) REVERSE Department C) ORDER BY Department DESC D) SORT BY Department DESC E) SORT BY Department REVERSE

C) ORDER BY Department DESC

Which of the following is not true about primary keys? A) Primary keys cannot be null. B) Primary keys must be unique. C) Primary keys must be a single attribute. D) Primary keys are used to represent relationships. E) Primary keys can be defined using an SQL CONSTRAINT phrase.

C) Primary keys must be a single attribute.

Given the table CUSTOMER(CustID, Name, PhoneNum, AcctBalance), what is the standard SQL query phrase to retrieve the Name and Phone Number of customers? A) SELECT CUSTOMER-Name AND CUSTOMER-PhoneNum B) SELECT (CUSTOMER-Name AND CUSTOMER-PhoneNum) C) SELECT Name, PhoneNum D) SELECT (Name, PhoneNum) E) SELECT *

C) SELECT Name, PhoneNum

Which SQL keyword is used to specify a condition that rows must meet to be included in the results of an SQL SELECT query? A) SELECT B) FROM C) WHERE D) ORDER BY E) GROUP BY

C) WHERE

Given the table CUSTOMER(CustID, Name, PhoneNum, AcctBalance), what is the standard SQL query phrase to retrieve data for customers with an account balance greater than 50? A) WHERE CUSTOMER-AcctBalance > 50 B) WHERE (CUSTOMER-AcctBalance > 50) C) WHERE AcctBalance > 50 D) WHERE (AcctBalance > 50) E) HAVING AcctBalance > 50

C) WHERE AcctBalance > 50

Which symbol is used in standard SQL as a wildcard to represent a single, unspecified character? A) % (percent sign) B) ! (exclamation mark) C) _ (underscore) D) ? (question mark) E) ; (semi-colon)

C) _ (underscore)

Which of the following data types used in SQL would define a numeric field of the pattern 99.99? A) integer(2,2) B) integer(5,2) C) numeric(2,2) D) numeric(4,2) E) numeric(5,2)

C) numeric(2,2)

The order of the columns returned by an SQL SELECT statement are determined by the: A) ORDER BY clause. B) SORT BY clause. C) order they are listed in following SELECT. D) order they are listed in following WHERE. E) order they are listed in following FROM.

C) order they are listed in following SELECT.

Which SQL keyword is used to eliminate duplicate rows in the results of an SQL SELECT query? A) UNIQUE B) SORT C) ORDER BY D) DISTINCT E) REDUCE

D) DISTINCT

Which of the following standard SQL data types is not supported in Microsoft Access SQL? A) Integer B) Char(25) C) VarChar(35) D) Numeric(5,3) E) DateTime

D) Numeric(5,3)

Which of the following is the correct SQL clause to restrict the results of a SELECT query to only records that have a value in the range of 10 to 50 in the Hours column? A) WHERE Hours = MIN(10) and MAX(50) B) WHERE Hours IN [10, 50] C) WHERE Hours = 10 and Hours = 50 D) WHERE Hours BETWEEN 10 AND 50 E) WHERE Hours RANGE 10 TO 50

D) WHERE Hours BETWEEN 10 AND 50

Conditions after the WHERE require single quotes around the values for columns that have which data type? A) Char B) VarChar C) Integer D) Numeric E) Both A and B

E) Both A and B

Which of the following SQL commands would be used to remove only the data from a table named STUDENT while leaving the table structure intact? A) DROP TABLE STUDENT; B) DELETE TABLE STUDENT; C) REMOVE TABLE STUDENT; D) SELECT * FROM STUDENT THEN DROP; E) DELETE FROM STUDENT;

E) DELETE FROM STUDENT;

Which SQL keyword can be used in conjunction with wildcards to select partial values? A) SELECT B) SEARCH C) FIND D) SUBSTRING E) LIKE

E) LIKE

Given the tables STUDENT(StudentID, StudentName, AdvisorID) and ADVISOR(AdvisorID, AdvisorName, Office, Phone), which of the following SQL statements would be used to implant a join between the two tables? A) WHERE STUDENT MATCH ADVISOR B) WHERE STUDENT.AdvisorID MATCH ADVISOR.AdvisorID C) WHERE STUDENT = ADVISOR D) WHERE STUDENT JOIN ADVISOR E) WHERE STUDENT JOIN ADVISOR ON STUDENT.AdvisorID = ADVISOR.AdvisorID

E) WHERE STUDENT JOIN ADVISOR ON STUDENT.AdvisorID = ADVISOR.AdvisorID

To open a new Microsoft Access Query window: A) click the New button on the Home command tab. B) click the New Query button on the Home command tab. C) click the Create Query button on the Create command tab. D) click the New Query in Design view button on the Create command tab. E) click the Query Design button on the Command tab.

E) click the Query Design button on the Command tab.

Microsoft Access SQL commands are run in: A) the SQL window. B) the QBE window. C) the Query View of an SQL window. D) the Design View of a Query window. E) the SQL View of a Query window.

E) the SQL View of a Query window.