SQL Interview Question 面试的时候发现会问一些SQL的基本问题,在此总结一下。 ProgramInterview/SQL这个网站上的问题还比较全。 1. Join type INNER JOIN: Returns all rows when there is at least one match in BOTH tables LEFT JOIN: Return all rows from the left table, and the matched rows from the...
The use of comparison operators like <,> or = can be done in a subquery. These kinds ofSQL Interview Questionsare a bit difficult to understand and answer accordingly. There are a lot ofSQL Interview Questionsapart from this, which the candidates must practice qualifying for the interview. Fo...
(90% asked PL SQL Interview Questions) Answer: 1.To create unique index you must have CREATE ANY INDEX privilege.Here the concept is bit different.User needs to check the values of the table to create unique index.If table contains uniquely identified values in specified column then you shoul...
5. What events need to be added to capture execution plan in sql profiller? 6. How to add memory to sql server 2005? 7. Which locks are held at the time of snapshot in log shipping? 8. What is the new lock escalation in sql 2008? 9. How to check the log file location for se...
For 64-bit sql servers we can also check the current memory usage using the below performance counter. Performance object: SQL Server:Memory Manager Counter: Total Server Memory (KB) Q. What is theoption”Lock Pages in Memory”? Ans: ...
Bit datatype is used to store boolean information like 1 or 0 (true or false). Untill SQL Server 6.5 bit datatype could hold either a 1 or 0 and there was no support for NULL. But from SQL Server 7.0 onwards, bit datatype can represent a third state, which is NULL. 5. Define ...
It is created as a view to easing porting problems, which allows code to remain compatible with Oracle SQL without obstructing the Postgres parser. Q8. What is the Maximum size for a database in PostgreSQL? Answer PostgreSQL has no maximum database size, so users can put unlimited data into...
sql interview question doc
If you're touching on a fact (e.g., language-specific trivia, a hairy bit of runtime analysis), don't try to appear to know something you don't. Instead, say "I'm not sure, but I'd guess $thing, because...". The because can involve ruling out other options by showing they ...
3 :: Explain two easy SQL optimizations. a. EXISTS can be better than IN under various conditionsb. UNION ALL is faster than UNION (not sorting)Read More 4 :: Name three SQL operations that perform a SORT. a. CREATE INDEXb. DISTINCTc. GROUP BYd. ORDER BYf. INTERSECTg. MINUSh. UNI...