Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
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
write short notes on relational model the relational model uses a collection of tables to show both data and
define the terms i ddl ii dml ddl data base schema is specified by a set of definitions expressed by a special
explain the two types of participation constraint total the participation of an entity set e in a relationship set r is said to be total if each
define weak and strong entity sets weak entity set entity set that do not have key attribute of their
define single valued and multivalued attributes single valued attributes attributes with a single value for a particular entity are known as
what is an entity relationship model the entity relationship model is a collection of basic objects known
what is a data dictionary a data dictionary is a data structure which keeps meta data about the structure of the database ie the schema of the