Database [3i Infotech Placement]: Sample Questions 110 - 112 of 294

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 110

Database

Question

MCQ▾

Tables derived from the ERD

Choices

Choice (4)

a.

May have multi-valued attributes

b.

Are totally normalised

c.

Are always in 1NF

d.

Can be further demoralised

Answer

c.

Explanation

1st Normal From example.

Table Shows the Product ID and Price
Product IDColorPrice
1Red, green15
2Yellow22
3Green17
4Yellow, blue10
5red25
  • This table is not in first normal form because the [color] column can contain multiple values
  • For ex. The first row includes value “red” and “green” .
  • To bring this table to first normal form, we split the table into two tables.
Table Shows the Product ID and Price
Product IDPrice
115
222
317
410
525
Table Shows the Product ID and Color
Product IDColor
1Red
1Green
2Yellow
3Green
4Yellow
4Blue
5red

Question 111

Database
Edit

Write in Short

Short Answer▾

What are the primitive operations common to all record management systems?

Explanation

Addition, deletion and modification are the primitive operations common to all record management systems.

Question 112

Database
Edit

Describe in Detail

Essay▾

What are the different phases of transaction?

Explanation

Understanding of 3 Phase of Transaction

Basically, 3 phase of transaction:

  • Analysis phase
  • Redo phase
  • Undo phase

Analysis phase:

  • Analysis phase is to find the best LSN starting from which rolling forward can be done during redo phase.

Redo:

  • Redo is the phase during which the changes caused by active transactions are hardened onto Data files.

Undo:

  • Undo is the phase where in, rolling back of the active transactions for consistency, takes place.

Developed by: