|
| 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 : 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 : 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 Write a query that displays the difference between the highest and lowest salaries. Label the column Write a query that displays the difference between the highest and lowest salaries. Label the column DIFFERENCE. Latest Answer : Instance is the memory structures and background processes used to interact with Database.Instance = SGA + Background ProcessDatabase is the physical files used to store information. the 3 types of physical files are: Datafiles, Control File and ... Read Answers (1) | Asked by : Mohammed Abdul Afroze Latest Answer : both are inverse...if we take the case with cold back we copy the all the physical files of the database i.e control files,data files,redo logs.this w3e do in non peak hourshot back up is somthing which is used to tabke backup of logical database that ... Read Answers (2) | Asked by : Sridhar Tags : Backup
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2 
0