Module 11: Filling in the Details with a Detailed Design.

 

Filling in the Details with a Detailed Design.

1. What is meant by default option for table?

A setting used as an optional value for a field in a record, when a value is not specified.

2. What is validation check constraint?

Validation check settings are sometimes called check constraint. All they do is to check the value in a field when a new record is added, or an existing record is changed.

3. What is a stored procedure?

Stored procedure is a chunk of code stored within and executed from within a database, typically on a data stored in a database.

4. What is stored function?

Stored function is a chunk of code stored within and executed from within a database that returns a single value.