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

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

1 Answer

Answer :

1. 95.42. Mohan Garg and scholarship awarded is 50000.3. 54. 6
by

Related questions

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

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;

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

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

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?

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

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

A scheduled caste student is visiting the class only to get his scholarship. What provisions will you make to attract his attention towards education? Options: A) Insulting remarks on the caste and the parents B) Tell him about the importance of education in one's life C) Rebuking the child D) Think about the irrationality of the scheme

Description : A scheduled caste student is visiting the class only to get his scholarship. What provisions will you make to attract his attention towards education? Options: A) Insulting remarks on the caste and the ... in one's life C) Rebuking the child D) Think about the irrationality of the scheme

Last Answer : B) Tell him about the importance of education in one's life 

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

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)

The percentage of marks obtained by a student in monthly unit tests are given below. -Maths 9th

Description : The percentage of marks obtained by a student in monthly unit tests are given below. -Maths 9th

Last Answer : (i) Number of tests in which the student scored more than 70% marks = 3 ∴ P(more than 70% marks) = 3/6 = 1/2 (ii) Number of tests in which the student scored less than 70% marks = 3 ∴ P(less ... ) Number of tests in which the student scored at least 60% marks = 5 ∴ P(at least 60% marks) = 5/6

The percentage of marks obtained by a student in a monthly test is as follows: What is the probability that the student gets more than 75% marks in a

Description : The percentage of marks obtained by a student in a monthly test is as follows: What is the probability that the student gets more than 75% marks in a

Last Answer : The percentage of marks obtained by a student in a monthly test is as follows: What is the ... student gets more than 75% marks in a test?

The average marks obtained by a student in Tamil, english, maths, science, and social together is 65% above the average mark obtained in maths and science together. How many more marks exceeded by the average of maths and science together than the sum of the tamil and english together? A) 50 B) 65 C) Data insufficient D) None of these

Description : The average marks obtained by a student in Tamil, english, maths, science, and social together is 65% above the average mark obtained in maths and science together. How many more marks exceeded by the average of ... of the tamil and english together? A) 50 B) 65 C) Data insufficient D) None of these

Last Answer : C) According to the question  There is no other information about the marks in any one of the subject. The data gives is insufficient to answer the question.

In a post graduate examination the marks obtained by a student is 75 per paper. If he had obtained 33 marks more in Evs paper & 27 more marks in science paper, then his average per paper is increased by 3 marks. Then how many papers were there in exam? A) 10 B) 12 C) 14 D) 20

Description : In a post graduate examination the marks obtained by a student is 75 per paper. If he had obtained 33 marks more in Evs paper & 27 more marks in science paper, then his average per paper is increased by 3 marks. Then how many papers were there in exam? A) 10 B) 12 C) 14 D) 20

Last Answer : Answer: D)  Let the number of paper be A. Then total marks earned him = 75A from questions, 75A + 33+ 27= 78A 3A = 60=> A=20 = number of subjects

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

Write a C++ program to declare a class student with members as roll no, name and department. Declare a parameterized constructor with default value for department as ‘CO’ to initialize members of object. Initialize and display data for two students.

Description : Write a C++ program to declare a class student with members as roll no, name and department. Declare a parameterized constructor with default value for department as ‘CO’ to initialize members of object. Initialize and display data for two students.

Last Answer : write a C plus plus program to declare a class which accept and display student information such as roll number division and percentage use get data and put data with required parameters

Write a C++ program to declare a class ‘College’ with data members as name and college code. Derive a new class ‘student’ from the class college with data members as sname and roll no. Accept and display details of one student with college data.

Description : Write a C++ program to declare a class ‘College’ with data members as name and college code. Derive a new class ‘student’ from the class college with data members as sname and roll no. Accept and display details of one student with college data.

Last Answer : #include<iostream.h> #include<conio.h> class college { char name[10]; int collegecode; public: void getcollege() { cout<<"Enter college name:"; cin>>name; cout< ... (); s.getstudent(); s.putcollege(); s.putstudent(); getch(); }

Give output for following code: class student { int roll no; char name [14]; } s[6]; void main() { cout<<sizeof(s); }

Description : Give output for following code: class student { int roll no; char name [14]; } s[6]; void main() { cout<<sizeof(s); }

Last Answer : Considering roll_no(Single variable) the output is: 96 OR Considering roll, no (Two variables) the output is: 108 OR Considering roll no the output is: error – space between roll and no

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.

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.

Consider the following database: Product Code Product Name Date of sale QtySold Customer Name Amount -Technology

Description : Consider the following database: Product Code Product Name Date of sale QtySold Customer Name Amount -Technology

Last Answer : 1. Qty Sold and Amount fields2. ProductCode field3. Date/Time data type4. ProductCode, ProductName and CustomerName fields5. 6 fields and 5 records6. Validation Rule

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

When Last semester 150 of 800 students made honor roll what percent of student made honor roll?

Description : When Last semester 150 of 800 students made honor roll what percent of student made honor roll?

Last Answer : 150 as a percentage of 800 is 18.75%

Following is the frequency distribution of total marks obtained by the students of different section of class-IX. -Maths 9th

Description : Following is the frequency distribution of total marks obtained by the students of different section of class-IX. -Maths 9th

Last Answer : Since class intervals of the given frequency distribution are not of equal width. We would make modifications in the lengths of the rectangles in the histogram, so that the areas of rectangles are proportional ... lengths as given in the last column .The histogram of the data is given below.

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 is the frequency distribution of total marks obtained by the students of different section of class-IX. -Maths 9th

Description : Following is the frequency distribution of total marks obtained by the students of different section of class-IX. -Maths 9th

Last Answer : Since class intervals of the given frequency distribution are not of equal width. We would make modifications in the lengths of the rectangles in the histogram, so that the areas of rectangles are proportional ... lengths as given in the last column .The histogram of the data is given below.

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

The marks obtained (out of 100) by a class of 80 students are given below: -Maths 9th

Description : The marks obtained (out of 100) by a class of 80 students are given below: -Maths 9th

Last Answer : In the given frequency distribution, the class intervals are not of equal width. Therefore, we would make modification in the lengths of the rectangle in the histogram so that the areas of rectangle ... draw rectangles with lengths as given in the last column. The histogram of data is given below:

In a class test, the sum of marks obtained by P in Mathematics and Science is 28. Had he got 3 more marks in Mathematics and 4 marks less in Science, the product of marks obtained in the two subjects would have been 180? Find the marks obtained in two subjects separately. -Maths 10th

Description : In a class test, the sum of marks obtained by P in Mathematics and Science is 28. Had he got 3 more marks in Mathematics and 4 marks less in Science, the product of marks obtained in the two subjects would have been 180? Find the marks obtained in two subjects separately. -Maths 10th

Last Answer : Let P has obtained x in mathematics and y in science. Then by the problem, x+y=28.......(1). If P would have got 3 marks more in mathematics, then P would have got (x+3) in mathematics ... P obtained 12 marks in mathematics and 16 in science. or, P obtained 9 marks in mathematics and 19 in science.

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

The number of students in four classes A, B, C, D and their respective mean marks obtained by each of the class are given below : Image The combined mean of the marks of four classes together will be : (A) 32 (B) 50 (C) 20 (D) 15

Description : The number of students in four classes A, B, C, D and their respective mean marks obtained by each of the class are given below :   The combined mean of the marks of four classes together will be : (A) 32 (B) 50 (C) 20 (D) 15 

Last Answer : Answer: A

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.

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;

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.

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.

How do I go about getting a scholarship for a first generation college student?

Description : How do I go about getting a scholarship for a first generation college student?

Last Answer : Inquire your targeted school on details and information on how to obtain a first generation scholarship. They may vary, so comparison may be needed to determine best choice.

Vedant gets his student scholarship directly in his a/c linked with Aadhar. 

Description : Vedant gets his student scholarship directly in his a/c linked with Aadhar. 

Last Answer : Identify and explain the concepts from the given illustrations: Vedant gets his student scholarship directly in his a/c linked with Aadhar.

Where can I find information about a scholarship for a Hispanic student?

Description : Where can I find information about a scholarship for a Hispanic student?

Last Answer : A website such as FastWeb.net can be an excellent resource in finding scholarships. Fastweb is constantly updated with a variety of scholarships including those geared toward Hispanic students.

I'm a student 4th year of pharmacy at the university of abidjan(Ivory Coast).I'm looking for a pharmacy post graduate scholarship in singapore.what do I have to do?

Description : I'm a student 4th year of pharmacy at the university of abidjan(Ivory Coast).I'm looking for a pharmacy post graduate scholarship in singapore.what do I have to do?

Last Answer : You should visit the sit www.pharmacystudy.Indonesia.com The best way is to find your local scholarship organization. A well-known scholarship organization is Fulbright.

Scholarship for college student requirements?

Description : Scholarship for college student requirements?

Last Answer : First, it is an idea to fill out the FAFSA form because it will help you tap into need based financial aid on the federal and state government level along with the college itself. It ... school guidance office because they have a list of local scholarships for students to apply for consideration.

Develop a dialogue between student and office clerk about the scholarship schemes and procedure of online application.

Description : Develop a dialogue between student and office clerk about the scholarship schemes and procedure of online application. 

Last Answer : Ans: Student : Good Afternoon Sir! Office Clerk : Good Afternoon! Student : Sir, I am studying in First Year CO and I want to enquire about the scholarship. Office Clerk : What do you want to ... Sir. Office Clerk : My pleasure. Do submit the form before the deadline. Student : Sure Sir. 

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

PEP = (RYEE – current year energy)/RYEE = (23011 – 23834)/23011 = (-) 0.0369 ie (-) 3.7 % …………………….1.5 marks Since the PEP is negative, it implies that the energy conservation measure did not yield reduction in energy consumption, action to be taken to improve the plant performance.

Description : A manufacturing industry plans to improve its energy performance under PAT through  implementation of an energy conservation scheme. After implementation, calculate the  Plant Energy Performance (PEP) with 2015-16 as the ... 34,000 T,   Reference year (2015-16 ) Energy consumption - 27,200 MWh.

Last Answer : Production factor (PF) = 28750/34000 = 0.846 …………………….1 mark Ref year equivalent energy (RYEE) = Ref Year Energy Use (RYEU) x PF   = 27,200 x 0.846= 23011MWh

A group of students of arithmetic mean of the marks in a test was 63. The brightest 30% of them secured a mean score of 70 and the dullest 15% a mean score of 41. The mean score of remaining 55 % is A) 63.675 B) 61.785 C) 65.181 D) 66.67

Description : A group of students of arithmetic mean of the marks in a test was 63. The brightest 30% of them secured a mean score of 70 and the dullest 15% a mean score of 41. The mean score of remaining 55 % is A) 63.675 B) 61.785 C) 65.181 D) 66.67

Last Answer : C) Let the requird mean score be ‘x’ Then (30*70)+(15*41)+55x = 63*100 2100+615+55x=6300 2715+55x=6300 55x=3585 X=65.181

In an exam Aashika secured 1328 marks. If she secured 32 % marks, find the maximum marks. a) 2250 b) 3600 c) 4400 d) 4150 e) 1298

Description : In an exam Aashika secured 1328 marks. If she secured 32 % marks, find the maximum marks. a) 2250 b) 3600 c) 4400 d) 4150 e) 1298

Last Answer : Answer: D  Let the maximum marks be x.  Aashika’s marks = 32% of x  Aashika secured 1328 marks  Therefore, 32% of x = 1328  ⇒ 32/100 × x = 1328  x = (1328 × 100)/32  x =132800/32 x = 4150 Therefore, Aashika got 1328 marks out of 4150 marks.

A candidate scoring 50% in an examination fails by 60 marks , while another candidate scores 75 % mark, gets 40 marks more than the minimum pass marks . Find the minimum pass mark. a) 125 b) 220 c) 140 d) 260 e) 298

Description :  A candidate scoring 50% in an examination fails by 60 marks , while another candidate scores 75 % mark, gets 40 marks more than the minimum pass marks . Find the minimum pass mark. a) 125 b) 220 c) 140 d) 260 e) 298

Last Answer : Answer: B  Let x be the maximum marks,  Then (50% of x)+60 = (75% of x)-40  x/2 +60 = 3x/4 -20  60+20 = 3x/4 – x/ 2 X=320  Hence maximum marks = 320  Minimum pass marks = 320/2 + 60 = 220

Sanjay gets 72 % marks in examinations. If these are 864 marks, find the maximum marks. a) 1050 b) 860 c) 1225 d) 1200 e) 1500

Description : Sanjay gets 72 % marks in examinations. If these are 864 marks, find the maximum marks. a) 1050 b) 860 c) 1225 d) 1200 e) 1500

Last Answer : Answer: D  Let the maximum marks be s  Then 72 % of s = 864  72/100 × s = 864  s = (846 × 100)/72  s = 86400/92  s = 1200 Therefore, maximum marks in the examinations are 1200.