What are various constraints used in SQL?
SQL constraints are used to specify rules for the data in a table.
NOT NULL - Indicates that a column cannot store NULL value
UNIQUE - Ensures that each row for a column must have a unique value
PRIMARY KEY - A combination of a NOT NULL and UNIQUE. Ensures that a column (or combination of two or more columns) have an unique identity which helps to find a particular record in a table more easily and quickly
FOREIGN KEY - Ensure the referential integrity of the data in one table to match values in another table
CHECK - Ensures that the value in a column meets a specific condition
DEFAULT - Specifies a default value when specified none for this column
Is This Answer Correct ? | 1 Yes | 0 No |
select statement does not retrieve any records. what exception is raised?
State the various uses of dbcc command?
hai, when to use char and varchar2....?
what are corelated subqueries
13. Display the second to fifth characters in each client name.
what are the database links ?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
What is a partition in oracle?
What is a trace file and how is it created in oracle?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What are temporal data types in oracle?