Similar Collections

.

questions

Title
Which of the join operations do not preserve non matched tuples
What type of join is needed when you wish to include rows that do not have matching values?
How many join types in join condition:
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:
In SQL the statement select * from R, S is equivalent to
Which join condition contains an equality operator:
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
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
What are the after triggers ?
The variables in the triggers are declared using
The default extension for an Oracle SQL*Plus file is:
Triggers ________ enabled or disabled
To include integrity constraint in a existing relation use :
Which of the following is not a integrity constraint ?
Which of the following is the right syntax for assertion?
Which of the following can be addressed by enforcing a referential integrity constraint?
Drop Table cannot be used to drop a table referenced by a _________ constraint
____________ is preferred method for enforcing data integrity
SQL stands for ________
The SQL command to create a table is:
total questions: 374

Questions

374

Views

15195

Best Answers

299

Points

5