Crowdly

Add to Chrome

Universities
moodle.spit.ac.in
MDM-DBMS

MDM-DBMS

Looking for MDM-DBMS test answers and solutions? Browse our comprehensive collection of verified answers for MDM-DBMS at moodle.spit.ac.in.

Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!

A degree in an entity relationship model

is:

Indicate

the number of entities that a relationship associate

A collection of similar entities where each entity has the same set of

attributes containing different values

View this question

In the context of timestamp-ordering

protocol, which of the following must be correct?

If TS(Ti) > W-timestamp(Q), the operation is rejected and Ti is rolled

back.

If TS(Ti) < W-timestamp(Q), W-timestamp(Q) is set to TS(Ti).

If TS(Ti) < W-timestamp(Q), the

operation is rejected and Ti is rolled back.

If T S(Ti) ≥ R-timestamp(Q), the operation is rejected

View this question

A user

executes a query which the ___ in the system uses to generate the internal form

of the query. In addition to checking the syntax of the query, the ____

verifies the name of the relation in the database, then the tuple, then the

attribute value.

Translation

Optimization

Evaluation

Parser

View this question

______ is a collection data, contains

information relevant to an enterprise.

Database

DBMS

Data

View this question

File manager responsible for

manages

the allocation of space on disk storage

provide

fast access

fetching

data from disk storage in to main memory and deciding what data to cache in

memory.

View this question

Practical use of information is known as;

Information

Knowledge

View this question

Match the following

Derived Attribute

Null Attribute

Composite attribute

Multivalued Attribute

View this question

Which one of the following is NOT a part

of the ACID properties of database transactions?

Isolation

Durability

Concurrency

Atomicity

View this question

Identify the correct type of join which

returns all matched or unmatched rows from the tables.

FULL OUTER JOIN

EQUI JOIN

LEFT OUTER JOIN

View this question

c,d

a,b

b,c

View this question

Want instant access to all verified answers on moodle.spit.ac.in?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Add to Chrome

Telegram Instagram TikTok Question Bank