Interview Questions for Freshers
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 this function. Now we will have to use mysql_query(“create database databasename”); to create database. mysql_drop_db($dbname,$link) is also...
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...
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 many client connections...