Problem Statement

SQL (L1) - Multiple Choice Section AP Moller Maersk, Software Engineer on-campus assessment. Section: SQL || L1 , one mark each. Each question below has exactly one correct option. --- Q1. SQL injection based on which of the following symbol is always true? A. = B. * C. + D. % --- Q2. Write a query to prefix 'Hii' in the FirstName attribute of the student table. A. Select 'Hii'% FirstName from students; B. Select 'Hii'_ FirstName from students; C. Select 'Hii'+ FirstName from students; D. Select 'Hii' AND FirstName from students; --- Q3. Which of the following is the correct query to find all the orders against the employee who works for the customer whose id is 1234? The required tables are: Employee(eid, name, city) and Orders(ord_no, purch_amt, ord_date, customer_id, eid) A. SELECT * FROM salesman WHERE eid = (SELECT DISTINCT eid FROM Orders) WHERE customer_id =1234; B. SELECT *FROM orders WHERE eid = (SELECT eid FROM Orders) WHERE customer_id =1234; C. SELECT * FROM orders WHERE ei