3i Infotech Placement: Sample Questions 448 - 449 of 1245

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

Question 448

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 449

Edit

Write in Short

Short Answer▾

What is the output of the following program?

  1. voidmain ()
  2. {
  3.     staticinti =i ++, j =j ++, k =k ++;
  4.     printf (i =%dj =%dk =%d, i, j, k);
  5. }

Explanation

In the program

Table Shows the Program
static int i = i ++ , j = j ++ , k = k ++ ;Here given the static integer variable i, j and k.

Since static variables are initialized to zero by default.

Then the all variables post increment of i, j and k are 1

printf (i =% d j =% d k =% d, i, j, k) ;Printf prints the value of i = 1 , j = 1 and k = 1

Developed by: