6. Computes the average value of a numeric column, offering insights into the central tendency or typical value in a dataset.A. AVGB. EQLC. SUMD. TOTAL5. SQL keyword that aggregates numeric values in a column, providing a total efficient analysis of numerical data.A. AVGB. EQLC. SUMD. TOTAL1.  The SQL ______ keyword is used in conjunction with the SELECT statement to fetch unique records from a table.A. DISTINCTB. UNIQUEC. AVGD. SELECT8. It is a logical operator used to combine multiple conditions in a WHERE clause. The result is true if at least one of the conditions is true.A. BETWEENB. ORC. LOGICD. AND2.  We use the _______ keyword with the SELECT statement when there is a need to avoid duplicate values present in any specific columns/tables.A. LIMITB. DISTINCTC. AVGD. SELECT4. It is an aggregate function in SQL used to ____ the number of rows that meet a specified condition or the total number of rows in a table.A. LIKEB. LIMITC. COUNTD. SELECT10. It is used as a database query language to express questions asked against databases.A. BETWEENB. ORC. LOGICD. AND9. It is a comparison operator used to filter results based on a range of values. It is often used with numerical or date values.A. BETWEENB. ORC. LOGICD. AND3.  It is used in an SQL query to restrict the number of rows returned by the query result.A. LIKEB. LIMITC. COUNTD. SELECT7. It is a logical operator used to combine multiple conditions in a WHERE clause. The result is true only if all the conditions are true.A. BETWEENB. ORC. LOGICD. AND

The AVG function in SQL is used for:Finding the difference between the highest and lowest values.Calculating the average of all values in a numeric column or within a group.Duplicating all rows in a table.Selecting rows based on a specific pattern.

Which of the following statements is wrong?Question 28Select one:a.AVG() outputs the average (arithmetic mean) of the column values addressed by the query.b.MAX() outputs the maximum, the largest, column value from those that are addressed by the query.c.SUM() outputs the sum total of all the column values that are addressed by the query. This function can be used with every column.d.MIN() outputs the minimum, the smallest, column value from those that are addressed by the query.

Which SQL function is used to calculate the average value of a numeric column?OptionsMAX()SUM()COUNT()AVG()

8. It is an aggregate function in SQL used to ____ the number of rows that meet a specified condition or the total number of rows in a table.A. LIKEB. LIMITC. COUNTD. SELECT15. These databases are ideal for representing and traversing complex relationships in data, such as social networks, fraud detection, and network analysis.A. Time-Series DatabasesB. Graph DatabasesC. RDBMSD. NoSQL Databases1. It is also known as fields or attributes, which define the different data types that can be stored in a table.A. RowsB. FieldsC. TablesD. Columns7. It is the process of organizing data to eliminate redundancy and improve data integrity.A. KeysB. TransactionsC. NormalizationD. Indexing16. It is a logical operator used to combine multiple conditions in a WHERE clause. The result is true if at least one of the conditions is true.A. BETWEENB. ORC. LOGICD. AND18. It is a comparison operator used to filter results based on a range of values. It is often used with numerical or date values.A. BETWEENB. ORC. LOGICD. AND17. These databases are optimized for handling data points indexed by time, making them suitable for applications like IoT (Internet of Things) sensor data, financial market data, and system monitoring.A. Time-Series DatabasesB. Graph DatabasesC. RDBMSD. NoSQL Databases5. It is also known as records or tuples, containing the data entries in a table.A. RowsB. FieldsC. TablesD. Columns11. These databases are suitable for scenarios with large volumes of unstructured or semi-structured data, such as real-time big data processing, content management systems, and applications that require horizontal scalability.A. Time-Series DatabasesB. Graph DatabasesC. RDBMSD. NoSQL Databases19. These databases are optimized for handling data points indexed by time, making them suitable for applications like IoT (Internet of Things) sensor data, financial market data, and system monitoring.A. IndexesB. ConstraintsC. Foreign KeysD. Primary Keys10. SQL keyword that aggregates numeric values in a column, providing a total efficient analysis of numerical data.A. AVGB. EQLC. SUMD. TOTAL6.  It is used in an SQL query to restrict the number of rows returned by the query result.A. LIKEB. LIMITC. COUNTD. SELECT4.  We use the _______ keyword with the SELECT statement when we need to avoid duplicate values in any specific columns/tables.A. LIMITB. DISTINCTC. AVGD. SELECT14. It is a logical operator used to combine multiple conditions in a WHERE clause. The result is true only if all the conditions are true.A. BETWEENB. ORC. LOGICD. AND13. These databases are used when data is highly structured and there is a need for complex queries and transactions.A. Time-Series DatabasesB. Graph DatabasesC. RDBMSD. NoSQL Databases20. It is used as a database query language to express questions asked against databases.A. BETWEENB. ORC. LOGICD. AND12. Computes the average value of a numeric column, offering insights into the central tendency or typical value in a dataset.A. AVGB. EQLC. SUMD. TOTAL9. It is a technique to optimize data retrieval by creating a data structure that allows faster access to specific records.A. KeysB. TransactionsC. NormalizationD. Indexing2.  The SQL ______ keyword is used with the SELECT statement to fetch unique records from a table.A. DISTINCTB. UNIQUEC. AVGD. SELECT3. These are individual data elements in a record. They represent specific properties or characteristics of the entity stored in the database.A. RowsB. FieldsC. TablesD. Columns

Which of the following is a SQL aggregate function?Select one:a.averageb.avgc.meand.sqrt