MGSC 394 Test 1

Why do we try to avoid data redundancy when designing tables? Select those that apply ​ A. Creates maintenance problems B. Can cause data inconsistency​ C. Decreases efficiency of database​ D. One large table is preferred over multiple tables

A. Creates maintenance problems B. Can cause data inconsistency​ C. Decreases efficiency of database​

Which design is better for storing names in a database? A. Have separate fields for each part of the name: First Name, Last Name, Salutation B. Place the entire name in one field.

A. Have separate fields for each part of the name: First Name, Last Name, Salutation

What does SQL stand for? A. Structured Query Language B. Strong Question Language C. Structured Question Language

A. Structured Query Language

When you save a query, you are actually saving which of the following? A. The query design (SQL Code) B. The query results C. Both D. Neither

A. The query design

Which of the following exemplifies the best notation for an access query? A. qryProductID B. QRYproductid C. QRYPRODUCTID D. qryPRODUCTID

A. qryProductID

Which operator is used to select values within a range? A. RANGE B. BETWEEN C. WITHIN

B. BETWEEN

Find two reasons we might want to use comments in SQL. A. Can comment out required clauses to help with debugging B. Can comment out optional clauses to help with debugging C. Make notes to yourself and others

B. Can comment out optional clauses to help with debugging C. Make notes to yourself and others

Fill in the missing word below so that SQL will return values for Country without any duplicates (each Country will only be listed one time). SELECT __________ Country FROM Orders; A. UNIQUE B. NODUP C. DISTINCT D. COUNT

C. DISTINCT

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"? A. SELECT * FROM Persons WHERE FirstName LIKE '%a' B. SELECT * FROM Persons WHERE FirstName='%a%' C. SELECT * FROM Persons WHERE FirstName LIKE 'a%'

C. SELECT * FROM Persons WHERE FirstName LIKE 'a%'

In Access, you can create a new query from which of the following? A. Tables only B. Queries only C. Tables or queries

C. Tables or queries

A Totals query can be used find the ___________ for a field. A. Sum B. Average C. Min D. Any of the Above

D. Any of the Above

Action queries can be undone TRUE FALSE

FALSE

When you create a relationship between tables in Access, the linking fields are required to have the same data type. TRUE FALSE

FALSE

When you create a relationship between tables in Access, the linking fields are required to have the same names. TRUE FALSE

FALSE

When you filter out certain records, you delete the records from the table. TRUE FALSE

FALSE

In order for a Crosstab query to run, which three of the following must be specified? Choose all three. A. Row Heading B. Column Heading C. Parameter D. Value

A,B, and D (Row Heading, Column Heading and Value)

What field needs go in the blank? SELECT City, COUNT(Orders.OrderID) AS [Number of Orders] FROM Orders INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID GROUP BY ____________; A. City B. Orders C. OrderID D. CustomerID

A. City

Which of the following most closely follows the principles of database design? A. Divide your data into multiple tables where each table focuses on one subject. Tables link together based on a common field. B. Find a way to store all of your data into one table C> Divide your data into multiple tables where each table focuses on one subject. Never use the same field in more than one table.

A. Divide your data into multiple tables where each table focuses on one subject. Tables link together based on a common field.

Which of the following are properties of a primary key? A. It is a value that does not change B. Must be at least 4 digits C. Must be different for each record D. Every record in the table must have one

A. It is a value that does not change C. Must be different for each record D. Every record in the table must have one

Which operator is used to search for a specified pattern in a column? A. LIKE B. GET C. FROM

A. LIKE

Which of the following are Access objects? A. Queries B. Tables C. Forms D. Fields

A. Queries B. Tables C. Forms

With SQL, how can you return the number of records in the "Persons" table? A. SELECT COUNT(*) FROM Persons B. SELECT COLUMNS(*) FROM Persons C. SELECT LEN(*) FROM Persons

A. SELECT COUNT(*) FROM Persons

Which SQL statement is used to return only different values? A. SELECT DISTINCT B. SELECT UNIQUE C. SELECT DIFFERENT

A. SELECT DISTINCT

In the Online SQL editor, which statement would return all records where the "firstname" starts with an "R"? A. Select * FROM Customers WHERE firstname like "R%"; B. Select * FROM Customers WHERE firstname like "R_"; C. Select * FROM Customers WHERE firstname like "%R%"; D. Select * FROM Customers WHERE firstname like "_R_";

A. Select * FROM Customers WHERE firstname like "R%"

Which of the following specifies conditions that apply to fields that are summarized (aggregated) in the SELECT statement? A. WHERE B. HAVING C. GROUP BY D. ON

B. HAVING

Which SQL statement is used to extract data from a database? A. EXTRACT B. SELECT C. OPEN

B. SELECT

With SQL, how do you select all the columns from a table named "Customers"? A. SELECT *.Customers B. SELECT * FROM Customers C. SELECT Customers

B. SELECT * FROM Customers

With SQL, how do you select all the columns from a table named "Persons"? A. SELECT *.Persons B. SELECT * FROM Persons C. SELECT Persons

B. SELECT * FROM Persons

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"? A. SELECT * FROM Persons WHERE FirstName<>'Peter' B. SELECT * FROM Persons WHERE FirstName='Peter' C. SELECT [all] FROM Persons WHERE FirstName='Peter

B. SELECT * FROM Persons WHERE FirstName='Peter'

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"? A. SELECT FirstName='Peter', LastName='Jackson' FROM Persons B. SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson' C. SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'

B. SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

With SQL, how do you select a column named "City" from a table named "Customers"? A. SELECT City.Customers B. SELECT City FROM Customers C. EXTRACT City FROM Customers

B. SELECT City FROM Customers

In the SQL online editor, which SQL statement would return all records where the "firstname" starts with an "R"? A. Select * FROM Customers WHERE firstname like "R_"; B. Select * FROM Customers WHERE firstname like "R%"; C. Select * FROM Customers WHERE firstname like "%R%";

B. Select * FROM Customers WHERE firstname like "R%";

Which of the following is not a type of join that we covered in class? A. Left outer join B. Unequal join C. Right outer join D. Inner join

B. Unequal join

Suppose an Access table contains a field for ProductName. One of the product names has changed. Which type of query would be the best option to change all of the appropriate records to the new product name? A. Parameter Query B. Update Query C. Select Query D. Export Query

B. Update Query

In the Online SQL editor we used in class, when was SQL case sensitive? A. Never B. When using "=" C. When using "Like"

B. When using "="

When sorting three adjacent columns simultaneously in Access, which of the following occurs? A. You cannot select 3 columns in access B. The left most column recieves priority in sorting C. The right most column receives priority in sorting

B. the left most column receives the priority in sorting

What word is missing? SELECT Country, COUNT(Orders.OrderID) AS [Number of Orders] FROM Orders INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID GROUP BY Country _________COUNT(Orders.OrderID) > 10 ORDER BY Customers.Country, Orders.CustomerID; A. WHERE B. AS C. HAVING D. ON

C. HAVING

What is the most common type of join? A. INSIDE JOIN B. JOINED TABLE C. INNER JOIN

C. INNER JOIN

Which of the following is used to specify the linking fields in a join? A. LINK B. RELATED C. ON D. AS

C. ON

Which SQL keyword is used to sort the result-set? A. SORT BY B. ORDER C. ORDER BY D. SORT

C. ORDER BY

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"? A. SELECT * FROM Persons SORT 'FirstName' DESC B. SELECT * FROM Persons ORDER FirstName DESC C. SELECT * FROM Persons ORDER BY FirstName DESC

C. SELECT * FROM Persons ORDER BY FirstName DESC

With SQL, how do you select a column named "FirstName" from a table named "Persons"? A. EXTRACT FirstName FROM Persons B. SELECT Persons.FirstName C. SELECT FirstName FROM Persons

C. SELECT FirstName FROM Persons

When creating a parameter query, which of the following expressions is the correct syntax to prompt the user to Enter the Maximum List Price? A. "Enter the Maximum List Price" B. (Enter the Maximum List Price) C. [Enter the Maximum List Price] D. {Enter the Maximum List Price}

C. [Enter the Maximum List Price]

What is the key feature of a relational database? A. There are multiple tables​ B.Entities are in rows and variables are in columns​ C. Tables contain related information D. There is a way to link between different tables​

D. There is a way to link between different tables​

Modifying data in a query does not affect the data in the table that was the source of the query. TRUE FALSE

FALSE

After you add a calculated field to a table, the calculation is done each time you add or change data. TRUE FALSE

TRUE

In Access, Null and a pair of quotes "" mean different things. TRUE FALSE

TRUE

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true TRUE FALSE

TRUE

When selecting an asterisk while building a query, all fields in the table are included in said query TRUE FALSE

TRUE

When working with a relational database in Access, it is best practice to set up the relationships between the tables under "Database Tools" before running queries or other analyses. TRUE FALSE

TRUE