Exam (elaborations)

DBI202 Exam Practice Questions and Answers Updated 2024

0 view 0 purchase

Course
2024/2025

Institution
2024/2025

DBI202 Exam Practice Questions and Answers Updated 2024 Which of the following statement is belong to DML? Select one: a. CREATE b. INSERT c. GRANT d. ALTER - Answer-b Suppose a relation R(A,B) and S(B,C) are bags. R has 2 tuples (1,3), (2,4) and S has 3 tuples (1,2), (1,2) and (4,5). The ...

[Show more]

Preview 4 out of 36 pages

View example

Uploaded on October 16, 2024
Number of pages 36
Written in 2024/2025
Type Exam (elaborations)
Contains Questions & answers

dbi202 exam practice questions and answers updated

Institution 2024/2025
Course 2024/2025

$12.49

Added

Add to cart Add to wishlist

100% satisfaction guarantee
Immediately available after payment
Both online and in PDF
No strings attached

EMILLECT 2024/2025 ACADEMIC YEAR ©2024 EMILLECT. ALL RIGHTS RESERVED FIRST PUBLISH OCTOBER, 2024

DBI202 Exam Practice Questions and
Answers Updated 2024

Which of the following statement is belong to DML?

Select one:

a. CREATE

b. INSERT

c. GRANT

d. ALTER - Answer✔✔-b

Suppose a relation R(A,B) and S(B,C) are bags. R has 2 tuples (1,3), (2,4) and S has 3 tuples (1,2),

(1,2) and (4,5). The theta join R ⋈ R.B>S.B S has __________ tuples

Select one:

a. 2

b. 3

c. 6

d. 4 - Answer✔✔-d

Choose a right statement about high level design.

Page 1/36

,EMILLECT 2024/2025 ACADEMIC YEAR ©2024 EMILLECT. ALL RIGHTS RESERVED FIRST PUBLISH OCTOBER, 2024

Select one:

a. high level design is process of constructing a model of information used in an enterprise

based on a specific data model, but independent of a particular DBMS or other physical

considerations

b. High-level design describes exactly the information needs of the business

c. high level design is process translating the logical description of the data into technical

specifications for storing and retrieving data - Answer✔✔-b

Which of the followings is false about UML?

Select one:

a. None of the others

b. UML does not support the multi-way relationships

c. UML classes are sets of objects, with states and behaviors

d. UML supports the subclass structures - Answer✔✔-a

In __________, a key is composed of attributes, some or all of them belong to another entity

set

Select one:

a. Weak entity set

b. Sub class

Page 2/36

,EMILLECT 2024/2025 ACADEMIC YEAR ©2024 EMILLECT. ALL RIGHTS RESERVED FIRST PUBLISH OCTOBER, 2024

c. Super class

d. Supporting entity set - Answer✔✔-a

Which of the following statements is valid?

Select one:

a. If A->->B, B->->C hold in relation R, then A->->C holds, too

b. If A->->B, B->C hold in relation R, then A->->C holds, too

c. If A->B, B->->C hold in relation R, then A->->C holds, too

d. All of the others - Answer✔✔-d

Which of the followings is TRUE about E/R model?

Select one:

a. Attributes are associated to both entity sets and relationship types

b. Attributes cannot have the same name in the same entity set

c. Attributes are very simple types, e.g. integers or character strings

d. All of the others - Answer✔✔-d

Which of the following statements is correct about weak entity set?

Select one:

a. Weak entity set can have only one supporting relationship

Page 3/36

, EMILLECT 2024/2025 ACADEMIC YEAR ©2024 EMILLECT. ALL RIGHTS RESERVED FIRST PUBLISH OCTOBER, 2024

b. None of the others

c. Weak entity set can not have more than one supporting entity set

d. The key of weak entity set includes all key attributes from supporting entity sets - Answer✔✔-

d

What often is used to describe about data model?

Select one:

a. All of others

b. Structure of data

c. Constraints

d. Operations on data - Answer✔✔-a

Suppose relation R(A,B,C,D,E), and set of FD's S={ A -> D, BD -> E}. Which of the followings is a

key of R?

Select one:

a. AB

b. ABC

c. ABCD

d. A - Answer✔✔-b

Page 4/36

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 Emillect. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $12.49. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

75632 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

Popular Universities in the United States

Popular books

Find notes and summaries for these qualifications