![]() |
| 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 : Pls check your answer practically first then only write it.WE cant use HAVING clause without group functions IT will show error.So pls mr.Rahul Be Carefull next time ... Latest Answer : 1)function returns a value.... procedure does not returns a value.....2) in function will pass the many input parameters and wiull get only one output parameter with return value....But procedure we can get more than one output parameter.... ... Latest Answer : Please refer that here we are discussing about Sql Server only. There is no function named 'Translate' in Sql Server. 'Translate' function exists in Oracle for translating a single character to some other character.Replace fucntion in ... Latest Answer : aggregate fact tables have two types of keys-composite key-serrogate key (system generated key)So aggregate-key is a primary key ... Latest Answer : VARCHAR is used to store alphanumeric values without padding unused memory locations. But VARCHAR2 is used to store alphanumeric values with padding unused memory locations. so using VARCHAR2 we are saving memory locations. ... What is the difference among "dropping a tableâ€,†truncating a table" and deleting all records" from a table? Latest Answer : Oracle is ORDBMS (Object Oriented Relational DataBase) while Access is RDBMS(Relational DataBase) only. ... 1)What is the maximum value that can be stored for a datetime field? a. Dec 31, 9999 b. Jun 6, 2079 c. Jan 1, 2753 d. Jan 1, 2100 2)What is the correct SQL syntax for returning all the columns from a table named "Persons" sorted REVERSE alphabetically by "FirstName"? a. SELECT * FROM Persons WHERE FirstName ORDER BY FirstName DESC b. SELECT * FROM Persons SORT REVERSE 'FirstName' c. SELECT * FROM Persons ORDER BY -'FirstName' d. SELECT Read Answers (3) | Asked by : samir khan Latest Answer : Select Columnname from Tablename Groupby Columnname Having Count*>1 ... Read Answers (10) | Asked by : Srinu Latest Answer : I Think the question is not well formed.. Please Elaborate ... Read Answers (1) | Asked by : Chetan Shewale
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||