Q. In contemporary databases the top level of the hierarchy consists of ______, each of which can contain _____.

View solution

Q. Which of the following statements creates a new table temp instructor that has the same schema as instructor.

View solution

Q. The____condition allows a general predicate over the relations being joined.

View solution

Q. Which of the join operations do not preserve non matched tuples.

View solution

Q. What type of join is needed when you wish to include rows that do not have matching values?

View solution

Q. How many join types in join condition:

View solution

Q. Which join refers to join records from the right table that have no matching key in the left table are include in the result set:

View solution

Q. In SQL the statement select * from R, S is equivalent to

View solution

Q. Which join condition contains an equality operator:

View solution

Q. A __________ is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.

View solution

Q. The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTER INSERT trigger.

View solution

Q. What are the after triggers ?

View solution

Q. The variables in the triggers are declared using

View solution

Q. The default extension for an Oracle SQL*Plus file is:

View solution

Q. Triggers ________ enabled or disabled.

View solution

Q. To include integrity constraint in a existing relation use :

View solution

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

View solution

Q. Which of the following is the right syntax for assertion?

View solution

Q. Which of the following can be addressed by enforcing a referential integrity constraint?

View solution

Q. Drop Table cannot be used to drop a table referenced by a _________ constraint.

View solution