100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
SER322: Fundamentals of Database Systems: Midterm study Exam And All Correct Answers. $10.29   Add to cart

Exam (elaborations)

SER322: Fundamentals of Database Systems: Midterm study Exam And All Correct Answers.

 6 views  0 purchase
  • Course
  • 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. ...

[Show more]

Preview 3 out of 23  pages

  • October 13, 2024
  • 23
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • Fundamentals of Database Systems
  • Fundamentals of Database Systems
avatar-seller
TestSolver9
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:



SALESPERSON (SSN, Name, Start_Year, Dept_No)



TRIP (TripID, SSN, From_City, To_City, Departure_Date, Return_Date)



EXPENSE (TripID, Account#, Amount)



Identify the foreign keys for this schema:



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

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

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

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 $10.29. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

81989 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$10.29
  • (0)
  Add to cart