Q. The user defined data type can be created using

View solution

Q. Values of one type can be converted to another domain using which of the following ?

View solution

Q. Which of the following closely resembles Create view ?

View solution

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