Database Technical Interview Questions
Q:How can we create a database using PHP and mysql? Answer: In the earlier versions of PHP we were using mysql_create_db($dbstring,$link) to create a database,but PHP5 n latest versions of PHP do not support...
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...
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....