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 various forms of data transparency? a) fragmentation transparency b) replication transparency c) location transparency
Describe Parameteric end users? Parametric end users might be given update access, but are commonly not permitted to change the structure of data.
What is called a query -execution engine? The query implementation engine takes a query evaluation plan, implements that plan, and returns the answers to the query.
What is De-normalization? De-normalization is the method of attempting to optimize the performance of a database by adding redundant data. It is sometimes essential because cur
Explain forms based and graphical interface? Forms based and graphical interface: graphical user interface (GUI) is a kind of user interface which permits people to interact
Define the Query optimisation The query parser commonly generates a standard initial tree to correspond to an SQL query, with no doing any optimization. Such type of a canonica
A database will be made to store information about patients in a hospital. On arrival, each patient’s personal details (name, address, and telephone number) are recorded where poss
WHAT IS DATABASE TECHNOLOGIES
2NF Normal Form : A relation schema process R is in 2NF if it is in 1NF and each non-prime attribute A in R is fully functionally related on primary key. Second normal form (2N
Differentiate between logical database design and physical database design. Show how this separation leads to data independence? Basis Logical Databas
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