Source Code 4 you

MYSQL Database Server

Question Total Page View * what is database testing and what we test in database testing?             178             * How can we know the number of days between two given dates using MySQL?             110             * How many types of buffers does use MySQL?             109             * What is the difference between CHAR and VARCHAR data types?             88             * What is meant by Virtual hosting?             93             * What is the difference between GROUP BY and ORDER BY in MySQL?             133             * How do you start and stop MySQL on Windows?             76             * What’s the default port for MySQL Server?             142             * What does tee command do in MySQL?             118             * How do you change a password for an existing user via MySQLadmin?             99             * how to upload comma seprated file in to mysql command             70             * How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?             72             * What's the difference between a primary key and a unique key?             70             * Define candidate key, alternate key, composite key.             106             * Explain different isolation levels             131             * What's the maximum size of a row?             116             * Explain the architecture of MySQL Server             85             * What are constraints? Explain different types of constraints.             87             * Explain CREATE DATABASE syntax             134             * What is RDBMS?             130             * What is Trigger?             113             * What is View?             100             * What is Index?             146             * What is the difference between clustered and a non-clustered index?             93             * What is cursors?             111             * What’s the difference between a primary key and a unique key?             117             * What is difference between DELETE & TRUNCATE commands?             77             * Difference between Function and Stored Procedure?             77             * What types of Joins are possible with MySql Server?             119             * What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?             96             * What is sub-query? Explain properties of sub-query.             72             * What is Self Join?             118             * What is Cross Join?             116             * What is a join and explain different types of joins.             85             * Find out nth highest salary from emp table             210             * What is UNION,UNION ALL in SQL?             94             * Suppose I have five SQL SELECT statements connected by UNION/UNION ALL, how many times should I specify UNION to eliminate the duplicate rows?             70             * In the WHERE clause what is BETWEEN and IN?             69             * What is a transaction and ACID?             75             * Materialized Query Tables in db2 ( This feature might not be available in oracle) ?             65             * What are the different data types supported by PostgreSQL?             108             * How do you create a data base with postgreSQL?             113             * What are the various enhancements to the straight relational data model by PostgreSQL?             77             * Explain about tokens?             117             * Explain about string constants?             73             1 2