Ques 121. Where the integrity constraints are stored in data dictionary?
The integrity constraints are stored in USER_CONSTRAINTS.
Is it helpful?
Add CommentView Comments
Ques 122. How will you activate/deactivate integrity constraints?
The integrity constraints can be enabled or disabled by ALTER TABLE ENABLE CONSTRAINT / DISABLE CONSTRAINT.
Is it helpful?
Add CommentView Comments
Ques 123. If unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?
It won't, Because SYSDATE format contains time attached with it.
Is it helpful?
Add CommentView Comments
Ques 124. What is a database link?
Database link is a named path through which a remote database can be accessed.
Is it helpful?
Add CommentView Comments
Ques 125. How to access the current value and next value from a sequence? Is it possible to access the current value in a session before accessing next value?
Sequence name CURRVAL, sequence name NEXTVAL. It is not possible. Only if you access next value in the session, current value can be accessed.