SER322: Fundamentals of Database Systems: Midterm study Exam And All Correct Answers.
6 views 0 purchase
Module
Fundamentals of Database Systems
Institution
Fundamentals Of Database Systems
Which SQL keyword is used to sort the result-set in descending order using the NAME column?
a. SORT BY NAME DESC
b. ORDER BY NAME DESC
c. ORDER DESC NAME
d. ORDER NAME DESC - Answer b. ORDER BY NAME DESC
The following keyword selects records that have matching values in both tables.
...
SER322: Fundamentals of Database
Systems: Midterm study Exam And All
Correct Answers.
Which SQL keyword is used to sort the result-set in descending order using the NAME column?
a. SORT BY NAME DESC
b. ORDER BY NAME DESC
c. ORDER DESC NAME
d. ORDER NAME DESC - Answer b. ORDER BY NAME DESC
The following keyword selects records that have matching values in both tables.
a. LEFT JOIN
b. INNER JOIN
c. RIGHT JOIN
d. SELF JOIN - Answer b. INNER JOIN
With SQL, how can you delete the records from "Students" table where the "LastName" is Williams.
a. DELETE ROW Students WHERE LastName ='Williams';
b. DELETE FROM Students WHERE LastName ='Williams';
c. DELETE Students WHERE LastName ='Williams';
d. DELETE TABLE Students WHERE LastName = 'Williams'; - Answer b. DELETE FROM Students WHERE
LastName ='Williams';
,How do you change the marks of all students in Students table with marks 65 to 70 with SQL.
a. UPDATE Students SET Marks=65 WHERE Marks = 70;
b. MODIFY Students SET Marks=70 WHERE Marks = 65;
c. UPDATE Students SET Marks=70 WHERE Marks = 65; - Answer c. UPDATE Students SET Marks=70
WHERE Marks = 65;
With SQL, how do you select all the records from a table named "Students" where the "FirstName" is
Jack and "Marks" are greater than 65?
a. SELECT * FROM Students WHERE 'FirstName'='Jack' AND 'Marks'>65;
b. SELECT * FROM Students WHERE 'FirstName'='Jack', 'Marks'>65;
c. SELECT * FROM Students WHERE FirstName='Jack' AND Marks>65; - Answer c. SELECT * FROM
Students WHERE FirstName='Jack' AND Marks>65;
Which SQL keyword is used to group rows with same values.
a. JOIN
b. ORDER BY
c. COMBINE
d. GROUP BY - Answer d. GROUP BY
_____ is an attribute (or a set of attributes) in a database relation that has a unique value.
a. Foreign Key
b. Super Key
c. Secondary Key
, d. Alternate Key - Answer Super Key
_____ constraint dictates that the foreign key must contain values that match the primary key in the
related table, or must contain null.
a. Domain
b. Key
c. Referential Integrity
d. Entity Integrity - Answer Referential Integrity
Consider the following relations for a database that keeps track of business trips of salespersons in a
sales office:
a. TripID in EXPENSE relation references TRIP relation; SSN in TRIP relation references SALESPERSON
relation
b. TripID in EXPENSE relation references TRIP relation
c. SSN in SALESPERSON relation
d. Account# in EXPENSE relation - Answer a. TripID in EXPENSE relation references TRIP relation;
SSN in TRIP relation references SALESPERSON relation
Consider the following relations for a database that keeps track of business trips of salespersons in a
sales office:
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 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 TestSolver9. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £8.38. You're not tied to anything after your purchase.
