Table Creation and Data Manipulation Commands sumita arora solution || Table Creation and Data Manipulation Commands class 12 sumita arora solution || Table Creation and Data Manipulation Commands class 12 sumita arora || Table Creation and Data Manipulation Commands sumita arora || sumita arora Table Creation and Data Manipulation Commands || sumita arora Table Creation and Data Manipulation Commands solution || Table Creation and Data Manipulation Commands sumita arora practical solution || sumita arora practical solution || Table Creation and Data Manipulation Commands class 12 solution || Table Creation and Data Manipulation Commands class 12
Q 1 = Insert all those records of table Accounts into table Pending where amt_outstanding is more than 10000
Q 2 = Increase salary of employee records by 10% (table employee).
Q 3 = Give commission of Rs. 500 to all employees who joined in year 1982 (table Empl).
Q 4 = Allocate the department situated in BOSTON to employee with employee number 7500 (tables EMPL, Dept)
Q 5 = Given the following tables:
Orders (OrdNo, Ord_date, ProdNo#, Qty)
Product (ProdNo, Descp, Price)
Payment (OrdNo, Pment)
Write a query to delete all those records from table Orders whose complete payment has been made.
Q 6. Enlist the names of all tables created by you.
Q 7 = Write Query statements for following transaction : (Consider tables of question 12)
(1)= Increase price of all products by 10%.
(2) = List the details of all orders whose payment is pending as per increased price.
(3) = Decrease prices by 10% for all those products for which orders were placed 10 months before.
Q 8 = Modify table Empl, add another column called Grade of VARCHAR type, size 1 into it.
Q 9 = In the added column Grade, assign grades as follows if sal is in range 700 -1500, Grade is 1 if sal is in range 1500 - 2200, Grade is 2 if sal is in range 2200 -3000, Grade is 3 if sal is in range 3000 - Grade is 4
Q 10 = Add a constraint (NN-Grade) in table Empl that declares column Grade not null.
Q 11 = Insert a record of your choice in table Empl. Make sure not to enter Grade.
Q 12 = Modify the definition of column Grade. Increase its size to 2.
Q 13 = Drop the table Empl.
Q 14 = Create the table Department table based on the following table instance chart.
Q 15 = Populate the table Department with data from table dept. Including only required columns.
Q 16 = Create the table Employee based un the following table instance chart.
Q 17 = Drop table Employee and Department.
Q 18 = Create table Customer as per following Table Instance Chart.
Q 19 = Add one column Email of data type VARCHAR and size 30 to the table Customer.
Q 20 = Add one more column CustomerincomeGroup of datatype VARCHAR(10).
Q 21 = Insert few records with relevant information, in the table.
Q 22 = Drop the column CustomerlncomeGroup from table Customer.
Q 23 = Create table Department as per following Table Instance Chart.
Q 24 = Create table Employee as per following Table Instance Chart.
q25?
ReplyDeletePlease give me question
DeletePlease partical book
Delete25)view structures of all tables created by you
ReplyDeletedesc Employee ;
Deletetype A questions please
ReplyDeleteSir , type A question's solution please
ReplyDeleteType A questions
ReplyDeleteQ25 isn't answered yet?
ReplyDeletePlease send me the question.
Delete25) view structures of all tables created by you.
ReplyDeleteOk. I have updated it.
DeleteType A solutions?
ReplyDeletePlease send me the questions.
DeletePlease provide type A answers:
ReplyDeleteTYPE A : SHORT ANSWER QUESTIONS/CONCEPTUAL QUESTIONS
1.What are different divisions of SQL and commands ? Give examples of commands in each
2.What is foreign key ? How do you define a foreign key in your table ?
3. How is FOREIGN KEY commands different from PRIMARY KEY command ?
4. How is FOREIGN KEY commands related to the PRIMARY KEY ?
5.How do you enforce business rules on a database ?
6.What are table constraints ? What are column constraints ? How are these two different ?
7.What is default value ? How do you define it ? What is the default value of column for which no default
value is define ?
8.Differentiate between :
(i) DROP TABLE, DROP DATABASE (ii)DROP TABLE, DROP clause of ALTER TABLE.
Send Ch 12 table creation and Data manipulation commands practical solutions
ReplyDeleteplease send ch 12 table creation and data manipulation commands practical solutions please
ReplyDeletePost a Comment
You can help us by Clicking on ads. ^_^
Please do not send spam comment : )