Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
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
what are the reasons for having variable length records what are the various ways to store variable length records variable-length records arise in
when a function module is activated syntax checking is performed automatically yes a function module is activated syntax
what is the disadvantage of a call by reference during a call by reference damage or loss of data is not restricted to the subroutine but will
what is a function group a function group is a collection of logically related modules that share global data with every other all the modules in
what is the difference between the function module and a normal abap4 subroutinein contrast to normal subroutines function modules have uniquely
discuss the methods for a hash file to expand and shrink dynamically what are the advantages and disadvantages of each the hashing methods that
describe the two alternatives for specifying structural constraints on relationship kindsrelationship kinds have certain constraints in which limit