This is default featured slide 1 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 2 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 3 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 4 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 5 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

Top 101 Interview Questions and Answers of Theory of machines Asked in Interviews and Exams for Fresher’s and Experienced


Top 101 Interview Questions and Answers of Theory of machines  Asked in Interviews and Exams for Fresher’s and Experienced

The idea of this post Top 101 Interview Questions and Answers of Theory of machines   Asked in Interviews and Exams for Freshers and Experienced  is to give an idea of questions to viewers of this post.  Top 101 Interview Questions and Answers of Theory of machines   Asked in Interviews and Exams for Freshers and Experienced are beneficial for students as well as candidates appearing for interviews.
Higher pair

Machine

Rigid body

Constrained motion

Coefficient. Of speed

Governor

Isochronism

Types of followers

Crowning in pulleys

Initial tension

Longitudinal vibration

Types of belts
Balancing

Dynamic balancing

Addendum

Pressure angle

Creep

Difference between structure and machine

Classify kinematics chains

Difference between mechanism and machine

Classify different types of gears

Write the advantage of cycloid gears

Explain the epicycle gear train

Write the advantage of v-belts over flat belts

Explain slip in belts

Write the application of bearing

Types of followers

Write the advantage of gear drives

Write the formula for calculation of power required for raising load with a screw jack

What are the harmful effects of vibrations

What is a need of balancing

Explain the purpose of screw jack

Explain the working of a single plate clutch with the help of neat diagram

Resistant body

Kinetic pair

Mechanism

Pantograph

Coefficient Of energy

Types of governors

Stability

Cam

Velocity ratio

Types of pulleys

Train value

Screw jack

Clutch

Torsional vibration

Rolling friction

Dedendum

Module

Arc of contact

Describe an elliptical trammel

Difference between open and closed pairs

Explain the working of watt governor

Classify different types of cams

Write the advantages of involutes gears

Explain reverted gear train

Explain difference between open and closed belt drivers

Where chain drivers are preferred

Explain the pulley types

What is clutch and what are its types

What is a pivot

What is need of balancing

What are the causes of vibration

Explain crank and slotted lever type quick return motion mechanism with neat sketch

A flywheel having a mas of 4ton has a radius of gyration of 2m. What amount of energy this fly wheel will store in it changing its speed from 420 to462 rpm

Write the function of flywheel

Explain crowning in pullies.

What is creep?

Explain longitudinal vibrations.

Explain diametric pitch.

Explain dynamic balancing.

List four type of followers.

What is hunting of governor.

The amplitude of vibration is always __________the radius of circle.

Define isochronisms.

What is law of belting?

What are meter gears?

What is governor height?

What is balancing machine?

What is resonance?

How a kinematics chain is converted into a mechanisms?

Give two types of machine vibration.

What is damping of vibration?

Differentiate flat and v belt drive?

Write harmful effect of vibration?

Define function of speed and functions of energy in case of flywheel.

Define Link resistant body mechanism

Define  inversion of mechanisms.

Write cause of vibrations in machines.

Define pitch cylinder , circular pitch and module.

Differentiate between static and dynamic balancing.

Describe an 'elliptical trammel'.

What is friction? Explain its types.

Define radius of gyration

What is lower pair and higher pair. explain.

What is a flywheel and what are its functions.

What is a flywheel? What is its use? Derive a relationship for coefficient of fluctuation of energy and the kinetic energy of flywheel at mean speed.

Where chain drivers are preferred
Explain dynamic balancing.
Rolling friction

Explain with neat sketches the following terms as used with a spur gear:

A)circular pitch         B) working depth

C) face                     D) flank


If you find this post Top 101 Interview Questions and Answers of Theory of machines  Asked in Interviews and Exams for Fresher’s and Experienced informative, share it on social media. Popular social media buttons are given below.





Add Column SQL



Add Column SQL


In this post Add Column SQL , we will have an idea about alter table command of sql. After reading this post Add Column SQL, readers will be able to add columns to existing tables as well as they will be able to alter the existing columns of the tables. Sometimes after the creation of a table, need of addition of a new column exists, in that case Alter table command is helpful.
Add Column SQL 1
Add Column SQL


Before we discuss add column SQL , lets us see why to add columns in an existing table. Sometimes while deciding columns of a table, we forget to include a particular field, in that case we can add new columns to the existing tables. 

In programming , some times need of a new columns in existing tables arises at a later stage.

In SQL, we can add a new column in an existing table as well as we can change the specifications of the existing columns.

Suppose you have a table named employee in database as given below-
 
Ecode
Ename
Ecity










After creating this table, need of a new column named zip code arises. You can add this new column using alter table command.

Add Column SQL


Add column SQL requires knowledge of alter table command of sql. Using alter table command, one can add new columns as well as can change the specifications of the existing columns. You can change the data types of the existing columns, one can change the field width of the existing columns.
 
Add Column SQL 1
Add Column SQL

Alter Table Command


A table in SQL can be altered by using alter table command. By using  alter table command , we can add new columns to an existing table. We can also change specification of the existing columns of a table using Alter Table command.

Whenever you will try to add column in sql, you have to take care of data.

Suppose you have a table named employee as given below –

Ecode
Ename
Ecity
E001
JOE
FLORDA
E002
JIM
SYDNEY




If you add a new column named zip code in the above table, structure of the above table will be like this-
Ecode
Ename
Ecity
Zip code
E001
JOE
FLORDA

E002
JIM
SYDNEY






Here you can see Zip code column is having no values, and then what will the values of Zip code in case of these two entered records.

In that case you have to use update command to add values to these two already entered records.

 How to Add Column in sql table using Alter Table command


To add new columns in an existing table, we can use add option of alter table command.



The general syntax of alter table command with add option is given below:



Alter table <table-name> add( new column specification);




Suppose we want to add zipcode column in employee table.



SQL>Alter table employee add(zipcode number(10));


This will add a new column zipcode to employee table.



Modifying existing columns of a table




To modify specification of existing columns of a table ,we can use modify option of  alter table command.



The general syntax for modifying existing columns is given below



Alter table <table-name> modify( column new_specification);



Suppose we wants to chamge filed width of ecode column from 4 to 6.



SQL>Alter Table employee modify( ecode char(6));

Note: Be careful while changing column specifications, this is because when you to change the data type of an existing column, if the table is having data that time, there may be some issues of data type mismatch. Also in case of column width alteration, if you try to reduce the width of an existing column , if that column is having values, in that case truncation of data may happen.


Summary


Hope this post  add column sql , is informative for you.Using alter table command, one can add column in sql as well as can alter the existing columns.

Searches related to add column sql server
add column sql server syntax
add column sql server 2012
add column sql server 2008
adding default value to a column in sql server
add new field in table sql
add column mssql
insert new column in sql
how to remove a column from a table
add column sql with default value
add column sql oracle
add column sql not null
add column sql server 2012
add column sql default
add column sql server
add column sql table
add column sql not null default value
add column mysql
add multiple column sql
add column sql with default value
add column sql server
add column sql nullable
rename column sql
add column sql not null
add column sql syntax