quizzes for students

The variables in the trigger are declared using ……… symbol a) - b) @ c) / d) /@

Triggers are supported in ……… a) Delete b) Update c) View d) ALL

A …….. is a special kind of stored procedure that execute in response to certain action on table a) View b) Trigger c) Function d) None

What does rollback do a) Un-does the Transaction before commit b) Clear all Transactions c) Redo all the transaction before commit d) No Action

Which of the following makes the transaction permanent in the database a) View b) Commit c) Rollback d) Flash back

A …….. Consists of a sequences of query or update statements. a) Transaction b) Commit c) Rollback d) Flash back

Which of the join operations do not preserve non-matched tuple a) Left outer Join b) Right outer Join c) Inner Join d) None

The ……….. condition allows a general predicated over the relations being joined a) On b) Using c) Set d) Where

Materialized views make sure that a) View is verified for errors b) View is updated c) View is kept Stable d) View is deleted after specifying the error

[{"selector":"#anim-af82e55d-b75a-4ee5-904e-122d5e155e12","keyframes":[{"transform":"rotate(-540deg) scale(0.1)","opacity":0},{"transform":"none","opacity":1}],"delay":0,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both","iterations":1}]

quizzes for students

which of the following creates a virtual relationship and stores the query a) View b) Procedure c) Function d) None

Answers in Last Page >>>

The variables in the trigger are declared using ……… symbol a) - b) @ c) / d) /@

Answers in Last Page >>>

Triggers are supported in ……… a) Delete b) Update c) View d) ALL

Answers in Last Page >>>

A …….. is a special kind of stored procedure that execute in response to certain action on table a) View b) Trigger c) Function d) None

Answers in Last Page >>>

What does rollback do a) Un-does the Transaction before commit b) Clear all Transactions c) Redo all the transaction before commit d) No Action

Answers in Last Page >>>

Which of the following makes the transaction permanent in the database a) View b) Commit c) Rollback d) Flash back

Answers in Last Page >>>

A …….. Consists of a sequences of query or update statements. a) Transaction b) Commit c) Rollback d) Flash back

Answers in Last Page >>>

Which of the join operations do not preserve non-matched tuple a) Left outer Join b) Right outer Join c) Inner Join d) None

Answers in Last Page >>>

The ……….. condition allows a general predicated over the relations being joined a) On b) Using c) Set d) Where

Answers in Last Page >>>

Materialized views make sure that a) View is verified for errors b) View is updated c) View is kept Stable d) View is deleted after specifying the error

Click here to check your answers