# 3i Infotech Placement: Sample Questions 477 - 478 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 477

Edit

### Write in Short

When an array is passed it is by

### Explanation

• An array is passed it is by pointer.
• When an array is passed to a function, what is being passed is a pointer to the array.
• In the formal parameter list, we can either specify the parameter an array or a pointer.
• A function working on an array needs to know where to start and stop.
• Another way to describe the array is by passing two pointer, with the first indicating the array starts and second array end.
• The function can alter the value of the pointer itself, making it point to each array element in turn.

## Question 478

Edit

Essay▾

What is 2NF?

### Explanation

• A relation schema R is in 2NF if it is in 1NF and every non-prime attribute A in R is fully functionally dependent on primary key.

2NF (Second Normal Form) Rules

• It is clear that we can՚t move forward to make our simple database in 2nd Normalization form unless we partition the table above.
 MEMBERSHIP ID FULL NAMES PHYSICAL ADDRESS SALTUTATION 1 Janat First street Plot No 4 Ms. 2 Rohit 3rd street 34 Mr. 3 Rohit 5th Avenue Mr.
 MEMBERSHIP ID MOVIES RENTED 1 Pirates of the Caribbean 1 Clash of the Titans 2 Forgetting sarah Marshal 2 Daddy՚s Little Girls 3 Clash of the Titans
• We have divided our 1NF table into two tables viz. Table 1 and Table2.
• Table 1 contains member information. Table 2 contains information on movies rented.
• We have introduced a new column called Membership_id which is the primary key for table 1. Records can be uniquely identified in Table 1 using membership id

Developed by: