Category: Database

Database Technical Interview Questions

database 0

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

DBA Interview Questions 2

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

MySQL management interview questions 1

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