Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
it is mandatory that for every table in the ldb hierarchy there should exist one get statement in the report false it is not
consider the subsequent relations along with keys underlinedstreet name location city house number streetname lives name housenumber define the above
describe substring comparison in sql for the relation person name address write a sql query that retrieves the names of people whose name starts
what is null give an example to described testing for null in sqlthe null sql keyword is used to represent either a missing value or a value which
explain the exists and unique functions of sql give an example for eachexists the exists function takes one parameter that is a sql statement if any
what is recursive closure why is it not possible to describe this operation in relational algebra recursive closure is applied to recursive
differance between unordered and ordered file unordered file do no has any sequence although ordered file has arranged in a few sequence and data are
differance between open addressing and chaining for collision resolution in open addressing proceeding from the occupied position specified by hash
explain differance between primary and secondary storage primary and secondary storagecomputer storage is classified within primarymain memory and
what sorts of tables one can se in designing the hierarchy of a ldb tables which are having foreign key
discuss the types of integrity constraints in which must be checked for the update operations - insert and delete give examples insert operation can
what is entity in dbmsentity a dbms entity is either a thing in the modelled world or a drawing element in an
explain composite attribute in sql composite attribute a composite attribute has many components each of that is atomic or
explain recursive relationship typerecursive relationship type a recursive relationship is one in that the similar entity participates more than once
write a short note on participation roleparticipation role roles are indicating in e-r diagram by labelling the lines that connect diamonds to
what is the difference among a database schema and a database statethe collection of information stored in database at particular moment in time is
what are the situations while dbms should not be used dbms should not be used in situations likei no need of security ii not difficulty to access the
what three major types of actions includes databases briefly discuss these the three major types of actions including databases arei defining it
write a short note on qbe stands for query by example qbe is a feature involved along with various database applications which gives user-friendly
in oracle what is system global area and how is it organized the sga is a collection of shared memory fields which along with the oracle processes
consider the relations given below borrower idno namebook accno title author borroweridno a define the above relations as tables in sql forming real
while sorting if the main storage available is not enough the system writes data to an external help file the sap profile parameter which
what is asterisk in sqlasterisk in sql the columns for all the tables and views in the from clause will be
why like predicate used forlike predicate the like predicate searches for strings in which have a certain
while sorting field groups we cannot use more than one key field