SQL Questions et reponses d'entretien
Test your skills through the online practice test: SQL Quiz Online Practice Test
Question 121. Where the integrity constraints are stored in data dictionary?
The integrity constraints are stored in USER_CONSTRAINTS.
Est-ce utile ?
Ajouter un commentaire
Voir les commentaires
Question 122. How will you activate/deactivate integrity constraints?
The integrity constraints can be enabled or disabled by ALTER TABLE ENABLE CONSTRAINT / DISABLE CONSTRAINT.
Est-ce utile ?
Ajouter un commentaire
Voir les commentaires
Question 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.
Est-ce utile ?
Ajouter un commentaire
Voir les commentaires
Question 124. What is a database link?
Database link is a named path through which a remote database can be accessed.
Est-ce utile ?
Ajouter un commentaire
Voir les commentaires
Question 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.
Est-ce utile ?
Ajouter un commentaire
Voir les commentaires
Les plus utiles selon les utilisateurs :