MIST 4610 Multiple Choice Question and answers rated A+ 2024
5 views 0 purchase
Course
MIST 4610
Institution
MIST 4610
MIST 4610 Multiple Choice Question and answers rated A+ 2024 MIST 4610 Muilitple Choice
An instance is a particular occurrence of an attribute.
(A): True
(B): False - correct answer (B): False
An instance is a particular occurrence of an Entity.
What do Names of identifiers correspon...
MIST 4610 Muilitple Choice
An instance is a particular occurrence of an attribute.
(A): True
(B): False - correct answer ✔(B): False
An instance is a particular occurrence of an Entity.
What do Names of identifiers correspond to in a Table?
(A): Columns
(B): Primary Keys
(C): Entities
(D): Rows - correct answer ✔(B): Primary Keys
Which query returns the entire contents of a table?
(A): FROM Buses SELECT ALL;
(B): FROM Buses SELECT *;
(C): SELECT ALL Buses WHERE busNumber <> 0;
(D): SELECT ALL FROM Buses;
(E): SELECT * FROM Buses; - correct answer ✔(E): SELECT * FROM
Buses;
Is this statement true or false? "composite primary keys are represented by a
yellow pin".
(A): True
(B): False - correct answer ✔(B): False
,An entity is some thing in the organizational environment we want to keep
track of.
(A): True
(B): False - correct answer ✔(A): True
A Record is equivalent to which of the following in a Table?
(A): Entity
(B): Row
(C): Primary Key
(D): Column - correct answer ✔(B): Row
Which of the following is the purpose of data modelling?
(A): Removing Records
(B): Creating Transactions
(C): Cost Estimates
(D): Blueprint for a Database - correct answer ✔(D): Blueprint for a Database
John Doe deleted 1000 Records from a Table. Which of the following did he
remove?
(A): 1000 Columns
(B): 1000 Rows
(C): 1000 Entities
(D): 1000 Values - correct answer ✔(B): 1000 Rows
Can a WHERE clause contain multiple conditions?
(A): True
(B): False - correct answer ✔(A): True
, Which question is the below query answering?
SELECT SUM(amount)
FROM Payments JOIN CustomersON Customers.customerNumber =
Payments.customerNumber
WHERE country = 'Australia';
(A): List the payment amount for Australian customers
(B): Report the number of Australian customers with payments
(C): Report the number of payments received from Australian customers
(D): List the total payment amount received from customers in Australia -
correct answer ✔(D): List the total payment amount received from customers
in Australia
Which query lists the department name and the first name of employees of the
department?
(A): SELECT departmentName, employeeFName
FROM Department
JOIN Employees;
(B): SELECT departmentName, employeeFName
FROM Department
JOIN Employees ON Department.departmentID = Employees.employeeID;
(C): SELECT departmentName, employeeFName
FROM Department
JOIN Employees ON Department.departmentID = Employees.departmentID;
(D): SELECT departmentName, employeeFName
FROM Department
FROM Employees ON Department.departmentID = Employees.departmentID;
- correct answer ✔(C): SELECT departmentName, employeeFName
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 Academia199. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.99. You're not tied to anything after your purchase.