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 : Prachi is working with following swing controls: jButton, jLabel, jTextField, jCheckBox. -Technology
Last Answer : getText(), setText()
Description : Prachi is working with following swing controls: jButton, jLabel, jTextField, jCheckBox. Suggest her any two basic methods commonly available -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
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(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 : The STUDENT information in a university is stored in the relation STUDENT (Name, Sex, Marks, DEPT_Name) Consider the following SQL Query SELECT DEPT_Name from STUDENT where SEX='M' group by ... The average marks of students is more than the average marks of male students in the University
Last Answer : (B) The average marks of male students is more than the average marks of the students in the University
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
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 : Write the output of the following SQL command. select round (49.88); (a)49.88 (b)49.8 (c)49.0 (d)50 -Technology
Last Answer : The correct answer is : (a) 50
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 : 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 : 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
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 : Explain the given command Click Here for wild animals -Technology
Last Answer : In this command, anchor tag and its href attribute are included. The text (Click Here for wild animals) will appear underlined and indicates that clicking the text activates the hypertext link. The address ... is an URL or Web page address and Click Here for wild animals is the hyperlinked text.
Description : Given a Pandas series called Sequences, the command which will display the first 4 rows is .... (a) print(Sequences.head(4)) -Technology
Last Answer : (a) print(Sequences.head(4))
Description : Given the following Series S1 and S2: Write the command to find the sum of series S1 and S2 -Technology
Last Answer : print(S1+S2)
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'.
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.
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
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.
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 : 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 : 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
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 : Observe the following table and write the HTML code to generate it: Question Marks -Technology
Last Answer : The HTML code isquestion< /th >marksl225
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 : 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 : Select Acc_No, sum(Amount) from Customer c, Transaction t where c.Acc_No=t.Acc_No group by c.Acc_No having Transaction_Type='Credit'; -Technology
Last Answer : 2301003 650002201002 20000
Description : What is the difference between the order by and group by clause when used along with the select statement. -Technology
Last Answer : The order by clause is used to show the contents of a table/relation in a sorted manner with respect to the column mentioned after the order by clause. The contents of the column can be arranged in ... a given column and then apply an aggregate function eg max(), min() etc on the entire group.
Description : A command tab which allows to create the table in an interactive manner is called (a) Home -Technology
Last Answer : (d) MS-Access provides a command tab named Create which allows creating the table in an interactive manner.
Description : Write the HTML command to display the following in your Web page. -Technology
Last Answer : The HTML command is – A2 + B2
Description : Write the output on the Web page for the following HTML command. -Technology
Last Answer : The output on the Web page will be the Atomic weight of O 2
Description : Which command should be use to link a page with HTML page? (a) -Technology
Last Answer : (b) page
Description : Sona wants to add her pictures in a Word document. 1. Which tab she should use? 2. Which command she should use to open Insert Picture dialog box? -Technology
Last Answer : 1. Insert tab2. Picture command in the Illustrations group.3. Yes4. Yes
Description : …….. command is used to move the text to a new page. -Technology
Last Answer : Page breakcommand is used to move the text to a new page.
Description : Which tab and command let you insert animations in your slide? Write the steps for applying animations in your presentation. -Technology
Last Answer : Animating Text and Objects:We can give sound effects or visual effects, including movement to the text or objects in a presentation. Animation can be used to focus on important points, to control the ... to animate the object.Effects appear in the Custom Animation list in the order that you add them
Description : Rehearse Timings command is present on ………………. tab. (a) Animations (b) Review (c) Slide Show (d) View -Technology
Last Answer : c) Rehearse Timings command is present on Slide Show tab.
Description : ………………. provides a command to change the layout of your slide. -Technology
Last Answer : Home tab provides a command to change the layout of your slide.
Description : The Custom Animation command is present on ………………. tab. -Technology
Last Answer : The Custom Animationcommand is present on Animationstab.
Description : Write command for the operations (i) to (iii) based on the spreadsheet below: -Technology
Last Answer : 1. At cell F2, type =D2*E2 and then copy this formula using mouse Fill handle onto range F3: F5.2. At cell G2, type =IF(C2=”Consumable”, F2*0.07, F2*0.11) and then copy this formula using mouse Fill handle onto range G3: G5.3. At cell G6, type =SUM(G2: G5).
Description : Which command we use to link a page with an HTML page? -Technology
Last Answer : link textuse to link a page with an HTML page .
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)
Description : (i) Write command to compute sum of every column of the data frame. -Technology
Last Answer : (i) df1.sum()(ii) df1[‘Rainfall’].mean()(iii) df1.loc[:11, ‘maxtemp’:’Rainfall’].mean( )
Description : Write the Django command to start a new app named ‘users’ in an existing project? -Technology
Last Answer : python manage.py startapp users
Description : What is the function of ALTER command? -Technology
Last Answer : Alter command is used to change/modify the structure of database object like a table, index, etc.
Description : The command used to give a heading to a graph is .... (a) plt.show() (b) plt.plot() (c) plt.xlabel() (d) plt.title() -Technology
Last Answer : (d)plt.title()