Rishi, a class XII student has given following commands for the given purposes: (i) To add a new column “Rating” : -Technology

Rishi, a class XII student has given following commands for the given purposes: (i) To add a new column “Rating” : -Technology
by

1 Answer

Answer :

No, above commands will not be able to achieve desired task as update and alter commands have been interchanged.In order to achieve desired result, following corrections should be incorporated in the previously used commands:(i) To add a new column “Rating”:Alter table library add column rating varchar(20);(ii) To give an increase of 50 Rs. to all the books:Update library set price=price+50;
by

Related questions

While creating a table named “Employee”, Mr. Rishi got confused as which data type he should chose for the column “EName” out of char and varchar. -Technology

Description : While creating a table named “Employee”, Mr. Rishi got confused as which data type he should chose for the column “EName” out of char and varchar. -Technology

Last Answer : Varchar would be the suitable data type for EName column as char data type is a fixed length data type while varchar is a variable length data type.Any employee‟s name will be of variable length so it‟s advisable to choose varchar over char data type.

Mrs. Sharma is the classteacher of Class ‘XII A’. She wants to create a table ‘Student’ to -Technology

Description : Mrs. Sharma is the classteacher of Class ‘XII A’. She wants to create a table ‘Student’ to -Technology

Last Answer : (i) RolINo, Name can be the attributes of Student table.(ii) Primary key of the table Student is RolINo, because RolINo is a field in Student table which uniquely identifies each rows/records in a database table.

Write the commands to do the following operations on the dataframes given above : (i) To add dataframes df1 and df2. -Technology

Description : Write the commands to do the following operations on the dataframes given above : (i) To add dataframes df1 and df2. -Technology

Last Answer : import numpy as npimport pandas as pddf1 = pd.DataFrame({'mark1':[30,40,15,40],'mark2':[20,45,30,70]});df2 = pd.DataFrame({'mark1':[10,20,20,50],'mark2':[15,25,30,30]});print(df1)print(df2)(i) ... , inplace=True) print(df1)(iv) df1.rename(index = {0: 'zero', 1:'one'}, inplace = True) print(df1)

What is the easiest way to get rid of sleep ? I am a class XII student and I get a lot of sleep in the evening when I sit down to study. Can I get rid of this sleep by playing ? Can I read for many more nights ?

Description : What is the easiest way to get rid of sleep ? I am a class XII student and I get a lot of sleep in the evening when I sit down to study. Can I get rid of this sleep by playing ? Can I read for many more nights ?

Last Answer : In fact, this happens due to physical weakness, that is, sleep comes again and again. You will have tea and books at night. Or sleep, actually eat tea, then read the book again. Or sleep will actually take a splash of water in the eyes. Then sleep will not come.

In Marks column of ‘Student’ table, for Rollnumber 2, the Class Teacher entered the marks as 45. -Technology

Description : In Marks column of ‘Student’ table, for Rollnumber 2, the Class Teacher entered the marks as 45. -Technology

Last Answer : UPDATE Student SET Marks = 50 WHERE Roll number = 2;

With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below: -Technology

Description : With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below: -Technology

Last Answer : (i) select TName, Passenger from Train T, Reservation R where T.TrainId=R.TrainId;(ii) select T.* from Train T, Reservation R where T.TrainId!=R.TrainId;(iii)TrainIdTNameSourceDestination3424Lucknow MailLucknowNew Delhi5400Century ExpressNew DelhiKanpur

Write the command using Insert() function to add a new column in the last place(3rd place) named “Salary” from the list Sal=[10000,15000,20000] -Technology

Description : Write the command using Insert() function to add a new column in the last place(3rd place) named “Salary” from the list Sal=[10000,15000,20000] -Technology

Last Answer : EMP.insert(loc=3,column=”Salary”,value=Sal)

In the table “Student”, Priya wanted to increase the Marks (Column Name: Marks) of those students -Technology

Description : In the table “Student”, Priya wanted to increase the Marks (Column Name: Marks) of those students -Technology

Last Answer : Correct SQL statement :UPDATE Student SET Marks = Marks +5 WHERE Marks

While creating the table Student last week, Ms. Sharma forgot to include the column -Technology

Description : While creating the table Student last week, Ms. Sharma forgot to include the column -Technology

Last Answer : ALTER TABLE Student ADD Game_Played VARCHAR (30) ;

In a school, a database named “school” is created in mysql whose password is “cbse”. Smith is trying to add a new record of a student having details -Technology

Description : In a school, a database named “school” is created in mysql whose password is “cbse”. Smith is trying to add a new record of a student having details -Technology

Last Answer : import mysql.connectormydb = mysql.connector.connect{host='localhost',user='root',passwd='cbse',database='school'}mycursor = mydb.cursor()mycursor.execute('INSERT INTO student values(3,'Michelle', 'Agartala');')mydb.commit()

Consider the table STUDENT given below: RollNo Name Class DOB Gender City Marks 1 Anand XI 6/6/97 M Agra 430 -Technology

Description : Consider the table STUDENT given below: RollNo Name Class DOB Gender City Marks 1 Anand XI 6/6/97 M Agra 430 -Technology

Last Answer : (1)b. Both (iii) and (iv)(2) b.RollnoNameClassDOBGenderCityMarks6734MaakhiyNehaGeetPreetiXIXXIXII12/12/948/12/956/5/978/8/95FFFFDubaiMoscowAgraMumbai256324470492

(1) Prachi has given the following command to obtain the highest marks Select max(marks) from student where group by class; -Technology

Description : (1) Prachi has given the following command to obtain the highest marks Select max(marks) from student where group by class; -Technology

Last Answer : (1)d. Select class, max(marks) from student group by class;(2)b. Both (ii) and (iv)(3)b. select name,max(DOB) from student;

A teacher’s major contribution towards the maximum self-realization of the student is affected through: Options: A) Constant fulfilment of the students’ needs B) Strict control of class-room activities C) Sensitivity to students’ needs, goals and purposes D) Strict reinforcement of academic standards

Description : A teacher's major contribution towards the maximum self-realization of the student is affected through: Options: A) Constant fulfilment of the students' needs B) Strict control of class-room ... C) Sensitivity to students' needs, goals and purposes D) Strict reinforcement of academic standards

Last Answer : C) Sensitivity to students’ needs, goals and purposes 

A teacher’s major contribution towards the maximum selfrealization of the student is affected through: (A) Constant fulfilment of the students’ needs (B) Strict control of class-room activities (C) Sensitivity to students’ needs, goals and purposes (D) Strict reinforcement of academic standards

Description : A teacher’s major contribution towards the maximum selfrealization of the student is affected through: (A) Constant fulfilment of the students’ needs (B) Strict control of class-room activities (C) Sensitivity to students’ needs, goals and purposes (D) Strict reinforcement of academic standards

Last Answer : (C) Sensitivity to students’ needs, goals and purposes

What are the commands contained by Create tab? -Technology

Description : What are the commands contained by Create tab? -Technology

Last Answer : The Create tab has various commands such as Table Design, Table Templates, Pivotchart, Form, Report, Macro and Query Wizard.

What is table? Name the basic commands for creating a table. -Technology

Description : What is table? Name the basic commands for creating a table. -Technology

Last Answer : Tables are made up of rows and columns. In HTML, tables are used to display tabular data in Web pages.The basic commands for creating tables are as follows:Table tags Row tags Cell tags andCaption tags .

Consider the following table Furniture. Write SQL commands for the statements (i) to (viii) and write output for SQL queries (ix) and (x). -Technology

Description : Consider the following table Furniture. Write SQL commands for the statements (i) to (viii) and write output for SQL queries (ix) and (x). -Technology

Last Answer : SQL commands for the given statements (i) to (viii) ;1. SELECT FCODE, NAME. PRICE FROM Furniture WHERE PRICE < 5000;2. SELECT NAME. PRICE FROM Furniture3.4. WHERE NAME LIKE %table% ;5. SELECT DISTINCT WCODE ... ;15.16. Output for SQL queries (ix) and (x)(ix)SUM(PRICE)6500(x)COUNT(DISTINCT PRICE)5

Write SQL Query commands based on the following table: -Technology

Description : Write SQL Query commands based on the following table: -Technology

Last Answer : This answer was deleted by our moderators...

Consider the decimal number x with value 8459.2654. Write commands in SQL to: i. round it off to a whole number -Technology

Description : Consider the decimal number x with value 8459.2654. Write commands in SQL to: i. round it off to a whole number -Technology

Last Answer : i. select round(8459.2654);ii.select round(8459.2654,-2);

Anjali writes the following commands with respect to a table employee having fields, empno, name, department, commission. -Technology

Description : Anjali writes the following commands with respect to a table employee having fields, empno, name, department, commission. -Technology

Last Answer : This is because the column commission contains a NULL value and the aggregate functions do not take into account NULL values. Thus Command1 returns the total number of records in the table whereas Command2 returns the total number of non NULL values in the column commission.

Consider the following SQL string: “Preoccupied” Write commands to display: (a)“occupied” (b)“cup” -Technology

Description : Consider the following SQL string: “Preoccupied” Write commands to display: (a)“occupied” (b)“cup” -Technology

Last Answer : commands to display:(a)“occupied” (b)“cup”

Considering the same string “Preoccupied” Write SQL commands to display: (a) the position of the substring ‘cup’ in the string “Preoccupied” -Technology

Description : Considering the same string “Preoccupied” Write SQL commands to display: (a) the position of the substring ‘cup’ in the string “Preoccupied” -Technology

Last Answer : (a)select instr 'Preoccupied' , ‘ 'cup'));(b)select left 'Preoccupied',4);

What support package did Chancellor Rishi Sunak announced for UK businesses?

Description : What support package did Chancellor Rishi Sunak announced for UK businesses?

Last Answer : Chancellor Rishi Sunak earlier this week announced a new £4.6bn package in lockdown grants to support businesses and protect jobs as a result of the latest coronavirus restrictions.The further support measures follow ... ready to return when they are able to reopen The top-ups will be granted to c

The constellation `Sapta Rishi' is known to Westerners as the – (1) Seven Monks (2) Alpha Centauri (3) Big Dipper (4) Small Bear

Description : The constellation `Sapta Rishi' is known to Westerners as the – (1) Seven Monks (2) Alpha Centauri (3) Big Dipper (4) Small Bear

Last Answer : (3) Big Dipper Explanation: The Steady State theory (also known as the Infinite Universe theory or continuous creation) was developed in 1948 by Fred Hoyle, Thomas Gold, Hermann Bondi and others as ... asserts that the observable universe is basically the same at any time as well as at any place.

There are 312, 260 and 156 students in class X, XI and XII respectively. Buses are to be hired to take these students to a picnic. Find the maximum number of students who can sit in a bus if each bus takes equal number of students (a) 52 (b) 56 (c) 48 (d) 63

Description : There are 312, 260 and 156 students in class X, XI and XII respectively. Buses are to be hired to take these students to a picnic. Find the maximum number of students who can sit in a bus if each bus takes equal number of students (a) 52 (b) 56 (c) 48 (d) 63

Last Answer : (a) 52

Consider the following database Student:Roll No. First Name Last Name Class Marks Obtained(%) Scholarship Awarded -Technology

Description : Consider the following database Student:Roll No. First Name Last Name Class Marks Obtained(%) Scholarship Awarded -Technology

Last Answer : 1. 95.42. Mohan Garg and scholarship awarded is 50000.3. 54. 6

Vani, a class X student has recently completed her HTML course and just started learning XML. Help her in the following: -Technology

Description : Vani, a class X student has recently completed her HTML course and just started learning XML. Help her in the following: -Technology

Last Answer : (i) Primary purpose of HTML is to design a webpage while XML is used to store and transport the data.(ii) Right(iii) Comments are added as notes or lines for understanding the purpose of an XML ... .Syntax for comments are as follows:(v)An XML document with correct syntax is called 'Well Formed'.

Ruby, a class XI student has just started learning java programming. Help her in the following: (i) Explain her the concept of variable -Technology

Description : Ruby, a class XI student has just started learning java programming. Help her in the following: (i) Explain her the concept of variable -Technology

Last Answer : (i)Variables are named storage location to store values temporarily which can be changed during program execution.Data type states the way the values of that type are stored, the operations that can be done ... setText( Just Pass );In the above if statement, value of marks is being compared with 40.

Ms. Archana, a class XI student has just started learning MySQL. Help her in understanding the basic difference between -Technology

Description : Ms. Archana, a class XI student has just started learning MySQL. Help her in understanding the basic difference between -Technology

Last Answer : ALTERUPDATEIt s a DDL command.It s a DML command.It can be used for the following purpose:To add a new column.To remove an existing column.To modify a column.To add/remove a constraint.It s ... Delhi ;suitable command:(i)Show Databases(ii) Use City(iii) Drop Database Clients(iv) Drop table Club

Ruby, a class XI student has just started learning java programming. Help her in the following: -Technology

Description : Ruby, a class XI student has just started learning java programming. Help her in the following: -Technology

Last Answer : i. Variables are named storage location to store values temporarily which can be changed during program execution.Data type states the way the values of that type are stored, the operations that can be done ... setText( Just Pass );In the above if statement, value of marks is being compared with 40.

In which part of the Indian Constitution, legislative relation between centre and state is given? (1) X (2) XI (3) XII (4) XIII

Description : In which part of the Indian Constitution, legislative relation between centre and state is given? (1) X (2) XI (3) XII (4) XIII

Last Answer : (2) XI Explanation: In part XI relations between the union and the states is mentioned. Part XIII deals with Trade and commerce within the territory of India. Part XII is about Finance, property, contracts and suits.

What are the main purposes of a database system? -Technology

Description : What are the main purposes of a database system? -Technology

Last Answer : • Storage of information.• Retrieval of information quickly.• Sorting, selecting data that satisfies certain criteria (filtering).• Produce the report in some standardized and readable format.

How many rows and column will be there in the Cartesian product of the above given tables. Also mention the degree and cardinality -Technology

Description : How many rows and column will be there in the Cartesian product of the above given tables. Also mention the degree and cardinality -Technology

Last Answer : Cartesian Product:Number of Rows: 20Number of Columns: 9Degree: 9Cardinality: 20

I put myself as a OP on a server for minecraft and none of the commands are working what do I do?

Description : I put myself as a OP on a server for minecraft and none of the commands are working what do I do?

Last Answer : answer:Make sure you’re putting the / before your server commands, of course. Otherwise, try and restart the server. Some changes like enabling monsters take time and a few restarts occasionally.

You happen to have purchased a house from the future. It accepts all kinds of voice commands. What are some of your commands?

Description : You happen to have purchased a house from the future. It accepts all kinds of voice commands. What are some of your commands?

Last Answer : “Make Bacon”

I have some matchsticks set up like this: I + XI = X. If you do not know Roman numerals, here is a quick starter: I=1 II=2 III=3 IV=4 V=5 VI=6 VII=7 VIII=8 IX=9 X=10 XI=11 XII=12 XIII=13 XIV=14 XV=15...... Of course, I + XI = X is wrong. You are told to move the minimum number of matchsticks to make the question correct. So, how many do you have to move? -Riddles

Description : I have some matchsticks set up like this: I + XI = X. If you do not know Roman numerals, here is a quick starter: I=1 II=2 III=3 IV=4 V=5 VI=6 VII=7 VIII=8 IX=9 X=10 XI=11 ... are told to move the minimum number of matchsticks to make the question correct. So, how many do you have to move? -Riddles

Last Answer : Most people would get to one move at the least, but the real answer is zero moves. If you rotate the whole question around 180 degrees, it will display this: X = IX + I

which type of fibers are found in the hypoglossal nerve (cn xii)? -General Knowledge

Description : which type of fibers are found in the hypoglossal nerve (cn xii)? -General Knowledge

Last Answer : motor to the muscles of the tongue.

What does XII mean in numbers?

Description : What does XII mean in numbers?

Last Answer : XII is a Roman numeral equivalent to 12

Factor XII (Hageman factor) deficiency?

Description : Factor XII (Hageman factor) deficiency?

Last Answer : DefinitionFactor XII deficiency is an inherited disorder that affects a protein (factor XII) involved in blood clotting.Causes, incidence, and risk factorsWhen you bleed, the body launches a ... rare inherited disorder.SymptomsThere are usually no symptoms.Signs and testsFactor XII deficiency is u

Factor XII assay?

Description : Factor XII assay?

Last Answer : DefinitionThe factor XII assay is a blood test to measure the activity of factor XII -- one of the substances involved in blood clotting.Alternative NamesHageman factor assayHow the test is performedBlood is ... the needle is removed, and the puncture site is covered to stop any bleeding.In infant

Which of the following statements about the coagulation cascade is/are true? A. The intrinsic pathway of coagulation is the predominant pathway in vivo for hemostasis and coagulation. B. The intrinsic pathway beginning with the activation of factor XII is the predominant in vivo mechanism for activation of the coagulation cascade. C. Deficiencies of factor VIII and IX cause highly significant coagulation abnormalities. D. Deficiencies of factor XII cause severe clinical bleeding syndromes.

Description : Which of the following statements about the coagulation cascade is/are true? A. The intrinsic pathway of coagulation is the predominant pathway in vivo for hemostasis and coagulation. ... coagulation abnormalities. D. Deficiencies of factor XII cause severe clinical bleeding syndromes.

Last Answer : Answer: AC DISCUSSION: Although it was previously held that two somewhat distinct pathways existed for the activation of the coagulation cascade, it is now recognized that the predominant ... bleeding. This further emphasizes the secondary role that the intrinsic pathway plays in coagulation

Which part of our Constitution envisages a three tier system of Panchayat? (1) Part IX (2) Part X (3) Part XI (4) Part XII

Description : Which part of our Constitution envisages a three tier system of Panchayat? (1) Part IX (2) Part X (3) Part XI (4) Part XII

Last Answer : (1) Part IX Explanation: Part IX of the constitution under article 243-C deals with Composition of Panchayats

Which part of the Constitution envisages a three tier system of panchayats? (1) Part IV (2) Part X (3) Part XI (4) Part XII

Description : Which part of the Constitution envisages a three tier system of panchayats? (1) Part IV (2) Part X (3) Part XI (4) Part XII

Last Answer : (1) Part IV Explanation: Three tier system panchayats enlisted in part IV of the constitution.

Which part of the Indian Constitution deals with centre-state financial relations? (1) Part XV (2) Part XIV (3) Part XII (4) Part X

Description : Which part of the Indian Constitution deals with centre-state financial relations? (1) Part XV (2) Part XIV (3) Part XII (4) Part X

Last Answer : (3) Part XII Explanation: Part XII of the Indian Constitution deals with centre-state financial relations. Part XV deals with Election Commission of India. In part XIV services under the union and ... Part X includes article 244 - 244A and is about administration of scheduled areas and tribal areas.

Of contempts of the lawful authority of public servants defined in___ of IPC a) Chapter IX b) Chapter Xc) Chapter XII d) Chapter XIII

Description : Of contempts of the lawful authority of public servants defined in___ of IPC a) Chapter IX b) Chapter X c) Chapter XII d) Chapter XIII 

Last Answer : b) Chapter X

Of offences by or relating to public servants defined in ____ of IPC a) Chapter IX b) Chapter X c) Chapter XII d) Chapter XIII

Description : Of offences by or relating to public servants defined in ____ of IPC a) Chapter IX b) Chapter X c) Chapter XII d) Chapter XIII

Last Answer : a) Chapter IX

Enhanced punishment for certain offence under Chapter XII or Chapter XVII after previous conviction a) 3 years upwards b) 4 year upwards c) 1 year upwards d) None of these

Description : Enhanced punishment for certain offence under Chapter XII or Chapter XVII after previous conviction  a) 3 years upwards b) 4 year upwards c) 1 year upwards d) None of these 

Last Answer : a) 3 years upwards

A company has to choose between two projects whose cash flows are as indicated below; Project 1: i. Investment – Rs. 15 Lakhs ii. Annual cost savings – Rs. 4 lakhs. iii. Bi-annual maintenance cost – Rs. 50,000/- iv. Reconditioning and overhaul during 5th year: 6 lakhs v. Life of the project – 8 years vi. Salvage value – Rs. 5 lakhs Project 2: vii. Investment – Rs. 14 Lakhs viii. Annual cost savings – Rs. 3.5 lakhs. ix. Annual Maintenance cost – Rs. 20,000/- x. Reconditioning and overhaul during 4th year: 5 lakhs xi. Life of the project – 8 years xii. Salvage Value- 2 lakhs Which project should the company choose? The annual discount rate is 12

Description :  A company has to choose between two projects whose cash flows are as indicated  below; Project 1:  i. Investment - Rs. 15 Lakhs ii. Annual cost savings - Rs. 4 lakhs. iii. Bi-annual ... years xii. Salvage Value- 2 lakhs Which project should the company choose? The annual discount rate is 12

Last Answer : Year Project 1 Project 2 Outgo Saving NPV Outgo Saving NPV 0 15.0 0 =-15.0 14.0 0 = -14 1 0 4.0 = (4 / (1+.12)1 = 3.571 0.2 3.5 = (3.3 / (1+.12)1 = 2.95 2 0.5 4.0 = (3.5 / (1+.12)2 = 2.79 0.2 3.5 ... (1+.12)8 = 3.43 0.2 5.5  (3.5+2) = (5.3 / (1+.12)8 = 2.14 NPV = + 2.301 @12% = + 0.15

Law relating to agency is contained in ……. Chapter of the Indian Contract Act. a. Chapter IX b. Chapter X c. Chapter XI d. Chapter XII

Description : Law relating to agency is contained in ……. Chapter of the Indian Contract Act. a. Chapter IX b. Chapter X c. Chapter XI d. Chapter XII

Last Answer : b. Chapter X