MCQs on Oracle SQL for Data Science and Analytics | Data Exploration

Using Oracle for Data Exploration and Analysis

1. Which of the following Oracle SQL clauses is used to filter data based on specific conditions?
   • a) GROUP BY
   • b) ORDER BY
   • c) WHERE
   • d) HAVING
2. Which of the following Oracle SQL functions is used to calculate the average value of a column?
   • a) COUNT()
   • b) SUM()
   • c) AVG()
   • d) MIN()
3. Which SQL clause in Oracle allows for grouping data into subsets based on column values?
   • a) GROUP BY
   • b) DISTINCT
   • c) JOIN
   • d) UNION
4. In Oracle SQL, which function is used to find the maximum value of a specified column?
   • a) MIN()
   • b) MAX()
   • c) SUM()
   • d) AVG()
5. Which Oracle SQL clause is used to sort the result set in ascending or descending order?
   • a) ORDER BY
   • b) GROUP BY
   • c) LIMIT
   • d) DISTINCT

Statistical Functions in Oracle SQL

6. Which statistical function in Oracle SQL returns the number of non-NULL values in a column?
   • a) COUNT()
   • b) SUM()
   • c) DISTINCT()
   • d) NVL()
7. What does the Oracle SQL function STDDEV() calculate?
   • a) The sum of the values in a column
   • b) The standard deviation of the values in a column
   • c) The average of the values in a column
   • d) The count of distinct values in a column
8. The Oracle SQL function VARIANCE() computes which of the following?
   • a) The average value of a column
   • b) The variance of the values in a column
   • c) The maximum value of a column
   • d) The count of rows in a column
9. In Oracle SQL, which function is used to calculate the median of a set of values?
   • a) MEDIAN()
   • b) PERCENTILE_CONT()
   • c) MODE()
   • d) RANK()
10. What is the purpose of the COVAR_POP() function in Oracle SQL?
    • a) To calculate the covariance of two columns
    • b) To calculate the correlation between two columns
    • c) To calculate the variance of a column
    • d) To calculate the sum of two columns

Integrating SQL with Data Science Tools (R, Python)

11. How can data from an Oracle database be imported into R for analysis?
    • a) Using the RODBC package
    • b) Using the SQL Server package
    • c) Using the DataFrame package
    • d) Using the OracleSQL package
12. Which Python library is commonly used to connect to Oracle databases for data analysis?
    • a) psycopg2
    • b) pyodbc
    • c) cx_Oracle
    • d) sqlalchemy
13. In Oracle, which method can be used to call a Python function within a SQL query?
    • a) Using Oracle’s PL/SQL API
    • b) Using the SQL Server Integration Services (SSIS)
    • c) Using the Python-Oracle Connector
    • d) Using the R-Python Interface
14. What is the function of Oracle Data Pump in data integration with Python or R?
    • a) To load data into Oracle directly from Python
    • b) To export and import large volumes of data between Oracle databases and external tools
    • c) To call Python functions directly from Oracle SQL
    • d) To integrate Oracle data with Microsoft Excel
15. How can R be used to perform predictive analytics on data stored in an Oracle database?
    • a) By using Oracle’s inbuilt R functions
    • b) By connecting to Oracle via the ROracle package and executing SQL queries
    • c) By importing data from Oracle into Excel and analyzing it there
    • d) By using Python and then feeding the results back to Oracle

Working with Big Data in Oracle (External Tables, Hadoop Integration)

16. What is an external table in Oracle SQL used for?
    • a) Storing data in a different schema
    • b) Accessing data stored outside the database, such as in flat files or Hadoop
    • c) Creating backups of the database
    • d) Accessing data in a different database
17. How can Oracle integrate with Hadoop for big data analytics?
    • a) By using the Oracle Big Data SQL feature
    • b) By using Oracle Data Pump
    • c) By using the Oracle GoldenGate tool
    • d) By using Oracle BI Publisher
18. What is the primary benefit of using Oracle External Tables for big data integration?
    • a) They store the data in Oracle format for easy querying
    • b) They allow seamless access to external data without moving it into the database
    • c) They provide built-in machine learning capabilities
    • d) They optimize queries for relational databases
19. Which of the following can be used to connect Oracle to Hadoop?
    • a) Oracle Big Data Connectors
    • b) Oracle Data Guard
    • c) Oracle Recovery Manager (RMAN)
    • d) Oracle GoldenGate
20. In Oracle, which of the following tools is used to query external tables in Hadoop?
    • a) Oracle BI
    • b) Oracle SQL Developer
    • c) Oracle Big Data SQL
    • d) Oracle Data Pump

Data Mining with Oracle Data Mining (ODM)

21. What is Oracle Data Mining (ODM) primarily used for?
    • a) Data visualization and reporting
    • b) Predictive analytics and machine learning
    • c) Data integration with external systems
    • d) Managing data backups and restores
22. Which of the following Oracle Data Mining algorithms is used for classification tasks?
    • a) Decision Tree
    • b) Linear Regression
    • c) K-means Clustering
    • d) Apriori Algorithm
23. In Oracle Data Mining, which function is used to build and deploy a classification model?
    • a) DBMS_DATA_MINING.CREATE_MODEL
    • b) DBMS_DATA_MINING.TRAIN_MODEL
    • c) DBMS_DATA_MINING.CREATE_CLASSIFIER
    • d) DBMS_DATA_MINING.RUN_PREDICTION
24. What is a key feature of Oracle Data Mining’s “association” algorithms?
    • a) They predict the future value of a column
    • b) They identify relationships between different items in a dataset
    • c) They classify data based on predefined categories
    • d) They cluster data into similar groups
25. Which of the following types of models can be created using Oracle Data Mining?
    • a) Decision Tree
    • b) Regression models
    • c) Clustering models
    • d) All of the above
26. What is the primary function of Oracle Data Mining’s “clustering” algorithms?
    • a) To find outliers in the dataset
    • b) To group similar records into clusters
    • c) To predict future outcomes
    • d) To classify records based on predefined categories
27. Which of the following statements is true about Oracle Data Mining models?
    • a) They require large amounts of unstructured data
    • b) They can be directly queried like any other database object
    • c) They can only be used for classification tasks
    • d) They are stored as tables in the database
28. In Oracle Data Mining, which function is used to evaluate the performance of a classification model?
    • a) DBMS_DATA_MINING.EVALUATE
    • b) DBMS_DATA_MINING.VALIDATE_MODEL
    • c) DBMS_DATA_MINING.PREDICT_MODEL
    • d) DBMS_DATA_MINING.TEST_MODEL
29. How can Oracle Data Mining be integrated with other Oracle tools for end-to-end analytics?
    • a) By using Oracle Business Intelligence (BI) tools
    • b) By using Oracle PL/SQL scripts
    • c) By using Oracle Data Integrator
    • d) All of the above
30. What is the main advantage of using Oracle Data Mining in data science workflows?
    • a) It can automatically clean and preprocess data
    • b) It allows seamless integration with data warehouses and transactional data
    • c) It only requires limited data preparation
    • d) It automatically selects the best machine learning algorithm for every task

Answer Key: