ct the correct answerInsert appropriate keyword to complete the query?INSERT INTO EmployeeRecord ________(18321 , Ravi ,100000);

correct answerInsert appropriate keyword to complete the query?INSERT INTO EmployeeRecord ________(18321 , Ravi ,100000);OptionsTableRelationValuesField

Which one of the following is the correct syntax for an insert statement?

A table has the following 3 columns: (Receipt_No INT PRIMARY KEY AUTO_INCREMENT, Receipt_Date DATETIME, Cust_No INT). To insert data, the INSERT INTO keyword should include how many data columns for the table?Select one:a.None of the answers are correctb.3c.4d.2e.1

Consider the below orders table:Column NameDatatypeConstraintorder_idNumberPKOrder_dateDate Order_modevarchar Customer_idNumber Order_totalNumber(8,2) There is only one customer with the CUST_LAST_NAME column having value Roberts. Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST_LAST_NAME is Roberts and CREDIT_LIMIT is 600?Select one:a.INSERT INTO orders ( order_id ,order _date,order_mode , (SELECT customer_id FROM customersWHERE cust_last_name ='Roberts' ANDcredit_limit =600) , order _total )VALUES (1,'10-mar-2007','direct' ,& &customer_id,1000);b.INSERT INTO( SELECT o.order_id,o.order,o.order_mode,c.customer_id,o.order_totalFROM orders o, customers c WHERE o.customer_id = c.customer_id AND c.cust_last_name='Roberts' and c.credit_limit =600)VALUES (1,'10-mar-2007','direct' ,& &customer_id,1000);FROM customersWHERE cust_last_name ='Roberts' ANDcredit_limit =600) ,1000 );c.INSERT INTO orders ( order_id ,order _date,order_mode , (SELECT customer_id FROM customersWHERE cust_last_name ='Roberts' ANDcredit_limit =600) , order _total )VALUES (1,'10-mar-2007','direct' ,& customer_id,1000);d.INSERT INTO orders VALUES( 1,'10-mar-2007','direct', (SELECT customer_id FROMcustomers WHERE cust_last_name ='Roberts' ANDcredit_limit =600) ,1000 );

Problem StatementCreate a query to update the membercost column to 1000 in the facilities table where the value of monthlymaintenance is greater than 500.The column names and data types are given below.