3i Infotech Placement: Sample Questions 329 - 330 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 329

Edit

Describe in Detail

Essay▾

What are normalization Rules? Define Normalization?

Explanation

Understanding the Process of Normalization
  • Normalization is process of organizing data in a database.
  • It organizes tables to reduce redundancy and dependency.
  • Redundant data wastes disk space and creates maintenance problems.
  • Data that exist in more than one place must be changed in same way in all locations.
  • For example, a customer address change is much easier to implement if that data is stored only in the customers table and nowhere else in the database.

Rules of database Normalization:

  • There are a few rules for database normalization.
  • Each rule is called a “normal form” .
  • If the first rule is observed, the database is said to be in “first normal form.”
  • If the first three rules are observed, the database is considered to be in “third normal form.”
  • Among the levels of normalization, third normal form is the highest level necessary for most applications.

Question 330

Edit

Write in Short

Short Answer▾

What is the output of the following program?

  1. inti, j;
  2. for (i =0; i ⇐ 10; i ++ )
  3. {
  4.     j += 5;
  5.     assert(i<5);
  6. }

Explanation

Runtime error: Abnormal problem termination.

assert failed (i < 5) , < file name > , < line number >

In a program

Table Shows the Program
int i, j;Define integer variable I and j.
for (i = 0; i ⇐ 10; i ++)

{

j += 5;

assert (i < 5) ;

}

  • Asserts are used during runtime debugging to make sure that certain conditions are satisfied.
  • If assertion fails during runtime, the program will terminate reporting the same.
  • This assertion will fail when i becomes 5.
  • After debugging use #undef NDEBUGand this will disable all the assertions from the source code.

Developed by: