KyaPoocha.com

Related Interview Questions

• What is the maximum length of a table name, a database name, or a field name in MySQL?  06.11.08

  Database name: 64 characters Table name: 64 characters Column name: 64 characters...

• Which characters can CSS-names contain?  29.08.08

  The CSS-names; names of selectors, classes and IDs can contain characters a-z, A-Z, digits 0-9, period, hyphen, escaped characters, Unicode characters 161-255,...

• What is the difference between a HAVING CLAUSE and a WHERE CLAUSE ?  24.07.08

  Having Clause is basically used only with the GROUP BY function in a query. WHERE Clause is applied to each row before they are part of the GROUP BY function in...

• What is read-only cursor ?  10.04.08

  A read-only cursor is one in which the result table was created by a query containing one of the following : • a DISTINCT keyword • a UNION o...

• How do you define a correlated name?  09.04.08

  A correlated name  can be defined in the FROM clause of a query and in the first clause of an UPDATE or DELETE statement....

• What are Unicode characters?  15.12.06

  Unicode is used for internal representation of characters and strings and it uses 16 bits to represent each other....

• Which characters can CSS-names contain?  20.11.06

  The CSS-names; names of selectors, classes and IDs can contain characters a-z, A-Z, digits 0-9, period, hyphen, escaped characters, Unicode characters 161-255,...

• What is the wildcard character in SQL?  04.07.06

  Let’s say you want to query database with LIKE for all employees whose name starts with La. The wildcard character is %, the proper query with LIKE would invo...

• When you use WHERE clause and when you use HAVING clause ?  16.03.06

  HAVING clause is used when you want to specify a condition for a group function and it is written after GROUP BY clause The WHEREÂ clause is used when you wan...

• What is the wildcard character in SQL?  14.03.06

  Let’s say you want to query database with LIKE for all employees whose name starts with La. The wildcard character is %, the proper query with LIKE would invo...