You have a table that was created with the following command:CREATE TABLE test ( primaryKey int NOT NULL AUTO_INCREMENT PRIMARY KEY, firstName varchar(30), lastName varchar(30), zipCode varchar(5))You need to create a new record in the test table with a first name of Jose, a last name of Federov, and a zip code of 12345. What statement should you enter?1 pointINSERT INTO test VALUES (‘Jose’, ‘Federov’, ‘12345’)INSERT INTO test VALUES (DEFAULT, ‘Jose’, ‘Federov’, ‘12345’)INSERT INTO test (primaryKey, firstName, lastName, zipCode) (DEFAULT, ‘Jose’, ‘Federov’, ‘12345’)INSERT INTO test (primaryKey, firstName, lastName, zipCode) (‘Jose’, ‘Federov’, ‘12345’)

You are working with a database that contains a table named 'members.'Write a query to change the column name zipcode to pincode in the members table.Input format :The input tables are already prepopulated, as given in the problem statement.Output format :The output should display the column details after the alteration, showcasing the updated 'pincode' column in place of the original 'zipcode.'Refer to the sample output for the column headers.Sample test cases :Input 1 :Output 1 :COLUMN_NAMEmemidsurnamefirstnameaddresspincodetelephonerecommendedbyjoindate

Problem StatementYou are working with a database that contains a table named 'members.' Your task is to retrieve the column names of this table from the database's information schema. Additionally, there is a requirement to alter the data type of the 'zipcode' column in the 'members' table to 'int' and rename it as 'pincode.'Input format :The input tables are already prepopulated, as given in the problem statement.Output format :The output should display the column details after the alteration, showcasing the updated 'pincode' column in place of the original 'zipcode.'Sample Output 1COLUMN_NAMEaddressfirstnamejoindatememidpincoderecommendedbysurnametelephoneRefer to the sample output for the column headers.Sample test cases :Input 1 :Output 1 :COLUMN_NAMEaddressfirstnamejoindatememidpincoderecommendedbysurnametelephone

CREATE TABLE IF NOT EXISTS `new_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `trn_date` datetime NOT NULL, `name` varchar(50) NOT NULL, `age`int(11) NOT NULL, `submittedby` varchar(50) NOT NULL, PRIMARY KEY (`id`) );

PRINT 'CIS 275, Lab Week 8, Question 3 [1pt possible]: Adding Data - - - - - - Change the INSERT INTO statements below to reference the tables you created in Question 2. You should only need to change ABC_ to match your initials. Be sure to change all four statements. Then, uncomment the lines. (remove the /* at the top and the */ at the bottom). 1 + CHAR ( 10 )

Create a procedure named 'insertMeter' which takes 2 input parameters namely, meter_number is type of varchar2 and building_id is type of int. This procedure will take the count of the existing table records(meter) and add 1 with that to generate the new meter id.The newly generated id along with the meter_number and building_id should be inserted into the meter table.Hints:Procedure name : insertMeterParameters : meter_number(varchar2) ,building_id(int)SubmitSaveExecutePrevious Submission