Saved Bookmarks
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
What is a view? Why should you use a view? |
| Answer» | |
| 2. |
Which SQL statement is used to add, modify or drop columns in a database table? |
| Answer» | |
| 3. |
What is the difference between VARCHAR2 AND CHAR datatypes? |
| Answer» | |
| 4. |
What is the purpose of the MERGE statement in SQL? |
| Answer» | |
| 5. |
Can you remove rows from a table based on values from another table? Explain. |
| Answer» | |
| 6. |
What happens if you omit the WHERE clause in a delete statement? |
| Answer» | |
| 7. |
Can you modify the rows in a table based on values from another table? Explain. |
| Answer» | |
| 8. |
What happens if you omit the WHERE clause in the UPDATE statement? |
| Answer» | |
| 9. |
How do you copy rows from one table to another? |
| Answer» | |
| 10. |
How do you insert null values in a column while inserting data? |
| Answer» | |
| 11. |
Which statement is used to add a new row in a database table? |
| Answer» | |
| 12. |
What is the pupose of DML statements in SQL? |
| Answer» | |
| 13. |
What are the various multiple row comparison operators in SQL? |
| Answer» | |
| 14. |
What do you understand by a subquery? When is it used? |
| Answer» | |
| 15. |
What’s wrong in the following query? |
| Answer» | |
| 16. |
What is the purpose of the group functions in SQL? Give some examples of group functions. |
| Answer» | |
| 17. |
What is the difference between cross joins and natural joins? |
| Answer» | |
| 18. |
You want to display a result query from joining two tables with 20 and 10 rows respectively. Erroneously you forget to write the WHERE clause. What would be the result? |
| Answer» | |
| 19. |
Which expressions or functions allow you to implement conditional processing in a SQL statement? |
| Answer» | |
| 20. |
Discuss the syntax and use of the COALESCE function? |
| Answer» | |
| 21. |
What is the use of the NULLIF function? |
| Answer» | |
| 22. |
What is the difference between the NVL and the NVL2 functions? |
| Answer» | |
| 23. |
What is the purpose of the NVL function? |
| Answer» | |
| 24. |
Which function returns the remainder in a division operation? |
| Answer» | |
| 25. |
What are the case manipulation functions of SQL? |
| Answer» | |
| 26. |
What are the specific uses of SQL functions? |
| Answer» | |
| 27. |
What is the default ordering of data using the ORDER BY clause? How could it be changed? |
| Answer» | |
| 28. |
How do you search for a value in a database table when you don’t have the exact value to search for? |
| Answer» | |
| 29. |
What is the purpose of the condition operators BETWEEN and IN? |
| Answer» | |
| 30. |
If a table contains duplicate rows, does a query result display the duplicate values by default? How can you eliminate duplicate rows from a query result? |
| Answer» | |
| 31. |
Say True or False. Give explanation if False. |
| Answer» | |
| 32. |
Is a NULL value same as zero or a blank space? If not then what is the difference? |
| Answer» | |
| 33. |
Can you sort a column using a column alias? |
| Answer» | |
| 34. |
What are various DCL commands in SQL? Give brief description of their purposes. |
| Answer» | |
| 35. |
What are various DML commands in SQL? Give brief description of their purposes. |
| Answer» | |
| 36. |
What are various DDL commands in SQL? Give brief description of their purposes. |
| Answer» | |
| 37. |
What is the difference between SQL and PL/SQL? |
| Answer» | |
| 38. |
What is the difference between SQL and MySQL or SQL Server? |
| Answer» | |