Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288) 1. Using the XML Document below, with the URI “recipe.xml”
define
the following queries in XQuery:
a.) Give the names of all breakfast in the menu.
b.) Select breakfasts that have price lower than $7.00?
What is the difference between a primary index and a secondary index? What is a duplicate data entry in an index? Can a primary index contain duplicates?
IBM,
5 32794Anybody can tell me, how do we find second largest emp salary from emp table.. Thanks in advance ...
Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon,
10 15858Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply
1 6308i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..
4 7998
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What is current version of mysql?
How do I remove duplicates in two columns?
Can we use distinct and group by together?
8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?
how to escape special characters in sql statements? : Sql dba
what is bcp? When does it used? : Sql dba
Can we rollback truncate?
How to connect php with different port numbers?
Are you familiar with user exits in reports?
Have you created fact table and dimension tables?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Is it possible to have clustered index on separate drive from original table location?
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
What are the source of constraints?