SQL Database Validation

Question

I am currently performing an SQL job, but a specific task mentioned that we need to perform validation and validation for our tables in the database that we created.

However, we did not learn anything about this topic, and after working on the Internet for hours I found the validation restrictions that you can give in the create table statement.

Please indicate some of the validation and validation METHODS for a table or SQL database.

Answer 1

You usually check by running some kind of test against the data.

There are different levels through which data passes, and there are various types of tests.

:

• /

• , , , , , , , ,
• , ( , )
• , (, , ), . ( , , ). - , , , () .

( ):

• (: , ?). , .)
• (: ?). , CHECK
• (: , , ). FOREIGN KEYS
• - ( , , " , , 100, , IP- , , , ". ) . - ( - PL/SQL, , , , , , ).

Answer 2

, , , . - , - . ... , . . , , .