Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
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
what is the role of order by clauseorder by clause the order by clause permits you to sort the records in your result set the order by clause can
what is the use of unique functionunique function if unique is specified then only unique values are used to computed the
what is the used of specifying aliasspecifying alias is used to rename column or attribute in a
while using extract datasets it is required to have a special workarea for interface false it is not required to have a special workarea for
a field-groups statement or an insert statement reverses storage space and transfers values
what does the extract statement do in extract datasetsthe data is written to virtual memory by extract
explain the difference between using functions along with and without grouping attributes in relational algebra give examplesans group functions are
can a filed occur in several field groupsyes but it leads to redundant data
consider the relations city cityname state hotel name address cityhotel hotelname cityname owneranswer the following queries in relational algebrai
consider the subsequent relationsrenterrno fname lname address telno preftype maxrent viewingrno pno date comment propertyforrent pno street area
what is the difference between internal tables and extract datasets the lines of an internal table always have the similar structure by using extract
discuss the mechanism to read data from and write to a disk disk readwrite heads are mechanisms in which read data from or write data to disk drives