Use Mongo shell  commands to answer following questions based on the collection sample_training .grades  Return the number of students who have enrolled class with class_id=149 Insert one student into the class with the class_id as 339; more specifically, the studend_id is 300999, and the student’s exam score is 95, and quiz#1 is 12.   Assume that the student whose student_id is 9888 has finished quiz#2 for class 339 and the grade is 15, update the document correspondingly to reflect the change Delete the document that has student_id is 300999 and class_id is 339

Please make sure you put the sqljdbc driver file under /Web-INF/lib folder to test. This is required for Webapplication to work with database. 1. Your regisLogin.jsp should ask user's ssn number (student's ssn) and move to validateLogin.java servlet.

The Sqlite.py file contains several very specific queries:         select_Query = "select sqlite_version()"        delete_query = "DELETE from Database where id = "+str(id)        sel = 'SELECT id FROM Database WHERE name == "{0}"'.format(value)        insert_query = """INSERT INTO Database (id, name, photo, html) VALUES (?, ?, ?, ?)"""        sqlite_select_query = """SELECT * from Database"""        table_query = '''CREATE TABLE Database (                                id INTEGER PRIMARY KEY,                                name TEXT NOT NULL,                                photo text NOT NULL UNIQUE,                                html text NOT NULL UNIQUE)'''                                Write a QueryBuilder function.  The QueryBuilder builds a generic Query to build ANY Query type (i.e. version, delete, select, insert, select, table).  The QueryBuilder parameters require:  The type of Query, the input tuple data and then constructs a query string based on the parameters.…

Create a procedure named DDCKPAY_SP that confirms whether a monthly pledge payment is the correct amount. The procedure needs to accept two values as input: a payment amount and a pledge ID. Based on these inputs, the procedure should confirm that the payment is the correct monthly increment amount, based on pledge data in the database. If it isn’t, a custom Oracle error using error number 20050 and the message “Incorrect payment amount - planned payment = ??” should be raised. The ?? should be replaced by the correct payment amount. The database query in the procedure should be formulated so that no rows are returned if the pledge isn’t on a monthly payment plan or the pledge isn’t found. If the query returns no rows, the procedure should display the message “No payment information.” Test the procedure with the pledge ID 104 and the payment amount $25. Then test with the same pledge ID but the payment amount $20.Finally, test the procedure with a pledge ID for a pledge that doesn’t…

The InstantRide Driver Relationship team wants to learn how many travels each driver has done in the month of October. You need to send them the DRIVER_ID, and two calculated columns: DAY and RIDES. The DAY column is calculated using the DAY() function with the TRAVEL_START_TIME as the argument. The RIDES column is calculated by using the COUNT() function to determine the number of rides given for each day. Filter the results with the MONTH function.

awk is similar to the SQL language in that you can query certain records. What command below will search the the file /etc/passwd file by locating all users that have a default shell '/bin/bash' and print the first column (which is the user name). awk -D: '$7 == "/bin/bash" {print $3}' /etc/passwd Give this to your new intern to figure out. awk -F: '$4 == "/bin/bash" {print $10}' /etc/passwd awk -F: '$7 == "/bin/bash" {print $1}' /etc/passwd awk -F: '$1 == "/bin/bash" {print $7}' /etc/passwd.

Please attach output of this queries CREATE TABLE Employee ( EmployeeID INT PRIMARY KEY, FirstName VARCHAR(50), LastName VARCHAR(50), Gender CHAR(1), BirthDate DATE, Department VARCHAR(50), Position VARCHAR(50), Salary DECIMAL(10, 2) ); Insert 10 records and find out the who's salary is greater than Harry's salary?