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.
No Answer is Posted For this Question
Be the First to Post Answer
How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?
How does normalization work?
if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?
what stored procedure would you use to view lock information? : Sql server administration
Selet all the data from table where last name is n of employee
Create and insert into temp table in sql server?
what is the difference between table and view
What is sql server replication? : sql server replication
Explain about extended stored procedure?
What is a user-defined function in the sql server and what is its advantage?
is there a column to which a default can't be bound? : Sql server database administration
what is mean by constraints in sql?
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)