Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
describe the two types of methods for retrieving rows in python fetchone- returns the next row as a sequence fetch all- returns the entire result
what are the differences among mysqlfetcharray mysqlfetchobject mysqlfetchrow mysqlfetchobject returns the result from the database like objects
define the categories of sql statements1 statements that dont return a result set this statement class includesinsert delete and update2statements
what is difference among mysqlconnect and mysqlpconnectmysqlconnect opens a new connection to the database while mysqlpconnect opens persistent
what are the three fundamental operations that are regular to mysql programsa establishing a connection to the mysql serverb choosing a databasec
describe the capabilities offered via mysql client apis bull checking for errors bull connecting to the mysql server selecting a database
describe the tools that are available for managing mysql servergiven below are the tools to manage mysql server mysqld - mysql server daemon this is
how can you terminate the mysql servertyping the following in command prompt will shut down the server completely as root user mysqladmin -u root -p
how can you start mysql serverto start the mysql program type it is name in the command- line prompt after starting mysql program just displaya
how can you connect to the mysql serverin order to connect to the mysql server it is necessary to give the username and password so this be able to
why do so various organizations use mysqladvantages open source highly efficient offers a high scalability in terms of size and connectivity highly
what is mysqlmysql is a relational database management system which has eleven million installations it can be used for both linux and window
what are the ways in which signal can be generateda signal might be generated in many ways such as a signal is result of particular physical
define signalit allows methods to respond to events triggered by themselves or by other processes each signal corresponds to an exacting event a
what is bankers algorithm bankers algorithm is a deadlock avoidance algorithm that is applicable to a resource-allocation system with multiple
define deadlock avoidance an alternative method for avoiding deadlocks is to needs additional information about how resources are to be requested
define deadlock preventiondeadlock prevention is a set of methods for ensuring that at least one of the four essential conditions like mutual
define data conversionhelpful to load data into temporary staging tables then can write sql code to do much of data processing sql code is simpler
write the motivations led to development of oo-dbms1 programmer frustration with rdbmss2 requirement for special
what are domain constraints a domain is a set of values that might be assigned to an attribute all
what is trigger triggers are statements that are executed automatically by the system as the side effect of a modification to the
what is the use of group by clause group by clause is used to apply aggregate functions to a set of tuples
write short notes on schema diagram a database schema along with primary key and foreign key dependencies can be depicted pictorially by
define query language a query is a statement requesting the retrieval of information the portion of dml that includes information retrieval is
write short notes on domain relational calculus the domain relational calculus uses domain variables that take on values from an attribute