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 ORDER BY EmpID ASC LIMIT 5;

SELECT * FROM Employees WHERE EmpID > 100 ORDER BY EmpID ASC;

SELECT * FROM Employees ORDER BY Name ASC LIMIT 5;

SELECT EmpID FROM Employees ORDER BY EmpID DESC LIMIT 5;

11. How to change the datatype of EmpName column to VARCHAR(100)?

ALTER TABLE table_name MODIFY EmpName VARCHAR(100);

ALTER TABLE table_name ALTER COLUMN EmpName TO VARCHAR(100);

UPDATE table_name SET EmpName = VARCHAR(100);

ALTER TABLE table_name CHANGE EmpName VARCHAR(100);

12. What is the output of this query? SELECT COUNT(*) FROM Employees;

An integer representing the number of employees.

A string indicating the employee names.

A boolean value representing if there are employees.

A date showing when the employees were hired.

13. Which query increases all salaries by 5%?

UPDATE employees SET salary = salary * 1.05;

SELECT * FROM employees WHERE salary > 50000;

ALTER TABLE employees ADD salary_increase DECIMAL(10,2);

UPDATE employees SET salary = salary + 5;

15. Which query copies all employees from Employees table to EmployeesBackup table?

INSERT INTO EmployeesBackup SELECT * FROM Employees;

INSERT EmployeesBackup VALUES (SELECT * FROM Employees);

SELECT * FROM Employees INTO EmployeesBackup;

COPY Employees TO EmployeesBackup;

16. How do you select all employees whose names end with 'n'?

SELECT * FROM employees WHERE name LIKE '%n';

SELECT * FROM employees WHERE name LIKE 'n%'

SELECT * FROM employees WHERE name LIKE '%a'

SELECT * FROM employees WHERE name = 'n'

17. How to delete employees with Salary less than 30000?

DELETE FROM employees WHERE salary < 30000;

DELETE employees WHERE salary > 30000;

REMOVE FROM employees WHERE salary < 30000;

DROP employees WHERE salary < 30000;

18. What happens when you run? TRUNCATE TABLE Employees;

All rows in the Employees table are deleted.

Only the structure of the Employees table is removed.

All data in the Employees table is archived.

The Employees table is renamed to 'FormerEmployees'.

19. Which query selects all employees with EmpID between 10 and 20 inclusive?

SELECT * FROM Employees WHERE EmpID BETWEEN 10 AND 20;

SELECT EmpID FROM Employees WHERE EmpID >= 10 AND EmpID <= 20;

SELECT * FROM Employees WHERE EmpID > 10 AND < 20;

SELECT * FROM Employees WHERE EmpID BETWEEN 5 AND 15;

20. How to insert multiple rows in one query?

INSERT INTO table_name (column1, column2) VALUES (value1a, value2a), (value1b, value2b), (value1c, value2c);

INSERT INTO table_name VALUES (value1a, value2a), (value1b, value2b), (value1c, value2c);

INSERT table_name (column1, column2) VALUES (value1a, value2a) AND (value1b, value2b);

INSERT INTO table_name (column1, column2) SET (value1a, value2a), (value1b, value2b);

infy

Authored by NV CHALLA

Computers

University

Used 2+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

20 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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);

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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;

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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;

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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');

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

TRUNCATE Employees;

DROP TABLE Employees;

DELETE * FROM Employees;

DELETE FROM Employees;

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

20 questions

Quiz -Evaluasi Query SQL

Quiz

•

University

15 questions

CIS1101-programming practice

Quiz

•

University

18 questions

Ms Word

Quiz

•

University

15 questions

Computer DESKTOP - CESA

Quiz

•

7th Grade - University

20 questions

UNIT IV Normalization

Quiz

•

University

18 questions

Quiz on Misinformation and Bias

Quiz

•

10th Grade - University

20 questions

BD 1 - SQL - geral

Quiz

•

University

20 questions

C++ Bootcamp 2k24

Quiz

•

University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

54 questions

Analyzing Line Graphs & Tables

Quiz

•

4th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

Discover more resources for Computers

20 questions

CompTIA Network+ - Ports and Protocols

Quiz

•

University

infy

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

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

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

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

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

6. What will this query do? UPDATE Employees SET EmpName = 'Sonia' WHERE EmpID = 5;

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

8. What does this command do?ALTER TABLE Employees DROP COLUMN JoiningDate;

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

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

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

6. What will this query do?
UPDATE Employees SET EmpName = 'Sonia' WHERE EmpID = 5;

8. What does this command do?
ALTER TABLE Employees DROP COLUMN JoiningDate;