GATE 2023 Database Quiz 19

What is the use of “AS” Clause in SQL?

Which of the following is the correct order of keywords for SQL SELECT statements?

Which SQL command used to avoid the selection of duplicate rows?

Which SQL command is used to delete complete table from the database?

Consider the following relational table:
Student (Sid, Sname, Smarks, Sgrade)
Consider the following SQL Queries:
S1: Select Sname From Student Where Sgrade IN (Select Sgrade From Student Where Smarks < 40)

S2: Select Sname From Student Where smarks < 40
Which of the following is true?

TRUNCATE statement in SQL is a?