SELECT command without WHERE clause return?
A. All the records from a table that match the previous WHERE clause
B. All the records from a table, or information about all the records
C. SELECT is invalid without a WHERE clause
D. Nothing
Answer: Option B
Solution (By Examveda Team)
The SELECT command in SQL is used to query data from a database table.When a SELECT command is used without a WHERE clause, it returns all the records from the specified table.
Option A is incorrect because it refers to records that match a previous WHERE clause, which is not applicable here.
Option C is incorrect because a SELECT command is valid without a WHERE clause.
Option D is incorrect because the SELECT command will return all the records from the table if no WHERE clause is specified.
Conclusion: Using a SELECT command without a WHERE clause retrieves all the records from the specified table.
Related User Ask Questions
Which of the following is not a primary function of a Bank?
A. Granting Loans
B. Collecting Cheques/Drafts customers
C. Facilitating import of goods
D. Issuing Bank Drafts
A. Regulatory jurisdictional fight between SEBI and IRDA
B. They don’t offer better tax benefits
C. They offer lesser returns compared to traditional insurance policies
D. All of the above
The Chameli Devi Jain Award is given for an outstanding woman ____?
A. Scientist
B. Reporter
C. Player
D. Teacher

Join The Discussion