What is the difference between deallocate cursor and close cursor?
No Answer is Posted For this Question
Be the First to Post Answer
Which table keeps the locking information?
What is database replicaion? What are the different types of replication you can set up in SQL Server?
5 Answers Aptech, HCL, Perpetual, SAIC,
What is partition, how will you implement it? : sql server analysis services, ssas
What is de-normalization in sql database administration? Give examples?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
What is trigger ?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
What is the difference between ddl,dml and dcl commands?
0 Answers BirlaSoft, Verifone,
What is Full Outer Join?
What is normalization of database? What are its benefits?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
There is a table1 with records (1,2,3,4,5,6) and table2 with records (4,5,6,7,8,9).write a query so as to get the result as 1,2,3,4,5,6,7,8,9
Oracle (3259)
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)