Technology Questions

Q:

What is the information does assembly manifest provide?

Answer

Information provided by Assembly Manifest:



  1.  Assembly Name

  2.  Version Number

  3.  Culture

  4.  Strong name

  5.  List of files inside the assembly

  6.  Reference information

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 2391
Q:

Could you explain the areas where tuning of database is required?

Answer

The following are the areas of concern for tuning:


- Memory Usage


- Data Storage


- Data Manipulation


- Physical Storage


- Logic Storage


- Network Traffic


Tuning Memory Usage: In Oracle 10g, we can use the Automatic Workload Repository (AWR) toolset to gather and manage statistical data but in case of Oracle 11g, we can use new initialization parameters such as MEMORY_TARGET to further control the overall memory used by Oracle. It helps us to tune the database automatically when we don’t have time to read the AWR report.


Tuning Data Manipulation: There are two ways to tune Data manipulation in Oracle one way is through Conventional Path mode and second is Direct Path mode.


Tuning Physical Storage: We need to tune the physical storage because it limits the disk in database. This can be done by: Distributing I/O, Striping and Mirroring.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2391
Q:

What is a TCP Session?

Answer

the layer that establishes ,manages and terminates the session between two communticating devices

Report Error

View answer Workspace Report Error Discuss

0 2390
Q:

Is it cost effective to implement a private cloud rather than a public cloud and why?

Answer

It depends on the type of business that demands a cloud setup. Suppose if the subscription on a public cloud for an application that is to be deployed on OS images is proving to be more costly then to buy some new datacenters and maintain them. Then obviously the a private cloud has to be setup instead of a public cloud. This public clouds follow utility billing methodology as electricity bill for example.

Report Error

View answer Workspace Report Error Discuss

Subject: Cloud Computing

0 2389
Q:

Explain how garbage collection deals with circular references?

Answer

The .Net runtime knows about all the references between the objects. It can identify all the circular references that are reachable from the root and hence finalize them to free them all at once if and when needed.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 2388
Q:

What is Data Integration?

Answer

- The process of combining data from different resources.


- The combined data is provided to the users with unified view.


- Information from different enterprise domains are integrated – known as Enterprise Information Integration.


- Useful for merging information from different technologies among enterprises.


- The sub areas of data integration are 


1. Data Warehousing.


2. Data Migration.


3. Master Data Management.

Report Error

View answer Workspace Report Error Discuss

0 2387
Q:

What are constraints? Mention the different types of constraints?

Answer

Constraints enable the RDBMS to enforce the integrity of the database automatically, without the need to create triggers, rule or defaults.


Types of Constraints: NOT NULL, CHEQUE, UNIQUE, PRIMARY KEY, FOREIGN KEY.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 2385
Q:

Why we use array_flip

Answer

array_flip exchange the keys with their associated values in array ie. Keys becomes values and values becomes keys.

<?php
$arrayName    = array("course1"=>"php","course2"=>"html");
$new_array    = array_flip($arrayName);
print_r($new_array);
?>

OUTPUT :

Array
(
[php]     => course1
[html]    => course2
)

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 2385