Related InterviewSolutions

• Say True or False. Give explanation if False.A view doesn’t have data of its own.
• What is a view? Why should you use a view?
• Which SQL statement is used to add, modify or drop columns in a database table?
• Say True or False. Give explanation if False.A DROP TABLE statement can be rolled back.
• What is the difference between VARCHAR2 AND CHAR datatypes?
• Say True or False. Give explanation if False.A DDL statement or a DCL statement is automatically committed.
• What is the purpose of the MERGE statement in SQL?
• Say True or False. Give explanation if False.You can use a subquery in an INSERT statement.
• Say True or False. Give explanation if False.Attempting to delete a record with a value attached to an integrity constraint, returns an error.
• Can you remove rows from a table based on values from another table? Explain.