Fresher Interview Questions

Here are some of the Microsoft SQL Server developer interview questions:

- Why is a UNION ALL faster than a UNION?
- What are some advantages to using Oracle’s CREATE DATABASE statement to create a new database manually?
- What are three rules of thumb to create good passwords? How would a DBA enforce those rules in Oracle? What business challenges might you encounter?
- Describe the Oracle Wait [...]

1. How do you show the currently running queries? - SHOW FULL PROCESSLIST;
2. How do you kill a MySQL query? - See the ID of it from the question above, then KILL id. You can separate multiple IDs by space.
3. I need to find out how [...]