Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
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
define graph matrix and connection matrix graph matrix a graph matrix is a square matrix whose size ie number of rows and columns
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
describe system testing system testingsystem test are designed to authenticate a fully developed systems with a view to assuring that it meets
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
why does the software design improve when we use object-oriented concepts the software design improves when we use object-oriented
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
importance of function point this is independent of the languages tools or methodology used for executionthey can be estimated from
function points function point calculates the functionality from the user point of view that is on the basis of what the user request and receives in
differentiate between structured analysis and structured design the aim of structured analysis is to transform the textual explanation of a
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
discuss the various strategies of design the design strategies are functional design the system is designed from a
list four reasons why it is difficult to improve software process it is difficult to improve software process due to following reasons1 lack
for this assignment you will need to design and construct a basic math program which targets elementary school children your program must adhere to
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 ripple effect the ripple effect is a term used to describe a situation where like the ever expanding ripples across
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