Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
discuss the difference between drop table r and delete from r drop table command deletes all the records with the table definition this command
explain the check clausethe check clause is employed to at the end of a create table statement specify table constraints this is known as table-based
discuss the count functionthe count function used returns the number of tuples or values fixed in a querythe count function comprises two types of
fan in is simply a count of the number of other components that can call or pass control to component
how nulls are treated in comparison operatoralong with comparison relational operators the null values are ignored as we cannot derive the relation
what is live variablea variable is live from its first to its last reference within a
product metrics explain the characteristics of the product such as size complexity design features performance efficiency reliability portability
list any three characteristics of a good srs the srs should be correct unambiguous complete 1 correct an srs is correct iff every
explain the software life cycle model that incorporates risk factor the problem with traditional software process models is that they do not deal
evolutionary development model evolutionary development model evolutionary development model resembles iterative enhancement model the similar
iterative enhancement modeliterative enhancement model this model has the similar phases as the waterfall model but with fewer restrictions normally
discuss any two software characteristicssoftware is not manufactured the life of software is from method exploration to the retirement of the
what is difference between primary index and secondary indexprimary indexa it is an ordered file whose records are of fixed length along with two
what is structured programming and why is it importantstructured programming is a programming which was coined in the late 1960s to mean programming
what are the disadvantages of file-processing system ans the disadvantages of file-processing systema data redundancy and inconsistency - data
what is reverse engineering it is a process of examining software with a view to understanding its design and specification- in
functions that dynamic testing tools supports 1 input setting selecting of the test data that the test object reads when called 2 stub
explain the project-join normal forma relation r is in pjnf along with respect to a set of functional dependencies d if for all join dependencies of
what are dynamic testing tools dynamic testing tools 1 coverage analyzers execution verifiers2 output comparators3 test data generators4
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