PostgreSQL Questions et reponses d'entretien
Question : Explain the difference between a stored procedure and a function in PostgreSQL.Reponse : Stored procedures are precompiled sets of one or more SQL statements stored in the database, while functions return a value and can be used in SQL queries like any other value. |
Enregistrer pour revision
Ajoutez cet element aux favoris, marquez-le comme difficile ou placez-le dans un ensemble de revision.
Connectez-vous pour enregistrer des favoris, des questions difficiles et des ensembles de revision.
Est-ce utile ? Oui Non
Les plus utiles selon les utilisateurs :
- Explain the concept of ACID properties in the context of databases.
- What is the purpose of the WHERE clause in a PostgreSQL query?
- What is a foreign key, and how does it enforce referential integrity?
- Explain the purpose of the SERIAL data type in PostgreSQL.