GeekInterview.com
  I am new, Sign me up!
 

MYSQL Interview Questions


MYSQL Interview Questions

Questions: 49
Comments: 131
 MYSQL Tags
 Showing Questions 1-10 of 49 Questions
[1] 2 3 4 5 Next >>
 Sponsored Links

 
 MYSQL Interview Questions
Sorting Options :  

Is it required to use Index when the MySQL table has only 100 rows? Justify your answer 
Latest Answer: For 100 rows may be no need to use the index. If a table having huge number of records with table fields also having more, that time indexing is needed to execute the query fast and reliable. ...

How will you fetch the records of last week and last month? 
Latest Answer: select * from state where stateTime  > date_sub(curdate(),interval 7 day); ...

Which cursor type do you use to retrieve multiple recordsets?  

How will you export tables as an XML file? 
Latest Answer: You can export any result set from MySQL Query Browser by right-clicking within the result set and choosing an option from the Export Resultset sub-menu. You can choose to export the result set in CSV, XML, HTML, Microsoft Excel ...
Read Answers (1) | Asked by : paricse

How can you avoid execution time out error while fetching record from MySQL? 
Latest Answer: It is done by using the PHP function void set_time_limit ( int $seconds ) If seconds set to zero, no time limit is imposed. Use the below resource: http: //in2.php . net/manual/en/function.set-time-limit . php ...
Read Answers (3) | Asked by : deepmid

Latest Answer: Any attribute that is uniquely identify a row in a table is candidate key for the table. We select one of the candidate key as Primary key. All candidate keys which are not chosen as "primary key" are Alternate keys. The key which uniquely identify the ...

Latest Answer: Weak entity means- existence depends on existence of another entity (example: Employee: Dependant)SubType related to a SuperType with unique attributes - Specialization,Subtypes are said to Inherit characteristics from its SuperType. ...

Latest Answer: select sname,phone,feebal,feepaid from student s left outer join fees fon s.sid=f.sid;union select sname,phone,feebal from student s right outer join fees f on s.sid=f.sid;u can use this compile code ...

Latest Answer: Here is the MySQL row idCreate table log_bookid (logbookID int IDENTITY (1,1),fdate datetime, actype varchar(16), acid varchar(16), nlandings int, nhours float);I am trying to go backwards i.e. find the Oracle version ...

Latest Answer: SELECT c1.CategoryID, c1.Name, c2.CategoryID, c2.NameFROM category AS c1, category AS c2WHERE c1.CategoryID = c2.ParentIDORDER BY c1.CategoryID, c2.CategoryID ...
Read Answers (1) | Asked by : Vishwapati Mishra

View page [1] 2 3 4 5 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Expert Members
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape