Sawaal
  • Home/
  • Searching for u

 Searching for "u"

Q:

What is Bex (Business Explorer) ?

Answer

Bex stands for Business Explorer. Bex enables end user to locate reports, view reports, analyze information and can execute queries. The queries in workbook can be saved to there respective roles in the Bex browser. Bex has the following components: Bex Browser, Bex analyzer, Bex Map, Bex Web.

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:

What are the built-ins used for finding Object ID function?

Answer

FIND_GROUP(function) FIND_COLUMN(function)

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

Give the sequence of execution of the various report triggers?

Answer

Before form , After form , Before report, Between page, After report.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

What is user Account in Oracle database?

Answer

An user account is not a physical structure in Database but it is having important relationship to the objects in the database and will be having certain privileges. 95. When will the data in the snapshot log be used? - We must be able to create a after row trigger on table (i.e., it should be not be already available) After giving table privileges. We cannot specify snapshot log name because oracle uses the name of the master table in the name of the database objects that support its snapshot log. The master table name should be less than or equal to 23 characters. (The table name created will be MLOGS_tablename, and trigger name will be TLOGS name).

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

What are the database administrators utilities available?

Answer

SQL * DBA - This allows DBA to monitor and control an ORACLE database. SQL * Loader - It loads data from standard operating system files (Flat files) into ORACLE database tables. Export (EXP) and Import (imp) utilities allow you to move existing data in ORACLE format to and from ORACLE database.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

What is the use of ANALYZE command?

Answer

To perform one of these function on an index, table, or cluster:


 - To collect statistics about object used by the optimizer and store them in the data dictionary. 


 - To delete statistics about the object used by object from the data dictionary.


 - To validate the structure of the object.


 - To identify migrated and chained rows off the table or cluster.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

What is database clusters?

Answer

Group of tables physically stored together because they share common columns and are often used together is called Cluster.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration