Q. What is the difference between a join and an outer join operation?

View solution

Q. The join operations that do not retain mismatched tuples are called as _________ operations

View solution

Q. What is the function of a left outer join?

View solution

Q. What is the function of a full outer join?

View solution

Q. What is the function of a right outer join?

View solution

Q. What is the function of inner join?

View solution

Q. State true or false: on and where behave differently for outer join

View solution

Q. Which off the following is not a valid type of join?

View solution

Q. If a left outer join is performed and the tuple on the left hand side does not match with the tuple on the right hand side, what happens to the values that are preserved on the left hand side?

View solution

Q. What is the command used to define view in SQL?

View solution

Q. create view studentdet
select ID, address, name
from student;

What is the result of the above query?

View solution

Q. State true or false: One view can be used in the expression defining another view

View solution

Q. If the actual relations used in the view definition change, the view is updated immediately. Such views are called _________

View solution

Q. The process of maintaining views up to date is called _________

View solution

Q. How can we insert data into a view?

View solution

Q. State true or false: We can update a view if it has multiple database relations in the from clause

View solution

Q. The _______ statement makes the updates performed by the transaction permanent.

View solution

Q. The _______ statement causes the statements to undo all the updates performed on the transaction

View solution

Q. Which of the following is not an integrity constraint?

View solution

Q. What is the function of the not null constraint?

View solution