Question 1Which of the following statements establishes the connection between a Jupyter Notebook SQL extension and an SQLite database ‘EMP.db’?1 point%sql sqlite:///EMP.db%sql sqlite:///EMP.db %sql sqlite:/EMP.db%sql sqlite3://EMP.db2.Question 2Which two of the follow

1.Question 1Which of the following commands will install the jupyter package onto your Python environment?1 pointinstall pip jupyterpip install jupyterpip upgrade jupyterPython install jupyter2.Question 2When connecting a Python front end to a SQL back end database, you use an API (also known as a driver). What is the most commonly used API that will allow you to connect your Python program to your database? 1 pointDatabase/Python ConnectorMySQL API ConnectorSQL ConnectionsMySQL/Python Connector 3.Question 3How can you communicate with a MySQL database after establishing a connection?1 pointCreate a connection objectCreate a Python string of your SQL queryCreate a cursor object.Create a MySQL database4.Question 4The Python cursordict subclass allows you to return each row as a dictionary and in turn assists with accessing variables from the data. What is a disadvantage of using this subclass?1 pointThe data returned must be stored locally in your computer.You will use more processing power for the data.There will be a high number of queries in order to process the data.Converting the data into a dictionary will require more code.5.Question 5Which of the following commands use the correct syntax to create a Python string object across multiple lines?1 point1mysql_query = SELECT * FROM Orders;12345mysql_query = """SELECT *FROM Orders """ 1234mysql_query = SELECT *FROM Orders; 12345mysql_query = "SELECT *FROM Orders " 6.Question 6You have executed a query on the database that’s returning five records.You then want to use the results from the first query in a subsequent second query. What’s the best approach to follow?1 pointCreate a standard cursor and call the fetchmany with size=1 to use the id in your second query. Create a standard cursor call and interleave the results in a second query.Create a buffered cursor and after all the results are returned, use that data in a second subsequent query. Create a dictionary cursor and call the fetchall module to use that data in your second query.7.Question 7Which of the following is the correct syntax to establish a connection between Python and MySQL databases with a connector aliased as conn?1 pointconnector(username=”user1”, password=”pass1”)connection = (username=”user1”, password=”pass1”)conn.connect(username=”user1”, password=”pass1”)conn.connection((username=”user1”, password=”pass1”)8.Question 8You are creating a new database table in your MySQL database using Python. How do you define the table structure and column types?1 pointDefine the table structure in Python. The column types are automatically selected by the MySQL database.Define both the table structure and the column types in your SQL CREATE TABLE statement.Define the table structure in your SQL CREATE TABLE statement. Define the column types in Python.Define the table structure and the column types in Python. Create a table using the SQL CREATE TABLE statement.9.Question 9Below is a query to create a new table to track data on customer orders at a restaurant. What is the correct order of operation to successfully use this query in a cursor object in the database?12345678create_table_customers = """CREATE TABLE customers(CustomerId INT AUTO_INCREMENT,Name VARCHAR(200),Age INT,OrderAmount INT""")1 pointcursor.commit(create_table_customers)cursor.commit(create_table_customers)cursor.execute()cursor.execute(create_table_customers)cursor.commit()cursor.execute(create_table_customers)10.Question 10What keyword or module must be added to your syntax to execute the query to create a new database?cursor = connection.____()cursor.execute("CREATE DATABASE database_name")1 pointconnectorconnectioninsertcursor

Question 9Which environment is used for creating and modifying Jupyter Notebooks on a local device?1 pointPythonSQLiteVisual Studio CodeGoogleColab

Question 7What is one of the features of JupyterLite?1 pointRequires a dedicated serverDefault kernel is SQLiteIt is not a static websiteCan create interactive graphics and visualizations

Question 8Which of the following statements about Jupyter Notebook is correct?1 pointJupyter Notebook provides storage of massive quantities of data in data lakes. Jupyter Notebook is a commercial product of IBM.Jupyter Notebook supports the Visualization of data in charts.Jupyter Notebook is only available if installed locally on your comp

What is the purpose of Jupyter Notebooks in data science?