Muhammad Imdad Ullah

Student and Instructor of Statistics and business mathematics. Completed my Ph.D. in Statistics from the Department of Statistics, Bahauddin Zakariya University, Multan, Pakistan. l like Applied Statistics, Mathematics and Statistical Computing. Statistical and Mathematical software used is SAS, STATA, GRETL, EVIEWS, R, SPSS, VBA in MS-Excel. Like to use type-setting LaTeX for composing Articles, thesis, etc.

MCQs Jupyter Notebook Code Editors IDEs

by

This post is about the Python MCQs Jupyter Notebook Code Editors IDEs Online Test with Answers. It consists of 20 multiple-choice questions about Python IDEs such as Jupyter Notebooks, Visual Code Editor, Anaconda, Google Colab, Jypyter Lab, etc. Let’s start with the Python MCQs Online Test with Answers.

MCQs Jupyter Notebook Code Editors IDEs

MCQs Jupyter Notebook Code Editors IDEs with Answers

1. What is the purpose of Anaconda?

 
 
 
 

2. What are the elements of Jupyter Notbook’s architecture?

 
 
 
 

3. What would be the outcome of the following Python code?

import sqlite3
import pandas as pd
conn = sqlite3.connect(‘HR.db’)
data = pd.read_csv(‘./employees.csv’)
data.to_sql(‘Employees’, conn)

 
 
 
 

4. Which environment is used for creating and modifying Jupyter Notebooks on a local device?

 
 
 
 

5. What is one of the features of Google Colab?

 
 
 
 

6. What is a feature of a JupyterLab?

 
 
 
 

7. Which of the following can be used to work with Jupyter Notebook?

 
 
 
 

8. How can you execute Python code in Visual Studio code?

 
 
 
 

9. Which two of the following can be stated as uses of cell magic in Jupyter Notebooks?

 
 
 
 

10. What is the purpose of the kernel in the Jupyter Notebook?

 
 
 
 

11. What functionality is provided by the Jupyter Notebook file to Data Scientists?

 
 
 
 

12. What is one of the features of JupyterLite?

 
 
 
 

13. In which formats can you share a notebook with other users?

 
 
 
 

14. How can you switch the kernel in the Jupyter Notebook?

 
 
 
 

15. What would be the correct way to query a database table using Python? Assume that output in any form is acceptable.

 
 
 
 

16. What do you use to convert the ipynb file to other formats?

 
 
 
 

17. Which option outputs the currently highlighted code cell in Jupyter Notebook?

 
 
 
 

18. Which of the following statements establishes the connection between a Jupyter Notebook SQL extension and an SQLite database ‘EMP.db’?

 
 
 
 

19. What is the default kernel of JupyterLite?

 
 
 
 

20. Which of the following features are provided by Jupyter Notebook in the context of Python programming?

 
 
 
 
 

MCQs Jupyter Notebook Code Editors IDEs

  • What functionality is provided by the Jupyter Notebook file to Data Scientists?
  • What is the purpose of the kernel in the Jupyter Notebook?
  • What are the elements of Jupyter Notbook’s architecture?
  • What is the default kernel of JupyterLite?
  • What is the purpose of Anaconda?
  • In which formats can you share a notebook with other users?
  • What is a feature of a JupyterLab?
  • Which option outputs the currently highlighted code cell in Jupyter Notebook?
  • How can you switch the kernel in the Jupyter Notebook?
  • Which of the following can be used to work with Jupyter Notebook?
  • What do you use to convert the ipynb file to other formats?
  • What is one of the features of JupyterLite?
  • What is one of the features of Google Colab?
  • Which environment is used for creating and modifying Jupyter Notebooks on a local device?
  • How can you execute Python code in Visual Studio code?
  • Which of the following statements establishes the connection between a Jupyter Notebook SQL extension and an SQLite database ‘EMP.db’?
  • Which two of the following can be stated as uses of cell magic in Jupyter Notebooks?
  • What would be the outcome of the following Python code?
    import sqlite3
    import pandas as pd
    conn = sqlite3.connect(‘HR.db’)
    data = pd.read_csv(‘./employees.csv’)
    data.to_sql(‘Employees’, conn)
  • What would be the correct way to query a database table using Python? Assume that output in any form is acceptable.
  • Which of the following features are provided by Jupyter Notebook in the context of Python programming?

Statistics and Data Analytics

R Language Basic Quiz 23

by

The post is about the “R Language Basic Quiz” which will help you check your ability to execute some basic or R Language, RStudio, Jupyter Notebook, and Google Colab. This quiz will help the learner to understand some basic concepts related to R Programming Language. This quiz may also improve your computational understanding, and it will also help you to learn and practice the R language Basic Quiz now.

R Language Basic Quiz with Answers
Please go to R Language Basic Quiz 23 to view the test

R Language Basic Quiz

  • Where can you type R commands in RStudio?
  • Which R library will you use for data visualizations such as histograms, bar charts, and scatterplots?
  • Which is the command used to install packages in R?
  • Which of the following is True about R language?
  • What is a great alternative to Jupyter Notebooks when programming in R?
  • Jupyter Notebooks is the tool most R developers use.
  • What type of environment is RStudio?
  • In a box plot, in which quartile does 50% of the sorted data fall below?
  • What does “CRAN” stand for in the context of R programming?
  • With data binning, observations are often organized into defined intervals called quartiles. Which quartile is the median of the dataset?
  • Which function replaces missing values in a dataset?
  • Which of the following is NOT a task facilitated by R?
  • Which of the following statements about Jupyter Notebook is correct?
  • Which of the following is a lightweight tool built from Jupyterlab components?
  • Which among the following is a cloud-based Jupyter notebook that can be saved on Google Drive?

Statistics Software and Data Analysis

R Language and Relational Databases Quiz 22

by

The post is about R Language and Relational Databases Management System Quiz with Answers. There are 20 multiple-choice questions about R language and database connectivity with R. Let us start with the R Language and Relational Databases Management System Quiz now.

Please go to R Language and Relational Databases Quiz 22 to view the test

R Language and Relational Databases Quiz

  • Which R function loads multiple R data structures from a *.Rda file?
  • Which of the following R variables holds the platform numeric limits for your R environment?
  • What is the role of the ODBC Driver Manager in the context of database connectivity? https://rfaqs.com
  • Suppose you are preparing to analyze sales data and have much information in an Excel spreadsheet. You have decided to convert the Excel spreadsheet to a relational database. What is your first step?
  • Which of the following correctly describes the condition for the referential constraint to occur?
  • Why is the SQL LOAD command recommended over the IMPORT command for large amounts of data?
  • What are two reasons to map an existing data source, like pre-existing database tables, database dump files, or raw data, to a relational database design?
  • Suppose, There are two tables in your database design: Customers, which lists all your customers, and Orders, which lists all the sales transactions that your customers have made over the years. Both the tables have a field called Customer_ID. Which of the following describes the relationship between the two tables?
  • What is the SQL DDL command that can be used to add primary keys to an existing table in a database?
  • What is the recommended SQL command for loading small to medium amounts of data into a database?
  • What are two ways to limit database movement and increase performance when querying a database?
  • What type of relationship does the database model indicate between each school board and multiple schools?
  • Which method is recommended to avoid unnecessary data transfer when analyzing data with a powerful database engine?
  • Which statement best describes data definition language (DDL) operations?
  • Which of the following is the correct general syntax for the INSERT statement?
  • Which statement best describes what a factor is in R?
  • Which SQL statement is used to delete records from a table?
  • Which of the following displays the correct general syntax for the SELECT statement that also includes a predicate?
  • What is a primary key?
  • Which of the following is classified as a data manipulation language (DML) statement?
R Language and Relational Databases Quiz with Answers

Online MCQs about Compute