infy

1. Which SQL command creates a table named Employees with columns EmpID (integer) and EmpName (varchar 50)?

• CREATE TABLE Employees (EmpID INT, EmpName VARCHAR(50));

• CREATE Employees TABLE (EmpID INT, EmpName VARCHAR(50));

• TABLE CREATE Employees (EmpID INT, EmpName VARCHAR(50));

• CREATE TABLE Employees (EmpID VARCHAR(50), EmpName INT);

2. How to add a new column JoiningDate of type DATE to the Employees table?

• CREATE TABLE Employees (JoiningDate DATE);
• UPDATE Employees SET JoiningDate = CURRENT_DATE;
• ALTER TABLE Employees ADD JoiningDate DATE;
• ALTER TABLE Employees ADD COLUMN JoiningDate;

3. What will this query do? DELETE FROM Employees WHERE EmpID = 100;

• It removes the employee with EmpID 100 from the Employees table.
• It updates the employee's details with EmpID 100 in the Employees table.
• It adds a new employee with EmpID 100 to the Employees table.
• It retrieves the employee with EmpID 100 from the Employees table.

4. How do you rename the column EmpName to EmployeeName in the Employees table?

• UPDATE Employees SET EmpName = 'EmployeeName';
• RENAME TABLE Employees TO NewEmployees;
• ALTER Employees CHANGE EmpName EmployeeName;
• ALTER TABLE Employees RENAME COLUMN EmpName TO EmployeeName;

5. Which query inserts a new employee with EmpID = 10 and EmpName = 'Rahul'?

• INSERT INTO Employees (EmpID, EmpName) VALUES (10, 'Rahul');
• INSERT Employee VALUES (10, 'Rahul') INTO Employees;
• ADD Employee (10, 'Rahul') TO Employees;
• INSERT INTO Employees (EmpID, EmpName) SET (10, 'Rahul');

6. What will this query do?

UPDATE Employees SET EmpName = 'Sonia' WHERE EmpID = 5;

• It retrieves the name of the employee with EmpID 5.
• It updates the name of the employee with EmpID 5 to Sonia.
• It adds a new employee named Sonia.
• It deletes the employee with EmpID 5.

7. How to delete all data from Employees without deleting the table?

• TRUNCATE Employees;
• DROP TABLE Employees;
• DELETE * FROM Employees;
• DELETE FROM Employees;

8. What does this command do?

ALTER TABLE Employees DROP COLUMN JoiningDate;

• It removes the 'JoiningDate' column from the 'Employees' table.
• It retrieves the 'JoiningDate' column from the 'Employees' table.
• It renames the 'JoiningDate' column in the 'Employees' table.
• It adds a new column named 'JoiningDate' to the 'Employees' table.

9. Which query fetches all employees who joined after 2021-01-01?

• SELECT * FROM employees WHERE join_date > '2021-01-01';
• SELECT * FROM employees WHERE join_date = '2021-01-01';
• SELECT name, join_date FROM employees;
• SELECT * FROM employees WHERE join_date < '2021-01-01';

10. Which query shows top 5 employees by EmpID in ascending order?

• SELECT * FROM Employees WHERE EmpID > 100 ORDER BY EmpID ASC;
• SELECT * FROM Employees ORDER BY Name ASC LIMIT 5;
• SELECT * FROM Employees ORDER BY EmpID ASC LIMIT 5;
• SELECT EmpID FROM Employees ORDER BY EmpID DESC LIMIT 5;