Compulsory Task 1 Follow these steps: ● Create a Python file called database_manip.py. Write the code to do the following tasks: Create a table called python_programming. O Insert the following new rows into the python_programming table: id 55 66 77 12 2 name Carl Davis Dennis Fredrickson Jane Richards Peyton Sawyer Lucas Brooke grade 61 88 78 45 99 O Select all records with a grade between 60 and 80. o Change Carl Davis's grade to 65. O Delete Dennis Fredrickson's row. Change the grade of all people with an id below than 55.

Hive table’s column, PERSON has an array value, [“jihee”, “jong”,“hemo”]. What function generate three records from the array value,[“jihee”, “jong”, “hemo”]?a. RECORDS(PERSON)b. EXPLODE(PERSON)c. LINES(PERSON)d. ROWS(PERSON)

QUESTION 21 Code a chain of MongoDB methods that    retrieves documents from MondoDB collection named WEB322 the only documents that are selected are the ones with value 211 in the semester field  the only fields of the selected documents that are retrieved are firstName and lastName make sure the _id field is NOT retrieved sort the selected documents by lastName in ascending sequence store the result to an array named result assume the connection between the program and database had already been established and the name of the database object is db

Insert, Update, and Delete statements can be referred to as blank queries.   a result b select c database d action

What is the maximum number of columns you can define as a primary key when using the column-level approach to creating a table? ( refer to the tables in the JustLee Books database).                                                              a. 0 b. 1 c. 30 d. 255

import sqlite3 from sqlite3 import Error # Creates connection to sqlite in-memory database def create_connection():     """     Create a connection to in-memory database     :return: Connection object     """     try:         conn = sqlite3.connect(":memory:")         return conn     except Error as e:         print(e)     # YOUR CODE HERE     # Use sqlite3.connect(":memory:") to create connection object     return conn # query to create the table table_sql = """ CREATE TABLE Horses (     id integer PRIMARY KEY NOT NULL,     name text,     breed text,     height real,     birthday text ); """ # query to insert data into the table ins_sql = """INSERT INTO Horses VALUES(1,'Babe','Quarter Horse',15.3,'2015-02-10'); """ # query to fetch all data from the table fetch_sql = """SELECT * FROM Horses;""" # creating db connection conn = create_connection() # fetching a cursor from the connection c = conn.cursor() # executing statement to create table c.execute(table_sql) # executing statement to…

Population Database   Compile and run CreateCityDB.java which will create a Java DB database named CityDB. The CityDB database will have a table named City, with the following columns: CityName & Population. Their Data Types: CHAR(50) Primary Key & DOUBLE. The CityName column stores the name of a city, and the Population column stores the population of that city. After you run the CreateCityDB.java program, the City table will contain 20 rows with various cities and their populations. Next, create an application that connects to the CityDB database and allows the user to select any of the following operations: Sort the list of cities by population, in ascending order. Sort the list of cities by population, in descending order. Sort the list of cities by name. Get the total population of all the cities. Get the average population of all the cities. Get the highest population. Get the lowest population.   CreateCityDB.java import java.sql.*; /**  This program creates the CityDB…