31 May BIS 345 Final Exam Guide Set 2 NEW
1. (TCO 1) Which of the following portions of an SQL Statement indicate the columns that should be included in the result set?(Points : 5)
SELECT
FROM
WHERE
INSERT
Question 2.2. (TCO 1) Which of the following operators uses wildcard characters to search for patterns or characters in a character string?(Points : 5)
SEARCH
LIKE
BETWEEN
EQUAL TO
Question 3.3. (TCO 1) Which of the following characters is used to merge the output of two columns into one? (Points : 5)
AND
PLUS
+
;
Question 4.4. (TCO 1) Which of the following would extract all rows containing the numbers 4 or 8? (Points : 5)
WHERE number = 4 or number = 8
WHERE number BETWEEN 4 and 8
WHERE number = ‘4 or 8’
Where number = ‘4’ or ‘8’
Question 5.5. (TCO 1) Assume you have a table called CourseTable. You would like to extract all courses that were developed in June and July of 2008. Which of the following operators would be of most use to you in your WHERE clause? (Points : 5)
BETWEEN
LIKE
IS NULL
None of the above
Question 6.6. (TCO 1) Given Professors table with LastName, FirstName, and MI fields, which of the following would select all fields from the table? (Points : 5)
SELECT * FROM Professors;
SELECT * Professors;
SELECT Last Name, First Name, MI FROM Professors;
SELECT * ALL
Question 7.7. (TCO 1) Which of the following would extract all rows containing the numbers 10 or 20? (Points : 5)
WHERE number BETWEEN 10 and 20
WHERE number = 10 or number = 20
WHERE number = ’10 or 20′
Where number = ’10’ or ’20’
Question 8.8. (TCO 3) Which of the following statements would extract the average price of all the products?
Assume you have a table with the following columns:
(Points : 5)
SELECT ProductID, Avg(UnitPrice)
FROM ProductTable
GROUP BYProductID;
SELECT Average(UnitPrice)
FROM ProductTable;
SELECT Avg(UnitPrice)
FROM ProductTable;
None of the above
Question 9.9. (TCO 3) Which of the following statements would the extract the total value of all the orders?
Assume you have a table with the following columns:
(Points : 5)
SELECT Total(OrderTotal)
FROM OrderTable;
SELECT Sum(OrderTotal)
FROM OrderTable;
SELECT Sum(OrderTotal)
FROM OrderTable
GROUP BY OrderTotal;
SELECT Rollup(OrderTotal)
FROM OrderTable;
Question 10.10. (TCO 4) Assume you have two queries. The first query selects its data using a join involving five tables. The second query selects its data using a join involving three tables. Which of the queries would run faster, all other things being equal? (Points : 5)
The first query will run slower than the second query.
The second query will run slower than the second query.
The queries will run at the same speed.
All of the above
Question 11.11. (TCO 4) Assume you have two select queries that must join two tables. The first query uses the INNER JOIN keyword, while the other accomplishes the join using the WHERE clause. Which query will be more likely to run faster – the first query or the second query? (Points : 5)
The first query will run slower than the second query.
The second query will run slower than the first query.
The queries will run at the same speed.
All of the above
Question 12.12. (TCO 7) Which of the following file formats are used to import data into SSRS. (Points : 5)
CSV
PDF
SLN
docx
Question 13.13. (TCO 8) Name the security concept involves ensuring that one person doesn’t have control over too many steps in a process.(Points : 5)
zroles
Separation of duties
Securing forms and reports
Using views
Question 14.14. (TCO 8) _____ is the process of creating ciphertext. (Points : 5)
Passcoding
Digital Certificate
Symmetric
Encryption
Question 15.15. (TCO 9) Which of the following reports requires the reader to look at data in both column and row format? (Points : 5)
Matrix
Exception
Tabular
None of the above
Question 16.16. (TCO 9) Assume you are creating a report which is sorted by class, and then by student within class. The class is considered the ____ column: (Points : 5)
gross
minor
major
None of the above
Question 17.17. (TCO 9) Which date function will return the difference between two dates in the specified units? (Points : 5)
DATEDIFFERENCE
DATEPART
DATEDIFF
DATEADD
Question 18.18. (TCO 10) Which of the following represent a popular report-writing tool that is not a Microsoft application? (Points : 5)
Access Reports
SSRS
SSMS
Crystal Reports
Question 19.19. (TCO 10) Which of the following is NOT one of the formats available for reports? (Points : 5)
XML
HTML
PDF
XPDF
Question 20.20. (TCO 2) Which date function will return the difference between two dates in the specified units? (Points : 5)
DATEDIFFERENCE
DATEPART
DATEDIFF
DATEADD
Question 21.21. (TCO 2) Which of the following functions would you use to extract the year, month, or day records in the database? (Points : 5)
Datepart
Datediff
Dateout
Dateyear
Question 22.22. (TCO 2) Which of the following functions would you use to extract characters from the middle of a string. (Points : 5)
Left()
Right()
Middle()
Substring()
Question 23.23. (TCO 3) Which of the following aggregate functions can be used with any data type. (Points : 5)
MAX
SUM
COUNT
AVG
Question 24.24. (TCO 5) When using the report server project wizard the most crucial step is _______. (Points : 5)
selecting your data source
naming your project
selecting the location to save your project
selecting the correct template
Question 25.25. (TCO 5) SSRS uses all of the following types of extensions except ______. (Points : 5)
data processing
security
delivery
communication
Question 26.26. (TCO 5) By default when we add a table to our report in Business Intelligence Development Studio, the table has _____ columns. (Points : 5)
2
3
4
5
Question 27.27. (TCO 5) You can use the ______ in Business Intelligence Development Studio to access the report items controls. (Points : 5)
Design tab
Toolbox
Toolbar
Preview tab
Question 28.28. (TCO 7) The chart control used in SSRS is licensed from ______ software. (Points : 5)
Dundas
Adobe
Apple
Google
Question 29.29. (TCO 7) ______ presents group data in a grid layout that’s capable of expanding both rows and columns. (Points : 5)
Table
Matrix
List
Dropdown
Question 30.30. (TCO 6) A ____ parameter are used during the processing of the query. (Points : 5)
Multidimensional Expressions (MDX)
query
report
Multivalue parameters
Question 31.31. (TCO 6) Which data source credentials option is considered an integrated security type. (Points : 5)
Prompt for credentials
Windows authentication
Hard-code credentials
No credentials
Question 32.32. (TCO 6) ______ data source is used to dynamically choose the data source at runtime. (Points : 5)
embedded
shared
unique
expression
Question 33.33. (TCO 3) Which of the following aggregate functions would not ignore null values. (Points : 5)
Count
AVG
MAX
Sum
Question 34.34. (TCO 3) Which of the following is not a valid aggregate function. (Points : 5)
DATEDIFFERENCE
COUNT
MAX
MIN
Question 35.35. (TCO 5) For the report server to use an extension, it must be ______. (Points : 5)
configured
linked to the server
added to the report
installed
36. (TCO 2) Refer to the tblCustomer table below. As a data analyst, you have been requested to select rows that meet the following requirements: For each city, list the city name in all upper case characters along with the exchange part of the customer phone number (the first 3 digits). Include only preferred
Part 1: Write the complete SQL statement needed to return the rows that meet these requirements.
Part 2: What rows will be returned from this query? List the customer ID only of the rows to be returned.
Part 3: What function did you use to extract the three-digit exchange? Why did you select this function? Rewrite the SQL using a different function to extract these characters. (Points : 25)
Part 3: To extract the three-digit exchange I used the LEFT(Phone,3) funcion.
37. (TCO 3) Refer to the tblCustomer table below. As a data analyst, you have been requested to select rows that meet the following requirements. For each city, list the name of the city, and the number of customers in that city. Include only those cities that have more than 1 customer in them. Order the data by city in descending order.
tblCustomer:
Part 1:
SELECT City, COUNT(*) FROM tblCustomer
GROUP BY City HAVING COUNT(*)>1
ORDER BY City DESC;
Part 2: Did you select any filter clause(s)? (WHERE, HAVING) Justify your choice of filter(s). (Points : 25)
38. (TCO 6) Evaluate the Supplier List report below. Management requested this report so they can monitor the value and quantity of the stock on hand; a requirement of the report is to be able to match the product to the supplier.
Part 1: Describe at least two enhancements that would make this report more readable to the user.
Part 1: The two enhancements I would make would be:
Part 2: Describe at least two features you would include that would add functionality to the report and improve its flexibility for the user. (Points : 25)
Part 2: If I had to include two features to add functionality to the report and improve its flexibility they would be:
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.