What are deterministic and non-deterministic functions in MariaDB database?

devquora
devquora

Posted On: Feb 22, 2018

 

Deterministic means that the result should be one value given a number of inputs parameters.

Non-deterministic means that the result can give a different value given a number of input parameters. The result can be changed because of the data, numbers, tables etc.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    MariaDB Interview Questions

    What do you understand by the MariaDB?

    MariaDB is developed by MySQL developers. It is a popular public source under GNU GPL which is related to database management technology...

    MariaDB Interview Questions

    Mention some characteristics of MariaDB?

    It has a lot of unique features that make it more useful and wonderful to work over it than MySQL. Some features are:..

    MariaDB Interview Questions

    Which command is used to delete the table in MariaDB’s database?

    The command DROP TABLE is used to delete the table in MariaDB’s database...