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
