SQL Quiz

What does SQL stand for?

• Simplified Query Language

• Simple Query Language

• Structured Query Language

• Structured Query Logic

Which keyword is used to retrieve data from a table?

• INSERT

• SELECT

• DELETE

• UPDATE

What is the purpose of the JOIN keyword in SQL?

• To sort data in ascending or descending order

• To calculate aggregate values

• To combine rows from two or more tables based on a related column

• To filter records based on a condition

Which DML statement is used to update existing data?

• SELECT

• DELETE

• INSERT

• UPDATE

Which statement is used to modify a table in SQL?

• ALTER

• DELETE

• INSERT

• UPDATE

Which company developed SQL?

• IBM

• Oracle

• Microsoft

• Google

Which statement is used to give privileges to a user in SQL?

• GRANT

• CREATE

• REVOKE

• ALTER

How to write a query to show the details of all students from StudentsTable whosename starts with K?

• SELECT * FROM StudentsTable WHERE 'K%' IN (Student_Name)

• SELECT FirstName FROM StudentsTable WHERE Student_Name LIKE 'K%'

• SELECT * FROM StudentsTable WHERE Student_Name LIKE 'K%'

• SELECT * FROM Student WHERE StudentsTable LIKE 'K'

What columns would be printed as a result?

• ShipperName, OrderID

• ShipperName, NumberOfOrders

• Shippers, Orders

• ShipperID, OrderID

When we execute the query, what attribute will be used to arrange the resulting values?

• COUNT(CustomerID)

• Customers

• CustomerID

• Country