Category: Database

Database Technical Interview Questions

database

How to Create Database using PHP and mysql

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...

DBA Interview Questions

DBA 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...

MySQL management interview questions

MySQL management interview questions

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...