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

1 Answer

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.

Related questions

Description : Abhay scanned a few photos but some of the scanned photos did not look colourful enough. -Technology

Last Answer : If some of the scanned photos do not look colourful enough, we can easily improve their tonal range with the “Auto” button in the Levels tool

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 : In covering a distance of 30 km, Abhay takes 2 hours more than Sameer. If Abhay doubles his speed, then he would take 1 hour less than Sameer. Abhay's speed is? a) 5 kmph b) 6 kmph c) 6.25 kmph d) 7.5 kmph e) None of these

Last Answer : Let Abhay's speed be x km/hr. Then, 30/x-30/2x= 3 6x = 30 x = 5 km/hr. Answer: a)

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

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

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.

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

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)

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

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.

Description : It is used to start programs, obtain help, search for files and folders etc. (a) File menu (b) Edit menu (c) Format menu (d) Start button -Technology

Last Answer : (d) Start button is used to start program, obtain helps, search for files and folders etc and also displays the most commonly used programs in a particular context.

Description : Which one of these refers to all objects that have sensors,network connectivity,software,and so on to connect to the network ? :- a) Internet of Things b) Artificial Intelligence c) Machine Learning d) Deep Learning -Technology

Last Answer : internet of things is the correct answer option a

Description : Saurabh wants to insert graphics object in his presentation. Give him names of two graphic objects, which he can insert in his presentation? -Technology

Last Answer : Two graphic objectsare Picture and AutoShapes

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.

Description : Naman wants to change the background image of his Laptop. 1. Can he set his image as wallpaper? -Technology

Last Answer : 1. Yes2. Label B E G A D F C

Description : Ram wants to create a text file to store name and roll number of his students. Suggest, which program he should use. -Technology

Last Answer : He can create a text file using Notepad or WordPad. Follow these steps to create a file using Notepad:(a) Step 1:Click Start.(b) Step 2:Choose All Programs -> Accessories -> Notepad.(c) Step 3: ... dialog box will appear.(g) Step 7:Give file name with extension.(h) Step 8: Click Save button.

Description : If a person wants to obtain agar for tissue culture, which plant group he should search?

Last Answer : If a person wants to obtain agar for tissue culture, which plant group he should search?

Description : If a new student at a research institute wants to understand important ethical standards before commencing his studies, how can he obtain information relevant to these standards?

Last Answer : (1)Searching the “Academic Ethics” section of the Ministry of Science and Technology’s website(2)Searching the “Laws and Regulations Database of the Republic of China” to understand laws ... academic organizations to obtain the latest information on ethical standards(4)All of the above

Description : Data by itself is not useful unless (a) it is massive (b) it is processed to obtain information -Technology

Last Answer : (b) Data is unprocessed and raw facts. It is not useful unless it is processed to obtain information

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 : Where is a good place to start learning about audio production and recording?

Last Answer : It takes a bit of time and practice and trial and error but on a quick Google this site doesn’t look like the worst advice you could get http://homerecording.about.com/od/recordingtutorials/Recording_Methods_Concept_Tutorials.htm

Description : Somya wants to collect some information regarding the history of India. 1. What is the fastest and easiest -Technology

Last Answer : 1. The online search using the search engine.2. (e) Open the Web browser(c) Load a search engine(a) Type keywords(d) Click the search button(b) Look at the list of Websites starting at the top.

Description : Ram wants to attach a CD_ROM to an E_mail. Can it be possible? -Technology

Last Answer : No, it is not possible.You can attach following items to an E-mail:• A Word document• A digital photograph• A program• A slideshow• Audio file• Video file• Web page

Description : Mr. Ravindra wants to send some money to her wife who is in some other city. -Technology

Last Answer : E-banking is the easiest way to transfer money through the bank.

Description : Shri wants to search about computer vendor in Meerut excluding Dell category. -Technology

Last Answer : (c) Computer vendor + Meerut – Dell

Description : Ramya wants to connect all the computers of her office wirelessly in order to avoid clumsy cables. -Technology

Last Answer : Wi-Fi technology would be best suitable for her office to avoid cabling.

Description : Sweety wants to use an operating system based on graphical user interface, suggest her a name. -Technology

Last Answer : Windows is an operating system based on graphical user interface. Graphical user interface means that it has pictures (graphics) that you use to communicate (interface) with the computer.

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 : Manu wants to replace the word ‘organise1 with ‘organize’ in a whole document. 1. Name the feature which is used by Manu. -Technology

Last Answer : 1. Mama can replace the word using Find and Replace feature.2. Label: b e a d c

Description : Automatic formatting that the user wants? (a) Replace text As You Type (b) AutoFormat As You Type -Technology

Last Answer : (b) For turning Automatic formatting On or Off, AutoFormat As You Type tab under Proofing is used.

Description : Kirti wants to add sound to slide transition. Which feature of Animations tab is useful for this purpose? -Technology

Last Answer : On the Animations tab in the Transition to This Slide group, click the arrow next to ‘Transition Sound’ to add sound to slide transition.

Description : Seema wants to give identical design to all the slides and handouts, she is going to print from her presentation. -Technology

Last Answer : 1. Seema can do this in following two ways:(a) Creating same design on each slide and handouts manually.(b) Using slide master and handout master.2. In the first method , the efforts are ... design may creep in. The second method ensures reduce efforts and identical design on each slide and handout.

Description : Rama is preparing a presentation on her company’s annual performance. She wants some text present on a slide to fly in from the left, -Technology

Last Answer : (c) Custom Animation can be used for the desired functionality.

Description : Hansika wants to apply MIN function on a cell range, -Technology

Last Answer : MIN function will return O(zero) in this case.

Description : Neha Mittal wants to store data of her montly expenditure for a period of two year and also wants -Technology

Last Answer : Microsoft Excel should be used because it cannot only be used for storing data but also be used to perform calculations and analysis of the data.

Description : Reena wants to get employment opportunities based on IT. What are the options for employments? -Technology

Last Answer : Web designing and developing, E-Learning, advertising etc are the options for employments opportunities based on IT.

Description : Laleema Chakradhar wants a broadband connection for accessing her mails and staying informed about the latest -Technology

Last Answer : VSNL, Airtel etc.

Description : Aayush wants to send highly sensitive form data such as username and password -Technology

Last Answer : POST METHODAppends form-data inside the body of the HTTP request (data is not shown in URL)Form submissions with POST cannot be bookmarked

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 : Mr. Sanjay wants to plot a bar graph for the given set of values of subject on x_axis and number of students who opted for that subject on -Technology

Last Answer : (i) plt.bar(x,y)(ii) plt.show()

Description : Mr. Harry wants to draw a line chart using a list of elements named LIST. -Technology

Last Answer : (i) PLINE.plot(LIST)(ii) PLINE.ylabel(“Sample Numbers”)

Description : ABC Company wants to link its computers in the Head office in New Delhi to its office in Sydney. -Technology

Last Answer : ABC Company will formed the World Area Network (WAN) to link its computers in the Head office in New Delhi to its office in Sydney. Unguided or wireless media should be used to form World Area Network.

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 : 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 : When learning new technology, do you first read the manual, or attain your learnings from online video?

Last Answer : I usually just fiddle around with it. I like the challenge of new technology. If I get stuck, I’ll check out the help section (if one exists) or google for an answer. Almost never use the manual or watch help videos.

Description : What is e_Learning? Mention any two main benefits of e –learning with respect to the use of Information Technology. -Technology

Last Answer : Learning with the help of electronic resources like computers, tablets, smart phone, internet etc. is known as E-learning.Advantages of eLearning are:It is time saving as well as removes the ... than traditional classroom-based instruction.It is less expensive to set-up an e-learning environment.

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 : 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 : A sport/event organization that wants to obtain information about the population in a certain geographic location might use A. Government sources B. Primary Databases C. Personal Questionaires D. telephone surveys

Last Answer : B. Primary Databases