Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
What are the differences among MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()?
Mysql_fetch_object returns the result from the database like objects while mysql_fetch_array returns result as an array.
This will permit access to the data via the field names E.g. using mysql_fetch_object field can be accessed as $result-
>name andusing mysql_fetch_array field can be accessed as $result->[name].
mysql_fetch_row($result):- where $result is the result resource come back from a successful query executed using the mysql_query() function.
Illustration:
$result = mysql_query("SELECT * from students);
while($row = mysql_fetch_row($result))
{
Some statement;
}
What are the drawbacks of shadow-paging technique? The drawbacks of shadow paging is:- a) Commit Overhead b) Data fragmentation c) Garbage collection
Define functional and multivalued dependencies. Ans: A functional dependency is a assets of the semantics of the attributes in a relation. The semantics point out how at
prototype of a distributed information system for a national car part retail outlet chain.
The External or View Level The external or view level is the highest level of abstraction of database. It gives a window on the conceptual view, which permits the user to see
With the linear commit protocol, sites are connected in a chain, and the subtransaction at the left-hand end of the chain initiates the protocol. Propose a crash recovery protocol
Evaluate: a.When transactions T1 and T2 are in a deadlock, one of the transactions will eventually implement to completion and let the other one continue implementation. b.
INSERT INTO command : Values can be inserted for all columns or for the selected columns Values can be given by sub query. In place of values parameter substitution
Speedup Query Processing: A query that includes data at various sites can be split into sub-queries. These sub- queries can be implemented in parallel by various sites. Such parall
The Database administrator (DBA) uses the data dictionary in each phase of a database life cycle, beginning from the data gathering phase to the design, execution and maintenance p
Define instance and schema? Instance: Collection of data stored in the data base at a certain moment is Schema: The overall design of the data base is known as the data base
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd