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

1 Answer

Answer :

Correct SQL statement :UPDATE Student SET Marks = Marks +5 WHERE Marks <33 ;

Related questions

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;

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

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

Description : Ms. Priya works as a programmer in “Avon Education” where she has designed a software -Technology

Last Answer : Here,Name is stored in jTextField1Fee Per Quarter is stored in jTextField2Concession Amount is stored in jTextField3Fee to be Paid is stored in jTextField4(i) We need to double click at the Calculate Charges' ... at the Exit' button (jButton3) and type the following code:System., exit (0) ;

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

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;

Description : Write the data type of variables that should be used to store : 1. Marks of students 2. Grades of students (Grade can be ‘A or ‘B’ or ‘C’) -Technology

Last Answer : (i) int data type(ii) char data type

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

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

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!!!

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!!!

Description : In a monthly test, 10 students were awarded marks in a Mathematics examination as follows: 23, 25, 15, 20, 17, 10, 24, 15, 19 If a student is selected

Last Answer : In a monthly test, 10 students were awarded marks in a Mathematics examination as follows: 23, 25 ... the probability that he gets more than 18 marks?

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. 

Description : What are the characteristics of Continuous and Comprehensive Evaluation ? (a) It increases the workload on students by taking multiple tests. (b) It replaces marks with grades. (c) It evaluates every aspect of the student. (d) It helps in ... ) and (d) (C) (a), (b) and (c) (D) (b), (c) and (d)

Last Answer : Answer: D

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

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;

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)

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)

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.

Description : Teachers of , what is something you've always wanted to tell a student/students that you never did or never could?

Last Answer : Need Answer

Description : In a school marks obtained by 80 students are given in the table. Draw a histogram. Also, make frequency polygon. -Maths 9th

Last Answer : Here, class size = 135 - 305 = 10 ∴ Lower limit of first class interval is 305 - 10 / 2 = 300 Upper limit of first class interval is 305 + 10 / 2 = 310 Thus, first class interval is 300 - 310 Required histogram and frequency polygon is given on the graph paper .

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

Description : In a school marks obtained by 80 students are given in the table. Draw a histogram. Also, make frequency polygon. -Maths 9th

Last Answer : Here, class size = 135 - 305 = 10 ∴ Lower limit of first class interval is 305 - 10 / 2 = 300 Upper limit of first class interval is 305 + 10 / 2 = 310 Thus, first class interval is 300 - 310 Required histogram and frequency polygon is given on the graph paper .

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

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.

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.

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.

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)

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

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.

Description : If a bar chart showed that 4 students received an A on the test 3 students received a B and 1 student received a C the shortest bar on the chart would be for the B column.?

Last Answer : No, the shortest bar would be C

Description : A table named School (containing data of students of the whole school) is created -Technology

Last Answer : AdmissionNo should be set as the primary key because admission numbers are unique for each and every student of the school, which is not possible in the case with RollNo and Name.

Description : To display the details of all those students who have IP as their optional subject. -Technology

Last Answer : (i) select * from student where optional=‟IP‟;(ii) select name, stream, optional from student where name like 'A%';(iii) update student set average=average+3 where stream=‟Humanities‟ and optional='Maths';(iv) select name from student where average>75;

Description : When using a search engine to search, then would you use quotation marks around search terms? -Technology

Last Answer : Quotation marks should be used around a phrase or search terms. Surrounding terms with quotation marks limit the search results to only those Web pages that contain the exact phrase, we have specified. ... to have nothing to do with your topic. For best results, you should write death penalty .

Description : String as a value of alt attribute must be enclosed in quotation marks. -Technology

Last Answer : True alt attribute contains the string which must be enclosed in quotation marks

Description : Write an XML document that marks up the following data: All these must be rendered -Technology

Last Answer : Raj Kumar Delhi Pankaj Mumbai Rahul Sharma Delhi Praveen Noida

Description : The values of the attributes are enclosed in double question marks. -Technology

Last Answer : False The values of the attributes are enclosed in double quotation marks.

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.

Description : Among the following propositions two are related in such a way that they cannot both be true but can both be false. Select the code that states those two propositions. Propositions: (a) Every student is attentive. (b) Some students are ... ) (a) and (c) (C) (b) and (c) (D) (c) and (d)

Last Answer : Answer: B 

Description : There are three different categories of jobs A, B and C. The average salary of the students who got the job of A and B categories is Rs.32 lakh per annum. The average salary of the student who got the job of B ... 30 & 44 B) lies between 48 & 56 C) lies between 38 & 45 D) lies between 49 & 50

Last Answer : Answer: C) Let the number of students who got the jobs of A, B and C categories is a, b and c respectively, ∴Total salary of Aand B = 32 (a +b) ∴Total salary of B and C = 54 (b+ ... the minimum salary must be Rs.38 lakh and the maximum salary cannot exceed 45, which is the highest of the three..

Description : To whom was the title 'Devanam Priya' given? -Do You Know?

Last Answer : answer:

Description : What is the meaning of the name Priya ?

Last Answer : The name Priya means: -Apanjan ,, Priyojan .

Description : What is the meaning of the name Priya ?

Last Answer : The name Priya means loved one.

Description : To whom was the title ‘Devanam Priya’ given?

Last Answer : Ashoka

Description : Which of the following breed is not related with broiler chicken in India? a) ILI-80 b) Golden-92 c) Priya d) Sonali e) Frizzle

Last Answer : b) Golden-92

Description : There is a circular path around a sports field. Priya takes 18 minutes to drive one round of the field. Harish takes 12 minutes. Suppose they both start at the same point and at the same time and go in the same ... will they meet ? (a) 36 minutes (b) 18 minutes (c) 6 minutes (d) They will not meet

Last Answer : (a) 36 minutes

Description : If A stands for 5 , B for 6, C for 7, D for 8, and so on, what do the following numbers stand for : 22, 25, 8, 22 and 5 ? (A) PRIYA (B) NEEMA (C) MEENA (D) RUDRA

Last Answer : Answer: D

Description : Praneetha and Pooja together can do a piece of work in 24 days ,which pooja and priya can do in 32 days. After praneetha has been working at it for 10 days and pooja for 14 days, Priya finishes it in 26 days. In how many days Priya alone will do the work? a) 12 days b) 24 days. c) 48 days d) 50 days

Last Answer : C Praneetha's 10 day's work + Pooja 14 day's work + Priya's 26 days work = 1 (Praneetha's +pooja's) 10 day's work + (pooja + priya)'s 4 day's work +priya's 22 days work = 1 =>10/24 + 4/32 + priya' ... 13/24 =11/24 Priya's 1 day's work = 11/24 * 1/22 =1/48 Priya can finish the work in 48 days.

Description : Pradeesh gets a chance of 40% to win 1st round of a game and a Priya gets a chance of 55% to win 2nd round of the game. In what % of cases are they likely to contradict each other, narrating the same incident? a) 49% b) 54% c) 51% d) 38%

Last Answer : Answer: C) Let A be the event that a pradeesh wins 1st round Let B be the event that a priya wins 2nd round. Then, A' = Event that the pradeesh losses 1st round and B' = event that the priya losses 2nd ... =72/400+132/400 = 204/400 We have to find the %. Required % = (204/400)x100 = 51%.

Description : If majority of students in your class is weak you should Options: A) Not Care About Intelligent student B) Keep Your Speed Of Teaching Fast So That Students Comprehension Level May Increase C) ... Helpful To Bright Students. D) Keep Your Teaching Slow Along With Some Extra Guidance To Bright People

Last Answer : D) Keep Your Teaching Slow Along With Some Extra Guidance To Bright People