SER322: Fundamentals of Database Systems: Midterm study Exam And All Correct Answers.
6 vues 0 fois vendu
Cours
Fundamentals of Database Systems
Établissement
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:
Les avantages d'acheter des résumés chez Stuvia:
Qualité garantie par les avis des clients
Les clients de Stuvia ont évalués plus de 700 000 résumés. C'est comme ça que vous savez que vous achetez les meilleurs documents.
L’achat facile et rapide
Vous pouvez payer rapidement avec iDeal, carte de crédit ou Stuvia-crédit pour les résumés. Il n'y a pas d'adhésion nécessaire.
Focus sur l’essentiel
Vos camarades écrivent eux-mêmes les notes d’étude, c’est pourquoi les documents sont toujours fiables et à jour. Cela garantit que vous arrivez rapidement au coeur du matériel.
Foire aux questions
Qu'est-ce que j'obtiens en achetant ce document ?
Vous obtenez un PDF, disponible immédiatement après votre achat. Le document acheté est accessible à tout moment, n'importe où et indéfiniment via votre profil.
Garantie de remboursement : comment ça marche ?
Notre garantie de satisfaction garantit que vous trouverez toujours un document d'étude qui vous convient. Vous remplissez un formulaire et notre équipe du service client s'occupe du reste.
Auprès de qui est-ce que j'achète ce résumé ?
Stuvia est une place de marché. Alors, vous n'achetez donc pas ce document chez nous, mais auprès du vendeur TestSolver9. Stuvia facilite les paiements au vendeur.
Est-ce que j'aurai un abonnement?
Non, vous n'achetez ce résumé que pour €10,13. Vous n'êtes lié à rien après votre achat.
