Technology Questions

Q:

Describe about Physical Data Integration?

Answer

- Physical Data Integration is all about creating new system that replicates data from the source systems.


- This process is done to manage the data independent of the original system.


- Data Warehouse is the example of Physical Data Integration.


- The benefits of PDI include data version management, combination of data from various sources, like mainframes, flat files, databases.


- A separate system is needed for handling vast data volumes.


 

Report Error

View answer Workspace Report Error Discuss

0 2767
Q:

Explain Check constraint.

Answer

Oracle check constraint is used to ensure that before inserting the data in the database, it is validated and checked for the condition.
Example:
Below, the constraint is that the id has to be between 0 and 1000.
create table employee ( id number check (id between 0 and 1000), Name varchar(200) );

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2766
Q:

What’s the difference between htmlentities( ) and htmlspecialchars( )?

Answer htmlspecialchars only takes care of , single quote ‘, double quote " and ampersand. htmlentities translates all occurrences of character sequences that have different meaning in HTML.
Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 2766
Q:

Explain the process of creating a menu using the MainMenu component

Answer

MainMenu component is a component that allows the display of Menus at runtime on a form.


Process of creating Menu using MainMenu Component:


a. Add MainMenu component on Windows Form.


b. Menu designer allows deciding the structure of the main menu by selecting the Type Here area and adding the Menu Items to be displayed on the menu.


c. Add functionality to Menu Items as required

Report Error

View answer Workspace Report Error Discuss

Subject: .NET
Job Role: Software Architect

0 2764
Q:

What is data cleaning? How can we do that?

Answer

Data cleaning is also known as data scrubbing. Data cleaning is a process which ensures the set of data is correct and accurate. Data accuracy and consistency, data integration is checked during data cleaning. Data cleaning can be applied for a set of records or multiple sets of data which need to be merged.


Data cleaning is performed by reading all records in a set and verifying their accuracy. Typos and spelling errors are rectified. Mislabeled data if available is labeled and filed. Incomplete or missing entries are completed. Unrecoverable records are purged, for not to take space and inefficient operations.

Report Error

View answer Workspace Report Error Discuss

0 2761
Q:

Describe how SAP handles Memory Management?

Answer

ST02 / ST03 In general via table buffers, you could go into the whole Work Process, roll in, roll out, heap (private) memory, etc. However just as a Unix or DBA admin would know, is you look this up when needed for the exact specifics.

Report Error

View answer Workspace Report Error Discuss

Subject: SAP

0 2760
Q:

What do you mean by Redo Log file mirroring ?

Answer

-  The process of having a copy of redo log files is called mirroring.
-  It is done by creating group of log files together. This ensures that LGWR automatically writes them to all the members of the current on-line redo log group.
-  In case a group fails, the database automatically switches over to the next group. It diminishes the performance.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2758
Q:

Which among the following validators checks if entered data matches a specific format

A) Compare validator B) RegularExpressionValidator
C) CustomValidator D) None
 
Answer & Explanation Answer: B) RegularExpressionValidator

Explanation:

RegularExpressionValidator checks if entered data matches a specific format

Report Error

View Answer Report Error Discuss

Filed Under: .NET
Job Role: Software Architect

0 2751