14. 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 Databases17. This includes columns for tracking metadata, such as creation and modification dates or user IDs.A. PartitioningB. Audit TrailsC. Data Volume and PerformanceD. Documentation18. The purpose of each table, the relationships between tables, and any specific considerations related to the design.A. PartitioningB. Audit TrailsC. Data Volume and PerformanceD. Documentation10. It is a technique to optimize data retrieval by creating a data structure that allows faster access to specific records.A. KeysB. TransactionsC. NormalizationD. Indexing15. 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 Keys11. 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 Databases7. 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. Columns4. This history was client-server architecture gained popularity, enabling distributed databases and improving scalability.A. 1990sB. 1950s-1960sC. 1970sD. 2000s20. These database databases are suitable for applications with complex data structures and relationships, where data is modeled as objects.A. Object-Oriented DatabasesB. Distributed DatabasesC. Columnar DatabasesD. NewSQL Databases8. It is also known as records or tuples, containing the data entries in a table.A. RowsB. FieldsC. TablesD. Columns

19. 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 Keys

19. This database is used in cloud computing environments, global enterprises, and systems requiring high availabilityA. Object-Oriented DatabasesB. Distributed DatabasesC. Columnar DatabasesD. NewSQL Databases6. 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. Columns

Which NoSQL database type stores each record and its associated data within a single document and also works well with Analytics platforms?1 pointColumn-based Key-value store  Graph-basedDocument-based

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 commonly used NoSQL database for handling unstructured or semi-structured data in Big Data Analytics?(1 Point)a) MySQLc) MongoDBd) Oracle Databased) SQL Server