Python and MySQL Database: A Practical IntroductionReal Pythonhttps://realpython.com › python-mysqlMySQL is available for all major operating systems, including Windows, macO

What is MySQL?A programming languageA relational database management system (RDBMS)A file storage systemAn operating system

1.Question 1What is the command you will use to verify the installed packages on your Python environment?1 pointlist packagespip list allshow packagespip list2.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 pointMySQL API ConnectorSQL ConnectionsMySQL/Python Connector Database/Python Connector3.Question 3How can you communicate with a MySQL database after establishing a connection?1 pointCreate a MySQL databaseCreate a cursor object.Create a connection objectCreate a Python string of your SQL query4.Question 4In the MySQL/Python connector, what type of cursor object will allow you to return the results of a SQL query without preprocessing the data into Python friendly interpretations?1 pointcursordictionary subclasscursorprimary subclasscursorraw subclasscursorprocess subclass5.Question 5Which of the following commands use the correct syntax to create a Python string object across multiple lines?1 point12345mysql_query = "SELECT *FROM Orders " 12345mysql_query = """SELECT *FROM Orders """ 1mysql_query = SELECT * FROM Orders;1234mysql_query = SELECT *FROM Orders; 6.Question 6You have executed a query on the database that’s returning five records. However, you only want to retrieve the first record from the database. What’s the best approach to follow?1 pointCreate a standard cursor and invoke the fetchone module after executing your SQL query. Create a dictionary cursor and call the fetchall module after executing your SQL query.Create a standard cursor and call the fetchmany with size=1 after executing your SQL query. Create a buffered cursor and call the fetchone module after executing your SQL query.7.Question 7You’re establishing a connection between MySQL databases using Python and need to pass your parameters. Which of the following parameters are required? Select all that apply.1 pointThe MySQL server address (the host)The correct MySQL passwordThe authenticated MySQL usernameThe MySQL database name8.Question 8Which of the following is the correct query to create a new database using Python code?1 pointcursor.execute(CREATE DATABASE sample_database)connection.execute(create, “sample_database”)database.create(“sample_database”)create_database_query = “CREATE DATABASE sample_database”9.Question 9When using Python to create a table, you must invoke the commit module on the connection after executing the CREATE TABLE statement. 1 pointTrueFalse10.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

MySQL is not suitable for web development and is primarily used for desktop applications.Select one:TrueFalse

What is MySQL? Explain its features?

5. How do you connect to a MySQL database using the command line or a MySQL client?