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

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

1 Answer

Answer :

UPDATE Student SET Marks = 50 WHERE Roll number = 2;
by

Related questions

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

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

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

(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;

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) ;

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

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

Last 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 ... give an increase of 50 Rs. to all the books:Update library set price=price+50;

A students maks were wrongly entered as 72 instead of 52. Due to that the average marks for the class got increased by half. The number of students in the class is. A) 50 B) 56 C) 46 D) 40

Description : A students maks were wrongly entered as 72 instead of 52. Due to that the average marks for the class got increased by half. The number of students in the class is. A) 50 B) 56 C) 46 D) 40

Last Answer : D)  Let there be y students in the class Total increase in marks = y *1/2 = y/2 Therefore y/2 = (72 – 52) y/2 = 20 y = 40

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.

What is the reason behind the adoption of 'GRADE' system instead of our old' MARKS' system? Options: A) It will improve the quality of assessment. B) It will improve teacher student relationship. C) It will eliminate the differentiation between students on marks basis. D) Grading system is easier than marks system.

Description : What is the reason behind the adoption of 'GRADE' system instead of our old' MARKS' system? Options: A) It will improve the quality of assessment. B) It will improve teacher student ... eliminate the differentiation between students on marks basis. D) Grading system is easier than marks system.

Last Answer : C) It will eliminate the differentiation between students on marks basis. 

Observe the following table and write the HTML code to generate it: Question Marks -Technology

Description : Observe the following table and write the HTML code to generate it: Question Marks -Technology

Last Answer : The HTML code isquestion< /th >marksl225

Construct a histogram for the marks of the student given below : - Marks 0-10,10-30,30-45,45-50,50-60 and number of students 8,32,18,10,6 -Maths 9th

Description : Construct a histogram for the marks of the student given below : - Marks 0-10,10-30,30-45,45-50,50-60 and number of students 8,32,18,10,6 -Maths 9th

Last Answer : see in book okay!!!

Construct a histogram for the marks of the student given below : - Marks 0-10,10-30,30-45,45-50,50-60 and number of students 8,32,18,10,6 -Maths 9th

Description : Construct a histogram for the marks of the student given below : - Marks 0-10,10-30,30-45,45-50,50-60 and number of students 8,32,18,10,6 -Maths 9th

Last Answer : see in book okay!!!

You have used a spreadsheet to calculate the average marks of a class in Mathematics. -Technology

Description : You have used a spreadsheet to calculate the average marks of a class in Mathematics. -Technology

Last Answer : (b) Marks of each student tor Mathematics will be required for calculating average marks of mathematics.

The table shows the marks obtained by a student in unit tests out of 50 : -Maths 9th

Description : The table shows the marks obtained by a student in unit tests out of 50 : -Maths 9th

Last Answer : Here the marks are out of 50 , so we find its percentage (i.e. out of 100)

The table shows the marks obtained by a student in unit tests out of 50 : -Maths 9th

Description : The table shows the marks obtained by a student in unit tests out of 50 : -Maths 9th

Last Answer : Here the marks are out of 50 , so we find its percentage (i.e. out of 100)

Consider the table Student(stuid, name, course, marks). Which one of the following two queries is correct to find the highest marks student in course 5? Q.1. Select S.stuid From student S Where not exists (select * from student e where e course='5' and e marks ≥ s marks) Q.2. Select S.stuid From student S Where s.marks > any (select distinct marks from student S where s.couse = 5) (A) Q.1 (B) Q.2 (C) Both Q.1 and Q.2 (D) Neither Q.1 nor Q.2

Description : Consider the table Student(stuid, name, course, marks). Which one of the following two queries is correct to find the highest marks student in course 5? Q.1. Select S.stuid From student S Where not exists (select * from student ... ) Q.1 (B) Q.2 (C) Both Q.1 and Q.2 (D) Neither Q.1 nor Q.2

Last Answer : (B) Q.2 Explanation: First query gives stuid of students whose marks are greater than all students taking course 5. Second query gives stuid of students whose marks are greater than any student taking ... comparison is between maximum of marks by any student in course 5. So the answer is option D.

What is the purpose of the description column in table Design View? -Technology

Description : What is the purpose of the description column in table Design View? -Technology

Last Answer : (a) A Design View of the table provides three columns as Field Name, Data Type, and Description. The description column provides the facility to write the description about Field Name.

<th>‘tag is used to specify the column heading in a table. -Technology

Description : ‘tag is used to specify the column heading in a table. -Technology

Last Answer : True tag is used to specify the column heading in a table.

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.

Write a C++ program to create a class STUDENT The data members of STUDENT class. Roll_No Name Marks

Description : Write a C++ program to create a class STUDENT The data members of STUDENT class. Roll_No Name Marks

Last Answer : #include #include class STUDENT { int Roll_No; char Name[20]; float Marks; }; OR #include #include class STUDENT { int Roll_No; char Name[20]; float Marks; public: void Accept(); void Display(); }; void STUDENT::Accept() { cout

The average marks of a class of 90 students is 126. Out Of them, 4 scores zero, first 60 students scored an average of 116, next 24 scored an average of 118. What is the mark obtained by the remaining student in the class? A) 750 B) 862 C) 774 D) 875

Description : The average marks of a class of 90 students is 126. Out Of them, 4 scores zero, first 60 students scored an average of 116, next 24 scored an average of 118. What is the mark obtained by the remaining student in the class? A) 750 B) 862 C) 774 D) 875

Last Answer : C) According to the question, 90*126=(4*0)+(60*116)+(24*118)+2y 11340=6960+2832+2y 2y=1548 y=774

on analyzing the result of an competitive exam the teacher found that the average for the entire the class was 69 marks. If we say that average of 10 % of the students scored 77 marks and average of 28 % of the students scored 66 marks, then calculate average marks of the remaining students of the class A) 67.54 B) 68.26 C) 66.91 D) 69.06

Description :  on analyzing the result of an competitive exam the teacher found that the average for the entire the class was 69 marks. If we say that average of 10 % of the students scored 77 marks and average of 28 % of the ... marks of the remaining students of the class A) 67.54 B) 68.26 C) 66.91 D) 69.06 

Last Answer : D) average of entire class = 69marks average of 28 % of the students = 66 marks average of 10% of the students = 77 marks then % of remaining students = (100- 10 - 28) = 62% let the average of 62% of the ... (62*x)+770+1848= 6900 62 * x = 6900-770-1848 62*x = 4282 x = 69.06

Help Ramesh in identifying any two columns for a table named student along with their suitable data type. -Technology

Description : Help Ramesh in identifying any two columns for a table named student along with their suitable data type. -Technology

Last Answer : Column NameData TypeRollNoIntegerNameVarchar(20)

On the basis of the Table Student, write the output(s) produced by executing the following queries: -Technology

Description : On the basis of the Table Student, write the output(s) produced by executing the following queries: -Technology

Last Answer : (i)Max(Average)Min(Average)9565(ii)NameShrishtiAdityaRitu RajSaumyaAshutoshAman

Consider the table ‘Teacher’ given below. -Technology

Description : Consider the table ‘Teacher’ given below. -Technology

Last Answer : (i) Select count(Department) from Teacher ;(ii) Select count (*) from Teacher ;

The mean marks obtained by a class of 40 students is 65. The mean marks of half of the students is found to be 45. The mean marks of the remaining students is (A) 85 (B) 60 (C) 70 (D) 65

Description : The mean marks obtained by a class of 40 students is 65. The mean marks of half of the students is found to be 45. The mean marks of the remaining students is (A) 85 (B) 60 (C) 70 (D) 65

Last Answer : Answer: A

Consider a table SALESMAN with the following data: SNO SNAME SALARY BONUS DATE OF JOIN A01 Beena Mehta 30000 45.23 29_10_2019 A02 K. L. -Technology

Description : Consider a table SALESMAN with the following data: SNO SNAME SALARY BONUS DATE OF JOIN A01 Beena Mehta 30000 45.23 29_10_2019 A02 K. L. -Technology

Last Answer : alternative answer

What happens when text is entered in a Number type field? -Technology

Description : What happens when text is entered in a Number type field? -Technology

Last Answer : When we enter text in a Number field and press Enter or press Tab key, MS-Access displays a message that “The value you entered does not match the Number data type in this column.”

Which field property sets limits on the data that is entered? -Technology

Description : Which field property sets limits on the data that is entered? -Technology

Last Answer : Fixed Field Length or Field Size property sets the limits on the data entered.

If = 6 _5 *2 is entered in a cell, then what will be the cell content? -Technology

Description : If = 6 _5 *2 is entered in a cell, then what will be the cell content? -Technology

Last Answer : -4 will be contained in the cell as a result.

In a spreadsheet software, the formula =A1 +$2 was entered in cell A3 and then copied into cell B3. What is the formula copied into B3? -Technology

Description : In a spreadsheet software, the formula =A1 +$2 was entered in cell A3 and then copied into cell B3. What is the formula copied into B3? -Technology

Last Answer : Need Answer

Sana has entered 49+30 in a cell. The worksheet is not displaying 79 in the cell. -Technology

Description : Sana has entered 49+30 in a cell. The worksheet is not displaying 79 in the cell. -Technology

Last Answer : In Excel, every formula must start with a = (equal) sign.Since Sana has not put = sign before 49+30, thus she is not able to see the desired result will be displayed if she will use = (49 + 30) formula.

In a worksheet, cell K12 has a value. A formula is to be entered in cell K15, such that if the value in cell K12 -Technology

Description : In a worksheet, cell K12 has a value. A formula is to be entered in cell K15, such that if the value in cell K12 -Technology

Last Answer : In cell K15, enter the conditional statement as: = IF (K12 > 300, K12 *1.33, K12 * 1.5). Here, IF condition checks the value at K12, that is, if it is greater than 300, then calculate 1.33 of K12, otherwise 1.5 of K12.

If the data entered in a cell is 546z then, Excel will treat it as a number because it starts with a digit. -Technology

Description : If the data entered in a cell is 546z then, Excel will treat it as a number because it starts with a digit. -Technology

Last Answer : False It will be treated as non-numeric data because it contains letters along with numbers.

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.

Following table gives the distribution of students of sections A and B of a class according to the marks obtained by them. -Maths 9th

Description : Following table gives the distribution of students of sections A and B of a class according to the marks obtained by them. -Maths 9th

Last Answer : Clearly, the mean score of two sections A and B is same

Following table gives the distribution of students of sections A and B of a class according to the marks obtained by them. -Maths 9th

Description : Following table gives the distribution of students of sections A and B of a class according to the marks obtained by them. -Maths 9th

Last Answer : Clearly, the mean score of two sections A and B is same

Which of the following particulars should also be furnished on the reverse of the daily account. a) Details of remittances received and sent from or to HO or other SO b) Particulars of UCR , UCP, bills paid , reason for holding cash/stamp below minimum or excess maximum c) Requisition for postage entered in remarks column d) All documents sent to along with the daily account e) All the above

Description : Which of the following particulars should also be furnished on the reverse of the daily account. a) Details of remittances received and sent from or to HO or other SO b) Particulars of UCR , UCP, ... entered in remarks column d) All documents sent to along with the daily account e) All the above

Last Answer : e) All the above

Forward mail list containing bags for one or more intervening office is to be entered in the mail list in a) Head ‘Due mail’ in the column TB b) L bag column c) Pl bag column d) Special bag column

Description : Forward mail list containing bags for one or more intervening office is to be entered in the mail list in a) Head ‘Due mail’ in the column TB b) L bag column c) Pl bag column d) Special bag column

Last Answer : a) Head ‘Due mail’ in the column TB

The clinical instructor assigned a nursing student to assist the operation. When the nursing student entered the OR suite, her curly long hair was not covered by the head cap. What would the circulating nurse do? A. Welcome the nursing student to the OR B. Request the clinical instructor to tell the nursing student to use the head cap properly C. Assist the nursing student to tuck-in all her hair inside the head cap D. Do not allow the nursing student to scrub in

Description : The clinical instructor assigned a nursing student to assist the operation. When the nursing student entered the OR suite, her curly long hair was not covered by the head cap. What would the circulating nurse ... in all her hair inside the head cap D. Do not allow the nursing student to scrub in

Last Answer : D. Remind the surgeon to scrub again

What is a good gift to give my cooperating teacher for thanking her for allowing me to stay in her class and student teach?

Description : What is a good gift to give my cooperating teacher for thanking her for allowing me to stay in her class and student teach?

Last Answer : What’s the subject/grade of the teacher?

Can a class teacher constantly defend a student from punishment by the principal? He claims that the student is the most exemplary, even though he can use it from time to time. Thank you

Description : Hello in our classroom, we need a student who the teacher believes in everything. Even if he denies, he gets a penalty of only 1. He's happy that the teacher is punishing others because of him. Thanks

Last Answer : As you can see, it can.

Can a class teacher constantly defend a student from punishment by the principal?

Description : Hello. I'm just wondering if a teacher can constantly defend a student from punishment by the principal. And sometimes he suffers coming to the hour a few minutes longer. She believes in everything because he is the most exemplary. He claims that he can use it from time to time. Thank you.

Last Answer : Yes it can. There's not a single reason she can't. It depends on her and her point of view.

A teacher should keep his voice in the class Options: A) High Enough To Be Heard By Every Student Clearly B) Loud, So That Every One Can Hear Clearly C) Moderate D) Sometime Low And Some Time High

Description : A teacher should keep his voice in the class Options: A) High Enough To Be Heard By Every Student Clearly B) Loud, So That Every One Can Hear Clearly C) Moderate D) Sometime Low And Some Time High

Last Answer : D) Sometime Low And Some Time High

If student do not understand what is taught in the class the teacher should feel Options: A) terribly bored B) to explain it in different way C) that he is wasting time D) pity for the students

Description : If student do not understand what is taught in the class the teacher should feel Options: A) terribly bored B) to explain it in different way C) that he is wasting time D) pity for the students

Last Answer : B) to explain it in different way

On the first day of his class, if a teacher is asked by the students to introduce himself, he should (A) ask them to meet after the class (B) tell them about himself in brief (C) ignore the demand and start teaching (D) scold the student for this unwanted demand

Description : On the first day of his class, if a teacher is asked by the students to introduce himself, he should (A) ask them to meet after the class (B) tell them about himself in brief (C) ignore the demand and start teaching (D) scold the student for this unwanted demand

Last Answer : (B) tell them about himself in brief

Develop a dialogue between a teacher and student who is apologising for using mobile phone in the class. (8-10 dialogues).

Description : Develop a dialogue between a teacher and student who is apologising for using mobile phone in the class. (8-10 dialogues). 

Last Answer : Ans: Teacher : Sumeet! What are you doing? Sumeet : Nothing sir. Teacher : Then what is there in your hands? Sumeet : Sorry sir, I was just checking the message on my phone. Teacher: This is too ... I will take care of it. Teacher : Okay. Now pay attention to the study. Sumeet : Okay sir.