DBI202 FINAL EXAM REAL EXAM QUESTIONS AND CORRECT ANSWERS (NEWEST VERSION)
3 views 0 purchase
Course
DBI202
Institution
DBI202
DBI202 FINAL EXAM REAL EXAM QUESTIONS AND CORRECT ANSWERS (NEWEST VERSION)
Which of the followings is false about weak entity set?
Choose one answer.
a. Every many - one relationship from a weak entity set need be supporting
b. The key for a weak entity set includes the keys for all suppo...
DBI202 FINAL EXAM REAL EXAM
QUESTIONS AND CORRECT
ANSWERS (NEWEST VERSION)
Which of the followings is false about weak entity set?
Choose one answer.
a. Every many - one relationship from a weak entity set need be supporting
b. The key for a weak entity set includes the keys for all supporting entity sets
c. A weak entity set has one or more relationships to other (supporting) entity sets
d. Do not construct a relation for any supporting relationship - Answer ✔ b. The key for a
weak entity set includes the keys for all supporting entity sets
Which of following feature is NOT responsibility of Database Management System
Choose one answer.
a. Manage user accounts of computer on which DBMS is running
b. Give users the ability to query the data
c. Allow users to create new databases and specify their schemas
d. Support the storage of very large amounts of data - Answer ✔ a. Manage user
accounts of computer on which DBMS is running
Given three relations: R(A,B,C), S(D,E) and T(F,G). There are two referential integrity
constraints: D of S references to A of R, E of S references to F of T. Which of following
actions may violate these two constraints?
Choose one answer.
a. delete existing tuples from R
b. insert a new tuple into S
c. update existing tuples in S
d. all of the answers - Answer ✔ a. delete existing tuples from R
,Which of the followings is TRUE about E/R model?
Choose one answer.
a. Attributes are very simple types, e.g. integers or character strings
b. Attributes cannot have the same name in the same entity set
c. All of the others
d. Attributes are associated to both entity sets and relationship types - Answer ✔ c. All
of the others
In referential integrity constraint, the referenced attribute(s) must be __________ or
_________
Choose one answer.
a. Primary key, Foreign key
b. Primary key, Unique key
c. None of the others
d. Unique key, Foreign key - Answer ✔ b. Primary key, Unique key
In order to assure the durable property of the transactions. The DBMS needs the
_________
Choose one answer.
a. concurrency-control manager
b. storage manager
c. logging and recovery manager
d. transaction manager - Answer ✔ c. logging and recovery manager
Any Create command maybe reserved by using a __________ command
Choose one answer.
a. Rollback
b. Drop
c. Commit
, d. Delete - Answer ✔ c. Commit
Suppose the query 'SELECT R.* FROM R LEFT OUTER JOIN S ON R.A=S.A'. Which
of the followings returns the same result as this query does?
Choose one answer.
a. SELECT R.* FROM R JOIN S ON R.A=S.A
b. None of the others
c. SELECT R.* FROM S RIGHT OUTER JOIN R ON S.A=R.A
d. SELECT R.* FROM R FULL OUTER JOIN S ON R.A=S.A - Answer ✔ c. SELECT
R.* FROM S RIGHT OUTER JOIN R ON S.A=R.A
Choose right answer(s).
Choose one answer.
a. NULL value is unknown, inapplicable, or withheld
b. Arithmetic operators on NULL values will return a NULL value
c. Comparisons with NULL values will return UNKNOWN
d. All of the others. - Answer ✔ d. All of the others.
Given the relation Movies(title, year, length, genre, studioName). Select the right query
to create a View with the titles and studio names of all movies that were produced in
1980
Choose one answer.
a. None of the others
b. CREATE VIEW OldMovies SELECT title, studioName FROM Movies WHERE
year=1980
c. CREATE VIEW OldMovies AS SELECT title, studioName FROM Movies WHERE
year=1980
d. CREATE VIEW OldMovies SELECT title, year FROM Movies WHERE year=1980 -
Answer ✔ c. CREATE VIEW OldMovies AS SELECT title, studioName FROM Movies
WHERE year=1980
Suppose two relations Movies(title, year, length, genre, studioName, producerC#) and
MovieExec (name, address, cert#).Evaluate the following SQL statement: SELECT
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 Scholarsstudyguide. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.09. You're not tied to anything after your purchase.
