SQL-QUIZ

Which is NOT a  TCL command?

• Commit

• Rollback

• Insert

• Savepoint

Expand ACID

• a) Atomicity, Consistency, Isolation and Durability

• b) Atomic, Concurrent, Isolate, Data

• c) Alter, Create, Integrity, Data

• d) Alter, Consistent, Integrity, Duplicate

Which of the following SQL statements deletes all rows in table called SalesData?

• DELETE ALL SalesData

• DELETE SalesData

• DELETE * FROM SalesData

• DELETE FROM SalesData

Choose the keyword used to fetch unique values from a table

• Unique

• Not null

• check

• distinct

Select * from Worker where FIRST_NAME like '%a%';   What will the rows displayed for this query?

• BCA

• SRM

• COLLEGE

• ALLTHEBEST

SELECT Salary FROM Worker ORDER BY Salary DESC LIMIT 5,1;   What does the query return?

• a) Arranges workers based on salary

• b) Returns the 5th highest salary

• c) Shows the top 5 rows in workers table

• d) SQL State Error