Ms. Archana, a class XI student has just started learning MySQL. Help her in understanding the basic difference between -Technology

Ms. Archana, a class XI student has just started learning MySQL. Help her in understanding the basic difference between -Technology
by

1 Answer

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 used to modify the records of the table.Example:If a table named emp already exists withfollowing columns:EmpnoNameDeptTo add an address column, we may use following command:Alter Table emp add address varchar(20);Example:To modify the address to Noida from “New Delhi”, we may usethe following command :Update emp set address= “Noida” where city= “New Delhi”;suitable command:(i)Show Databases(ii) Use City(iii) Drop Database Clients(iv) Drop table Club
by

Related questions

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.

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.

Shewani has recently started working in MySQL. Help her in understanding the difference between the following : -Technology

Description : Shewani has recently started working in MySQL. Help her in understanding the difference between the following : -Technology

Last Answer : (i) Where clause is used to show data set for a table based on a condition and having clause is used to put condition on the result set that comes after using Group by clause.(ii) COUNT ... unique as single column or combined multiple columns to the table. They are all candidates for Primary Key.

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'.

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

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

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.

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

What is MySQL used for? Abhay wants to start learning MySQL. From where can he obtain the MySQL software? -Technology

Description : What is MySQL used for? Abhay wants to start learning MySQL. From where can he obtain the MySQL software? -Technology

Last Answer : MySQL is a Relational Database Management System (RDBMS), used for adding, accessing and processing data in a database. Abhay can download the MySQL software setup from Internet.

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

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

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.

Ms. Cathy is creating a form for Vidya University Sports Council application. Help her to choose the most appropriate controls -Technology

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

is_connected() is the MYSQL function to : -Technology

Description : is_connected() is the MYSQL function to : -Technology

Last Answer : (e)verify whether the python application is connected to mysql database.

Write the code in python to read the contents of “number.csv” file consisting of data from a mysql table and print the data of the table -Technology

Description : Write the code in python to read the contents of “number.csv” file consisting of data from a mysql table and print the data of the table -Technology

Last Answer : f = open('numbers.csv', 'r') with f:reader = csv.reader(f)for row in reader:for e in row:print(e)

The avg() function in MySql is an example of ..... (a) Math function (b) Text function (c) Date Function (d) Aggregate Function -Technology

Description : The avg() function in MySql is an example of ..... (a) Math function (b) Text function (c) Date Function (d) Aggregate Function -Technology

Last Answer : (d)Aggregate Function

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

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

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

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.

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

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

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

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

What is a good book for learning PHP and MySQL?

Description : What is a good book for learning PHP and MySQL?

Last Answer : I’d start here: http://www.php.net/manual/en/ Get a feel for PHP, then buy books to fill in the gaps or get deeper into particular areas.

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

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.

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

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;

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;

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.

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

There are 312, 260 and 156 students in class X, XI and XII respectively. Buses are to be hired to take these students to a picnic. Find the maximum number of students who can sit in a bus if each bus takes equal number of students (a) 52 (b) 56 (c) 48 (d) 63

Description : There are 312, 260 and 156 students in class X, XI and XII respectively. Buses are to be hired to take these students to a picnic. Find the maximum number of students who can sit in a bus if each bus takes equal number of students (a) 52 (b) 56 (c) 48 (d) 63

Last Answer : (a) 52

If I already know basic PHP/MySQL, what else should I learn to use Google App Engine?

Description : If I already know basic PHP/MySQL, what else should I learn to use Google App Engine?

Last Answer : answer:I am not an expert, I just started reading up on this myself, but here are a couple of starting points on data storage. Rather than a separately maintained SQL database, ... .com/appengine/articles/datastore/overview.html http://code.google.com/appengine/docs/python/datastore/overview.html

Which of the following is not a key activity of an operations manager? a. Understanding Understanding the needs of customer customer b. Continually learning Continually learning c. Managing cash flows d. Exploiting Exploiting technology to technology to produce goods produce goods and ser and services

Description : Which of the following is not a key activity of an operations manager? a. Understanding Understanding the needs of customer customer b. Continually learning Continually learning c. Managing cash ... d. Exploiting Exploiting technology to technology to produce goods produce goods and ser and services

Last Answer : c. Managing cash flows

Ws of 1991, the most recent award of a Nobel Prize in medicine to a woman scientist went to this esteemed pharmacologist and biochemist. She shared her prize with George Hitchings for their development of drugs based on understanding basic cell processes. They came up with drugs that selectively block nucleic acid synthesis without damaging normal cells. Name this woman scientist.

Description : Ws of 1991, the most recent award of a Nobel Prize in medicine to a woman scientist went to this esteemed pharmacologist and biochemist. She shared her prize with George Hitchings for ... drugs that selectively block nucleic acid synthesis without damaging normal cells. Name this woman scientist.

Last Answer : ANSWER: (GERTRUDE) ELION

What convincing argument was made by Anne? i) She was talkative just like any other student in the class. ii) She had the right to be talkative, as it was a classroom and not a prison. iii) She had inherited the trait from her mother, so couldn‘t stop being talkative. iv) She found it impossible to be quiet like the others as she couldn‘t change herself.

Description : What convincing argument was made by Anne? i) She was talkative just like any other student in the class. ii) She had the right to be talkative, as it was a classroom and not a prison. iii) ... being talkative. iv) She found it impossible to be quiet like the others as she couldn t change herself.

Last Answer : iii) She had inherited the trait from her mother, so couldn‘t stop being talkative.

Prachi is working with following swing controls: jButton, jLabel, jTextField, jCheckBox. Suggest her any two basic methods commonly available -Technology

Description : Prachi is working with following swing controls: jButton, jLabel, jTextField, jCheckBox. Suggest her any two basic methods commonly available -Technology

Last Answer : getText(), setText()

As a student, K-12, did you view field trips and movies shown in class as a learning experience or a break from classwork?

Description : As a student, K-12, did you view field trips and movies shown in class as a learning experience or a break from classwork?

Last Answer : answer:When I was a kid, they were breaks in the monotony and nothing more. Sure, we went to the Museum of Science or the New England Aquarium. But I already went there with my mom - and when I was ... and experience, but I honestly believe they are just a fun (or not so fun) treat for the kids.

Which one of the following is not a quality of teacher? Options: A) Teacher should use modern techniques. Methods and gadgets are teaching for better understanding of subject matter. B) Teacher should maintain a autocratic atmosphere in the class. C) He/she should have interest in his/her profession and knowledge must be updated. D) Teacher must be fair tin grading and marking.

Description : Which one of the following is not a quality of teacher? Options: A) Teacher should use modern techniques. Methods and gadgets are teaching for better understanding of subject matter. B) Teacher should ... /her profession and knowledge must be updated. D) Teacher must be fair tin grading and marking.

Last Answer : B) Teacher should maintain a autocratic atmosphere in the class. 

Ms. Farrell has 36 students in her class. This is 5 more students than Mr. Carter has. How many students does Mr.carter have?

Description : Ms. Farrell has 36 students in her class. This is 5 more students than Mr. Carter has. How many students does Mr.carter have?

Last Answer : 4000

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

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.

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

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.

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

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

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

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

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

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

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

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.

A teacher generally asks questions to his pupils during the lecture, why? Options: A) Are Students Listening The Lecture Attentively? B) To Know, Which Student Is Brilliant One? C) To Know Whether The Students Are Understanding The Lecture Or Not. D) To Help The Students

Description : A teacher generally asks questions to his pupils during the lecture, why? Options: A) Are Students Listening The Lecture Attentively? B) To Know, Which Student Is Brilliant One? C) To Know Whether The Students Are Understanding The Lecture Or Not. D) To Help The Students

Last Answer : C) To Know Whether The Students Are Understanding The Lecture Or Not. 

Raj at is a commerce student and wants to do his homework but somehow he has lost his calculator and wants to take computer’s help. -Technology

Description : Raj at is a commerce student and wants to do his homework but somehow he has lost his calculator and wants to take computer’s help. -Technology

Last Answer : Rajat can use calculator in the system that can do simple as well as sophisticated calculations.To start the calculator:Click Start —> All Programs —> Accessories —> Calculator.

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)

What's a good way to go about learning electronics that doesn't involve a class?

Description : What's a good way to go about learning electronics that doesn't involve a class?

Last Answer : A computer website is the next best teacher. Its all there, you just have to search for it.

Teachers use teaching aids for Options: A) Making Teaching Interesting. B) Making Teaching With Understanding Level Of Students C) Making Student Attentive. D) The Sake Of Its Use.

Description : Teachers use teaching aids for Options: A) Making Teaching Interesting. B) Making Teaching With Understanding Level Of Students C) Making Student Attentive. D) The Sake Of Its Use. 

Last Answer : B) Making Teaching With Understanding Level Of Students 

Write one basic difference between bgcolor and background attributes. -Technology

Description : Write one basic difference between bgcolor and background attributes. -Technology

Last Answer : The bgcolor attribute is used for coloring the background of the document while background attribute specifies a background image for a document.

Which one of the following is not required for effective learning? Options: A) Ask open ended divergent questions which allow for a variety of acceptable answers B) Use the 'brain storming ' techniques to evaluate the understanding of specific facts and their feedback C) Ask students to go for a group discussion on a subject/topic D) All of these are helpful in effective teaching

Description : Which one of the following is not required for effective learning? Options: A) Ask open ended divergent questions which allow for a variety of acceptable answers B) Use the 'brain storming ' techniques ... for a group discussion on a subject/topic D) All of these are helpful in effective teaching

Last Answer : D) All of these are helpful in effective teaching

Which theory of learning has found knowledge of internal processes crucial to the understanding of learning? Options: A) Cognitive theorists B) Stimulus response theorists C) Operant conditioning theorists D) Classical conditioning theorists

Description : Which theory of learning has found knowledge of internal processes crucial to the understanding of learning? Options: A) Cognitive theorists B) Stimulus response theorists C) Operant conditioning theorists D) Classical conditioning theorists

Last Answer : A) Cognitive theorists

The most important objective of teaching is to Options: A) facilitate students when it comes to the construction of knowledge and understanding B) cover the Syllabus timely C) create a friendly environment inside the classroom or teaching learning process D) attend and takes the classes regularly and timely

Description : The most important objective of teaching is to Options: A) facilitate students when it comes to the construction of knowledge and understanding B) cover the Syllabus timely C) create a friendly ... inside the classroom or teaching learning process D) attend and takes the classes regularly and timely

Last Answer : A) facilitate students when it comes to the construction of knowledge and understanding

Psychologists would consider the real criterion of whether or not learning has taken place to be Options: A) Increased sensitivity to appropriate stimuli B) Increased understanding C) Improved behaviour D) Speed of reaction

Description : Psychologists would consider the real criterion of whether or not learning has taken place to be Options: A) Increased sensitivity to appropriate stimuli B) Increased understanding C) Improved behaviour D) Speed of reaction

Last Answer : C) Improved behaviour