|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Latest Answer : Primary Key: 1) One Primary Key per Table2) By Default creates Clustred Index3) Cannot Have Null values.Unique Key1) Can have multiple Unique keys.2) By default creates Non-Clustred Index.3) Can Have one Null value.Shoot a question on MSSql concepts.Thanks ... Latest Answer : ther is Physical structure & Logical structurePhysical structure Consits of 3 files one or more data files two ... Latest Answer : in oracle null is a undefined value,something value is there dut we can not manipulated it. in c null is a zero or any valid data ... Latest Answer : What's the Difference between COM and DCOM?Obviously, the difference is that DCOM is distributed but COM is not. To be more precise, there are three main elements added to COM: The way for creating a remote object. The way for accessing a remote object. ... Read Answers (1) | Asked by : satish Latest Answer : SGA: System Global Area. Its a chuck of memory used on oracle processes. ... Read Answers (23) | Asked by : Rahul Latest Answer : 1. VARCHAR is going to be replaced by VARCHAR2 in next version. So, Oracle suggests the use VARCHAR2 instead of VARCHAR while declaring datatype.2. VARCHAR can store up to 2000 bytes of characters while VARCHAR2 can store up ... Read Answers (19) | Asked by : Srinu Latest Answer : if we write query like this using traslate functionSYNTAX:- transalte(string,char which u want replace with,)Suppose for the EMPLOYEE table.... SQL>SELECT TRASLATE (upper(ENAME), ... Read Answers (8) | Asked by : Srinu Latest Answer : this statement is supported by the prescence of cube and rollup operators in oracle 9i which indicates that it is a multidimensional dbs ... Read Answers (2) | Asked by : Srinu Latest Answer : rownum is generated for the data retrieved and stored in an implicit cursor so depending on the outcum it may varry where as rowid is generated automatically for creation of every row,hence forth if we want retrive a particular row in a table we ... Read Answers (4) | Asked by : senthil I want to try create the database from my script which i made.can help me how to run a script. can explain me step by step because i am a starter.thank's
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
