Exam (elaborations)
Itm Sql Exam Questions And Answers Latest Update 2024/2025
- Course
- Institution
Itm Sql Exam Questions And Answers Latest Update 2024/2025
[Show more]
Content preview
Itm Sql Exam Questions And Answers LatestUpdate 2024/2025
On a ranch a person can Owen many horses. However, each horse is owned by a single person. What
type of relationship do we see here? Answer: One to many (1: N)
Which of the following would be an example of predictive analytics? Answer: creating an analysis of
office supply expenses by month for the prior year to identify what costs may be for each month in the
upcoming year
Collecting information from many sources and storing them together into a single location is referred to
as Answer: data aggregation
Jeff is creating a database to track TV shows and actors. Actors can be in multiple shows and shows can
have multiple actors. Which of the following is a type of relationship and number of tables needed to
implement this in a relational database? Answer: n:m & 3 tables
Which of the following describes a speed of data? Answer: velocity
For every student MSU they have a unique identifier number which is known as the APID. What would
the APID likely be used for in a table MSU students? Answer: Primary key
A car dealership sells new cars to various individuals. However only a single new car can be sold to a
single individual. What kind of relationship would you have and how many tables? Answer: One to
many (1:n) / 2 tables
Zara is ready to buy a house so she decides to hire a real estate agent from East Lansing Realty. Each real
estate agent works with several customers and the agent receives a commission on the sale of each
house. However, East Lansing Realty has a policy that each customer can be assigned no more than one
, real estate agent. This is an example of what type of relationship between customer and agent?
Answer: 1:n
Text in a novel is an example of unstructured data Answer: True
Did we make a profit last year? Answer: Descriptive analytic
What will our sales be next quarter? Answer: Predictive analysis
Should we make or buy an expensive part for our machines? Answer: Prescriptive analysis
What functions are allowed to pull all the information from a single table? Answer: Right join and
left join
When using a joint statement you specified the table you were joining to the query. What other
information is needed for the statement to complete the join? Answer: Specifications of the fields
that join the tables
If the following joint statement is used to join two tables in a query, which of the following tables would
all of the tuples in the relation appear and results?
Left outer join schema.customers on invoices.customerID = customers.customerID Answer: Invoices
What wildcard is used to look for specific letters that is before or after a word? Answer: %
The AS function in SQL is used for: Answer: Renaming Columns
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Schoolflix. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $14.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
81113 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now