TECHNICAL INTERVIEW QUESTIONS AND ANSWER 16 TO 21

16.DATABASE SCHEMA:

         A database schema represents the logical view of entire database in a skeleton structure. It defines how the data are organised and how the relations among them are associated.

         Database designers will be designing this schema to help the programmers understand the database.

17.IC AND ITS IMPORTANCE:

         IC expands Integrated Circuit which is a small chip that acts as an amplifier, microprocessor, timer, oscillator and even computer memory. This is made of silicon which is holding nearly hundreds to millions of transistors, resistors and capacitors.

18.PROGRAM TO CHECK WHETHER THE GIVEN NUMBER IS PERFECT OR NOT.

Understanding of a program:

6 is a perfect number. The divisor of 6 are 3,2 and 1.

3+2+1=6.

#include<iostream.h>

#include<conio.h>

void main()

{

int n,i,sum=0;

cout<<”\nEnter a number: “;

cin>>n;

for(i=1;i<n;i++)

{

if(n%i==0)

{ sum+=i; }

}

if(sum==n)

cout<<”\nPerfect Number”;

else

cout<<”\nNot a Perfect Number”;

getch();

}

19.DSN

         Data Source Name is a data structure that contains the information about a specific database that an ODBC (OPEN DATABASE CONNECTIVITY). Driver needs in order to connect it.

20.CLUSTERED INDEX VS NON CLUSTERED INDEX

NO	CLUSTERED	NON-CLUSTERED
1.	A table can have single clustered data.	A table can have multiple non clustered indexes.
2.	Doesn’t store pointers to the actual data	Stores both the value and a pointer to the actual row that holds a value.
3.	Requires less memory space	Requires more memory space.
4.	Faster	Slower

21.C VS EMBEDDED C

NO	C	EMBEDDED C
1.	Developed by Dennis Ritchie.	Developed by C Standards Committee.
2.	Hardware independent.	Hardware dependent.
3.	Standard compilers helps to compile and execute the program.	Requires specific compilers that are capable of generating micro controller based outputs.
4.	Compiler generate OS dependent executable files.	Compiler generate Hardware dependent executable files.