ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Databases  >>  MySQL
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
Query to select passwords from a table having a column
"Password" Whose length is b/w 8 &15 and having   'A' as the
first character in the password irrespective of case.
 Question Submitted By :: Ramesh
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Query to select passwords from a table having a column "Password" Whose length is b/w 8 &15 and having 'A' as the first character in the password irrespective of case.
Answer
# 1
SELECT Password
FROM tablename
WHERE Password LIKE 'A%'
AND Length( Password) >=8
AND Length( Password) <=15
 
Is This Answer Correct ?    4 Yes 1 No
Mdeva
[Geni]
 

 
 
 
Other MySQL Interview Questions
 
  Question Asked @ Answers
 
What?s the difference between query_cache_type 1 and 2?  1
How many ways we can we find the current date using MySQL?  1
how do i list constraints in my database by using sql server2000?  1
How can we change the name of a column of a table?  4
Explain MySQL optimization?  1
How many values can the SET function of MySQL take? Creative-Informatics2
What does tee command do in MySQL?  1
How can increase the performance of MySQL select query? Span-Systems2
What is ACID?  2
Explain the difference between FLOAT, DOUBLE and REAL.  3
A select query over a large table runs very slow because of the growing number of entries in that table. What different measures could be taken to improve speed?  3
What is SERIAL data type in MySQL?  2
ru compare the 2 null values? ACC1
How to get full name of monthname ?  3
about join  2
How can we store binary data in mysql? HP2
What happens if a table has one column defined as TIMESTAMP?  1
How do you prevent MySQL from caching a query?  1
how to display only 4 records from a table based on a condition for ex i have a table called products in that nid,prodname are fields i want to display only any 4 records of perticular product plz tell me  4
What is the maximum length of a table name, database name, and fieldname in MySQL? TISL1
 
For more MySQL Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com