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

1 Answer

Answer :

ALTER TABLE Student ADD Game_Played VARCHAR (30) ;

Related questions

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 : 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 : What is created when you use F11 shortcut key while creating a chart in MS Excel: a) A default chart b) A 2 dimensional column chart c) A 2 dimensional bar chart d) A 3 dimensional line chart e) None of The Above

Last Answer : b) A 2 dimensional column chart

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 : 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 : Ms. Cathy is creating a form for Vidya University Sports Council application. Help her to choose the most appropriate controls -Technology

Last Answer : Appropriate controls for the given entries :S.NOFunctionControl1.To let the user enter NameTextField2.To let the user enter MOBILE NUMBERTextField3.To let the user choose one PROFESSION out of the ... , Yoga, Table Tennis, Badminton and Aerobics. More than one facility may be chosen.CheckBox

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 : Team India created history as they clinched their first ever bilateral ODI series Feb, 2018 win on South African soil under the captaincy of: (a) MS Dhoni (b) Rohit Sharma (c) Virat Kohli (d) None of These

Last Answer : (c) Virat Kohli

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 : Sanchita is working for a nationalized bank and is in the process of creating a table to store the details of customers of the bank. -Technology

Last Answer : Primary key AccountNoCandidate key AccountNo and PAN NumberAlternate key PAN Number

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 .

Description : Ms. Shalini has just created a table named “Employee” containing columns Ename, Department, Salary. -Technology

Last Answer : SQL command to add a primary key column:Alter table employee add empid int primary key;Importance of Primary key in a table:Primary key column is used to uniquely identify each record of the table. A column defined as primary key cannot have a duplicate entry and can't be left blank.

Description : While working in Netbeans, Ms. Sonia has designed a login page where she wants to display -Technology

Last Answer : If statement is more appropriate for this situation because here is given only two conditions which will be executed by if statement while switch statement is used where multiple branch selection statements are given.

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 : 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 : 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 : The cellspacing attribute tells the browser how much space to include between the walls of the table. -Technology

Last Answer : False cellspacing attribute is used to create space between different cells in a table.

Description : A student coming out cell fractionation of a tissue and forgot to label his tubes. The contents of one tube when studied showed organelles bounded by

Last Answer : A student coming out cell fractionation of a tissue and forgot to label his tubes. The contents of ... . SER B. Chloroplast C. Lysosome D. Perosisome

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 : 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 : Mr. Sharma decided to walk down the escalator of a tube station. He found that if he walks down 26 steps, he requires 30 seconds to reach the bottom. However, if he steps down 34 stairs he would only ... time he steps off the last step at the bottom, find out the height of the stair way in steps?

Last Answer : Answer: 46 steps.

Description : What if technology is destroying jobs faster than it is creating them?

Last Answer : Yes, it is, and I think it’s a ship that has sailed.

Description : When creating a Web document, which unit is used to express an image’s height and width? (a) Centimetres (b) Pixels -Technology

Last Answer : (b) Image’s height and width unit are expressed in pixels or in percent form.

Description : Carefully study the Web page given below. Identify 10 tags (structural as well as formatting tags) that have been utilized in creating this -Technology

Last Answer : 1. to specify title of the Web page.2. contains all the text content that is to be displayed on Web page and all the various formatting and structural tag.3. defines the most important and biggest ... provide caption to the table.9. used to create a table row.10. used to define data cells.

Description : What are the different ways in which you can start creating a new presentation? Write steps for each. -Technology

Last Answer : Creating New Presentation:For creating a new presentation in MS-PowerPoint, there are two options available to make a selection of creating new presentation:1. Creating Blank PresentationFor creating a blank presentation, ... name box, enter a new name to save the file.3. Then, click Save button

Description : A virus is a harmful program, which one entering a computer, starts creating copies of itself. -Technology

Last Answer : True Virus is a malicious program that is designed to make a system sick, just like a real virus.

Description : What is Multimedia? What are the various types of hardware used in creating a multimedia project? -Technology

Last Answer : Multimedia is a means to process and structure information into a well-defined structure. Multimedia is called so because it incorporates many other media such as text, graphics, animation, audio ... following hardware devices - CPU, Monitor, Scanner, Touchscreen, Video grabbing card, mouse etc.

Description : When creating a Web document, what format is used to express an image's height and width? -Technology

Last Answer : Pixelsis used to express an image's height and width.

Description : Ms. Ivana, a leading marketing professional working in a multinational company, is most of the time on move to cater her profession demands. -Technology

Last Answer : Software name:Team Viewer

Description : Ms. Pari, a beginner in SQL is not able to understand the meaning of “Cancelling a Transaction”. Help her in understanding the same. -Technology

Last Answer : Cancelling a transaction means rolls the transaction to the beginning. It aborts any changes made during the transaction and the state of database is returned to what it was before the transaction began to execute.Rollback command is used for the same.

Description : Mention any one major environmental benefits of ICT to Ms. Megha so that she can utilize it in her future “Save Earth” campaign. -Technology

Last Answer : Major environmental impact of ICT on our society is that it is creating a virtually paperless work environment so reducing cutting down of trees for paper manufacturing.

Description : Ms. Achla, works as a Programmer in a survey firm named “National Survey Foundation”. In her current project, she is supposed to design -Technology

Last Answer : S. No.Control used to inputControl1TRAINEE’S NAMETextField2TRAINING LOCATIONRadio Button/Combo Box3GRADE THE SESSION(Excellent, Good, Satisfactory, Unsatisfactory)Radio Button/Combo Box4SUGGESTIONSText Area

Description : Ms. Sita trying to log into your Internet Banking account for online transaction activity. However, as strange as it may seem, -Technology

Last Answer : I. (i)Source code is available.(ii) Money need not to be paid for procuring the license for usage and further distribution.II. She could be under a DoS attack!She should deploy an ... into her network if not already done. This helps in restricting the bandwidth usage to authenticated users only.

Description : (i) Ms. Sangeeta wants to add few descriptive lines in the HTML code which should not be displayed on the webpage rather -Technology

Last Answer : (i) She should use comments in HTML.Any text to make comments in HTML, should be preceded by Example:Welcome(ii)HTML is used to display data and to focus on formatting of data, whereas XML ... XML is used to store and transfer the data over different platforms while HTML is used to design webpages.

Description : Ms. Neelam works as a programmer in “Kidz Entertainment Zone”. She has designed a Registration Page to calculate -Technology

Last Answer : (i)int age=Integer.parseInt(jTextField2.getText());if(age>=3 && age1000)disc=fee*20/100;jTextField4.setText(''+(disc));(iv)int fee=Integer.parseInt(jTextField3.getText());int disc=Integer.parseInt(jTextField4.getText());jTextField5.setText(''+(fee-disc));

Description : Ms. Juhi, works as an IT Executive in a health insurance company named 'Total Health'. She has been assigned a task to design -Technology

Last Answer : S. No.Control used toControl1CUSTOMER‟S NAMETextField2CUSTOMER‟S CITYComboBox3POLICY TYPE (Individual/Family)RadioButton4INCLUSIONS (Critical Illness/Accidental Coverage/Health Checkup/Others)CheckBox/ListBox

Description : Ms Samtha has many electronics gadgets which are not usable due to outdated hardware and software. Help her to find any three best ways -Technology

Last Answer : 1. Give Your Electronic Waste to a Certified E-Waste Recycler2. Donating Your Outdated Technology3. Give Back to Your Electronic Companies and Drop Off Points.

Description : Ms. Ivana, a leading marketing professional working in a multinational company, is most of the time on move to cater her profession demands. -Technology

Last Answer : Team Viewer

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 : If someone told you they had a Christmas present for your child, but forgot to bring it the last time you got together, would you remind them to bring it this time?

Last Answer : answer:Possibility a) you remind her and she has somehow lost or done something else with the present. She is annoyed and embarrassed and maybe has to go out and get and wrap a new present. b) She remembers ... . The only good scenario. I'd say that there is a one-third chance this will end up well.

Description : Can I still use the 6 cups of brown basmati rice that I cooked last night but forgot to put away... It still smells soooo good!

Last Answer : Technically you shouldn’t. I will confess, however, that I have done it with no ill effects. Partly, it depends on the temperature it sat out in. Also, if you do, use it as quickly as possible (the next day or so at most).

Description : I forgot my password on amazon.com and i tried to recover it by clicking the "forgot password?" link and it wants me to enter the last four digits of the last credit card I used but I didn't use a credit card I used a checking account. Please help.

Last Answer : Why don’t you just open an new account?

Description : The person who sat for the last tashahhud ; But Tashahhud forgot to pronounce: What is his ruling ?

Last Answer : One: Two stops of the last Tashahhud recitation and the sitting prayer for it ; Without these two prayers will not be valid. In the book "Jadul Mustaqani", while describing the rukun of prayer, it ... Then return the salutation. And if it is too late then repeat the whole prayer. GOD is Omniscient.

Description : I forgot the last digit of a 7-digit telephone number. If I randomly dial the final 3 digits after correctly dialing the first four, then what is the chance of dialing the correct number? a) 1/1001 b) 1/1000 c) 1/999 d) 1/990

Last Answer : b) 1/1000

Description : Some will use me, while others will not, some have remembered, while others have forgot. For profit or gain, I'm used expertly, I can't be picked off the ground or tossed into the sea. Only gained from patience and time, can you unravel my rhyme? What am I? -Riddles

Last Answer : I'm Knowledge.

Description : What composer sometimes forgot o attach his suspenders only to have to hold his pants up while conducting to keep them from falling down?

Last Answer : Feel Free to Answer

Description : I forgot to put water in pressure cooker while cooking , do u have the part that i need to replace It is some kind of nut n bolt near to the wishtle?

Last Answer : Check with Sears parts and Repair in your local area. If they dont have it thet can order it for you. Just check for your model number at the bottom of your pressure cooker.. Check with Sears parts ... can order it for you. Just check for your model number at the bottom of your pressure cooker..