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 ? | 2 Yes | 0 No |
12. Display the client name in upper case only and in lower case only.
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
How would you extract DDL of a table without using a GUI tool?
Difference between cartesian join and cross join?
How to run create database statement again?
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?
What are named parameters?
What is the CAP theorem?
In oracle there is column command, how will you explain that?
How to shutdown your 10g xe server?
How do I recompile a procedure in oracle?
Explain the use of parfile option in exp command.