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

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

1 Answer

Answer :

(d)Aggregate Function
by

Related questions

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.

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

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.

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

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)

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.

Why are aggregate functions called so? Name some aggregate functions. -Technology

Description : Why are aggregate functions called so? Name some aggregate functions. -Technology

Last Answer : Recruits support aggregate functions. These are ao called because they accept a record set and a field name as inputs and generate a single result. The supported aggregate functions are the following: 1) Count ... in rescel. By default they are applied to the totality of the records in a record set.

Write one example of each field, for which you would use 1. Text data type -Technology

Description : Write one example of each field, for which you would use 1. Text data type -Technology

Last Answer : 1. Text data type It allows to store text or combination of text and numbers as well as numbers that don't require calculations such as phone number. This data type allows maximum 255 characters ... Description will be of Memo data type, because the length of description of employee may be large.

Google (www.google.com) is a (a) Search Engine (b) Number in Math (c) Chat service on the web -Technology

Description : Google (www.google.com) is a (a) Search Engine (b) Number in Math (c) Chat service on the web -Technology

Last Answer : Google (www.google.com) is aSearch Engine .

Does MySQL have a native counter function for its results?

Description : Does MySQL have a native counter function for its results?

Last Answer : I know that with PHP when you query the database and it returns any results it'll provide an array of results I think so you can loop through them and get the data from them, however nativly I don't ... and report what I find, if anything at all :) what langauge are you programming in by the way?

AVG detected a supposed threat but how do I know it's really a problem?

Description : AVG detected a supposed threat but how do I know it's really a problem?

Last Answer : Delete it. It’s a trojan pretending to be a Windows program. But if it was a legitimate Windows program, it wouldn’t be hanging out on the root of your E: drive.

Is it required to renew your anti-virus license with AVG?

Description : Is it required to renew your anti-virus license with AVG?

Last Answer : answer:Nobody can make you renew the program. You won’t get the newest version, and maybe won’t get some upgrades, but that’s it. That being said, you can have your computer perfectly well protected using only free things and common sense.

AVG sent me an email, stating my license will expire in 57 days. whats this all about?

Description : AVG sent me an email, stating my license will expire in 57 days. whats this all about?

Last Answer : Most anti-virus software you have to renew yearly. You should be able to do this online rather than going out and buying a new c.d. Here’s their website.

I've downloaded AVG for free, do I get rid of my free subscription from Norton on my computer?

Description : I've downloaded AVG for free, do I get rid of my free subscription from Norton on my computer?

Last Answer : Nuke Norton. First of all it sucks. And second it is kinda bad to run two anti virus programs at the same time. I would just use AVG. And don’t use IE. Use Firefox or Chrome to browse.

I'm an AVG user, I'm wondering what other free anti virus software is good?

Description : I'm an AVG user, I'm wondering what other free anti virus software is good?

Last Answer : I've used Avira, Avast, AVG and Microsoft Security Essentials (MSE). Currently I'm using MSE, it seems to impact the performance of my laptop less than others. But it seems every 6 months or ... trojan horses/spyware. Even if things aren't acting up, I scan with Malwarebytes every couple of weeks.

For those who have used both, do you prefer AVG or Avast anti-virus and why?

Description : For those who have used both, do you prefer AVG or Avast anti-virus and why?

Last Answer : I’ve happily used both. In my opinion neither is sufficient by itself, but I believe that to be true for all such security programs. I run Comodo, AVG, Spyware Dr., Malware Bytes Adaware and a couple of others design to ferret out root kits.

Why is it so slow to scan my computer using AVG? How do I quarantine on AVG?

Description : Why is it so slow to scan my computer using AVG? How do I quarantine on AVG?

Last Answer : Any virus scan is resource intensive, so it is better that the scan be slow than that the scan slows down your system. On the results page you should be able to make the choices to delete, quarantine, or ... the full scan to complete. Just let it run overnight, or all day if you are away at work.

How do I edit "AVG 8 Free" site block list?

Description : How do I edit "AVG 8 Free" site block list?

Last Answer : answer:I have a different version but I think this is the same process. You need to open up AVG, Select Tools, Advanced Settings and then go to LinkScanner on the left, there should be some boxes you can ... to like a list of exceptions But it's all I know and no one else answered it seems. :)

Where is AVG (FREE ENGLISH) safe to download?

Description : Where can I safely download the free version of AVG Anti-Virus? Last time I didn’t even know where I took it from, and I swallowed a good little Trojan with it. :) 

Last Answer : If you want to be sure, download from the developer's page. Click HERE and you can download the free version. 

Where is AVG safe to download?

Description : Where can I safely download the free version of AVG Anti-Virus? Last time I didn’t even know where I took it from, and I swallowed a good little Trojan with it. :) 

Last Answer : It's a good question because there are really plenty of places to come across fake download sites where they cheat on clicking on ads. If you want to download the free version of AVG, you can do ... click the green "try" button, you will only be installing a trial version that is time limited.   

Avast or AVG?

Description : I need to put my heads together with someone. I will outline the situation: I have a new computer with Win 8 and pre-installed McAfee LifeSafe and McAfee Security Scan, as supplied by Lenovo as part of its kits. Now, ... , but I won't read it in a row, it's too long. Thank you for the advice. :)

Last Answer : I have a bad experience with avg - it requires a lot of computer ram. after trying different antiviruses, I chose avast. I acknowledge that the situation may have changed since 2008, but I have been with ... . opt for a free version (sufficient) or a paid version (no need) as needed. (tuxedo)

is avg better than kaspersky

Description : is avg better than kaspersky

Last Answer : Need Answer

How much is the avg. gas fireplace installation cost in the U.S.?

Description : How much is the avg. gas fireplace installation cost in the U.S.?

Last Answer : The average gas fireplace installation cost is about $500. It is cheaper than a wood burning foreplace installation.

Is AVG any good?

Description : Is AVG any good?

Last Answer : I've used Norton Anti-Virus and had great success. It is easy to use and is also free.

In which of the following categories of Robot AVG placed?  1. A saturated robot  2. A mobile robot  3. A uncontrolled robot  4. A natural robot

Description : In which of the following categories of Robot AVG placed?  1. A saturated robot  2. A mobile robot  3. A uncontrolled robot  4. A natural robot

Last Answer : 2

A blog consists of (a) images (b) text (c) links (d) All of these -Technology

Description : A blog consists of (a) images (b) text (c) links (d) All of these -Technology

Last Answer : (d) A blog consists of images, text and links.

Why we cannot use a text editor as a picture editing tool? -Technology

Description : Why we cannot use a text editor as a picture editing tool? -Technology

Last Answer : Text editor is a editing program which does not support the editing of graphical images because it works only on text.

………… elements help to express emotions or feelings in E_mail or text messages. -Technology

Description : ………… elements help to express emotions or feelings in E_mail or text messages. -Technology

Last Answer : Emoticon elements help to express emotions or feelings in E-mail or text messages.

Plain text (txt) E_mail messages can be read by any type of E_mail application. -Technology

Description : Plain text (txt) E_mail messages can be read by any type of E_mail application. -Technology

Last Answer : True Plain text E-mail contains plain text without any formatting options such as bold, italic, colored fonts etc., so these can be read by any type of E-mail application.

E_learning only supports text materials. -Technology

Description : E_learning only supports text materials. -Technology

Last Answer : False E-learning includes numerous types of media that deliver text, audio, images, animation and streaming videos.

Which of the following is not related to a utility software? (a) Text editor (b) Antivirus program (c) Disk compression software -Technology

Description : Which of the following is not related to a utility software? (a) Text editor (b) Antivirus program (c) Disk compression software -Technology

Last Answer : (d) Railway reservation system is an example of application software whereas, rest all are software utilities.

A text editor is used to facilitate the creation and correction of text. -Technology

Description : A text editor is used to facilitate the creation and correction of text. -Technology

Last Answer : TrueA text editor is used to create and edit the text. Text editor is a part of utility.

Encrypted data is referred as cipher text. -Technology

Description : Encrypted data is referred as cipher text. -Technology

Last Answer : TrueEncrypted data is presented in coded form. So, it is known as cipher text.

What happens when you enter numbers in a Text data type field? -Technology

Description : What happens when you enter numbers in a Text data type field? -Technology

Last Answer : Numbers are accepted as a text value.

What happens when text is entered in a Number type field? -Technology

Description : What happens when text is entered in a Number type field? -Technology

Last Answer : When we enter text in a Number field and press Enter or press Tab key, MS-Access displays a message that “The value you entered does not match the Number data type in this column.”

If the data type of a field is set to Text, what will be its number range? -Technology

Description : If the data type of a field is set to Text, what will be its number range? -Technology

Last Answer : Its range will be 0 to 255.

When Memo data type is preferred over Text type for a field? -Technology

Description : When Memo data type is preferred over Text type for a field? -Technology

Last Answer : When the length of the field is more than 255 characters. Text data type is not capable to store the project description because its length cannot be more than 255 characters so, Memo data type is preferred over the Text data type.

Distinguish between Text and Memo data types. -Technology

Description : Distinguish between Text and Memo data types. -Technology

Last Answer : Distinguishing between Text and Memo are as follows:TextMemoIt is used for relatively short entries.It is used for long text paragraphs.It can store upto 255 characters only.It can store upto 65536 ... the number of characters.It does not use field size property.e.g. Emp_namee.g. Emp_description

How are field types Text and Memo different from each other? -Technology

Description : How are field types Text and Memo different from each other? -Technology

Last Answer : Distinguishing between Text and Memo are as follows:TextMemoIt is used for relatively short entries.It is used for long text paragraphs.It can storeupto255 characters only.It can storeupto65536 characters. ... number of characters.It does not use field size property.e.g. Emp_namee.g. Emp_description

A text field is initially 40 characters long and one record has an entry in this field in MS_Access database. -Technology

Description : A text field is initially 40 characters long and one record has an entry in this field in MS_Access database. -Technology

Last Answer : Since the new field length is 20 characters long. So, this field will contain only left 20 characters including spaces and the remaining data will be discarded. Thus, the data from the right side of the field will be lost.

What data type should you choose for a zipcode field in a table? (a) Text (b) Number -Technology

Description : What data type should you choose for a zipcode field in a table? (a) Text (b) Number -Technology

Last Answer : (b) Number data type should be chosen for a zip code field in a table.

In a Text type data field, we can enter a maximum of ………….. characters. -Technology

Description : In a Text type data field, we can enter a maximum of ………….. characters. -Technology

Last Answer : In a Text type data field, we can enter a maximum of 255characters.

A Text data type cannot allow number entry. -Technology

Description : A Text data type cannot allow number entry. -Technology

Last Answer : False As, it can include both text as well as numbers.

Explain the following statement: <BODY bgcolor=“yellow” text =“red” vlink=“blue”> -Technology

Description : Explain the following statement: -Technology

Last Answer : The code will set the Web page background color as yellow, text color as red and visited link color as blue.

How would you display text in the title bar of a browser? -Technology

Description : How would you display text in the title bar of a browser? -Technology

Last Answer : To display text in a title bar of a browser, use the tag inside the tag in the HTML document.e.g. HTML document

Which tag do we use to change the size and style (face) of the text of an HTML file viewed on a Web browser? -Technology

Description : Which tag do we use to change the size and style (face) of the text of an HTML file viewed on a Web browser? -Technology

Last Answer : tag is used to change the size and style (face) of the text of an HTML file displayed on a Web browser. Two attributes of tag are as follows:size: It specifies the size of the text inside a tag.Syntaxface: It specifies the font name of the text inside a tag.Syntax