Database Concepts

Front 1

1) SQL is a data sublanguage, not a complete programming language.

Back 1

True

Front 2

2)When using SQL to create a table, a column is defined by declaring, in the following order, the items: data type, column name, and properties.

Back 2

False

Front 3

3) When using SQL to create a table, specifying the NULL property for a column indicates that only null values may be stored in that column.

Back 3

False

Front 4

4)When using SQL to create a table, specifying a data type of Char(10) indicates a fixed length field of 10 characters.

Back 4

True

Front 5

5)For a column to be defined as the primary key using table constraints, the column must have been given the property NULL.

Back 5

false

Front 6

6)If you need to create a primary key that is a composite key using SQL, the key may be defined when the table is created using the CREATE TABLE statement.

Back 6

True

Front 7

7)Referential integrity constraints can be created using the ON DELETE phrase when the table is created using the CREATE TABLE statement.

Back 7

True

Front 8

8)Referential integrity constraints using the ON DELETE NO ACTION phrase must be explicitly stated when the table is created using the CREATE TABLE statement.

Back 8

false

Front 9

9)The result for SELECT statements in SQL is a relation unless the result is a single number.

Back 9

False

Front 10

10)To force the DBMS to remove duplicate rows from the results of a SQL SELECT query, the keyword DISTINCT must be used.

Back 10

True

Front 11

11)In SQL, the WHERE clause is used to specify which columns will be included in the result.

Back 11

false

Front 12

12)In SQL, to refer to a range in a WHERE clause, use the WITHIN keyword.

Back 12

false

Front 13

13)In SQL, the LIKE keyword can be used to select partial values.

Back 13

True

Front 14

14)In SQL, the order of the rows that result from a SELECT statement can be set using the SORT BY phrase.

Back 14

False

Front 15

15)The SUM built-in function in SQL is used to total the values in a numeric column.

Back 15

True

Front 16

16)Standard SQL does not allow built-in functions to be used in a WHERE clause.

Back 16

True

Front 17

17)Data from a maximum of three tables can be combined through the use of subqueries in SQL.

Back 17

false

Front 18

18)A subquery is appropriate if the final result contains only data from a single table.

Back 18

True

Front 19

19)The basic idea of a join is to combine the contents of two or more relations into a new relation.

Back 19

True

Front 20

20)Using standard SQL, unmatched rows will not appear in the result of a join.

Back 20

true

Front 21

21)Values of existing data can be changed using SQL through the CHANGE command.

Back 21

False

Front 22

22)The ON DELETE CASCADE referential integrity constraint does not apply when rows are deleted using the SQL DELETE command.

Back 22

false

Front 23

23)Which of the following data types used in SQL would define a fixed-length text field of 10 characters? 23) _______

Back 23

B)char(10)

Front 24

24)Which of the following data types used in SQL would define a numeric field of the pattern 99.99? 24) _______

Back 24

B)numeric(4,2)

Front 25

25)Which of the following is not a standard data type used in SQL? 25)

Back 25

B)text

Front 26

26)Which of the following is not true about primary keys? 26) _______

Back 26

D)Primary keys must be a single attribute.

Front 27

27)A composite primary key can be defined using the CONSTRAINT phrase in which SQL command? 27) _______

Back 27

D)CREATE TABLE

Front 28

28)Which of the following cannot be done using the CONSTRAINT phrase? 28)

Back 28

D)All of A, B and C can be done using the CONSTRAINT phrase.

Front 29

29)Which of the following SQL commands would be used to remove both the data and the table structure of a table named STUDENT? 29) _______

Back 29

B)DROP TABLE STUDENT;

Front 30

30)The order of the columns returned by a SQL SELECT statement are determined by the: 30) _______

Back 30

E)order they are listed in following SELECT.

Front 31

31)Which SQL keyword is used to eliminate duplicate rows in the results of a SQL SELECT query? 31) _______

Back 31

D)DISTINCT

Front 32

32)Which SQL keyword is used to specify a condition that rows must meet to be included in the results of an SQL SELECT query? 32) _______

Back 32

B)WHERE

Front 33

33)Conditions after the WHERE keyword require single quotes around the value for columns that have which data type? 33) _______

Back 33

A)Integer
B)VarChar

Front 34

34)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? 34) _______

Back 34

E) WHERE Hours BETWEEN 10 AND 50

Front 35

35)Which symbol is used in standard SQL as a wildcard to represent a single, unspecified character? 35) _______

Back 35

A)_ (underscore)

Front 36

36)Which symbol is used in standard SQL as a wildcard to represent a series of one or more unspecified characters? 36) _______

Back 36

C)% (percent sign)

Front 37

37)Which SQL keyword can be used in conjunction with wildcards to select partial values? 37) _______

Back 37

C) LIKE

Front 38

38)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?

Back 38

E)ORDER BY Department DESC

Front 39

39)Which of the following is not one of the five SQL built-in functions?

Back 39

A) MODE

Front 40

40) Given the table CUSTOMER(CustID, Name, PhoneNum, AcctBalance), what is the standard SQL query phrase to retrieve the Name and Phone Number of customers?

Back 40

B) SELECT Name, PhoneNum

Front 41

41)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?

Back 41

E)WHERE AcctBalance > 50

Front 42

42)Which SQL keyword is used to apply conditions to restrict groups that appear in the results of a SELECT query that uses GROUP BY?

Back 42

B)HAVING

Front 43

43)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?

Back 43

D) OUTER JOIN

Front 44

44)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?

Back 44

A) INSERT INTO STUDENT (New Student Data) VALUES (123,'Jones','Smith');

Front 45

45)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?

Back 45

B)UPDATE STUDENT SET Advisor = 'Smith';

Front 46

46)_ Structured Query Language , or SQL, is not a complete programming language, but is rather a ________.

Back 46

Structured Query Language; data sublanguage

Front 47

47)SQL was developed by the ________ in the late 1970s.

Back 47

IBM Corporation

Front 48

48)The keyword(s) ________ means that a value must be supplied before a new row can be created

Back 48

48)NOT NULL

Front 49

49)A data type ________ would indicate a variable-length character with maximum length 75.

Back 49

49)VarChar(75)

Front 50

50)A data type ________ means that values consist of seven decimal numbers with two numbers assumed to the right of the decimal point

Back 50

50)Numeric(7,2)

Front 51

51)One way to specify all of the columns of a table is to use the special character * after the keyword ________.

Back 51

51)SELECT

Front 52

52)Conditions after the ________ require quotes around values for Char and VarChar columns, but no quotes for Integer and Numeric columns.

Back 52

52)WHERE

Front 53

53)Multiple tables can be queried using either subqueries or ________.

Back 53

53)joins

Front 54

54)When using SQL, there are three data modification operations: ________, ________,and ________.

Back 54

54)INSERT; MODIFY; DELETE

Front 55

55)The values of existing data can be modified using the powerful SQL ________ command, which can be used to change several column values at once.

Back 55

55)UPDATE

Front 56

61)Given the table CUSTOMER(CustID, Name, PhoneNum, AcctBalance), write the standard SQL query to retrieve the Name and Phone Number of customers with a balance greater than 50.

Back 56

61) SELECT Name, PhoneNum
FROM CUSTOMER
WHERE AcctBalance > 50;

Front 57

62)Given the table CUSTOMER(CustID, Name, PhoneNum, AcctBalance), write the standard SQL query to retrieve the Name and Phone Number of customers whose name begins with 'S'.

Back 57

62) SELECT Name, PhoneNum
FROM CUSTOMER
WHERE Name LIKE 'S%';

Front 58

63)What are SQL built-in functions?

Back 58

63)SQL built-in functions manipulate the results of a SQL SELECT statement. The built-in functions for standard SQL are COUNT, SUM, AVG, MAX, and MIN. The COUNT function counts the number of rows in the result. The SUM function totals the values in a number-oriented field. The AVG function calculates the mean of the values in a number-oriented field. The MAX function determines the highest value, and the MIN function determines the lowest value, in a number-oriented field.

Front 59

64)Distinguish between the HAVING clause and the WHERE clause.

Back 59

64)The HAVING clause and the WHERE clause differ in that the WHERE clause is used to identify rows that satisfy a stated condition. The HAVING clause is used to identify groups,