Databases Exam 1 - Quizzes

Enabling different data points to relate to one another... A. Requires the use of a GO statement. B. Is one of the core functions of a database. C. Is beyond the scope of an introductory database class. D. Can only be handled through multivariate analysis.

B

A "primary key" is... A. Required for each record. B. Only necessary if there is a foreign key. C. Repeated for similar records within a table. D. Another word for "table".

A.

When joining tables... A. It is necessary to match the foreign key in one table to the primary key in another within the query. B. You can't join more than two tables in any one query. C. You do not need to have a FROM clause. D. The foreign key and primary key must be matched in the WHERE clause.

A.

When there is a relationship between records in two different tables... A. The mandatory side donates its key to the many side. B. The mandatory side key is given to the many side and the many side key is given to the mandatory side. C. The one side receives a key from the mandatory side. D. The many side key is combined with the mandatory side key.

A.

Which of the following is not a clause in a SELECT query? A. SORT BY B. WHERE C. SELECT D. GROUP BY

A.

Assuming that the table and fields referenced are valid, which of the following queries have appropriate syntax and would work without error? A. SELECT PlayerNumber, PlayerName, Weight WHERE Weight > 100 FROM Roster; B. SELECT PlayerName, Position, Height FROM Roster WHERE Height > 63 ORDER BY Position; C. SELECT PlayerName, Gender, Position WHERE Position = 'Seeker' SORT BY PlayerName ASC; D. SELECT PlayerName, Hometown FROM Roster WHERE Hometown IS 'Pittsburgh'

B.

Using a database that includes information about every opera ever written, I want to write a query that displays information only about those operas that were written prior to the year 1825. To do this, I would use which of the following? A. @ operator B. WHERE clause C. SORT BY clause D. HAVING clause

B.

Which of the following WHERE clauses would include only those records from the Customer table where the customer's last name (the LastName field) starts with Y and the customer's birthday (DOB field) falls some time after 1994? A. WHERE LastName STARTS WITH 'Y' AND DOB >= '1/1/1994' B. WHERE LastName LIKE 'Y%' AND DOB > '1994-12-31' C. WHERE (LastName IS 'Y%') AND (DOB >= '1994-01-01') D. WHERE LastName LIKE 'Y' AND DOB > 1994-12-31

B.

Databases... (Select all/any that apply.) A. Organize data into categories, called "buckets", and sub-categories, called "nests". B. Generally only include one table. C. Rely on primary and foreign keys to relate records from different tables. D. Can have no more than one primary key. E. Should only contain a few records before being split off into an additional database.

C.

In a company's database, a given table... A. Usually consists of many sub-tables. B. Primarily consists of incremental, sequenced numbers. C. Can include millions of records. D. Should have multiple primary keys, since these are often changed.

C.

Which of the following WHERE clauses would include only those records in the output where the value in the Destination field is something OTHER than Norman? A. WHERE Destination =/= 'Norman' B. WHERE Destination != 'Norman' C. WHERE Destination <> 'Norman' D. WHERE Destination NOT 'Norman'

C.

What is the order of execution of the SELECT statement? A. SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY B. SELECT, GROUP BY, WHERE, HAVING, FROM, ORDER BY C. FROM, SELECT, WHERE, GROUP BY, HAVING, ORDER BY D. FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY

D.

Which of the following WHERE clauses would include only those records in the output for which the value of UniformNumber is 1, 3, 5, or 7? A. WHERE UniformNumber < 8 B. WHERE UniformNumber NOT IN (2, 4, 6, 8) C. WHERE UniformNumber = 1, 3, 5, 7 D. WHERE UniformNumber IN (1, 3, 5, 7)

D.

A company includes information about its customers in a database table called Customer. Each line within this table includes a customer's name, phone number, address, and date of birth. These lines are called...

Records