Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
what is a foreign key and what is it used fora foreign key is used to establish relationships between relations in the relational model technically a
what is sql and why is it importantsql stands for structured query language and is the most significant data processing language in use today it is
what is enterprise resource planning erp and what kind of a database is used in an erp applicationenterprise resource planning erp is an information
what are stand-alone proceduresprocedures that are not part of a package are called as stand-alone because they independently defined a good example
what are stored-procedures and what are the advantages of using themstored procedures are database objects that perform a user defined operation a
what is database triggera database trigger is a plsql block that can explained to automatically execute for insert update and delete statements
name the three major set of files on disk that compose a database in oraclethere are three main sets of files on disk that compose a database all the
what do you mean by correlated subquerysubqueries or nested queries are used to bring back a set of rows to be used by the parent query depending on
what is a phantom deadlock in distributed deadlock detection the delay in propagating local information might cause the deadlock detection algorithms
what do you mean by atomicity and aggregation atomicity either all actions are carried out or none are users should not have to worry about the
what is system catalog or catalog relation how is better known asa rdbms maintains a explanation of all the data that it contains information about
what are partial alternate artificial compound and natural keypartial key it is a set of attributes that can uniquely recognize weak entities and
what is functional dependency a functional dependency is shown by x y among two sets of attributes x and y that are subsets of r specifies a
what is normalizationit is a method of analysing the given relation schemas based on their functional dependencies fds and primary key to attain the
how does tuple-oriented relational calculus vary from domain-oriented relational calculusthe tuple-oriented calculus uses a tuple variables ie
what is dml data manipulation languagethis language that enable user to access or manipulate data as organised by appropriate data modelprocedural
what is data storagethe storage structures and access methods used by database system are specified by a set of explanation in a special type of ddl
what is object oriented model this model is based on collection of objects an object has values stored in instance variables with in the object an
what is e-r modelthis data model is based on real world that having of basic objects called entities and of relationship between these objects
what is a view how it is related to data independencea view might be thought of as a virtual table that is a table that does not really exist in its
what is system r what are its two major subsystemssystem r was intended and developed over a period of 1974-79 at ibm san jose research center it is
what is a java package and how is it used a java package is a naming context for classes and interfaces a package is used to make a separate name
how is final different from finally and finalize final is a modifier which can be applied to a class or a method or a variable final class cant be
how to define a constant variable in javathe variable should be declared as static and final so only one copy of the variable exists for all
what are instance variablesinstance variables are those which are explained at the class level instance variables require not be initialized before