RRB JE (IT) : DBMS fundamentals Quiz 2

Attempt now to get your rank among 285 students!

Question 1

The reservation system of Indian railways is an example of

• Atransaction processing system
• Binteractive decision support system
• Cmanagement controls system
• Dexpert system

Question 2

The term physical data independence is defined as:

• AIf we modify the middle level schema, then any one schema is modified.
• BIf we modify conceptual schema then there is no need to modify the external schema.
• CIf we modify conceptual schema then there is no need to modify the physical schema.
• DIf we modify physical schema then there is no need to modify the conceptual schema.

Question 3

The NULL values in a database can be interpreted as:

• AData is missing
• BData is not known
• CData is not applicable
• DAll of the above

Question 4

A relation R with 5 attributes Given the following FDs

Find the number of candidates keys that includes attribute

• A3
• B6
• C7
• D8

Question 5

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

• AWeak entities can be deleted automatically when their strong entity is deleted.
• BWeak entity set avoids the data duplication and consequent possible inconsistencies caused by duplicating the key of the strong entity.
• CA weak entity set has no primary keys unless attributes of the strong entity set on which it depends are included.
• DTuples in a weak entity set are not partitioned according to their relationship with tuples in a strong entity set.

• 285 attempts
• 0 upvotes
• 2 comments