Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
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
sstf stands for abbreviation of sstf is shortest-seek-time-first
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
what does the insert statement in extract datasets do it describes the fields of a field
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
it is possible to assign a local data object defined in a subroutine or function module to a field
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
a set of methods that allow executing a program which is not completely in memory is called a set of methods that allow executing a program
define the jobs which are admitted to the system for processing is called the jobs which are admitted to the system for processing is known as
what are the reasons for having variable length records what are the various ways to store variable length records variable-length records arise in
define a program in execution is known asa program in execution is known as a
the field that consists of a segment index or an internal index is known as target datum is field that consists of a segment index or an internal
when a function module is activated syntax checking is performed automatically yes a function module is activated syntax