__ is a feature of a spreadsheet applications thatallow you to summarize large amounts of dataSelect one:a.Conditional Formattingb.Sorting and Filteringc.Pivot Tablesd.Mixed Type Charts

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

____ is used in Pandas to describe the column names of a DataFrame.

Charts are basically used toa) design tablesb) organize data in tablesc) Sort data in different columnsd) show the quantities and their relationships graphically

A pivot table is used to summarize, analyze, explore, and present summary data. True False

_ is a term used to refer to an attribute of an object that allowspeople to know how to use it.VisibilityAffordance (page 105)ConstraintNone of these