Source Code 4 you

MYSQL Database Server

Question Total Page View * How To Delete Duplicate Records – Rows             107             * what is database testing and what we test in database testing?             257             * How can we know the number of days between two given dates using MySQL?             204             * How many types of buffers does use MySQL?             200             * What is the difference between CHAR and VARCHAR data types?             150             * What is meant by Virtual hosting?             147             * What is the difference between GROUP BY and ORDER BY in MySQL?             300             * How do you start and stop MySQL on Windows?             176             * What’s the default port for MySQL Server?             235             * What does tee command do in MySQL?             186             * How do you change a password for an existing user via MySQLadmin?             150             * how to upload comma seprated file in to mysql command             128             * How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?             120             * What's the difference between a primary key and a unique key?             136             * Define candidate key, alternate key, composite key.             418             * Explain different isolation levels             231             * What's the maximum size of a row?             190             * Explain the architecture of MySQL Server             157             * What are constraints? Explain different types of constraints.             182             * Explain CREATE DATABASE syntax             218             * What is RDBMS?             200             * What is Trigger?             190             * What is View?             148             * What is Index?             199             * What is the difference between clustered and a non-clustered index?             286             * What is cursors?             162             * What’s the difference between a primary key and a unique key?             159             * What is difference between DELETE & TRUNCATE commands?             132             * Difference between Function and Stored Procedure?             131             * What types of Joins are possible with MySql Server?             216             * What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?             169             * What is sub-query? Explain properties of sub-query.             130             * What is Self Join?             173             * What is Cross Join?             180             * What is a join and explain different types of joins.             197             * Find out nth highest salary from emp table             645             * What is UNION,UNION ALL in SQL?             176             * Suppose I have five SQL SELECT statements connected by UNION/UNION ALL, how many times should I specify UNION to eliminate the duplicate rows?             100             * In the WHERE clause what is BETWEEN and IN?             140             * What is a transaction and ACID?             137             * Materialized Query Tables in db2 ( This feature might not be available in oracle) ?             134             * What are the different data types supported by PostgreSQL?             153             * How do you create a data base with postgreSQL?             155             * What are the various enhancements to the straight relational data model by PostgreSQL?             122             * Explain about tokens?             174             1 2