Interview Questions Answers in MySQL

shaikiliyas

{ City } bangalore
< Country > india
* Profession * looking froo job
User No # 77547

Total Questions Posted # 0
Total Answers Posted # 3

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 1
Users Marked my Answers as Wrong # 0

Questions / { shaikiliyas }

Questions Answers Category Views Company eMail

Answers / { shaikiliyas }

Question { 7249 }

What is check constraint?

Answer

Check Constraint defines a condition that each row must satisfy.

create table emp(empid number,ename varchar2(15),salary
number,deptid number constraint emp_salary_min
CHECK(sALARY>1000));

Is This Answer Correct ?

1 Yes

0 No

Question { 6707 }

What is the difference between a Table and a View?

Answer

-Table will have its own data,View doesnt have its own data.

-In Tables data stored Physically,In view its logiacally.

-we have tables of single type,but in views, Simply and
complex views.

Is This Answer Correct ?

0 Yes

0 No

Question { 6469 }

I have a table like this tblData (month int,Qty int)

and i am inserting three rows in this table
1.tblData Values (1,100)
2.tblData Values (2,200)
3.tblData Values (3,300)

The Result I want is the Running total of the field Qty

that is 1 100 100
2 200 300
3 300 600

What is the Query for that ?

Answer

select a.month,a.quantity,sum(b.quantity) as total from qunt
a cross join qunt b
where b.month<=a.month
group by a.month,a.quantity
order by month

Is This Answer Correct ?

0 Yes

0 No