SAP DB Interview Questions

Type is used to define a field
Type table of will be default like standard table
Type standard table of is having a key field
like line of is work area.

Task is nothing but Process.For example your manager going to assign some work called Task.

And after completion of task or work they may require more advantages as same application called change request.

Commit is the operation that saves all the information into database, however rollback is the opposite operation to remove all the transactions done!!

Commit database is consistant state and all transaction successfully.
Rollback database in inconsistant state.

Insert - To add new records to the DB
Update - To update existing recs in the DB
Modify - Updates the recs if the data exists in the DB or else just inserts the recs in the DB

BR* Tools

Use of update command without WHERE Clause is it sets the values total table column
For Example
 
UPDATE EMP SET ADDRESS=BANGALORE

The above command sets the address to the total rows in the table column.

select *, select distinct, select single *.