1. What is default constraint? Constraints are specific values that used to limit the type of data that can go into a table by ensure certain columns have a true condition when data is inserting, modi...
A coulumn can be given a default value by using DEFAULT option. This option prevents null values from entering the column if a row is inserted with out a value in to the table.Ex: .......Hire_date DATE DEFAULT SYSDATE,.......
User It is just an account name for the user Owns a schema Have the same name Create user command, create the user User can be considered schema User can created without schema It is the account for t...
senthil kumar B
Feb 13th, 2006
Diff b.w OLTP and OLAP :------------------------OLTP Schema :* Normalized * More no.of trans* Less time for queries execution* More no.of users* Have Insert,delete and update trans. OLAP (D...