Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
explain the exec statement in sqlans exec statement has the structure exec sql ltembedded sql statementgt end-exec embeded sql statements
define cascading rollbackthe phenomenon where a single transaction failure leads to a series of transaction rollbacks is known as cascading
define the attribute inheritancethe attributes of a higher level entity set are inherited through a lower level entity set made by
define granularity hierarchy of granularity of locks amp multiple granularity locking explain the modified two phase locking along with multiple
when are two schedules said to be view equivalent ans two schedules that is denoted as s and s are said to be view equivalent if the
what are the objectives of query processing ans the objectives of query processing is to transform a query written in a high
describe the definition of a transaction in sql ans the sql transaction starts implicitly transactions are finished by either commit work that
difference between left outer join and right outer joinin left outer join tuples from the left-hand-side relation which do not match any tuple in the
explain the difference between drop and deletedelete deletes one or more than one tuples of a particular relation from the database drop is employed
what is the difference between where and having clausespredicates in the where clause applies to every tuple while the predicate in the having clause
differentiate between a subquery and a joinif we need to acquire information from one or more tables after that either subquery or join can be used
explain the structure of well formed formulae in relational calculusans a an atom is a formulab if p1 is a formula after that so are notp1 and p1c if
define cardinality and participation constraints on a relationship type completeness constraint on generalization ans
explain the role of a database administratora defining the schema the dba describes the schema which consists of the structure of the data in
what is outer join they can be employed while we want to keep all the tuples in r or all those in s or all those in both relations in the result
explain the theta-join and equijoinrefer tables car and boat which list models of cars and boats and their relevant prices assume a customer wants to
explain the natural joinnatural join is a binary operator which is written as r s in which r and s are relations the effect of the natural join is
what are deadlocks how can they be avoided ans deadlock considers to a particular condition when two or more processes are every waiting for
differentiate between static hashing and dynamic hashing ans static hashing comprises the number of primary pages in the directory fixed so while
how does a query tree represent a relational algebra expression ans this includes transforming an initial expression tree into an
what is indexed sequential file organization what are the applications of this organization ans an index file can be employed to effectively
what are the reasons of bucket overflow explain any two methods for solving this problemans it is general for file structures to be divided into
define the boyce-codd normal form with instance and also compare bcnf and 3nf ans bcnf for each functional dependency x-gty in a set f of
what is ddl make a list of commands with short description used in ddlans data definition language that is abbreviated as ddl is a computer language
how relational calculus is different from relational algebra what do understand by trc queries and drc queries ans relational calculus contain two