Sawaal
  • Home/
  • Searching for CH

 Searching for "CH"

Q:

What is a batch input session?

Answer

BATCH INPUT SESSION is an intermediate step between internal table and database table. Data along with the action is stored in session ie data for screen fields, to which screen it is passed, program name behind it, and how next screen is processed.

Report Error

View answer Workspace Report Error Discuss

Subject: SAP

Q:

What is the alternative to batch input session?

Answer

Call transaction

Report Error

View answer Workspace Report Error Discuss

Subject: SAP

Q:

What are the problems in processing batch input sessions and How is batch input process different from processing online ?

Answer

PROBLEMS:


i) If the user forgets to opt for keep session then the session will be automatically removed from the session queue(log remains). However if session is processed we may delete it manually.


ii)if session processing fails data will not be transferred to SAP database table.

Report Error

View answer Workspace Report Error Discuss

Subject: SAP

Q:

Why do you usually choose to implement SAP?

Answer

There are number of technical reasons numbers of companies are planning to implement SAP. It’s highly configurable, highly secure data handling, min data redundancy, max data consistency, you can capitalize on economics of sales like purchasing, tight integration-cross function.

Report Error

View answer Workspace Report Error Discuss

Subject: SAP

Q:

How would you force a log switch?

Answer

ALTER SYSTEM SWITCH LOGFILE;

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

How would you go about increasing the buffer cache hit ratio?

Answer

Use the buffer cache advisory over a given workload and then query the v$db_cache_advice table. If a change was necessary then I would use the alter system set db_cache_size command.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

Answer

Disable the foreign key constraint to the parent, drop the table, re-create the table, enable the foreign key constraint.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode?

Answer

Complete database recovery from disk failure is possible only in ARCHIVELOG mode. Online database backup is possible only in ARCHIVELOG mode.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration