ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
 Categories  >>  Software  >>  Databases       
 
  Oracle (1578)   SQL Server (699)   MS Access (12)   MySQL (134)   Postgre (4)
  Sybase (13)   DB Architecture (1)   DB Administration (145)   DB Development (41)   SQL PLSQL (446)
  Databases AllOther (56)
 
Suggest New Category 
 


 

View Page with Answers
  Question  Asked @ Answers Views     select
 
WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX L&T  1  17
event classes in sql server Accenture  1  27
WHAT IS UNIQUE IDENTIFIER DATA TYPE? Sparsh  1  22
A left outer join B B right outer join A gives the same result then what is the use of two?  0  8
how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables? Lason  1  19
SELECT country,city FROM customers GROUP BY country ORDER BY city DESC HCL  2  48
One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h  0  31
Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500  1  37
Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)  3  68
One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h  0  17
9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18  1  56
Fname Lname City Pin ramesh kumar salem 365241 Query to generate a code having the firstletter of Fname,Lname & 3letter of city Last 3letter of pin,all in capital letters  1  28
Query to select passwords from a table having a column "Password" Whose length is b/w 8 &15 and having 'A' as the first character in the password irrespective of case.  1  39
write down the code for "how we delete a table without using of Drop command " ? Sonata  1  186
i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L  4  59
E-Mail New Answers        Answer Selected Questions       
 
 [1]    2  ... 14   ... 27   ... 40   ... 53   ... 66   ... 79   ... 92   ... 105   ... 118   ... 131   ... 144   ... 157   ... 170   ... 183    Next
 
 
 Programming Languages interview questions   Programming Languages Interview Questions  Scripts interview questions   Scripts Interview Questions  Networking interview questions   Networking Interview Questions
 Microsoft Related interview questions   Microsoft Related Interview Questions  Databases interview questions   Databases Interview Questions  Operating Systems interview questions   Operating Systems Interview Questions
 Testing interview questions   Testing Interview Questions  Servers interview questions   Servers Interview Questions  MainFrame interview questions   MainFrame Interview Questions
 Java Related interview questions   Java Related Interview Questions  Middleware interview questions   Middleware Interview Questions  Web Related interview questions   Web Related Interview Questions
 Data Warehouse interview questions   Data Warehouse Interview Questions  HR Questions interview questions   HR Questions Interview Questions  Software Design interview questions   Software Design Interview Questions
 Debugging interview questions   Debugging Interview Questions  Version Control interview questions   Version Control Interview Questions  Editors interview questions   Editors Interview Questions
 Telecom interview questions   Telecom Interview Questions  ERP CRM interview questions   ERP CRM Interview Questions  Embedded Systems interview questions   Embedded Systems Interview Questions
 Client Server interview questions   Client Server Interview Questions  Artificial Intelligence interview questions   Artificial Intelligence Interview Questions  Cryptography interview questions   Cryptography Interview Questions
 EAI interview questions   EAI Interview Questions  Multimedia interview questions   Multimedia Interview Questions  Software Development Life Cycle interview questions   Software Development Life Cycle Interview Questions
 Image Processing interview questions   Image Processing Interview Questions
 
 
 
Un-Answered Questions
 
 Question Views Asked at   Select
 
Give two examples of referential integrity constraints. 215  
Explain couple pf features of SQL server 259  
Can u explain me the Restricted and unrestricted procedure in Forms And reports and example as well ?? 237  
How can we expand Parameter Form Canvas on Reports 6i? 288 ABB
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000???? 224  
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card 173 TCS
What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name. 204 TCS
Explain the difference between $ORACLE_HOME and $ORACLE_BASE. 527  
What view would you use to determine free space in a tablespace? 155  
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table? 153  
A left outer join B B right outer join A gives the same result then what is the use of two? 8  
Which dictionary tables and/or views would you look at to diagnose a locking issue? 1  
Hi Can any one tell me what are the API's used in requisition import. 28  
Explain materialized views and how they are used. 141  
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance. 87 IBM
Write the major components of a Database Management System? 295  
how can db_files > maxdatafiles since db_files is for instance and the later is for database 184 CTS
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution 185 TCS
sequence of firing triggers for text-item is: 1)key_next_item, 2)when_validate_item, 3)post_text_item Now i change sequence of firing triggers like when_validate_item,key_next_item... Is it possible to change sequence? How? 394  
what is the sql equivaent of the dataset relation object ? 97  
E-Mail New Answers        Answer Selected Questions
 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com