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

Q. What is the function of the unique constraint?

View solution

Q. What is the functions of on delete cascade?

View solution

Q. What does the following condition do?
check( name in( ‘Ryan’, ‘Cristiano’, ‘Leo’))

View solution

Q. Referential integrity constraints are also called as _________

View solution

Q. ________ is a predicate that we expect the database to always satisfy

View solution

Q. State true or false: Oracle does not support complex check conditions

View solution