What are trace files?
No Answer is Posted For this Question
Be the First to Post Answer
What is difference between count (*) and count column?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
What are scalar functions?
What is resource governor in sql server?
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.
What is Schema? and why we use schemas?
Do you know the cursor optimization tips?
Explain system functions or built-in functions? What are different types of system functions?
Explain user defined functions?
What is a partition key?
How to write stored procedure to update the data in 10 tables
What does COMMIT command do?
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)