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 ...
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 ...
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 ...
View page [1] 2 3 4 5 Next >>
Go Top
